1. Home
  2. Resources
  3. SAP Tables
  4. FMFIX - Line Items from FI Documents - Enhanced

SAP Table FMFIX

Line Items from FI Documents - Enhanced

FMFIX (Line Items from FI Documents - Enhanced) 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 FMFIX to other SAP tables.

FMFIX table fields

Field Data element Checktable Datatype Length Decimals
FONDS Fund BP_GEBER FMFINCODE CHAR 10 0
FICTR Funds Center FM_FICTR FMFCTR CHAR 16 0
FIPEX Commitment Item FM_FIPEX FMCI CHAR 24 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
FMBELNR Document Number of FM Line Item FM_BELNR CHAR 10 0
FMBUZEI Number of a posting line in a TR-FM line item FM_BUZEI NUMC 3 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)
WTEXT Val.type name FM_WRTTPT CHAR 40 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
BTEXT Name of amount type FM_BTARTT CHAR 40 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)
STATT Name of statistics indicator FM_STATST CHAR 40 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
BLART Document Type BLART T003 CHAR 2 0
GJAHR Fiscal Year GJAHR NUMC 4 0
GNJHR Year of Cash Effectivity GNJHR NUMC 4 0
PERIO Period CO_PERIO NUMC 3 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
ZHLDT Funds Management - Update Date FM_ZHLDT DATS 8 0
PSOBT Posting Day PSOBT DATS 8 0
TRANR Funds Management Transaction Number FM_TRANR CHAR 16 0
CTRNR Funds Management Control Number FM_CTRNR CHAR 20 0
BUKRS Company Code BUKRS T001 CHAR 4 0
HKONT General Ledger Account HKONT SKA1 CHAR 10 0
SGTXT Item Text SGTXT CHAR 50 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 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
FAREA Functional Area FM_FAREA TFKB CHAR 16 0
FTEXT Name of the functional area FKBTX CHAR 25 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
KTEXT General Name KTEXT CHAR 20 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
ATEXT Description AUFTEXT CHAR 40 0
POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
POST1 PS: Short description (1st text line) PS_POST1 CHAR 40 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
PRCTRT General Name KTEXT CHAR 20 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
VORNR Operation/Activity Number VORNR CHAR 4 0
FWAER FM area currency FMWAER TCURC CUKY 5 0
FKBTRC Amount to be checked against commt budget, in FM area crcy FM_FKBTRCM CURR 15 2
FKBTRP Amount to be checked against payment budget, in FM area crcy FM_FKBTRPY CURR 15 2
TWAER Transaction Currency TWAER TCURC CUKY 5 0
TRBTRC Amount to be checked against commt budget, in trans.crcy FM_TRBTRCM CURR 15 2
TRBTRP Amount to be checked against the paymt budget, in trans crcy FM_TRBTRPY CURR 15 2
SKNTO Cash discount amount in local currency SKNTO CURR 13 2
RDIFF Exchange Rate Gain/Loss Realized RDIFF CURR 13 2
XREVS Cancelation flag STNKZ CHAR 1 0
VRGNG CO Business Transaction CO_VORGANG TJ01 CHAR 4 0
VTEXT Name of CO transaction FM_VRGNGT CHAR 30 0
AWTYP Reference Transaction AWTYP TTYP CHAR 5 0
AWREF RW document number FM_AWREF CHAR 10 0
AWORG Reference Organizational Units AWORG CHAR 10 0
AWSYS Logical system of source document AWSYS TBDLS CHAR 10 0
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
VRFPOS Predecessor document item FM_VRFPOS NUMC 5 0
VRFKNT Predecessor account assignment FM_VRFKNT NUMC 5 0
CF_FLAG Carryforwards at year-end closing FM_CF_FLAG CHAR 1 0
X Yes
NULL No
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
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
USERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM CHAR 10 0
STUNR Number that clearly identifies the line key in database FM_STUNR CHAR 16 0
PERIO7 Period/year JAHRPER NUMC 7 0
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)
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD FMBUDGETPD CHAR 10 0
BUS_AREA Business Area GSBER CHAR 4 0

FMFIX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMFIX AUFNR SYST MANDT AUFK Order master data MANDT
FMFIX AUFNR FMFIX AUFNR AUFK Order master data AUFNR
FMFIX AWSYS FMFIX AWSYS TBDLS Logical system LOGSYS
FMFIX AWTYP FMFIX AWTYP TTYP Object Types for Accounting AWTYP
FMFIX BLART SYST MANDT T003 Document Types MANDT
FMFIX BLART FMFIX BLART T003 Document Types BLART
FMFIX BUDGET_PD SYST MANDT FMBUDGETPD FM: Budget Period Master Data MANDT
FMFIX BUDGET_PD FMFIX BUDGET_PD FMBUDGETPD FM: Budget Period Master Data BUDGET_PD
FMFIX BUKRS SYST MANDT T001 Company Codes MANDT
FMFIX BUKRS FMFIX BUKRS T001 Company Codes BUKRS
FMFIX FAREA FMFIX FAREA TFKB Functional areas FKBER
FMFIX FAREA SYST MANDT TFKB Functional areas MANDT
FMFIX FICTR * FMFCTR Funds Center Master Record DATBIS
FMFIX FICTR SYST MANDT FMFCTR Funds Center Master Record MANDT
FMFIX FICTR FKRS FIKRS FMFCTR Funds Center Master Record FIKRS
FMFIX FICTR FMFIX FICTR FMFCTR Funds Center Master Record FICTR
FMFIX FIPEX * FMCI Commitment items master data FIKRS
FMFIX FIPEX FMFIX FIPEX FMCI Commitment items master data GJAHR
FMFIX FIPEX SYST MANDT FMCI Commitment items master data .INCLUDE
FMFIX FIPEX FKRS FIKRS FMCI Commitment items master data MANDT
FMFIX FONDS SYST MANDT FMFINCODE FIFM: Financing code MANDT
FMFIX FONDS FKRS FIKRS FMFINCODE FIFM: Financing code FIKRS
FMFIX FONDS FMFIX FONDS FMFINCODE FIFM: Financing code FINCODE
FMFIX FWAER SYST MANDT TCURC Currency Codes MANDT
FMFIX FWAER FMFIX FWAER TCURC Currency Codes WAERS
FMFIX HKONT SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
FMFIX HKONT * SKA1 G/L Account Master (Chart of Accounts) KTOPL
FMFIX HKONT FMFIX HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
FMFIX KOKRS SYST MANDT TKA01 Controlling Areas MANDT
FMFIX KOKRS FMFIX KOKRS TKA01 Controlling Areas KOKRS
FMFIX KOSTL FMFIX KOSTL CSKS Cost Center Master Data KOSTL
FMFIX KOSTL * CSKS Cost Center Master Data DATBI
FMFIX KOSTL SYST MANDT CSKS Cost Center Master Data MANDT
FMFIX KOSTL FMFIX KOKRS CSKS Cost Center Master Data KOKRS
FMFIX KUNNR FMFIX KUNNR KNA1 General Data in Customer Master KUNNR
FMFIX KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
FMFIX LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
FMFIX LIFNR FMFIX LIFNR LFA1 Vendor Master (General Section) LIFNR
FMFIX PRCTR FMFIX PRCTR CEPC Profit Center Master Data Table PRCTR
FMFIX PRCTR * CEPC Profit Center Master Data Table DATBI
FMFIX PRCTR FMFIX KOKRS CEPC Profit Center Master Data Table KOKRS
FMFIX PRCTR SYST MANDT CEPC Profit Center Master Data Table MANDT
FMFIX TWAER SYST MANDT TCURC Currency Codes MANDT
FMFIX TWAER FMFIX TWAER TCURC Currency Codes WAERS
FMFIX VRGNG FMFIX VRGNG TJ01 Business Transactions VRGNG