1. Home
  2. Resources
  3. SAP Tables
  4. FMOIX - Line Items - Extended

SAP Table FMOIX

Line Items - Extended

FMOIX (Line Items - Extended) 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 FMOIX to other SAP tables.

Source: FMOIX (Line Items - Extended)

FMOIX 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
REFBN Reference Document Number CO_REFBN CHAR 10 0
RFPOS Item number of reference document CC_RFPOS NUMC 5 0
REFBT Reference document category (conversion exit; c.f. REFBTYP) CO_REFBTYP NUMC 3 0
010 Purchase requisition
020 Purchase order
030 Material reservation
100 Earmarked funds
200 Transfer price agreement
RFORG Reference Organizational Units AWORG CHAR 10 0
RFSYS Logical system of source document AWSYS TBDLS CHAR 10 0
RFTYP Reference Transaction AWTYP CHAR 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
WRTTP Value Type CO_WRTTP CHAR 2 0
01 Plan
02 Plan: Splitting Among Activity Types
03 Actual: Splitting Among Activity Types
04 Actual
05 Target
06 Target (WIP)
07 Target: Splitting Among Activity Types
08 Plan: Correction for Internal Bus.Vol Between Cost Centers
09 Actual: Correction for IBV Between Cost Centers
10 Statistical Plan
11 Statistical Actual
12 Down Payment as Operating Expense
13 Statistical Down Payments as Expense
19 Order Receipt/Orders Balance
21 Commitments from Purchase Requisition
22 Purchase Order Commitment
23 Reservation Commitment
24 Funds Commitment
25 Remainder from Apportioned Orders/Networks (Order Commitmts)
26 Commitments from Transfer Price Agreement
28 Value from Customer Quotation
29 Value from Sales Order
2A Funds Reservation
2B Funds Precommitment
30 Scrap
31 Variances
32 Results Analysis and WIP Calculation
33 Results Analysis: Credit Side/Debit Side
34 Results Analysis: Cost of Sales from Resource-Rel. Billing
35 Plan for True Investments
36 Budget for True Investments
37 Program Budget for True Investments
38 Program Plan for True Investments
39 Request Plan
40 Request Plan for True Investments
41 Budget
42 Assigned Budget
43 Payment Budget
44 Payment Budget: Assigned Funds
45 Payment budget: Releases
46 Cash Release
47 Program Budget
48 Program Plan
49 Planned Accrual Calculations: Results Analysis, WIP Calc.
4A Payment Budget: Statistical
4B Budget Balance
4C Payment Budget: Clear on Revenue Item
50 Purchase Requisitions
5A Payment Obligations from Purchasing Down Payments
51 Purchase Orders
52 Business Trip Commitments
53 User-Defined Payment Commitment (Financial Transaction 50)
54 Invoices
55 Bank clearings
56 User-Defined Payment Obligation (Financial Transaction 70)
57 Payments
58 Down Payment Requests
59 Down Payments for Bank Clearing
60 Parked Document
61 Down Payments
62 Planned Payments
6A Planned Down Payments
6B Clarification Worklist FI-CA
63 Down Payment Clearings
64 Funds Transfers
65 Funds Commitment
66 Profit Transfer Postings
67 Other Statistical Documents
68 Other Non-Statistical Document
69 Commitment Budget: Funds Reservations
70 Commitment Budget
71 Commitment Budget - Assigned Funds
72 Commitment Budget: Releases
73 Purchase Order: Cycle Counting Blocking Amount
74 Funds Reservation: Cycle Counting Blocking Amount
75 Commitment Budget: Funds Reservation Cycle Cntg Blckng Amt
76 Commitment Budget: Purchase Orders, Cycle Counting Blckg Amt
77 Commitment Budget: Purchase Orders
7C Commitment Budget: Expense Type Budget for Revenue Item
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation
85 Payment Budget: Reservations
86 Payment Budget: Earmarked Funds
87 Payment Budget: Reserved Releases
88 Payment Budget: Earmarked Releases
89 Commitment Budget: Reservations
90 Commitment Budget: Earmarked Funds
91 Commitment Budget: Reserved Releases
92 Commitment Budget: Earmarked Releases
93 Financial Budget
94 Payment Budget: Adjustment Field
95 Actual CO Postings
96 Purchase Order Overhead
97 Purchase Requisition Overhead
98 Funds Reservation (CO)
99 Financial Result
9A Financial Result: Statistical
9B Financial Budget: Statistical
9C Financial Budget Plan Balance
9D Funds Management: HR Integration
9E Approved Total Costs/Revenue
D1 Distribution of Actual Costs (By Source Assignment)
D2 Distribution of Commitments (By Source Assignment)
D3 Distribution of Work-in-Process (By Source Assignment)
D4 Distribution of Earned Value (By Source Assignment)
D5 Distribution of Payments (By Source Assignment)
D6 Distribution of Down Payments (By Source Assignment)
P1 Earned Value (Plan)
P2 Earned Value (Actual)
P3 Capitalized Remainder Costs
3C Control Costs
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
ERLKZ Completion indicator for line item KBLERLKZ CHAR 1 0
NULL Not Selected
X Selected
LOEKZ Deletion Indicator KBLLOEKZ CHAR 1 0
NULL Not Selected
X Selected
GJAHR Fiscal Year GJAHR NUMC 4 0
GNJHR Year of Cash Effectivity GNJHR NUMC 4 0
PERIO Period FM_PERIODE NUMC 3 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
ZHLDT Funds Management - Update Date FM_ZHLDT 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
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 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
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
FWAER FM area currency FMWAER TCURC CUKY 5 0
FKBTRP Amount to be checked against payment budget, in FM area crcy FM_FKBTRPY CURR 15 2
FKBTRC Amount to be checked against commt budget, in FM area crcy FM_FKBTRCM CURR 15 2
FKBTRW Amount processed in Workflows, expressed in FM area crcy FM_FKBTRWF CURR 15 2
TWAER Transaction Currency TWAER TCURC CUKY 5 0
TRBTRP Amount to be checked against the paymt budget, in trans crcy FM_TRBTRPY CURR 15 2
TRBTRC Amount to be checked against commt budget, in trans.crcy FM_TRBTRCM CURR 15 2
TRBTRW Amount processed in workflow, in transaciton currency FM_TRBTRWF CURR 15 2
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
VRFPOS Predecessor document item FM_VRFPOS NUMC 5 0
VREFBN Predecessor document number FM_VREFBN 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
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
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
VRGNG CO Business Transaction CO_VORGANG CHAR 4 0

FMOIX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMOIX AUFNR FMOIX AUFNR AUFK Order master data AUFNR
FMOIX AUFNR SYST MANDT AUFK Order master data MANDT
FMOIX BUKRS FMOIX BUKRS T001 Company Codes BUKRS
FMOIX BUKRS SYST MANDT T001 Company Codes MANDT
FMOIX FAREA SYST MANDT TFKB Functional areas MANDT
FMOIX FAREA FMOIX FAREA TFKB Functional areas FKBER
FMOIX FICTR * FMFCTR Funds Center Master Record DATBIS
FMOIX FICTR FMOIX FICTR FMFCTR Funds Center Master Record FICTR
FMOIX FICTR FKRS FIKRS FMFCTR Funds Center Master Record FIKRS
FMOIX FICTR SYST MANDT FMFCTR Funds Center Master Record MANDT
FMOIX FIPEX FKRS FIKRS FMCI Commitment items master data MANDT
FMOIX FIPEX SYST MANDT FMCI Commitment items master data .INCLUDE
FMOIX FIPEX * FMCI Commitment items master data FIKRS
FMOIX FIPEX FMOIX FIPEX FMCI Commitment items master data GJAHR
FMOIX FONDS FKRS FIKRS FMFINCODE FIFM: Financing code FIKRS
FMOIX FONDS SYST MANDT FMFINCODE FIFM: Financing code MANDT
FMOIX FONDS FMOIX FONDS FMFINCODE FIFM: Financing code FINCODE
FMOIX FWAER SYST MANDT TCURC Currency Codes MANDT
FMOIX FWAER FMOIX FWAER TCURC Currency Codes WAERS
FMOIX HKONT FMOIX HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
FMOIX HKONT SYST MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
FMOIX HKONT * SKA1 G/L Account Master (Chart of Accounts) KTOPL
FMOIX KOKRS SYST MANDT TKA01 Controlling Areas MANDT
FMOIX KOKRS FMOIX KOKRS TKA01 Controlling Areas KOKRS
FMOIX KOSTL * CSKS Cost Center Master Data DATBI
FMOIX KOSTL FMOIX KOSTL CSKS Cost Center Master Data KOSTL
FMOIX KOSTL FMOIX KOKRS CSKS Cost Center Master Data KOKRS
FMOIX KOSTL SYST MANDT CSKS Cost Center Master Data MANDT
FMOIX LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
FMOIX LIFNR FMOIX LIFNR LFA1 Vendor Master (General Section) LIFNR
FMOIX PRCTR SYST MANDT CEPC Profit Center Master Data Table MANDT
FMOIX PRCTR FMOIX PRCTR CEPC Profit Center Master Data Table PRCTR
FMOIX PRCTR * CEPC Profit Center Master Data Table DATBI
FMOIX PRCTR FMOIX KOKRS CEPC Profit Center Master Data Table KOKRS
FMOIX RFSYS FMOIX RFSYS TBDLS Logical system LOGSYS
FMOIX TWAER FMOIX TWAER TCURC Currency Codes WAERS
FMOIX TWAER SYST MANDT TCURC Currency Codes MANDT