SAP Table FMIO

Object Table for Funds Management

FMIO (Object Table for 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 FMIO to other SAP tables.

FMIO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
OBJNR Object number for FI-SL tables GOBJNR CHAR 18 0
DATIV Posting date frm which the objct is valid for act.postings DAT_0_VON DATS 8 0
DATIB Posting date up to which the object is valid for act.postngs DAT_0_BIS DATS 8 0
DATPV Posting date frm which the objct is valid for plan postings DAT_1_VON DATS 8 0
DATPB Posting date up to which the objct is valid for plan postngs DAT_1_BIS DATS 8 0
BUKRS Company Code BUKRS T001 CHAR 4 0
FISTL Funds Center FISTL CHAR 16 0
FONDS Fund BP_GEBER CHAR 10 0
FIPEX Commitment Item FM_FIPEX CHAR 24 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)
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
GNJHR Year of Cash Effectivity GNJHR NUMC 4 0
HKONT General Ledger Account HKONT CHAR 10 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)
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
OBJNRZ Object number J_OBJNR CHAR 22 0
VRGNG CO Business Transaction CO_VORGANG CHAR 4 0
USERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM CHAR 10 0
FAREA Functional Area FM_FAREA CHAR 16 0
MEASURE Funded Program FM_MEASURE CHAR 24 0

FMIO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMIO BUKRS FMIO MANDT T001 Company Codes MANDT
FMIO BUKRS FMIO BUKRS T001 Company Codes BUKRS
FMIO MANDT FMIO MANDT T000 Clients MANDT