Follow us on LinkedIn for your next SAP project

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 Possible values
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
TRANSAC
Business Transaction
J_VORGANG TJ01
CHAR
4 0
TRANSAC_TYPE
Transaction Type
RMVCT
CHAR
3 0
FIVOR
Financial transaction
FIVOR
NUMC
2 0
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
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
FLG_FUND_CENTER_NOT_VALID
Funds Center for Posting Date Not Valid
FM_FLG_FUND_CENTER_NOT_VALID
CHAR
1 0
FLG_FUNCTION_NOT_VALID
Functional Area Not Valid for Key Date
FM_FLG_FUNCTION_NOT_VALID
CHAR
1 0
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
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
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
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
FLG_COMMIT_ITEM_NOT_VALID
Commitment Item for Posting date Not Valid
FM_FLG_COMMIT_ITEM_NOT_VALID
CHAR
1 0
FLG_GRANT_NOT_VALID
Grant for Posting Date Not valid
FM_FLG_GRANT_NOT_VALID
CHAR
1 0
CRM_PAYMENT_TYPE
Payment Type for Grantor
GTRT_CRM_GRM_PAYMENT_TYPE
CHAR
4 0
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
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 SYST MANDT SKA1
G/L Account Master (Chart of Accounts)
MANDT
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 ASSET SYST MANDT ANLA
Asset Master Record Segment
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 ASSETTRTYP SYST MANDT TABW
Asset transaction types
MANDT
FMDERIVE ASSETTRTYP FMDERIVE ASSETTRTYP TABW
Asset transaction types
BWASL
FMDERIVE BUILDING_NUMBER FMDERIVE BUILDING_NUMBER VIOB03
Real estate building master
SGENR
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 BUSINESS_ENTITY SYST MANDT VIOB01
Business entities
MANDT
FMDERIVE BUSINESS_ENTITY FMDERIVE COMPANY_CODE VIOB01
Business entities
BUKRS
FMDERIVE BUSINESS_ENTITY FMDERIVE BUSINESS_ENTITY VIOB01
Business entities
SWENR
FMDERIVE BUS_AREA FMDERIVE BUS_AREA TGSB
Business Areas
GSBER
FMDERIVE BUS_AREA SYST MANDT TGSB
Business Areas
MANDT
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 SYST MANDT CSKA
Cost Elements (Data Dependent on Chart of Accounts)
MANDT
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 CO_AREA FMDERIVE CO_AREA TKA01
Controlling Areas
KOKRS
FMDERIVE CO_AREA SYST MANDT TKA01
Controlling Areas
MANDT
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 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 FM_AREA SYST MANDT FM01
Financial Management Areas
MANDT
FMDERIVE FM_AREA FMDERIVE FM_AREA FM01
Financial Management Areas
FIKRS
FMDERIVE FUND_TYP SYST MANDT FMFUNDTYPE
FM Fund Types
MANDT
FMDERIVE FUND_TYP FMDERIVE FM_AREA FMFUNDTYPE
FM Fund Types
FM_AREA
FMDERIVE FUND_TYP FMDERIVE FUND_TYP FMFUNDTYPE
FM Fund Types
FUND_TYPE
FMDERIVE MOVE_TYPE SYST MANDT T156
Movement Type
MANDT
FMDERIVE MOVE_TYPE FMDERIVE MOVE_TYPE T156
Movement Type
BWART
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 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_NV FMDERIVE ORDER_POSNR_NV AFVC
Operation within an order
APLZL
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 FMDERIVE ORDER_POSNR_SD VBUP
Sales Document: Item Status
POSNR
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 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 POSTING_DATE CEPC
Profit Center Master Data Table
DATBI
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 PROPERTY_NUMBER FMDERIVE BUSINESS_ENTITY VIOB02
Property master data
SWENR
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 SPEC_STOCK SYST MANDT T148
Special Stock Indicator
MANDT
FMDERIVE SPEC_STOCK FMDERIVE SPEC_STOCK T148
Special Stock Indicator
SOBKZ
FMDERIVE SUB_ASSET FMDERIVE COMPANY_CODE ANLA
Asset Master Record Segment
BUKRS
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 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 SYST MANDT T025
Valuation Classes
MANDT
FMDERIVE VAL_CLASS FMDERIVE VAL_CLASS T025
Valuation Classes
BKLAS
FMDERIVE VAL_TYPE FMDERIVE VAL_TYPE T149D
Global Valuation Types
BWTAR
FMDERIVE VAL_TYPE SYST MANDT T149D
Global Valuation Types
MANDT