FMDERIVE007 SAP table for – Derivation rule:WBS Element to Commitment Item/Funds Ctr/Fun

Here we would like to draw your attention to FMDERIVE007 table in SAP. As we know it is being mainly used with the SAP PSM-FM (Funds Management in PSM) component which is coming under PSM module (Public Sector Management). FMDERIVE007 is a SAP standard transp table used for storing Derivation rule:WBS Element to Commitment Item/Funds Ctr/Fun related data in SAP. It comes under the package FMFS_E.

SAP FMDERIVE007 table

Table FMDERIVE007 technical data

TableFMDERIVE007
Data storingDerivation rule:WBS Element to Commitment Item/Funds Ctr/Fun
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFS_E
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-PS
Table CategoryTRANSP

SAP FMDERIVE007 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMDERIVE007 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SOUR1_FROM : Work Breakdown Structure Element (WBS Element)
    Its a key field. Its data type is CHAR (Character String) with field length 24
  • SOUR1_TO : Work Breakdown Structure Element (WBS Element)
    Its a key field. Its data type is CHAR (Character String) with field length 24
  • VALID_FROM : Lower Range Limit for Current Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TARGET1 : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • TARGET2 : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • TARGET3 : Fund
    Its data type is CHAR (Character String) with field length 10
  • TARGET4 : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • DELETE_FLG : Deletion Flag
    Its data type is CHAR (Character String) with field length 1
  • ADDED_BY : Created by
    Its data type is CHAR (Character String) with field length 12
  • ADDED_ON : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8