FMDERIVE004 SAP table for – Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F

Here we would like to draw your attention to FMDERIVE004 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). FMDERIVE004 is a SAP standard transp table used for storing Derivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F related data in SAP. It comes under the package FMFS_E.

SAP FMDERIVE004 table

Table FMDERIVE004 technical data

TableFMDERIVE004
Data storingDerivation rule:Order/CE to Commitment Item/Funds Ctr/Fund/F
ModulePSM
Sub ModulePSM-FM
SAP PackageFMFS_E
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentEA-PS
Table CategoryTRANSP

SAP FMDERIVE004 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 FMDERIVE004 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SOUR1_FROM : Order Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • SOUR1_TO : Order Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • SOUR2_FROM : Cost Element
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SOUR2_TO : Cost Element
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • 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