The FMDERIVE005 table in SAP ERP or S/4HANA stores Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func data. There are total 11 fields in FMDERIVE005 table. The Derivation rule:Order to Commitment Item/Funds Ctr/Fund/Func table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMDERIVE005 table. It is in Updating/Integration Funds Management (master lang. english) (FMFS_E) ABAP package and is part of the Funds Management (PSM-FM) module.
SAP FMDERIVE005 Table Fields
Following is the list of fields that are available in SAP FMDERIVE005 table. The primary key fields of the table are MANDT (Client), SOUR1_FROM (Order Number), SOUR1_TO (Order Number), VALID_FROM (Lower Range Limit for Current Date).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| SOUR1_FROM | Order Number | AUFNR | * | CHAR (12) |
| SOUR1_TO | Order Number | AUFNR | * | CHAR (12) |
| VALID_FROM | Lower Range Limit for Current Date | ABAINTAB | DATS (8) | |
| TARGET1 | Commitment item | FM_FIPEX | * | CHAR (24) |
| TARGET2 | Funds Center | FISTL | * | CHAR (16) |
| TARGET3 | Fund | BP_GEBER | * | CHAR (10) |
| TARGET4 | Functional Area | FKBER | * | CHAR (16) |
| DELETE_FLG | Deletion Flag | ABADRDELFLAG | CHAR (1) | |
| ADDED_BY | Created by | ABADRERFASSER | CHAR (12) | |
| ADDED_ON | Date on which the record was created | ERDAT | DATS (8) |
