SAP table FM01D (Funds Management Update Control)

SAP table FM01D has 3 primary key fields being MANDT,FIKRS,APPLC.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
FIKRS Financial Management Area CHAR 4 0 FM01 FIKRS
APPLC Funds Management Application Indicator CHAR 1 0 FM_APPLC
BEG_INV Start Year for Cash Budget Management Balances NUMC 4 0 FM_BEG_INV
END_INV Last Year for Cash Budget Management Balances NUMC 4 0 FM_END_INV
CIACC Assignment of FM Account Assignment to Account Is Binding CHAR 1 0 FM_CIACC
COACC Assignment of FM-CO Account Assignment Is Binding CHAR 1 0 FM_COACC
FLG_PODATE Date Purchase Order Was Recorded CHAR 1 0 FM_PODATE
FLG_MWST Control on Recording of Tax CHAR 1 0 FM_MWST
FLG_WERE Goods Receipt/Invoice Receipt Flag CHAR 1 0 FM_WERE
FLG_AUTO Control Lines Generated Automatically CHAR 1 0 FM_AUTO
FLG_INDATE Date Invoice Recorded CHAR 1 0 FM_INDATE
FLG_PADATE Date Payment Was Recorded CHAR 1 0 FM_PADATE
FLG_PRDATE Purchase Requisition Update Date CHAR 1 0 FM_PRDATE
FLG_WAKNT Acct Assignment Type for Goods Issue CHAR 1 0 FM_WAKNT
FLG_BEKNT Account Assignment Type for Unassigned Purchase Orders CHAR 1 0 FM_BEKNT
FLG_PAYM Payment Conversion CHAR 1 0 FM_PAYM
FLG_PAYM_RC Activate Payment Match CHAR 1 0 FM_PAYM_RC
FLG_PAYM_RC_DEL Delete Payments on Accounts Without Invoice Reference CHAR 1 0 FM_PAYM_RC_DEL
FLG_PAYM_RC_66 Evaluate Expenditure Transfer Postings with Payment Matching CHAR 1 0 FLG_PAYM_RC_66
FLG_CFPAY Deactivate Check on Fiscal Year Change CHAR 1 0 FM_CFPAY
FLG_SPLIT Activate Splitting Procedure for Payment Conversion CHAR 1 0 FM_SPLIT
FM_DP_DIT Activate Conversion of Bank Clearings (80-90) CHAR 1 0 FM_DP_DIT
CFLEV_OI Use Commitment Documents to Determine Carrforward Level CHAR 1 0 FM_CFLEVOI
CFLEV_FI Use Invoices to Determine Carryforward Level CHAR 1 0 FM_CFLEVFI
FM_PAYM_FISTL Funds Center for Payment Transfer Without Invoice Reference CHAR 16 0 FMFCTR FM_PAYM_FISTL
FM_PAYM_FIPEX Commitment Item for Payment Transfer Without Invoice Ref. CHAR 24 0 FMCI FM_PAYM_FIPEX
FM_MONTH_CLOSING Period for Period-End Closing NUMC 2 0 FM_MONTH_CLOSING
FM_YEAR_CLOSING Fiscal Year for Period-End Closing NUMC 4 0 FM_YEAR_CLOSING
FM_PAYTR_PARAL Number of Parallel Processes for Payment Processing NUMC 2 0 FM_PAYTR_PARAL
FM_PAYTR_DEST RFC Server Group for Parallel Background Processing CHAR 20 0 FM_PAYTR_DEST
FM_PAYTR_SDOC_1 Doc Interval for Preferred Handling of Parallelization CHAR 10 0 FM_PAYTR_DOCS
FM_PAYTR_EDOC_1 Doc Interval for Preferred Handling of Parallelization CHAR 10 0 FM_PAYTR_DOCS
FM_PAYTR_NPARA_1 Number of Parallel Processes for Payment Processing NUMC 2 0 FM_PAYTR_PARAL
FM_PAYM_S200_NRC Activated RFFMS200 with Original Functions CHAR 1 0 FM_PAYM_S200_NRC
FM_PAYM_S200_RC Activated RFFMS200 with Enhanced Function CHAR 1 0 FM_PAYM_S200_RC
PCACC Activity/Component Account Assignment in PM Order Activated CHAR 1 0 FM_PCACC
FM_USEREAL Indicator: Use Real CO Object to derive FM Assignment CHAR 1 0 FM_USEREAL
XSEC_CURRENCY Company Code Currency Corresponding to FM Area Currency CHAR 1 0 FM_CURRENCY
FM_PAYM_CM_UPD Control Update of Credit Memos CHAR 1 0 FM_PAYM_CMEM_UPD
Payment Records with Payment Type 'Paid'
X Payment Records with Payment Type 'Paid Credit Memo'
FLG_TAX_TO_GL Adjust Tax Update in GL to FM CHAR 1 0 FM_FLG_TAX_TO_GL
FLG_MULTIANNUAL Budget for all Years CHAR 1 0 FM_MULTIANNUAL_FMUPDATE
FLG_AK_PAYM_FICA Transfer Payments on Account from Contract A/R & A/P CHAR 1 0 FLG_AK_PAYM_FICA
FLG_AK_PAYM_FIAR Payments on Account from Accts Payable/Receivable Accounting CHAR 1 0 FLG_AK_PAYM_FIAR
FLG_FM_CURTP Assign Local Currency of Company Codes to FM Area CHAR 2 0 FLG_FM_CURTP
10 Company Code Currency
11 Company Code Currency, Group Valuation
12 Company Code Currency, Profit Center Valuation
20 Controlling Area Currency
30 Group Currency
31 Group Currency, Group Valuation
32 Group Currency, Profit Center Valuation
40 Hard Currency
50 Index-Based Currency
60 Global Company Currency
FLG_SDOR_UPDATE Indicator: Deactivate Sales Order Update CHAR 1 0 FM_SDOR_UPDATE
FM_PAYM_PUR Activates the Online Payment Update (document splitting) CHAR 1 0 FM_PAYM_PUR
FM_DTACT_PUR Online Payment Update in FM: Activation Date DATS 8 0 FM_DTACT_PUR
FM_PO_ADJ_INV Adjust Only Using Invoice Unit Price CHAR 1 0 FM_PO_ADJ_INV_ONLY
FM_USE_INV_COMPL Reduce Purchase Order if Final Invoice Selected CHAR 1 0 FM_USE_INV_COMPL
FM_NO_PO_REVAL Indicator: Deactivate Purchase Order Revaluation CHAR 1 0 FM_NO_PO_REVAL
FM_PAYM_PUR_OFF Deactivates Online Payment Update (Document Distribution) CHAR 1 0 FM_PAYM_PUR_OFF
FLG_BTC_CL Cash Budget Management: Clearing posted in batch CHAR 1 0 CBM_BTC_CL

FM01D foreign key relationships

Table Field Check Table Check Field
0 FM01D FIKRS FM01 Financial Management Areas FIKRS
1 FM01D FM_PAYM_FIPEX FMCI Commitment items master data .INCLUDE
1 FM01D FM_PAYM_FIPEX FMCI Commitment items master data MANDT
1 FM01D FM_PAYM_FIPEX FMCI Commitment items master data FIKRS
1 FM01D FM_PAYM_FIPEX FMCI Commitment items master data GJAHR
0 FM01D FM_PAYM_FISTL FMFCTR Funds Center Master Record FIKRS
0 FM01D FM_PAYM_FISTL FMFCTR Funds Center Master Record DATBIS