Follow us on LinkedIn for your next SAP project

← Back to Search

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.

FMOIX table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

FONDS

Fund

BP_GEBER

FMFINCODE

CHAR

FICTR

Funds Center

FM_FICTR

FMFCTR

CHAR

FIPEX

Commitment Item

FM_FIPEX

FMCI

CHAR

MEASURE

Funded Program

FM_MEASURE

CHAR

GRANT_NBR

Grant

GM_GRANT_NBR

CHAR

REFBN

Reference Document Number

CO_REFBN

CHAR

RFPOS

Item number of reference document

CC_RFPOS

NUMC

REFBT

Reference document category (conversion exit; c.f. REFBTYP)

CO_REFBTYP

NUMC

Value	Description
010	Purchase requisition
020	Purchase order
030	Material reservation
100	Earmarked funds
200	Transfer price agreement

RFORG

Reference Organizational Units

AWORG

CHAR

RFSYS

Logical system of source document

AWSYS

TBDLS

CHAR

RFTYP

Reference Transaction

AWTYP

CHAR

RFKNT

Account assignment number of reference document

CC_RFKNT

NUMC

RFETE

Reference document classification number

CC_RFETE

NUMC

RCOND

Counter Conditions and Level Number

RCOND

NUMC

WRTTP

Value Type

CO_WRTTP

CHAR

Value	Description
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

BTART

Amount type

FM_BTART

CHAR

Value	Description
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

STATS

Funds Management Statistical Indicator

FM_STATS

CHAR

Value	Description
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

RRCTY

Record Type

RRCTY

CHAR

Value	Description
NULL	Actual
1	Plan
2	Actual assessment/distribution
3	Planned assessment/distribution

ERLKZ

Completion indicator for line item

KBLERLKZ

CHAR

Value	Description
NULL	Not Selected
X	Selected

LOEKZ

Deletion Indicator

KBLLOEKZ

CHAR

Value	Description
NULL	Not Selected
X	Selected

GJAHR

Fiscal Year

GJAHR

NUMC

GNJHR

Year of Cash Effectivity

GNJHR

NUMC

PERIO

Period

FM_PERIODE

NUMC

BUDAT

Posting Date in the Document

BUDAT

DATS

ZHLDT

Funds Management - Update Date

FM_ZHLDT

DATS

TRANR

Funds Management Transaction Number

FM_TRANR

CHAR

CTRNR

Funds Management Control Number

FM_CTRNR

CHAR

BUKRS

Company Code

BUKRS

T001

CHAR

HKONT

General Ledger Account

HKONT

SKA1

CHAR

SGTXT

Item Text

SGTXT

CHAR

LIFNR

Account Number of Vendor or Creditor

LIFNR

LFA1

CHAR

FAREA

Functional Area

FM_FAREA

TFKB

CHAR

FTEXT

Name of the functional area

FKBTX

CHAR

KOKRS

Controlling Area

KOKRS

TKA01

CHAR

KOSTL

Cost Center

KOSTL

CSKS

CHAR

KTEXT

General Name

KTEXT

CHAR

AUFNR

Order Number

AUFNR

AUFK

CHAR

ATEXT

Description

AUFTEXT

CHAR

POSID

Work Breakdown Structure Element (WBS Element)

PS_POSID

CHAR

POST1

PS: Short description (1st text line)

PS_POST1

CHAR

PRCTR

Profit Center

PRCTR

CEPC

CHAR

PRCTRT

General Name

KTEXT

CHAR

NPLNR

Network Number for Account Assignment

NPLNR

CHAR

VORNR

Operation/Activity Number

VORNR

CHAR

CF_FLAG

Carryforwards at year-end closing

FM_CF_FLAG

CHAR

Value	Description
X	Yes
NULL	No

CFSTAT

FM Commitment Carryforward: Status

FM_CFST

NUMC

Value	Description
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

Value	Description
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

CFLEV

Carryforward level

FM_CFLEV

CHAR

Value	Description
NULL	Document and Predecessor not Carried Forward
X	X Document or Predecessor Carried Forward
U	U Customer Flag: Document or Predecessor Carried Forward
NULL	Customer Specification: Number of Carryforwards

USERDIM

Customer Field for FM Actual and Commitment Data

FM_USERDIM

CHAR

FWAER

FM area currency

FMWAER

TCURC

CUKY

FKBTRP

Amount to be checked against payment budget, in FM area crcy

FM_FKBTRPY

CURR

FKBTRC

Amount to be checked against commt budget, in FM area crcy

FM_FKBTRCM

CURR

FKBTRW

Amount processed in Workflows, expressed in FM area crcy

FM_FKBTRWF

CURR

TWAER

Transaction Currency

TWAER

TCURC

CUKY

TRBTRP

Amount to be checked against the paymt budget, in trans crcy

FM_TRBTRPY

CURR

TRBTRC

Amount to be checked against commt budget, in trans.crcy

FM_TRBTRCM

CURR

TRBTRW

Amount processed in workflow, in transaciton currency

FM_TRBTRWF

CURR

VREFBT

Predecessor document category

FM_VREFBT

NUMC

Value	Description
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

VREFBN

Predecessor document number

FM_VREFBN

CHAR

STUNR

Number that clearly identifies the line key in database

FM_STUNR

CHAR

PERIO7

Period/year

JAHRPER

NUMC

CPUDT

Day On Which Accounting Document Was Entered

CPUDT

DATS

CPUTM

Time of Entry

CPUTM

TIMS

USNAM

User name

USNAM

CHAR

TCODE

Transaction Code

TCODE

CHAR

BLDOCDATE

Budgetary Ledger Document Date

FM_BL_DOCDATE

DATS

BUDGET_PD

FM: Budget Period

FM_BUDGET_PERIOD

CHAR

KUNNR

Customer Number

KUNNR

CHAR

VRGNG

CO Business Transaction

CO_VORGANG

CHAR

FMOIX foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
FMOIX	AUFNR	SYST	MANDT	AUFK Order master data	MANDT
FMOIX	AUFNR	FMOIX	AUFNR	AUFK Order master data	AUFNR
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	FMOIX	FICTR	FMFCTR Funds Center Master Record	FICTR
FMOIX	FICTR	*		FMFCTR Funds Center Master Record	DATBIS
FMOIX	FICTR	SYST	MANDT	FMFCTR Funds Center Master Record	MANDT
FMOIX	FICTR	FKRS	FIKRS	FMFCTR Funds Center Master Record	FIKRS
FMOIX	FIPEX	FKRS	FIKRS	FMCI Commitment items master data	MANDT
FMOIX	FIPEX	*		FMCI Commitment items master data	FIKRS
FMOIX	FIPEX	FMOIX	FIPEX	FMCI Commitment items master data	GJAHR
FMOIX	FIPEX	SYST	MANDT	FMCI Commitment items master data	.INCLUDE
FMOIX	FONDS	SYST	MANDT	FMFINCODE FIFM: Financing code	MANDT
FMOIX	FONDS	FKRS	FIKRS	FMFINCODE FIFM: Financing code	FIKRS
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	SYST	MANDT	SKA1 G/L Account Master (Chart of Accounts)	MANDT
FMOIX	HKONT	*		SKA1 G/L Account Master (Chart of Accounts)	KTOPL
FMOIX	HKONT	FMOIX	HKONT	SKA1 G/L Account Master (Chart of Accounts)	SAKNR
FMOIX	KOKRS	SYST	MANDT	TKA01 Controlling Areas	MANDT
FMOIX	KOKRS	FMOIX	KOKRS	TKA01 Controlling Areas	KOKRS
FMOIX	KOSTL	SYST	MANDT	CSKS Cost Center Master Data	MANDT
FMOIX	KOSTL	FMOIX	KOKRS	CSKS Cost Center Master Data	KOKRS
FMOIX	KOSTL	FMOIX	KOSTL	CSKS Cost Center Master Data	KOSTL
FMOIX	KOSTL	*		CSKS Cost Center Master Data	DATBI
FMOIX	LIFNR	FMOIX	LIFNR	LFA1 Vendor Master (General Section)	LIFNR
FMOIX	LIFNR	SYST	MANDT	LFA1 Vendor Master (General Section)	MANDT
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