1. Home
  2. Resources
  3. SAP Tables
  4. FMIDATA - Common Data for Funds Management Actual Data

SAP Table FMIDATA

Common Data for Funds Management Actual Data

FMIDATA (Common Data for Funds Management Actual Data) 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 FMIDATA to other SAP tables.

Source: FMIDATA (Common Data for Funds Management Actual Data)

FMIDATA table fields

Field Data element Checktable Datatype Length Decimals
ZHLDT Funds Management - Update Date FM_ZHLDT DATS 8 0
GNJHR Year of Cash Effectivity GNJHR NUMC 4 0
PERIO Period CO_PERIO NUMC 3 0
CFSTAT FM Commitment Carryforward: Status FM_CFST NUMC 2 0
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) FM_CFSTSV NUMC 2 0
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
CFCNT Year-End Closing: Number of Transfers FM_CFCNT NUMC 2 0
OBJNRZ Object number J_OBJNR ONR00 CHAR 22 0
TRBTR Amount in transaction currency FM_TRBTR CURR 13 2
FKBTR Amount in FM area currency FM_FKBTR CURR 13 2
FISTL Funds Center FISTL FMFCTR CHAR 16 0
FONDS Fund BP_GEBER FMFINCODE CHAR 10 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0
FAREA Functional Area FM_FAREA TFKB CHAR 16 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
BUS_AREA Business Area GSBER CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
WRTTP Value Type FM_WRTTP CHAR 2 0
50 Purchase Requisitions
51 Purchase Orders
52 Business Trip Commitments
54 Invoices
57 Payments
58 Down Payment Requests
60 Parked Documents
6B Clarification Worklist FI-CA
61 Down Payments
64 Funds Transfers
65 Funds Commitment
66 Transfer Postings
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 CO_VORGANG TJ01 CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
STATS Funds Management Statistical Indicator FM_STATS CHAR 1 0
NULL Real (Budget Relevant)
X Statistical (not budget-relevant, no FYC)
Y Statistical (not budget relevant, relevant for FYC)
TWAER Transaction Currency TWAER TCURC CUKY 5 0
CFLEV Carryforward level FM_CFLEV CHAR 1 0
NULL Document and Predecessor not Carried Forward
X X Document or Predecessor Carried Forward
U U Customer Flag: Document or Predecessor Carried Forward
0 Customer Specification: Number of Carryforwards
SGTXT Item Text SGTXT CHAR 50 0
TRANR Funds Management Transaction Number FM_TRANR CHAR 16 0
CTRNR Funds Management Control Number FM_CTRNR CHAR 20 0
USERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM CHAR 10 0
FMVOR Classification of Document Lines FMVOR CHAR 4 0
ADUP Commitment Increase
ADDN Commitment Decrease
PAMG Purchase Account Processing
PD01 Price Difference, General
PD02 Price Difference, Relevant with Quantity
SC01 Subcontracting, Clearing
SC02 Subcontracting, Material Offsetting Posting
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0

FMIDATA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMIDATA BUKRS FMIDATA BUKRS T001 Company Codes BUKRS
FMIDATA BUKRS SY MANDT T001 Company Codes MANDT
FMIDATA FAREA SY MANDT TFKB Functional areas MANDT
FMIDATA FAREA FMIDATA FAREA TFKB Functional areas FKBER
FMIDATA FISTL * FMFCTR Funds Center Master Record DATBIS
FMIDATA FISTL FMIDATA FISTL FMFCTR Funds Center Master Record FICTR
FMIDATA FISTL FM01 FIKRS FMFCTR Funds Center Master Record FIKRS
FMIDATA FISTL SY MANDT FMFCTR Funds Center Master Record MANDT
FMIDATA FONDS FM01 FIKRS FMFINCODE FIFM: Financing code FIKRS
FMIDATA FONDS FMIDATA FONDS FMFINCODE FIFM: Financing code FINCODE
FMIDATA FONDS SY MANDT FMFINCODE FIFM: Financing code MANDT
FMIDATA OBJNRZ SY MANDT ONR00 General Object Number MANDT
FMIDATA OBJNRZ FMIDATA OBJNRZ ONR00 General Object Number OBJNR
FMIDATA TWAER SY MANDT TCURC Currency Codes MANDT
FMIDATA TWAER FMIDATA TWAER TCURC Currency Codes WAERS
FMIDATA VRGNG FMIDATA VRGNG TJ01 Business Transactions VRGNG
FMIDATA ZZREGION FMIDATA ZZREGION ZREG User Defined Regions ZZREGION
FMIDATA ZZREGION SYST MANDT ZREG User Defined Regions MANDT
FMIDATA ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
FMIDATA ZZSPREG FMIDATA ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
FMIDATA ZZSTATE FMIDATA ZZSTATE T005S Taxes: Region (Province) Key BLAND
FMIDATA ZZSTATE * T005S Taxes: Region (Province) Key LAND1
FMIDATA ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
FMIDATA ZZUSERFLD1 FMIDATA ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1
FMIDATA ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT