SAP table FMFIX (Line Items from FI Documents - Enhanced)

Field Description Data Type Length Decimals Checktable Data Element
FONDS Fund CHAR 10 0 FMFINCODE BP_GEBER
FICTR Funds Center CHAR 16 0 FMFCTR FM_FICTR
FIPEX Commitment Item CHAR 24 0 FMCI FM_FIPEX
MEASURE Funded Program CHAR 24 0 FM_MEASURE
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
FMBELNR Document Number of FM Line Item CHAR 10 0 FM_BELNR
FMBUZEI Number of a posting line in a TR-FM line item NUMC 3 0 FM_BUZEI
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)
WTEXT Value Type Name CHAR 40 0 FM_WRTTPT
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
BTEXT Name of amount type CHAR 40 0 FM_BTARTT
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)
STATT Name of statistics indicator CHAR 40 0 FM_STATST
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
BLART Document Type CHAR 2 0 T003 BLART
GJAHR Fiscal Year NUMC 4 0 GJAHR
GNJHR Year of Cash Effectivity NUMC 4 0 GNJHR
PERIO Period NUMC 3 0 CO_PERIO
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
ZHLDT Funds Management Update Date DATS 8 0 FM_ZHLDT
PSOBT Posting Day DATS 8 0 PSOBT
TRANR Funds Management Transaction Number CHAR 16 0 FM_TRANR
CTRNR Funds Management Control Number CHAR 20 0 FM_CTRNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
HKONT General Ledger Account CHAR 10 0 SKA1 HKONT
SGTXT Item Text CHAR 50 0 SGTXT
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
VOGJAHR Fiscal year for payment document number NUMC 4 0 FM_VOGJAHR
VOBELNR Payment Document Number CHAR 10 0 FM_VOBELNR
VOBUZEI Item for Payment Document Number NUMC 3 0 FM_VOBUZEI
KNGJAHR Fiscal year for FI document number NUMC 4 0 FM_KNGJAHR
KNBELNR FI document number CHAR 10 0 FM_KNBELNR
KNBUZEI Document item for FI document number NUMC 3 0 FM_KNBUZEI
FAREA Functional Area CHAR 16 0 TFKB FM_FAREA
FTEXT Name of the functional area CHAR 25 0 FKBTX
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
KTEXT General Name CHAR 20 0 KTEXT
AUFNR Order Number CHAR 12 0 AUFK AUFNR
ATEXT Description CHAR 40 0 AUFTEXT
POSID Work Breakdown Structure Element (WBS Element) CHAR 24 0 PS_POSID
POST1 PS: Short description (1st text line) CHAR 40 0 PS_POST1
PRCTR Profit Center CHAR 10 0 CEPC PRCTR
PRCTRT General Name CHAR 20 0 KTEXT
NPLNR Network Number for Account Assignment CHAR 12 0 * NPLNR
VORNR Operation/Activity Number CHAR 4 0 VORNR
FWAER FM area currency CUKY 5 0 TCURC FMWAER
FKBTRC Amount to be checked against commt budget, in FM area crcy CURR 17 2 FM_FKBTRCM
FKBTRP Amount to be checked against payment budget, in FM area crcy CURR 17 2 FM_FKBTRPY
TWAER Transaction Currency CUKY 5 0 TCURC TWAER
TRBTRC Amount to be checked against commt budget, in trans.crcy CURR 17 2 FM_TRBTRCM
TRBTRP Amount to be checked against the paymt budget, in trans crcy CURR 17 2 FM_TRBTRPY
SKNTO Cash Discount Amount in Local Currency CURR 13 2 SKNTO_CS
RDIFF Exchange Rate Gain/Loss Realized CURR 13 2 RDIFF_CS
XREVS Cancelation flag CHAR 1 0 STNKZ
VRGNG CO Business Transaction CHAR 4 0 TJ01 CO_VORGANG
VTEXT Name of CO transaction CHAR 30 0 FM_VRGNGT
AWTYP Reference procedure CHAR 5 0 TTYP AWTYP
AWREF RW document number CHAR 10 0 FM_AWREF
AWORG Reference Organizational Units CHAR 10 0 AWORG
AWSYS Logical system of source document CHAR 10 0 TBDLS AWSYS
VREFBT Predecessor Document Category NUMC 3 0 FM_VREFBT
VREFBN Predecessor Document Number CHAR 10 0 FM_VREFBN
VRFPOS Predecessor Document Item NUMC 5 0 FM_VRFPOS
VRFKNT Predecessor Account Assignment NUMC 5 0 FM_VRFKNT
CF_FLAG Carryforwards at year-end closing CHAR 1 0 FM_CF_FLAG
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
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
USERDIM Customer Field for FM Actual and Commitment Data CHAR 10 0 FM_USERDIM
STUNR Number That Clearly Identifies the Line Key in Database CHAR 16 0 FM_STUNR
PERIO7 Period/Year NUMC 7 0 JAHRPER
PAYFLG Payment Status of FM Documents CHAR 1 0 FM_PAYFLG
Document to be processed with payment transfer (extended)
A Cleared payment without invoice reference
C Open cross-company code payment without invoice reference
D Reversed cross-company code payment without invoice
N Document was processed with payment transfer (extended)
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
BUDGET_PD Budget Period CHAR 10 0 FMBUDGETPD FM_BUDGET_PERIOD
BUS_AREA Business Area CHAR 4 0 GSBER
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
FMXDOCNR FM Reference Document Number CHAR 10 0 FM_XDOCNR
FMXYEAR FM Reference Year NUMC 4 0 FM_XYEAR
FMXDOCLN FM Reference Line Item NUMC 6 0 FM_XDOCLN
FMXZEKKN FM Reference Sequence Account Assignment NUMC 5 0 FM_XZEKKN
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

FMFIX foreign key relationships

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