SAP ABAP Table FMOIX (Line Items - Extended)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ FI-FM-IS (Application Component) Information System
     ⤷ FMRP (Package) ISPS reporting

Basic Data

Table Category	INTTAB	Structure
Structure	FMOIX	Table Relationship Diagram
Short Description	Line Items - Extended

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	FM Account Assignment Without Master Data
2	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
3	FICTR	☐	FM_FICTR	FISTL	CHAR	16	0	Funds Center	FMFCTR
4	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	FMCI
5	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
6	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
7	.INCLUDE	☐				0	0	Line Items
8	REFBN	☐	CO_REFBN	BELNR	CHAR	10	0	Reference Document Number
9	RFPOS	☐	CC_RFPOS	NUMC05	NUMC	5	0	Item number of reference document
10	REFBT	☐	CO_REFBTYP	BELEGTYP	NUMC	3	0	Reference document category (conversion exit; c.f. REFBTYP)
11	RFORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
12	RFSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	TBDLS
13	RFTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
14	RFKNT	☐	CC_RFKNT	NUMC05	NUMC	5	0	Account assignment number of reference document
15	RFETE	☐	CC_RFETE	ETENR	NUMC	4	0	Reference document classification number	*
16	RCOND	☐	RCOND	RCOND	NUMC	5	0	Counter Conditions and Level Number
17	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
18	WTEXT	☐	FM_WRTTPT	TEXT40	CHAR	40	0	Val.type name
19	BTART	☐	FM_BTART	FM_BTART	CHAR	4	0	Amount type
20	BTEXT	☐	FM_BTARTT	TEXT40	CHAR	40	0	Name of amount type
21	STATS	☐	FM_STATS	FM_STATS	CHAR	1	0	Funds Management Statistical Indicator
22	STATT	☐	FM_STATST	TEXT40	CHAR	40	0	Name of statistics indicator
23	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
24	ERLKZ	☐	KBLERLKZ	CHAR1_X	CHAR	1	0	Completion indicator for line item
25	LOEKZ	☐	KBLLOEKZ	CHAR1_X	CHAR	1	0	Deletion Indicator
26	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
27	GNJHR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
28	PERIO	☐	FM_PERIODE	PERDE	NUMC	3	0	Period
29	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
30	ZHLDT	☐	FM_ZHLDT	DATUM	DATS	8	0	Funds Management - Update Date
31	TRANR	☐	FM_TRANR	CHAR16	CHAR	16	0	Funds Management Transaction Number
32	CTRNR	☐	FM_CTRNR	CHAR20	CHAR	20	0	Funds Management Control Number
33	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
34	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
35	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
36	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
37	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	TFKB
38	FTEXT	☐	FKBTX	TEXT25	CHAR	25	0	Name of the functional area
39	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
40	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
41	KTEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
42	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
43	ATEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
44	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
45	POST1	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
46	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
47	PRCTRT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
48	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
49	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
50	CF_FLAG	☐	FM_CF_FLAG	XFELD	CHAR	1	0	Carryforwards at year-end closing
51	CFSTAT	☐	FM_CFST	FM_CFST	NUMC	2	0	FM Commitment Carryforward: Status
52	CFSTATSV	☐	FM_CFSTSV	FM_CFST	NUMC	2	0	Year-End Closing: Status (Back Up)
53	CFCNT	☐	FM_CFCNT	FM_CFCNT	NUMC	2	0	Year-End Closing: Number of Transfers
54	CFLEV	☐	FM_CFLEV	FM_CFLEV	CHAR	1	0	Carryforward level
55	USERDIM	☐	FM_USERDIM	CHAR10	CHAR	10	0	Customer Field for FM Actual and Commitment Data
56	FWAER	☐	FMWAER	WAERS	CUKY	5	0	FM area currency	TCURC
57	FKBTRP	☐	FM_FKBTRPY	WERTV8	CURR	15	2	Amount to be checked against payment budget, in FM area crcy
58	FKBTRC	☐	FM_FKBTRCM	WERTV8	CURR	15	2	Amount to be checked against commt budget, in FM area crcy
59	FKBTRW	☐	FM_FKBTRWF	WERTV8	CURR	15	2	Amount processed in Workflows, expressed in FM area crcy
60	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
61	TRBTRP	☐	FM_TRBTRPY	WERTV8	CURR	15	2	Amount to be checked against the paymt budget, in trans crcy
62	TRBTRC	☐	FM_TRBTRCM	WERTV8	CURR	15	2	Amount to be checked against commt budget, in trans.crcy
63	TRBTRW	☐	FM_TRBTRWF	WERTV8	CURR	15	2	Amount processed in workflow, in transaciton currency
64	VREFBT	☐	FM_VREFBT	FM_REFBTYP	NUMC	3	0	Predecessor document category
65	VRFPOS	☐	FM_VRFPOS	NUMC05	NUMC	5	0	Predecessor document item
66	VREFBN	☐	FM_VREFBN	BELNR	CHAR	10	0	Predecessor document number
67	STUNR	☐	FM_STUNR	CHAR16	CHAR	16	0	Number that clearly identifies the line key in database
68	PERIO7	☐	JAHRPER	JAHRPER	NUMC	7	0	Period/year
69	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
70	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
71	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
72	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
73	BLDOCDATE	☐	FM_BL_DOCDATE	DATUM	DATS	8	0	Budgetary Ledger Document Date
74	.INCLUDE	☐				0	0
75	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
76	VRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMOIX	AUFNR	AUFK	AUFNR
2	FMOIX	BUKRS	T001	BUKRS
3	FMOIX	FAREA	TFKB	FKBER
4	FMOIX	FICTR	FMFCTR	FICTR
5	FMOIX	FIPEX	FMCI	GJAHR
6	FMOIX	FONDS	FMFINCODE	FINCODE
7	FMOIX	FWAER	TCURC	WAERS
8	FMOIX	HKONT	SKA1	SAKNR
9	FMOIX	KOKRS	TKA01	KOKRS
10	FMOIX	KOSTL	CSKS	KOSTL
11	FMOIX	LIFNR	LFA1	LIFNR
12	FMOIX	PRCTR	CEPC	PRCTR
13	FMOIX	RFSYS	TBDLS	LOGSYS
14	FMOIX	TWAER	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in