SAP FMOIX Line Items - Extended Table data and field list

FMOIX is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Line Items - Extended" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FMOIX TYPE FMOIX.

The FMOIX table consists of various fields, each holding specific information or linking keys about Line Items - Extended data available in SAP. These include FONDS (Fund), FICTR (Funds Center), FIPEX (Commitment Item), MEASURE (Funded Program)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FMOIX structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FMOIX structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FMOIX table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
FONDS	Fund	BP_GEBER	CHAR	10	FMFINCODE		BP_GEBER	FIC
FICTR	Funds Center	FM_FICTR	CHAR	16	FMFCTR		FISTL	FIS
FIPEX	Commitment Item	FM_FIPEX	CHAR	24	FMCI		FM_FIPEX	FPS
MEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
REFBN	Reference Document Number	CO_REFBN	CHAR	10		ALPHA	BELNR
RFPOS	Item number of reference document	CC_RFPOS	NUMC	5			NUMC05
REFBT	Reference document category (conversion exit; c.f. REFBTYP)	CO_REFBTYP	NUMC	3		REFBT	BELEGTYP
RFORG	Reference Organizational Units	AWORG	CHAR	10			AWORG
RFSYS	Logical system of source document	AWSYS	CHAR	10	TBDLS	ALPHA	LOGSYS
RFTYP	Reference Transaction	AWTYP	CHAR	5	Assigned to domain		AWTYP
RFKNT	Account assignment number of reference document	CC_RFKNT	NUMC	5			NUMC05
RFETE	Reference document classification number	CC_RFETE	NUMC	4	Assigned to domain		ETENR
RCOND	Counter Conditions and Level Number	RCOND	NUMC	5			RCOND
WRTTP	Value Type	CO_WRTTP	CHAR	2			CO_WRTTP
WTEXT	Val.type name	FM_WRTTPT	CHAR	40			TEXT40
BTART	Amount type	FM_BTART	CHAR	4			FM_BTART
BTEXT	Name of amount type	FM_BTARTT	CHAR	40			TEXT40
STATS	Funds Management Statistical Indicator	FM_STATS	CHAR	1			FM_STATS
STATT	Name of statistics indicator	FM_STATST	CHAR	40			TEXT40
RRCTY	Record Type	RRCTY	CHAR	1			RRCTY
ERLKZ	Completion indicator for line item	KBLERLKZ	CHAR	1			CHAR1_X
LOEKZ	Deletion Indicator	KBLLOEKZ	CHAR	1			CHAR1_X
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
GNJHR	Year of Cash Effectivity	GNJHR	NUMC	4		GJAHR	GJAHR	GNJHR
PERIO	Period	FM_PERIODE	NUMC	3			PERDE	GFP
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
ZHLDT	Funds Management - Update Date	FM_ZHLDT	DATS	8			DATUM
TRANR	Funds Management Transaction Number	FM_TRANR	CHAR	16			CHAR16
CTRNR	Funds Management Control Number	FM_CTRNR	CHAR	20			CHAR20
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
HKONT	General Ledger Account	HKONT	CHAR	10	SKA1	ALPHA	SAKNR
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	LFA1	ALPHA	LIFNR	LIF	KRED_C
FAREA	Functional Area	FM_FAREA	CHAR	16	TFKB		FKBER	FBE
FTEXT	Name of the functional area	FKBTX	CHAR	25			TEXT25
KOKRS	Controlling Area	KOKRS	CHAR	4	TKA01		CACCD	CAC
KOSTL	Cost Center	KOSTL	CHAR	10	CSKS	ALPHA	KOSTL	KOS
KTEXT	General Name	KTEXT	CHAR	20			TEXT20
AUFNR	Order Number	AUFNR	CHAR	12	AUFK	ALPHA	AUFNR	ANR
ATEXT	Description	AUFTEXT	CHAR	40			TEXT40
POSID	Work Breakdown Structure Element (WBS Element)	PS_POSID	CHAR	24		PROJN	PS_POSID	PRO
POST1	PS: Short description (1st text line)	PS_POST1	CHAR	40			TEXT40
PRCTR	Profit Center	PRCTR	CHAR	10	CEPC	ALPHA	PRCTR	PRC	PRCTR_EMPTY
PRCTRT	General Name	KTEXT	CHAR	20			TEXT20
NPLNR	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
VORNR	Operation/Activity Number	VORNR	CHAR	4		NUMCV	VORNR	VGN
CF_FLAG	Carryforwards at year-end closing	FM_CF_FLAG	CHAR	1			XFELD
CFSTAT	FM Commitment Carryforward: Status	FM_CFST	NUMC	2			FM_CFST
CFSTATSV	Year-End Closing: Status (Back Up)	FM_CFSTSV	NUMC	2			FM_CFST
CFCNT	Year-End Closing: Number of Transfers	FM_CFCNT	NUMC	2			FM_CFCNT
CFLEV	Carryforward level	FM_CFLEV	CHAR	1			FM_CFLEV
USERDIM	Customer Field for FM Actual and Commitment Data	FM_USERDIM	CHAR	10			CHAR10
FWAER	FM area currency	FMWAER	CUKY	5	TCURC		WAERS
FKBTRP	Amount to be checked against payment budget, in FM area crcy	FM_FKBTRPY	CURR	15(2)			WERTV8
FKBTRC	Amount to be checked against commt budget, in FM area crcy	FM_FKBTRCM	CURR	15(2)			WERTV8
FKBTRW	Amount processed in Workflows, expressed in FM area crcy	FM_FKBTRWF	CURR	15(2)			WERTV8
TWAER	Transaction Currency	TWAER	CUKY	5	TCURC		WAERS	FWS
TRBTRP	Amount to be checked against the paymt budget, in trans crcy	FM_TRBTRPY	CURR	15(2)			WERTV8
TRBTRC	Amount to be checked against commt budget, in trans.crcy	FM_TRBTRCM	CURR	15(2)			WERTV8
TRBTRW	Amount processed in workflow, in transaciton currency	FM_TRBTRWF	CURR	15(2)			WERTV8
VREFBT	Predecessor document category	FM_VREFBT	NUMC	3			FM_REFBTYP
VRFPOS	Predecessor document item	FM_VRFPOS	NUMC	5			NUMC05
VREFBN	Predecessor document number	FM_VREFBN	CHAR	10		ALPHA	BELNR
STUNR	Number that clearly identifies the line key in database	FM_STUNR	CHAR	16			CHAR16
PERIO7	Period/year	JAHRPER	NUMC	7		PERI7	JAHRPER
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
USNAM	User name	USNAM	CHAR	12	Assigned to domain		XUBNAME	USR
TCODE	Transaction Code	TCODE	CHAR	20	Assigned to domain		TCODE	TCD
BLDOCDATE	Budgetary Ledger Document Date	FM_BL_DOCDATE	DATS	8			DATUM
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
VRGNG	CO Business Transaction	CO_VORGANG	CHAR	4	Assigned to domain		J_VORGANG

Key field

Non-key field

< FMOI - Line Items FMOI_ADD_ENRICH - Enrichment Structure for FMOI_ADD >

How do I retrieve data from SAP structure FMOIX using ABAP code?

As FMOIX is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMOIX as there is no data to select.

How to access SAP table FMOIX

Within an ECC or HANA version of SAP you can also view further information about FMOIX and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to FMOIX

    FKRS - Financial Management Area
        FMB_SEL_SCREEN - General selection criteria
    FMAA_CO - FMAA - Availability Control Objects
        FMAA_BA - FMAA - Budget Addresses
            FMAA_PA - FMAA - Posting Addresses
    FMAA_CO_CG - FMAA - Avail. Control Objects of Aut. Cover Group
        FMAA_BA_CG - FMAA - Budget Addresses of Automatic Cover Group
            FMAA_PA_CG - FMAA - Posting Addresses of Automatic Cover Group
    AVCT - AVC Totals (BCS)
        BUDT - Budget Totals (BCS)
            BUDP - Budget Line Items (BCS)
            BUHL - Budget Entry Documents (BCS)
    FFND - Funds
            CONVAL - Consumed Values (BCS)
    FMTOX - Totals Records: Commitments and Actuals
    FMOIX - Line Items of Commitment Documents
    FMFIX - Line Items of FI Documents
        FMBKPF - FI Documents: Relevant Fields in Document Header
    FMCOX - Line Items of CO Documents
    FBPD - Budget Period
    FCTR - Funds centers
    FPOS - Commitment items
    FNCT - Functional Areas
    FMAS - Funded Programs
    FGMG - Grants
    BVSN - Budget/planning version

    FKRS - Financial Management Areas
        FMF_SEL_SCREEN - General Selection Criteria for FMF
            FVSN - Budget Versions
                BPBTX - Totals records: overall budget for fund
                    EPBT - Line Items: Overall Budget
                    VEPT - Line items: Commitment/actual for annual budget
                BPBYX - Totals records: annual budget
                    EPBY - Annual budget line items
                    VEPY - Line items: Commitment/actual for annual budget
                BPBPX - Totals Records: Period Budget
                    EPBP - Line Items: Period Budget
            FMTOX - Totals Records: Commitment and Actual
            FFND - Fund
            FMOIX - Line Items
            FMFIX - Line Items from FI Documents
                FMBKPF - FI Documents: Relevant Fields in Document Header
            FMCOX - Line Items from CO Postings
            FMCFX - Year-End Closing
                FMRU - Carryforward Rules for Year-End Closing
            FCTR - Funds Centers
            FPOS - Commitment Items
            FNCT - Functional Area
            FMAA - FM Account Assignments
                FMAAREL - Assigned FM Account Assignments
                    FMFUDRULE - Rules for Revenues Increasing Budget
                FMSNREL - Assigned FM Acct Asst to Collective Expenditures