SAP table FMIDATA (Common Data for Funds Management Actual Data)

Field Description Data Type Length Decimals Checktable Data Element
ZHLDT Funds Management Update Date DATS 8 0 FM_ZHLDT
GNJHR Year of Cash Effectivity NUMC 4 0 GNJHR
PERIO Period NUMC 3 0 CO_PERIO
CFSTAT FM Commitment Carryforward: Status NUMC 2 0 FM_CFST
00
31 Carried forward to following year
32 Carried forward from previous year
41 Selected for carryforward (Workflow)
42 Carryforward Approved (Workflow)
51 Carryforward reversed
99 No commitment cfwd
CFSTATSV Year-End Closing: Status (Back Up) NUMC 2 0 FM_CFSTSV
CFCNT Year-End Closing: Number of Transfers NUMC 2 0 FM_CFCNT
OBJNRZ Object number CHAR 22 0 ONR00 J_OBJNR
TRBTR Amount in transaction currency CURR 13 2 FM_TRBTR
FKBTR Amount in FM area currency CURR 13 2 FM_FKBTR
FISTL Funds Center CHAR 16 0 FMFCTR FISTL
FONDS Fund CHAR 10 0 FMFINCODE BP_GEBER
FIPEX Commitment Item CHAR 24 0 FM_FIPEX
FAREA Functional Area CHAR 16 0 TFKB FM_FAREA
MEASURE Funded Program CHAR 24 0 FM_MEASURE
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
BUS_AREA Business Area CHAR 4 0 GSBER
PRCTR Profit Center CHAR 10 0 PRCTR
WRTTP Value Type CHAR 2 0 FM_WRTTP
50 Purchase Requisitions
51 Purchase Orders
52 Business Trip Commitments
54 Invoices
57 Payments
58 Down Payment Requests
60 Parked Documents
61 Down Payments
64 Funds Transfers
65 Funds Commitment
66 Transfer Postings
6B Clarification Worklist FI-CA
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation (Not for General Use)
95 Secondary Cost Postings (CO)
VRGNG CO Business Transaction CHAR 4 0 TJ01 CO_VORGANG
BUKRS Company Code CHAR 4 0 T001 BUKRS
STATS Funds Management Statistical Indicator CHAR 1 0 FM_STATS
Real (Budget Relevant)
X Statistical (not budget-relevant, no FYC)
Y Statistical (not budget relevant, relevant for FYC)
Z Statistical (Customer-Specific)
TWAER Transaction Currency CUKY 5 0 TCURC TWAER
CFLEV Carryforward Level CHAR 1 0 FM_CFLEV
Document and Predecessor not Carried Forward
0 Customer Specification: Number of Carryforwards
U U Customer Flag: Document or Predecessor Carried Forward
X X Document or Predecessor Carried Forward
SGTXT Item Text CHAR 50 0 SGTXT
TRANR Funds Management Transaction Number CHAR 16 0 FM_TRANR
CTRNR Funds Management Control Number CHAR 20 0 FM_CTRNR
USERDIM Customer Field for FM Actual and Commitment Data CHAR 10 0 FM_USERDIM
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
FMVOR Classification of Document Lines CHAR 4 0 FMVOR
AA01 Asset Posting, General
ACDC Standardized Documents (BSTAT = 'U' -> No BSEG)
ADDN Commitment Decrease
ADUP Commitment Increase
CR00 Correction
CR01 Correction: ADUP
CR02 Correction: ADDN
CR03 Correction: PAMG
CR04 Correction: PD01
CR05 Correction: PD02
CR06 Correction: SC01
CR07 Correction: SC02
CR08 Correction: SC03
CR09 Correction: AA01
PAMG Purchase Account Processing
PD01 Price Difference, General
PD02 Price Difference, Relevant with Quantity
SC01 Subcontracting, Clearing
SC02 Subcontracting, Material Offsetting Posting
SC03 Subcontracting, Specific
BUDGET_PD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD

FMIDATA foreign key relationships

Table Field Check Table Check Field
0 FMIDATA BUKRS T001 Company Codes BUKRS
1 FMIDATA FAREA TFKB Functional areas FKBER
0 FMIDATA FISTL FMFCTR Funds Center Master Record FIKRS
0 FMIDATA FISTL FMFCTR Funds Center Master Record DATBIS
1 FMIDATA FONDS FMFINCODE FIFM: Financing code FIKRS
1 FMIDATA FONDS FMFINCODE FIFM: Financing code FINCODE
0 FMIDATA OBJNRZ ONR00 General Object Number MANDT
0 FMIDATA OBJNRZ ONR00 General Object Number OBJNR
1 FMIDATA TWAER TCURC Currency Codes MANDT
1 FMIDATA TWAER TCURC Currency Codes WAERS
0 FMIDATA VRGNG TJ01 Business Transactions VRGNG