FMDERIVE005 SAP table for – Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func

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

SAP FMDERIVE005 table

Table FMDERIVE005 technical data

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

SAP FMDERIVE005 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 FMDERIVE005 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
  • 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