SAP table FMIOI (Commitment Documents Funds Management)

SAP table FMIOI has 14 primary key fields being MANDT,REFBN,REFBT,RFORG,RFPOS,RFKNT,RFETE,RCOND,RFTYP,RFSYS,BTART,RLDNR,GJAHR,STUNR.

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 T000 MANDT
REFBN Reference Document Number CHAR 10 0 CO_REFBN
REFBT Reference Document Category NUMC 3 0 FM_REFBTYP
010 Purchase requisitions
020 Purchase orders
040 Trips
050 Sales Order Predecessor Document
060 Sales Orders
110 Earmarked Funds
900 Parked documents
910 FI documents
920 CO documents
RFORG Reference Organizational Units CHAR 10 0 AWORG
RFPOS Item Number of Reference Document NUMC 5 0 CC_RFPOS
RFKNT Account Assignment Number of Reference Document NUMC 5 0 CC_RFKNT
RFETE Reference Document Classification Number NUMC 4 0 * CC_RFETE
RCOND Counter Conditions and Level Number NUMC 5 0 RCOND
RFTYP Reference procedure CHAR 5 0 * AWTYP
RFSYS Logical System CHAR 10 0 * LOGSYSTEM
BTART Amount Type CHAR 4 0 FM_BTART
0100 Original
0110 Approved in Workflow (Workflow ledger 9D only)
0120 Not approved in Workflow (Workflow ledger 9D only)
0150 Change
0200 Reduction
0210 Reduction Cheque Clearing
0220 Change by Revaluation
0250 Paid
0260 Paid Cheque Clearing
0270 Paid Credit Memo
0300 Previous Year Carryforward (Commitments)
0350 Following year carryforward (commitments)
0351 Commitment Carryforward: Carryforward Consumed Amount
0352 Commitment Carryforward: Reduction of Consumed Amount
0360 Balance from Previous Years
0400 Block Entry
0500 Adjustment by Follow-on Document
0600 Reassignment Sender
0650 Reassignment Receiver
0700 Settlement of Retirements
0750 Settlement of Acquisitions
RLDNR Ledger CHAR 2 0 T881 RLDNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
STUNR Number That Clearly Identifies the Line Key in Database CHAR 16 0 FM_STUNR
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
HKONT General Ledger Account CHAR 10 0 * HKONT
ERLKZ Completed Indicator for Open Items CHAR 1 0 ERLKZ
Open
F Reduced
X Completed
LOEKZ Deletion Indicator CHAR 1 0 KBLLOEKZ
FIKRS Financial Management Area CHAR 4 0 FM01 FIKRS
BUDAT Posting Date in the Document DATS 8 0 BUDAT
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
BL_DOC_TYPE FM budgetary ledger document type CHAR 4 0 FM_BL_DOC_TYPE
DP_WITH_PO FM Down payment with reference to purchase order for BL CHAR 1 0 FM_DP_WITH_PO
Down payment without reference to a purchase order
X Down payment with reference to a purchase order
VREFBT Predecessor Document Category NUMC 3 0 FM_VREFBT
VREFBN Predecessor Document Number CHAR 10 0 FM_VREFBN
VRFORG Predecessor Document Organization CHAR 10 0 FM_VRFORG
VRFPOS Predecessor Document Item NUMC 5 0 FM_VRFPOS
VRFKNT Predecessor Account Assignment NUMC 5 0 FM_VRFKNT
VRFTYP Reference procedure CHAR 5 0 * AWTYP
VRFSYS Logical System CHAR 10 0 * LOGSYSTEM
ITCNACT FM: Change with Active CCN Functionality CHAR 1 0 FM_ITCNACT
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
USNAM User Name CHAR 12 0 * USNAM
TCODE Transaction Code CHAR 20 0 * TCODE
BLDOCDATE Budgetary Ledger Document Date DATS 8 0 FM_BL_DOCDATE
QUANT_OPEN Quantity QUAN 13 3 MENGE_D
QUANT_INV Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
KUNNR Customer Number CHAR 10 0 KUNNR

FMIOI foreign key relationships

Table Field Check Table Check Field
0 FMIOI BUKRS T001 Company Codes BUKRS
1 FMIOI FAREA TFKB Functional areas FKBER
0 FMIOI FIKRS FM01 Financial Management Areas FIKRS
1 FMIOI FISTL FMFCTR Funds Center Master Record FIKRS
1 FMIOI FISTL FMFCTR Funds Center Master Record DATBIS
0 FMIOI FONDS FMFINCODE FIFM: Financing code FIKRS
0 FMIOI FONDS FMFINCODE FIFM: Financing code FINCODE
1 FMIOI LIFNR LFA1 Supplier Master (General Section) MANDT
1 FMIOI LIFNR LFA1 Supplier Master (General Section) LIFNR
0 FMIOI MANDT T000 Clients MANDT
1 FMIOI MEINS T006 Units of Measurement MSEHI
0 FMIOI OBJNRZ ONR00 General Object Number MANDT
0 FMIOI OBJNRZ ONR00 General Object Number OBJNR
1 FMIOI RLDNR T881 Ledger Master MANDT
0 FMIOI TWAER TCURC Currency Codes MANDT
0 FMIOI TWAER TCURC Currency Codes WAERS
1 FMIOI VRGNG TJ01 Business Transactions VRGNG