SAP table FMDERIVE (FM Derivation Structure)

Field Description Data Type Length Decimals Checktable Data Element
COMPANY_CODE Company Code CHAR 4 0 BUKRS
CO_AREA Controlling Area CHAR 4 0 TKA01 KOKRS
FM_AREA Financial Management Area CHAR 4 0 FM01 FIKRS
ACCOUNT_NUMBER G/L Account Number CHAR 10 0 SKA1 SAKNR
ASSET Main Asset Number CHAR 12 0 ANLA ANLN1
SUB_ASSET Asset Subnumber CHAR 4 0 ANLA ANLN2
COST_ELEMENT Cost Element CHAR 10 0 CSKA KSTAR
COST_CENTER Cost Center CHAR 10 0 KOSTL
ORDER_NUMBER Order Number CHAR 12 0 AUFK AUFNR
WBS_ELEMENT Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
PROFIT_CENTER Profit Center CHAR 10 0 PRCTR
BUSINESS_ENTITY Business Entity Number CHAR 8 0 VIOB01 SWENR
PROPERTY_NUMBER Land Number for BE CHAR 8 0 VIOB02 SGRNR
BUILDING_NUMBER Building Number CHAR 8 0 VIOB03 SGENR
RENTAL_UNIT Number of Rental Unit CHAR 8 0 SMENR
LEASE_NUMBER Lease-Out Number CHAR 13 0 SMIVE
SETTLEMENT_UNIT Settlement Unit CHAR 5 0 SEMPSL
COMMIT_ITEM Commitment Item CHAR 24 0 FM_FIPEX
FUND_CENTER Funds Center CHAR 16 0 FISTL
FUND Fund CHAR 10 0 BP_GEBER
FUND_TYP FM Fund Type CHAR 6 0 FMFUNDTYPE FM_FUNDTYPE
FUNCTION_AREA Functional Area CHAR 16 0 FKBER
POSTING_DATE Posting Date in the Document DATS 8 0 BUDAT
ORDER_NUMBER_NP Network Number for Account Assignment CHAR 12 0 NPLNR
ORDER_NUMBER_NV Routing number of operations in the order NUMC 10 0 AFVC CO_AUFPL
ORDER_POSNR_NV General counter for order NUMC 8 0 AFVC CO_APLZL
ORDER_NUMBER_SD Sales and Distribution Document Number CHAR 10 0 VBELN
ORDER_POSNR_SD Sales Document Item NUMC 6 0 POSNR_VA
DR_CR_IND Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
TRANSAC Business Transaction CHAR 4 0 TJ01 J_VORGANG
TRANSAC_TYPE Transaction type CHAR 3 0 RMVCT
FIVOR Financial Transaction NUMC 2 0 FIVOR
05 Funds reservation
10 Purchase requisition
20 Purchase order commitment
30 Post revenue, expenditure, asset, inventory stocks...
40 Post goods receipt, goods issue
50 Company Code Clearing
60 Post rcvbls and pybls from goods + services, down payment
80 Post bank clearing, bill of exchange
90 Post cash holdings
PARTNER_FUND Partner Fund CHAR 10 0 FM_PFUND
PARTNER_FUND_TYP FM Fund Type CHAR 6 0 FMFUNDTYPE FM_FUNDTYPE
FLG_CO_RECON CO reconciliation object CHAR 1 0 FM_FLG_AO
DISTR_CHAN Distribution Channel CHAR 2 0 VTWEG
SALESORG Sales Organization CHAR 4 0 VKORG
DIVISION Division CHAR 2 0 SPART
PLANT Plant CHAR 4 0 WERKS_D
MATERIAL_NUMBER Material Number CHAR 40 0 MATNR
BUS_AREA Business Area CHAR 4 0 TGSB GSBER
CO_BUSPROC Business Process CHAR 12 0 CBPR CO_PRZNR
COSTOBJECT Cost Object CHAR 12 0 CKPH KSTRG
VAL_TYPE Valuation Type CHAR 10 0 T149D BWTAR_D
VAL_AREA Valuation area CHAR 4 0 T001K BWKEY
SPEC_STOCK Special Stock Indicator CHAR 1 0 T148 SOBKZ
TR_PART_BA Trading partner's business area CHAR 4 0 TGSB PARGB
PART_PRCTR Partner Profit Center CHAR 10 0 CEPC PPRCTR
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
MEASURE Funded Program CHAR 24 0 FM_MEASURE
EE_GROUPING_FOR_FIXED_ACCT Employee Grouping Fixed Account Assignment FM/GM CHAR 3 0 EG_ACCT_ASSGMT_FIX_FMGM
FLG_FUND_NOT_VALID Fund for Posting Date Not Valid CHAR 1 0 FM_FLG_FUND_NOT_VALID
FLG_FUND_CENTER_NOT_VALID Funds Center for Posting Date Not Valid CHAR 1 0 FM_FLG_FUND_CENTER_NOT_VALID
FLG_FUNCTION_NOT_VALID Functional Area Not Valid for Key Date CHAR 1 0 FM_FLG_FUNCTION_NOT_VALID
USERTEMP1 Temporary field 1 (user-defined) CHAR 40 0 KEDRTMPVALUE1
BUS_TRANS_CAT Business Transaction Category NUMC 4 0 TCR_BUSTRANSCAT
DIST_FLOWTYPE Update Type CHAR 8 0 TCR_DIS_FLOWTYPE
PRODUCT_TYPE Product Type CHAR 3 0 VVSART
PORTFOLIO Portfolio CHAR 10 0 RPORTB
DOCUMENT_DATE Document Date in Document DATS 8 0 BLDAT
KOFIZ Account Determination ID CHAR 2 0 KOFIZ_KK
HVORG Main Transaction for Line Item CHAR 4 0 TFKHVO HVORG_KK
TVORG Subtransaction for Document Item CHAR 4 0 TFKTVO TVORG_KK
PERSL Key for Period Assignment CHAR 4 0 TFK001P PERSL_KK
ASSET_ACCOUNT_NUMBER Number of Asset G/L Account CHAR 10 0 SAKAA_KK
FICA_FMDERIVE FM Account Derivation Called from Contract AR & AP CHAR 1 0 FICA_FMDERIVE_KK
CONTRACT_NUMBER Real Estate Contract Number CHAR 13 0 RECNNR
REVERSEDOC Identifier for reversal document CHAR 1 0 CO_STFLG
ORDER_NUMBER_PM Order Number of a Maintenance Order CHAR 12 0 * PMAUFNR
MOVE_TYPE Movement type (inventory management) CHAR 3 0 T156 BWART
VAL_CLASS Valuation Class CHAR 4 0 T025 BKLAS
FLG_INVNTRY_PSTNG Indicates that current posting is an inventory posting CHAR 1 0 FM_FLG_INVNTRY_PSTNG
Not an inventory posting
X Inventory Posting
ASSETTRTYP Asset Transaction Type CHAR 3 0 TABW BWASL
DOC_TYPE Document Type CHAR 2 0 FM_DOCUMENT_TYPE
FM_SPLIT Line Is Result of Account Assignment Drilldown CHAR 1 0 FMSP_SPLIT_RESULT_FLAG
SERVICE_CHARGE_KEY Service Charge Key CHAR 4 0 SNKSL
FLG_MEASURE_NOT_VALID Funded Program for Posting Date Not Valid CHAR 1 0 FM_FLG_MEASURE_NOT_VALID
FLG_COMMIT_ITEM_NOT_VALID Commitment Item for Posting date Not Valid CHAR 1 0 FM_FLG_COMMIT_ITEM_NOT_VALID
FLG_GRANT_NOT_VALID Grant for Posting Date Not valid CHAR 1 0 FM_FLG_GRANT_NOT_VALID
RES_DOC Document Number for Earmarked Funds CHAR 10 0 * KBLNR
RES_ITEM Earmarked Funds: Document Item NUMC 3 0 KBLP KBLPOS
CRM_PAYMENT_TYPE Payment Type for Grantor CHAR 4 0 GTRT_CRM_GRM_PAYMENT_TYPE
GADV Grantor Advance
GEFE Grantor EF Expenditure
GEFR Grantor EF Revenue
GHBK Grantor Holdback
GPIN Grantor RePayment
GPOU Grantor Payment
GPRC Grantor Pmt Recovery
CRM_EXPENSE_TYPE Expense Type for Grantor CHAR 4 0 GTRT_CRM_GRM_EXPENSE_CAT
PROG_PROFILE Program Profile CHAR 10 0 GTR_PROG_PROFILE
PO_NUMBER Purchasing Document Number CHAR 10 0 EBELN
PO_LINE_ITEM Item Number of Purchasing Document NUMC 5 0 * EBELP
PO_SEQ_AA Sequential Number of Account Assignment NUMC 2 0 DZEKKN
PO_NUMBER_SES Entry Sheet Number CHAR 10 0 LBLNI
PO_LINE_ITEM_SES FM Reference Line Item NUMC 6 0 FM_XDOCLN
PO_SEQ_AA_SES FM Reference Sequence Account Assignment NUMC 5 0 FM_XZEKKN
PO_PRED_ORG Predecessor Document Organization CHAR 10 0 FM_VRFORG
LOGSYSTEM Logical System CHAR 10 0 * LOGSYSTEM
USER_NAME User Name CHAR 12 0 UNAME
ACCT_TYPE Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
ACCT_KEY Transaction Key CHAR 3 0 KTOSL
REF_TRANS Reference procedure CHAR 5 0 * AWTYP
PROCESS_INFO Process info status (FMDERIVE) CHAR 2 0 FM_PROCESS_INFO
PO Chained Process to a Purchase Order
PROCESS_DETAIL Process Detail (FMDERIVE) CHAR 6 0 FM_PROCESS_DETAIL
GR_CLR GR/IR clearing line item during Goods Receipt
IR_CLR GR/IR clearing line item during Invoice Receipt
USERTEMP2 Temporary field 2 (user-defined) CHAR 40 0 KEDRTMPVALUE2
USERTEMP3 Temporary field 3 (user-defined) CHAR 40 0 KEDRTMPVALUE3
USERTEMP4 Temporary field 4 (user-defined) CHAR 40 0 KEDRTMPVALUE4
USERDIM Customer Field for FM Actual and Commitment Data CHAR 10 0 FM_USERDIM
FLG_USERDIM_NOT_VALID Invalid USERDIM for Posting Date CHAR 1 0 FM_FLG_USERDIM_NOT_VALID
FMXDOCNR FM Reference Document Number CHAR 10 0 FM_XDOCNR
FMXYEAR FM Reference Year NUMC 4 0 FM_XYEAR
FMXDOCLN FM Reference Line Item NUMC 6 0 FM_XDOCLN
FMXZEKKN FM Reference Sequence Account Assignment NUMC 5 0 FM_XZEKKN
BUDGET_PERIOD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
PARTNER_BUDGET_PERIOD FM: Partner Budget Period CHAR 10 0 * FM_PBUDGET_PERIOD
FLG_BUD_PD_NOT_VALID Fund/Budget Period for Posting Date Not Valid CHAR 1 0 FM_FLG_FUND_BUDPD_NOT_VALID
ORDER_GRP Order Group CHAR 15 0 AUFGR
COST_CENTER_GRP Cost Center Group CHAR 15 0 KSGRU
COST_ELEMENT_GRP Cost Element Group CHAR 15 0 KAGRU
WBS_ELEMENT_GRP WBS element group CHAR 15 0 POSIDGR

FMDERIVE foreign key relationships

Table Field Check Table Check Field
0 FMDERIVE ACCOUNT_NUMBER SKA1 G/L Account Master (Chart of Accounts) MANDT
0 FMDERIVE ACCOUNT_NUMBER SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 FMDERIVE ACCOUNT_NUMBER SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 FMDERIVE ASSET ANLA Asset Master Record Segment BUKRS
1 FMDERIVE ASSET ANLA Asset Master Record Segment ANLN1
1 FMDERIVE ASSET ANLA Asset Master Record Segment ANLN2
0 FMDERIVE ASSETTRTYP TABW Asset transaction types MANDT
1 FMDERIVE BUILDING_NUMBER VIOB03 Real estate building master MANDT
1 FMDERIVE BUILDING_NUMBER VIOB03 Real estate building master BUKRS
1 FMDERIVE BUILDING_NUMBER VIOB03 Real estate building master SGENR
0 FMDERIVE BUSINESS_ENTITY VIOB01 Business entities MANDT
0 FMDERIVE BUSINESS_ENTITY VIOB01 Business entities BUKRS
1 FMDERIVE BUS_AREA TGSB Business Areas MANDT
1 FMDERIVE BUS_AREA TGSB Business Areas GSBER
0 FMDERIVE COSTOBJECT CKPH Master Record: Cost Object ID Number MANDT
0 FMDERIVE COSTOBJECT CKPH Master Record: Cost Object ID Number KSTRG
0 FMDERIVE COSTOBJECT CKPH Master Record: Cost Object ID Number DATBI
1 FMDERIVE COST_ELEMENT CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
1 FMDERIVE COST_ELEMENT CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
0 FMDERIVE CO_AREA TKA01 Controlling Areas MANDT
1 FMDERIVE CO_BUSPROC CBPR CO-ABC: Activity Master Table KOKRS
1 FMDERIVE CO_BUSPROC CBPR CO-ABC: Activity Master Table PRZNR
1 FMDERIVE CO_BUSPROC CBPR CO-ABC: Activity Master Table DATBI
0 FMDERIVE FM_AREA FM01 Financial Management Areas FIKRS
1 FMDERIVE FUND_TYP FMFUNDTYPE FM Fund Types MANDT
1 FMDERIVE FUND_TYP FMFUNDTYPE FM Fund Types FM_AREA
0 FMDERIVE HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
0 FMDERIVE HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
1 FMDERIVE MOVE_TYPE T156 Movement Type MANDT
1 FMDERIVE MOVE_TYPE T156 Movement Type BWART
0 FMDERIVE ORDER_NUMBER AUFK Order master data AUFNR
1 FMDERIVE ORDER_NUMBER_NV AFVC Operation within an order AUFPL
1 FMDERIVE ORDER_NUMBER_NV AFVC Operation within an order APLZL
0 FMDERIVE ORDER_POSNR_NV AFVC Operation within an order AUFPL
0 FMDERIVE ORDER_POSNR_NV AFVC Operation within an order APLZL
1 FMDERIVE PARTNER_FUND_TYP FMFUNDTYPE FM Fund Types MANDT
1 FMDERIVE PARTNER_FUND_TYP FMFUNDTYPE FM Fund Types FM_AREA
0 FMDERIVE PART_PRCTR CEPC Profit Center Master Data Table PRCTR
0 FMDERIVE PART_PRCTR CEPC Profit Center Master Data Table DATBI
0 FMDERIVE PART_PRCTR CEPC Profit Center Master Data Table KOKRS
1 FMDERIVE PERSL TFK001P Period key MANDT
1 FMDERIVE PERSL TFK001P Period key PERSL
0 FMDERIVE PROPERTY_NUMBER VIOB02 Property master data MANDT
0 FMDERIVE PROPERTY_NUMBER VIOB02 Property master data BUKRS
0 FMDERIVE PROPERTY_NUMBER VIOB02 Property master data SGRNR
1 FMDERIVE RES_ITEM KBLP Document Item: Manual Document Entry MANDT
1 FMDERIVE RES_ITEM KBLP Document Item: Manual Document Entry BELNR
0 FMDERIVE SPEC_STOCK T148 Special Stock Indicator MANDT
0 FMDERIVE SPEC_STOCK T148 Special Stock Indicator SOBKZ
1 FMDERIVE SUB_ASSET ANLA Asset Master Record Segment BUKRS
1 FMDERIVE SUB_ASSET ANLA Asset Master Record Segment ANLN1
1 FMDERIVE SUB_ASSET ANLA Asset Master Record Segment ANLN2
0 FMDERIVE TRANSAC TJ01 Business Transactions VRGNG
1 FMDERIVE TR_PART_BA TGSB Business Areas MANDT
1 FMDERIVE TR_PART_BA TGSB Business Areas GSBER
0 FMDERIVE TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
0 FMDERIVE TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
1 FMDERIVE VAL_CLASS T025 Valuation Classes MANDT
1 FMDERIVE VAL_CLASS T025 Valuation Classes BKLAS
0 FMDERIVE VAL_TYPE T149D Global Valuation Types MANDT
0 FMDERIVE VAL_TYPE T149D Global Valuation Types BWTAR