SAP Table FMIFIIT

FI Line Item Table in Funds Management

FMIFIIT (FI Line Item Table in 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 FMIFIIT to other SAP tables.

FMIFIIT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FMBELNR Document Number of FM Line Item FM_BELNR FMIFIHD CHAR 10 0
FIKRS Financial Management Area FIKRS FM01 CHAR 4 0
FMBUZEI Number of a posting line in a TR-FM line item FM_BUZEI NUMC 3 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 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
VOBUKRS Company code for payment document number FM_VOBUKRS CHAR 4 0
VOGJAHR Fiscal year for payment document number FM_VOGJAHR NUMC 4 0
VOBELNR Payment Document Number FM_VOBELNR CHAR 10 0
VOBUZEI Item for payment document number FM_VOBUZEI NUMC 3 0
KNGJAHR Fiscal year for FI document number FM_KNGJAHR NUMC 4 0
KNBELNR FI document number FM_KNBELNR CHAR 10 0
KNBUZEI Document item for FI document number FM_KNBUZEI NUMC 3 0
SKNTO Cash discount amount in local currency SKNTO CURR 13 2
RDIFF Exchange Rate Gain/Loss Realized RDIFF CURR 13 2
PAYFLG Payment Status of FM Documents FM_PAYFLG CHAR 1 0
A Cleared payment without invoice reference
C Open cross-company code payment without invoice reference
D Reversed cross-company code payment without invoice
O Open payment without invoice reference
X Document is completed for the payment transfer
Y Document to be processed with payment transfer (original)
Z Reversal Records PBET
NULL Document to be processed with payment transfer (extended)
N Document was processed with payment transfer (extended)
PSOBT Posting Day PSOBT DATS 8 0
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
VBUND Company ID of trading partner RASSC CHAR 6 0
XREF3 Reference key for line item XREF3 CHAR 20 0
PUMETH Payment Update Procedure in FM PUMETH CHAR 4 0
S200 Conventional Payment Selection
FMPU Online Payment Update
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
FMXDOCNR FM Reference Document Number FM_XDOCNR CHAR 10 0
FMXYEAR FM Reference Year FM_XYEAR NUMC 4 0
FMXDOCLN FM Reference Line Item FM_XDOCLN NUMC 6 0
FMXZEKKN FM Reference Sequence Account Assignment FM_XZEKKN NUMC 5 0

FMIFIIT foreign key relationships

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