SAP table FMOIX (Line Items - Extended)

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
REFBN Reference Document Number CHAR 10 0 CO_REFBN
RFPOS Item Number of Reference Document NUMC 5 0 CC_RFPOS
REFBT Reference Document Category (Conversion Exit; See REFBTYP) NUMC 3 0 CO_REFBTYP
RFORG Reference Organizational Units CHAR 10 0 AWORG
RFSYS Logical system of source document CHAR 10 0 TBDLS AWSYS
RFTYP Reference procedure CHAR 5 0 * AWTYP
RFKNT Account Assignment Number of Reference Document NUMC 5 0 CC_RFKNT
RFETE Reference Document Classification Number NUMC 4 0 * CC_RFETE
RCOND Counter Conditions and Level Number NUMC 5 0 RCOND
WRTTP Value Type CHAR 2 0 CO_WRTTP
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
3C Control Costs
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
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
5A Payment Obligations from Purchasing Down Payments
60 Parked Document
61 Down Payments
62 Planned Payments
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
6A Planned Down Payments
6B Clarification Worklist FI-CA
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
U1 Source Document - Statistical Actuals
U4 Source Document - Actual
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
ERLKZ Completion Indicator for Line Item CHAR 1 0 KBLERLKZ
LOEKZ Deletion Indicator CHAR 1 0 KBLLOEKZ
GJAHR Fiscal Year NUMC 4 0 GJAHR
GNJHR Year of Cash Effectivity NUMC 4 0 GNJHR
PERIO Period NUMC 3 0 FM_PERIODE
BUDAT Posting Date in the Document DATS 8 0 BUDAT
ZHLDT Funds Management Update Date DATS 8 0 FM_ZHLDT
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
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
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
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
FWAER FM area currency CUKY 5 0 TCURC FMWAER
FKBTRP Amount to be checked against payment budget, in FM area crcy CURR 17 2 FM_FKBTRPY
FKBTRC Amount to be checked against commt budget, in FM area crcy CURR 17 2 FM_FKBTRCM
FKBTRW Amount processed in Workflows, expressed in FM area crcy CURR 15 2 FM_FKBTRWF
TWAER Transaction Currency CUKY 5 0 TCURC TWAER
TRBTRP Amount to be checked against the paymt budget, in trans crcy CURR 17 2 FM_TRBTRPY
TRBTRC Amount to be checked against commt budget, in trans.crcy CURR 17 2 FM_TRBTRCM
TRBTRW Amount processed in workflow, in transaciton currency CURR 15 2 FM_TRBTRWF
VREFBT Predecessor Document Category NUMC 3 0 FM_VREFBT
VRFPOS Predecessor Document Item NUMC 5 0 FM_VRFPOS
VREFBN Predecessor Document Number CHAR 10 0 FM_VREFBN
STUNR Number That Clearly Identifies the Line Key in Database CHAR 16 0 FM_STUNR
PERIO7 Period/Year NUMC 7 0 JAHRPER
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
USNAM User Name CHAR 12 0 USNAM
TCODE Transaction Code CHAR 20 0 TCODE
BLDOCDATE Budgetary Ledger Document Date DATS 8 0 FM_BL_DOCDATE
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
KUNNR Customer Number CHAR 10 0 KUNNR
VRGNG CO Business Transaction CHAR 4 0 CO_VORGANG
BUS_AREA Business Area CHAR 4 0 GSBER

FMOIX foreign key relationships

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