1. Home
  2. Resources
  3. SAP Tables
  4. FMIOI - Commitment Documents Funds Management

SAP Table FMIOI

Commitment Documents Funds Management

FMIOI (Commitment Documents Funds Management) 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 FMIOI to other SAP tables.

FMIOI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
REFBN Reference Document Number CO_REFBN CHAR 10 0
REFBT Reference document category FM_REFBTYP NUMC 3 0
010 Purchase requisitions
020 Purchase orders
110 Earmarked Funds
910 FI documents
900 Parked documents
040 Trips
920 CO documents
050 Sales Order Predecessor Document
060 Sales Orders
RFORG Reference Organizational Units AWORG CHAR 10 0
RFPOS Item number of reference document CC_RFPOS NUMC 5 0
RFKNT Account assignment number of reference document CC_RFKNT NUMC 5 0
RFETE Reference document classification number CC_RFETE NUMC 4 0
RCOND Counter Conditions and Level Number RCOND NUMC 5 0
RFTYP Reference Transaction AWTYP CHAR 5 0
RFSYS Logical System LOGSYSTEM CHAR 10 0
BTART Amount type FM_BTART CHAR 4 0
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
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 RLDNR T881 CHAR 2 0
GJAHR Fiscal Year GJAHR NUMC 4 0
STUNR Number that clearly identifies the line key in database FM_STUNR CHAR 16 0
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
HKONT General Ledger Account HKONT CHAR 10 0
ERLKZ Completed Indicator for Open Items ERLKZ CHAR 1 0
NULL Open
F Reduced
X Completed
LOEKZ Deletion Indicator KBLLOEKZ CHAR 1 0
NULL Not Selected
X Selected
FIKRS Financial Management Area FIKRS FM01 CHAR 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
BL_DOC_TYPE FM budgetary ledger document type FM_BL_DOC_TYPE CHAR 4 0
DP_WITH_PO FM Down payment with reference to purchase order for BL FM_DP_WITH_PO CHAR 1 0
NULL Down payment without reference to a purchase order
X Down payment with reference to a purchase order
VREFBT Predecessor document category FM_VREFBT NUMC 3 0
010 Purchase requisitions
020 Purchase orders
110 Earmarked Funds
910 FI documents
900 Parked documents
040 Trips
920 CO documents
050 Sales Order Predecessor Document
060 Sales Orders
VREFBN Predecessor document number FM_VREFBN CHAR 10 0
VRFORG Predecessor document organization FM_VRFORG CHAR 10 0
VRFPOS Predecessor document item FM_VRFPOS NUMC 5 0
VRFKNT Predecessor account assignment FM_VRFKNT NUMC 5 0
VRFTYP Reference Transaction AWTYP CHAR 5 0
VRFSYS Logical System LOGSYSTEM CHAR 10 0
ITCNACT FM: Change with active CCN functionality FM_ITCNACT CHAR 1 0
X Yes
NULL No
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
USNAM User name USNAM CHAR 12 0
TCODE Transaction Code TCODE CHAR 20 0
BLDOCDATE Budgetary Ledger Document Date FM_BL_DOCDATE DATS 8 0
QUANT_OPEN Quantity MENGE_D QUAN 13 3
QUANT_INV Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
KUNNR Customer Number KUNNR CHAR 10 0

FMIOI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMIOI BUKRS FMIOI MANDT T001 Company Codes MANDT
FMIOI BUKRS FMIOI BUKRS T001 Company Codes BUKRS
FMIOI FAREA SY MANDT TFKB Functional areas MANDT
FMIOI FAREA FMIOI FAREA TFKB Functional areas FKBER
FMIOI FIKRS FMIOI MANDT FM01 Financial Management Areas MANDT
FMIOI FIKRS FMIOI FIKRS FM01 Financial Management Areas FIKRS
FMIOI FISTL FMIOI MANDT FMFCTR Funds Center Master Record MANDT
FMIOI FISTL FMIOI FIKRS FMFCTR Funds Center Master Record FIKRS
FMIOI FISTL FMIOI FISTL FMFCTR Funds Center Master Record FICTR
FMIOI FISTL FMIOI BUDAT FMFCTR Funds Center Master Record DATBIS
FMIOI FONDS FM01 FIKRS FMFINCODE FIFM: Financing code FIKRS
FMIOI FONDS FMIOI FONDS FMFINCODE FIFM: Financing code FINCODE
FMIOI FONDS SY MANDT FMFINCODE FIFM: Financing code MANDT
FMIOI LIFNR FMIOI MANDT LFA1 Vendor Master (General Section) MANDT
FMIOI LIFNR FMIOI LIFNR LFA1 Vendor Master (General Section) LIFNR
FMIOI MANDT FMIOI MANDT T000 Clients MANDT
FMIOI MEINS * T006 Units of Measurement MANDT
FMIOI MEINS FMIOI MEINS T006 Units of Measurement MSEHI
FMIOI OBJNRZ FMIOI OBJNRZ ONR00 General Object Number OBJNR
FMIOI OBJNRZ FMIOI MANDT ONR00 General Object Number MANDT
FMIOI RLDNR FMIOI MANDT T881 Ledger Master MANDT
FMIOI RLDNR FMIOI RLDNR T881 Ledger Master RLDNR
FMIOI TWAER FMIOI MANDT TCURC Currency Codes MANDT
FMIOI TWAER FMIOI TWAER TCURC Currency Codes WAERS
FMIOI VRGNG FMIOI VRGNG TJ01 Business Transactions VRGNG
FMIOI ZZREGION SYST MANDT ZREG User Defined Regions MANDT
FMIOI ZZREGION FMIOI ZZREGION ZREG User Defined Regions ZZREGION
FMIOI ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
FMIOI ZZSPREG FMIOI ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
FMIOI ZZSTATE FMIOI ZZSTATE T005S Taxes: Region (Province) Key BLAND
FMIOI ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
FMIOI ZZSTATE * T005S Taxes: Region (Province) Key LAND1
FMIOI ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT
FMIOI ZZUSERFLD1 FMIOI ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1