SAP Table FMDERIVE
FM Derivation Structure
FMDERIVE (FM Derivation Structure) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FMDERIVE to other SAP tables.
FMDERIVE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | 0 | |||||||||||||||||||||
| CO_AREA | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||||||||||||
| FM_AREA | Financial Management Area | FIKRS | FM01 | CHAR | 4 | 0 | ||||||||||||||||||||
| ACCOUNT_NUMBER | G/L Account Number | SAKNR | SKA1 | CHAR | 10 | 0 | ||||||||||||||||||||
| ASSET | Main Asset Number | ANLN1 | ANLA | CHAR | 12 | 0 | ||||||||||||||||||||
| SUB_ASSET | Asset Subnumber | ANLN2 | ANLA | CHAR | 4 | 0 | ||||||||||||||||||||
| COST_ELEMENT | Cost Element | KSTAR | CSKA | CHAR | 10 | 0 | ||||||||||||||||||||
| COST_CENTER | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||||||||||||||||
| ORDER_NUMBER | Order Number | AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||||||
| WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | 0 | |||||||||||||||||||||
| PROFIT_CENTER | Profit Center | PRCTR | CHAR | 10 | 0 | |||||||||||||||||||||
| BUSINESS_ENTITY | Site Number | SWENR | VIOB01 | CHAR | 8 | 0 | ||||||||||||||||||||
| PROPERTY_NUMBER | Property Number for BE | SGRNR | VIOB02 | CHAR | 8 | 0 | ||||||||||||||||||||
| BUILDING_NUMBER | Building Number | SGENR | VIOB03 | CHAR | 8 | 0 | ||||||||||||||||||||
| RENTAL_UNIT | Number of Rental Unit | SMENR | CHAR | 8 | 0 | |||||||||||||||||||||
| LEASE_NUMBER | Lease-Out Number | SMIVE | CHAR | 13 | 0 | |||||||||||||||||||||
| SETTLEMENT_UNIT | Settlement Unit | SEMPSL | CHAR | 5 | 0 | |||||||||||||||||||||
| COMMIT_ITEM | Commitment Item | FM_FIPEX | CHAR | 24 | 0 | |||||||||||||||||||||
| FUND_CENTER | Funds Center | FISTL | CHAR | 16 | 0 | |||||||||||||||||||||
| FUND | Fund | BP_GEBER | CHAR | 10 | 0 | |||||||||||||||||||||
| FUND_TYP | FM Fund Type | FM_FUNDTYPE | FMFUNDTYPE | CHAR | 6 | 0 | ||||||||||||||||||||
| FUNCTION_AREA | Functional Area | FKBER | CHAR | 16 | 0 | |||||||||||||||||||||
| POSTING_DATE | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||||||||||||||||
| ORDER_NUMBER_NP | Network Number for Account Assignment | NPLNR | CHAR | 12 | 0 | |||||||||||||||||||||
| ORDER_NUMBER_NV | Routing number of operations in the order | CO_AUFPL | AFVC | NUMC | 10 | 0 | ||||||||||||||||||||
| ORDER_POSNR_NV | General counter for order | CO_APLZL | AFVC | NUMC | 8 | 0 | ||||||||||||||||||||
| ORDER_NUMBER_SD | Sales and Distribution Document Number | VBELN | VBUK | CHAR | 10 | 0 | ||||||||||||||||||||
| ORDER_POSNR_SD | Sales Document Item | POSNR_VA | VBUP | NUMC | 6 | 0 | ||||||||||||||||||||
| DR_CR_IND | Debit/Credit Indicator | SHKZG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| TRANSAC | Business Transaction | J_VORGANG | TJ01 | CHAR | 4 | 0 | ||||||||||||||||||||
| TRANSAC_TYPE | Transaction Type | RMVCT | CHAR | 3 | 0 | |||||||||||||||||||||
| FIVOR | Financial transaction | FIVOR | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||||
| PARTNER_FUND | Partner Fund | FM_PFUND | CHAR | 10 | 0 | |||||||||||||||||||||
| PARTNER_FUND_TYP | FM Fund Type | FM_FUNDTYPE | FMFUNDTYPE | CHAR | 6 | 0 | ||||||||||||||||||||
| FLG_CO_RECON | CO reconciliation object | FM_FLG_AO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| DISTR_CHAN | Distribution Channel | VTWEG | CHAR | 2 | 0 | |||||||||||||||||||||
| SALESORG | Sales Organization | VKORG | CHAR | 4 | 0 | |||||||||||||||||||||
| DIVISION | Division | SPART | CHAR | 2 | 0 | |||||||||||||||||||||
| PLANT | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||||||||||||||
| MATERIAL_NUMBER | Material Number | MATNR | CHAR | 18 | 0 | |||||||||||||||||||||
| BUS_AREA | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||||||||||||
| CO_BUSPROC | Business Process | CO_PRZNR | CBPR | CHAR | 12 | 0 | ||||||||||||||||||||
| COSTOBJECT | Cost Object | KSTRG | CKPH | CHAR | 12 | 0 | ||||||||||||||||||||
| VAL_TYPE | Valuation Type | BWTAR_D | T149D | CHAR | 10 | 0 | ||||||||||||||||||||
| VAL_AREA | Valuation Area | BWKEY | T001K | CHAR | 4 | 0 | ||||||||||||||||||||
| SPEC_STOCK | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 | 0 | ||||||||||||||||||||
| TR_PART_BA | Trading partner's business area | PARGB | TGSB | CHAR | 4 | 0 | ||||||||||||||||||||
| PART_PRCTR | Partner Profit Center | PPRCTR | CEPC | CHAR | 10 | 0 | ||||||||||||||||||||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | 0 | |||||||||||||||||||||
| MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | 0 | |||||||||||||||||||||
| EE_GROUPING_FOR_FIXED_ACCT | Employee Grouping Fixed Account Assignment FM/GM | EG_ACCT_ASSGMT_FIX_FMGM | CHAR | 3 | 0 | |||||||||||||||||||||
| FLG_FUND_NOT_VALID | Fund for Posting Date Not Valid | FM_FLG_FUND_NOT_VALID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| FLG_FUND_CENTER_NOT_VALID | Funds Center for Posting Date Not Valid | FM_FLG_FUND_CENTER_NOT_VALID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| FLG_FUNCTION_NOT_VALID | Functional Area Not Valid for Key Date | FM_FLG_FUNCTION_NOT_VALID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| USERTEMP1 | Temporary field 1 (user-defined) | KEDRTMPVALUE1 | CHAR | 32 | 0 | |||||||||||||||||||||
| BUS_TRANS_CAT | Business Transaction Category | TCR_BUSTRANSCAT | NUMC | 4 | 0 | |||||||||||||||||||||
| DIST_FLOWTYPE | Update Type | TCR_DIS_FLOWTYPE | CHAR | 8 | 0 | |||||||||||||||||||||
| PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | 0 | |||||||||||||||||||||
| PORTFOLIO | Portfolio | RPORTB | CHAR | 10 | 0 | |||||||||||||||||||||
| DOCUMENT_DATE | Document Date in Document | BLDAT | DATS | 8 | 0 | |||||||||||||||||||||
| CONTRACT_NUMBER | Real Estate Contract Number | RECNNR | CHAR | 13 | 0 | |||||||||||||||||||||
| REVERSEDOC | Identifier for reversal document | CO_STFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| ORDER_NUMBER_PM | Order Number of a Maintenance Order | PMAUFNR | CHAR | 12 | 0 | |||||||||||||||||||||
| MOVE_TYPE | Movement Type (Inventory Management) | BWART | T156 | CHAR | 3 | 0 | ||||||||||||||||||||
| VAL_CLASS | Valuation Class | BKLAS | T025 | CHAR | 4 | 0 | ||||||||||||||||||||
| FLG_INVNTRY_PSTNG | Indicates that current posting is an inventory posting | FM_FLG_INVNTRY_PSTNG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| ASSETTRTYP | Asset Transaction Type | BWASL | TABW | CHAR | 3 | 0 | ||||||||||||||||||||
| DOC_TYPE | Document Type | FM_DOCUMENT_TYPE | CHAR | 2 | 0 | |||||||||||||||||||||
| FM_SPLIT | Line is Result of Account Assignment Distribution | FMSP_SPLIT_RESULT_FLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| SERVICE_CHARGE_KEY | Service Charge Key | SNKSL | CHAR | 4 | 0 | |||||||||||||||||||||
| FLG_MEASURE_NOT_VALID | Funded Program for Posting Date Not Valid | FM_FLG_MEASURE_NOT_VALID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| FLG_COMMIT_ITEM_NOT_VALID | Commitment Item for Posting date Not Valid | FM_FLG_COMMIT_ITEM_NOT_VALID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| FLG_GRANT_NOT_VALID | Grant for Posting Date Not valid | FM_FLG_GRANT_NOT_VALID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| CRM_PAYMENT_TYPE | Payment Type for Grantor | GTRT_CRM_GRM_PAYMENT_TYPE | CHAR | 4 | 0 |
Possible values
|
||||||||||||||||||||
| CRM_EXPENSE_TYPE | Expense Type for Grantor | GTRT_CRM_GRM_EXPENSE_CAT | CHAR | 4 | 0 | |||||||||||||||||||||
| PROG_PROFILE | Program Profile | GTR_PROG_PROFILE | CHAR | 10 | 0 | |||||||||||||||||||||
| USERTEMP2 | Temporary field 2 (user-defined) | KEDRTMPVALUE2 | CHAR | 32 | 0 | |||||||||||||||||||||
| USERTEMP3 | Temporary field 3 (user-defined) | KEDRTMPVALUE3 | CHAR | 32 | 0 | |||||||||||||||||||||
| USERTEMP4 | Temporary field 4 (user-defined) | KEDRTMPVALUE4 | CHAR | 32 | 0 | |||||||||||||||||||||
| BUDGET_PERIOD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | 0 | |||||||||||||||||||||
| PARTNER_BUDGET_PERIOD | FM: Partner Budget Period | FM_PBUDGET_PERIOD | CHAR | 10 | 0 | |||||||||||||||||||||
| FLG_BUD_PD_NOT_VALID | Fund/Budget Period for Posting Date Not Valid | FM_FLG_FUND_BUDPD_NOT_VALID | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| ORDER_GRP | Order Group | AUFGR | CHAR | 15 | 0 | |||||||||||||||||||||
| COST_CENTER_GRP | Cost Center Group | KSGRU | CHAR | 15 | 0 | |||||||||||||||||||||
| COST_ELEMENT_GRP | Cost Element Group | KAGRU | CHAR | 15 | 0 | |||||||||||||||||||||
| WBS_ELEMENT_GRP | WBS element group | POSIDGR | CHAR | 15 | 0 | |||||||||||||||||||||
FMDERIVE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| FMDERIVE | ACCOUNT_NUMBER | * | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL | |
| FMDERIVE | ACCOUNT_NUMBER | FMDERIVE | ACCOUNT_NUMBER | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| FMDERIVE | ACCOUNT_NUMBER | SYST | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| FMDERIVE | ASSET | FMDERIVE | COMPANY_CODE | ANLA | Asset Master Record Segment | BUKRS |
| FMDERIVE | ASSET | FMDERIVE | ASSET | ANLA | Asset Master Record Segment | ANLN1 |
| FMDERIVE | ASSET | FMDERIVE | SUB_ASSET | ANLA | Asset Master Record Segment | ANLN2 |
| FMDERIVE | ASSET | SYST | MANDT | ANLA | Asset Master Record Segment | MANDT |
| FMDERIVE | ASSETTRTYP | SYST | MANDT | TABW | Asset transaction types | MANDT |
| FMDERIVE | ASSETTRTYP | FMDERIVE | ASSETTRTYP | TABW | Asset transaction types | BWASL |
| FMDERIVE | BUILDING_NUMBER | SYST | MANDT | VIOB03 | Real estate building master | MANDT |
| FMDERIVE | BUILDING_NUMBER | FMDERIVE | COMPANY_CODE | VIOB03 | Real estate building master | BUKRS |
| FMDERIVE | BUILDING_NUMBER | FMDERIVE | BUSINESS_ENTITY | VIOB03 | Real estate building master | SWENR |
| FMDERIVE | BUILDING_NUMBER | FMDERIVE | BUILDING_NUMBER | VIOB03 | Real estate building master | SGENR |
| FMDERIVE | BUSINESS_ENTITY | FMDERIVE | COMPANY_CODE | VIOB01 | Business entities | BUKRS |
| FMDERIVE | BUSINESS_ENTITY | FMDERIVE | BUSINESS_ENTITY | VIOB01 | Business entities | SWENR |
| FMDERIVE | BUSINESS_ENTITY | SYST | MANDT | VIOB01 | Business entities | MANDT |
| FMDERIVE | BUS_AREA | SYST | MANDT | TGSB | Business Areas | MANDT |
| FMDERIVE | BUS_AREA | FMDERIVE | BUS_AREA | TGSB | Business Areas | GSBER |
| FMDERIVE | COSTOBJECT | SYST | MANDT | CKPH | Master Record: Cost Object ID Number | MANDT |
| FMDERIVE | COSTOBJECT | FMDERIVE | COSTOBJECT | CKPH | Master Record: Cost Object ID Number | KSTRG |
| FMDERIVE | COSTOBJECT | FMDERIVE | POSTING_DATE | CKPH | Master Record: Cost Object ID Number | DATBI |
| FMDERIVE | COST_ELEMENT | * | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL | |
| FMDERIVE | COST_ELEMENT | FMDERIVE | COST_ELEMENT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
| FMDERIVE | COST_ELEMENT | SYST | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| FMDERIVE | CO_AREA | SYST | MANDT | TKA01 | Controlling Areas | MANDT |
| FMDERIVE | CO_AREA | FMDERIVE | CO_AREA | TKA01 | Controlling Areas | KOKRS |
| FMDERIVE | CO_BUSPROC | FMDERIVE | CO_BUSPROC | CBPR | CO-ABC: Activity Master Table | PRZNR |
| FMDERIVE | CO_BUSPROC | FMDERIVE | POSTING_DATE | CBPR | CO-ABC: Activity Master Table | DATBI |
| FMDERIVE | CO_BUSPROC | SYST | MANDT | CBPR | CO-ABC: Activity Master Table | MANDT |
| FMDERIVE | CO_BUSPROC | FMDERIVE | CO_AREA | CBPR | CO-ABC: Activity Master Table | KOKRS |
| FMDERIVE | FM_AREA | SYST | MANDT | FM01 | Financial Management Areas | MANDT |
| FMDERIVE | FM_AREA | FMDERIVE | FM_AREA | FM01 | Financial Management Areas | FIKRS |
| FMDERIVE | FUND_TYP | FMDERIVE | FUND_TYP | FMFUNDTYPE | FM Fund Types | FUND_TYPE |
| FMDERIVE | FUND_TYP | SYST | MANDT | FMFUNDTYPE | FM Fund Types | MANDT |
| FMDERIVE | FUND_TYP | FMDERIVE | FM_AREA | FMFUNDTYPE | FM Fund Types | FM_AREA |
| FMDERIVE | MOVE_TYPE | FMDERIVE | MOVE_TYPE | T156 | Movement Type | BWART |
| FMDERIVE | MOVE_TYPE | SYST | MANDT | T156 | Movement Type | MANDT |
| FMDERIVE | ORDER_NUMBER | SYST | MANDT | AUFK | Order master data | MANDT |
| FMDERIVE | ORDER_NUMBER | FMDERIVE | ORDER_NUMBER | AUFK | Order master data | AUFNR |
| FMDERIVE | ORDER_NUMBER_NV | FMDERIVE | ORDER_POSNR_NV | AFVC | Operation within an order | APLZL |
| FMDERIVE | ORDER_NUMBER_NV | SYST | MANDT | AFVC | Operation within an order | MANDT |
| FMDERIVE | ORDER_NUMBER_NV | FMDERIVE | ORDER_NUMBER_NV | AFVC | Operation within an order | AUFPL |
| FMDERIVE | ORDER_NUMBER_SD | SYST | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| FMDERIVE | ORDER_NUMBER_SD | FMDERIVE | ORDER_NUMBER_SD | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| FMDERIVE | ORDER_POSNR_NV | SYST | MANDT | AFVC | Operation within an order | MANDT |
| FMDERIVE | ORDER_POSNR_NV | FMDERIVE | ORDER_NUMBER_NV | AFVC | Operation within an order | AUFPL |
| FMDERIVE | ORDER_POSNR_NV | FMDERIVE | ORDER_POSNR_NV | AFVC | Operation within an order | APLZL |
| FMDERIVE | ORDER_POSNR_SD | SYST | MANDT | VBUP | Sales Document: Item Status | MANDT |
| FMDERIVE | ORDER_POSNR_SD | FMDERIVE | ORDER_NUMBER_SD | VBUP | Sales Document: Item Status | VBELN |
| FMDERIVE | ORDER_POSNR_SD | FMDERIVE | ORDER_POSNR_SD | VBUP | Sales Document: Item Status | POSNR |
| FMDERIVE | PARTNER_FUND_TYP | SYST | MANDT | FMFUNDTYPE | FM Fund Types | MANDT |
| FMDERIVE | PARTNER_FUND_TYP | FMDERIVE | FM_AREA | FMFUNDTYPE | FM Fund Types | FM_AREA |
| FMDERIVE | PARTNER_FUND_TYP | FMDERIVE | PARTNER_FUND_TYP | FMFUNDTYPE | FM Fund Types | FUND_TYPE |
| FMDERIVE | PART_PRCTR | FMDERIVE | CO_AREA | CEPC | Profit Center Master Data Table | KOKRS |
| FMDERIVE | PART_PRCTR | SYST | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| FMDERIVE | PART_PRCTR | FMDERIVE | PART_PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| FMDERIVE | PART_PRCTR | FMDERIVE | POSTING_DATE | CEPC | Profit Center Master Data Table | DATBI |
| FMDERIVE | PROPERTY_NUMBER | FMDERIVE | PROPERTY_NUMBER | VIOB02 | Property master data | SGRNR |
| FMDERIVE | PROPERTY_NUMBER | SYST | MANDT | VIOB02 | Property master data | MANDT |
| FMDERIVE | PROPERTY_NUMBER | FMDERIVE | COMPANY_CODE | VIOB02 | Property master data | BUKRS |
| FMDERIVE | PROPERTY_NUMBER | FMDERIVE | BUSINESS_ENTITY | VIOB02 | Property master data | SWENR |
| FMDERIVE | SPEC_STOCK | SYST | MANDT | T148 | Special Stock Indicator | MANDT |
| FMDERIVE | SPEC_STOCK | FMDERIVE | SPEC_STOCK | T148 | Special Stock Indicator | SOBKZ |
| FMDERIVE | SUB_ASSET | FMDERIVE | ASSET | ANLA | Asset Master Record Segment | ANLN1 |
| FMDERIVE | SUB_ASSET | FMDERIVE | SUB_ASSET | ANLA | Asset Master Record Segment | ANLN2 |
| FMDERIVE | SUB_ASSET | SYST | MANDT | ANLA | Asset Master Record Segment | MANDT |
| FMDERIVE | SUB_ASSET | FMDERIVE | COMPANY_CODE | ANLA | Asset Master Record Segment | BUKRS |
| FMDERIVE | TRANSAC | FMDERIVE | TRANSAC | TJ01 | Business Transactions | VRGNG |
| FMDERIVE | TR_PART_BA | SYST | MANDT | TGSB | Business Areas | MANDT |
| FMDERIVE | TR_PART_BA | FMDERIVE | TR_PART_BA | TGSB | Business Areas | GSBER |
| FMDERIVE | VAL_AREA | SYST | MANDT | T001K | Valuation area | MANDT |
| FMDERIVE | VAL_AREA | FMDERIVE | VAL_AREA | T001K | Valuation area | BWKEY |
| FMDERIVE | VAL_CLASS | FMDERIVE | VAL_CLASS | T025 | Valuation Classes | BKLAS |
| FMDERIVE | VAL_CLASS | SYST | MANDT | T025 | Valuation Classes | MANDT |
| FMDERIVE | VAL_TYPE | SYST | MANDT | T149D | Global Valuation Types | MANDT |
| FMDERIVE | VAL_TYPE | FMDERIVE | VAL_TYPE | T149D | Global Valuation Types | BWTAR |
