SAP ABAP Table FMIFIIT (FI Line Item Table in Funds Management)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-FM (Application Component) Funds Management
     ⤷ FMFS_CORE (Package) Update Funds Management Core Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FMIFIIT	Table Relationship Diagram
Short Description	FI Line Item Table in Funds Management

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	FI - Key for Funds Management Actual Data
3	FMBELNR	☑	FM_BELNR	BELNR	CHAR	10	0	Document Number of FM Line Item	FMIFIHD
4	FIKRS	☑	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	FM01
5	FMBUZEI	☑	FM_BUZEI	NUMC03	NUMC	3	0	Number of a posting line in a TR-FM line item
6	.INCLUDE	☑				0	0	Common Key for Funds Management Actual Data
7	BTART	☑	FM_BTART	FM_BTART	CHAR	4	0	Amount type
8	RLDNR	☑	RLDNR	RLDNR	CHAR	2	0	Ledger	*
9	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
10	STUNR	☑	FM_STUNR	CHAR16	CHAR	16	0	Number that clearly identifies the line key in database
11	.INCLUDE	☐				0	0	Common Data for Funds Management Actual Data
12	ZHLDT	☐	FM_ZHLDT	DATUM	DATS	8	0	Funds Management - Update Date
13	GNJHR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
14	PERIO	☐	CO_PERIO	PERBL	NUMC	3	0	Period
15	CFSTAT	☐	FM_CFST	FM_CFST	NUMC	2	0	FM Commitment Carryforward: Status
16	CFSTATSV	☐	FM_CFSTSV	FM_CFST	NUMC	2	0	Year-End Closing: Status (Back Up)
17	CFCNT	☐	FM_CFCNT	FM_CFCNT	NUMC	2	0	Year-End Closing: Number of Transfers
18	OBJNRZ	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
19	TRBTR	☐	FM_TRBTR	WERTV7	CURR	13	2	Amount in transaction currency
20	FKBTR	☐	FM_FKBTR	WERTV7	CURR	13	2	Amount in FM area currency
21	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
22	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
23	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
24	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	TFKB
25	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
26	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
27	BUS_AREA	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
28	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
29	WRTTP	☐	FM_WRTTP	FM_WRTTP	CHAR	2	0	Value Type
30	VRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	TJ01
31	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
32	STATS	☐	FM_STATS	FM_STATS	CHAR	1	0	Funds Management Statistical Indicator
33	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
34	CFLEV	☐	FM_CFLEV	FM_CFLEV	CHAR	1	0	Carryforward level
35	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
36	TRANR	☐	FM_TRANR	CHAR16	CHAR	16	0	Funds Management Transaction Number
37	CTRNR	☐	FM_CTRNR	CHAR20	CHAR	20	0	Funds Management Control Number
38	USERDIM	☐	FM_USERDIM	CHAR10	CHAR	10	0	Customer Field for FM Actual and Commitment Data
39	.INCLUDE	☐				0	0
40	.INCLU--AP	☐				0	0	Field Enhancements for EA-PS 2.0
41	FMVOR	☐	FMVOR	FMVOR	CHAR	4	0	Classification of Document Lines
42	.INCLU--AP	☐				0	0	Budget Period
43	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
44	.INCLUDE	☐				0	0	Clean FI Data for Funds Management Actual Data
45	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
46	VOBUKRS	☐	FM_VOBUKRS	BUKRS	CHAR	4	0	Company code for payment document number	*
47	VOGJAHR	☐	FM_VOGJAHR	GJAHR	NUMC	4	0	Fiscal year for payment document number
48	VOBELNR	☐	FM_VOBELNR	BELNR	CHAR	10	0	Payment Document Number
49	VOBUZEI	☐	FM_VOBUZEI	BUZEI	NUMC	3	0	Item for payment document number
50	KNGJAHR	☐	FM_KNGJAHR	GJAHR	NUMC	4	0	Fiscal year for FI document number
51	KNBELNR	☐	FM_KNBELNR	BELNR	CHAR	10	0	FI document number
52	KNBUZEI	☐	FM_KNBUZEI	BUZEI	NUMC	3	0	Document item for FI document number
53	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
54	RDIFF	☐	RDIFF	WRTV7	CURR	13	2	Exchange Rate Gain/Loss Realized
55	PAYFLG	☐	FM_PAYFLG	FM_PAYFLG	CHAR	1	0	Payment Status of FM Documents
56	PSOBT	☐	PSOBT	DATUM	DATS	8	0	Posting Day
57	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
58	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
59	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
60	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
61	PUMETH	☐	PUMETH	PUMETH	CHAR	4	0	Payment Update Procedure in FM
62	.INCLUDE	☐				0	0	Ref. Funds Management Actual Data to Preceding Document
63	VREFBT	☐	FM_VREFBT	FM_REFBTYP	NUMC	3	0	Predecessor document category
64	VREFBN	☐	FM_VREFBN	BELNR	CHAR	10	0	Predecessor document number
65	VRFORG	☐	FM_VRFORG	AWORG	CHAR	10	0	Predecessor document organization
66	VRFPOS	☐	FM_VRFPOS	NUMC05	NUMC	5	0	Predecessor document item
67	VRFKNT	☐	FM_VRFKNT	NUM05	NUMC	5	0	Predecessor account assignment
68	VRFTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
69	VRFSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
70	.INCLUDE	☐				0	0	Funds Management Actual Data Reference Document
71	FMXDOCNR	☐	FM_XDOCNR	BELNR	CHAR	10	0	FM Reference Document Number
72	FMXYEAR	☐	FM_XYEAR	GJAHR	NUMC	4	0	FM Reference Year
73	FMXDOCLN	☐	FM_XDOCLN	NUMC6	NUMC	6	0	FM Reference Line Item
74	FMXZEKKN	☐	FM_XZEKKN	NUMC5	NUMC	5	0	FM Reference Sequence Account Assignment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMIFIIT	BUKRS	T001	BUKRS		C	CN
2	FMIFIIT	FAREA	TFKB	FKBER
3	FMIFIIT	FIKRS	FM01	FIKRS	KEY	1	CN
4	FMIFIIT	FISTL	FMFCTR	FICTR	REF	1	CN
5	FMIFIIT	FMBELNR	FMIFIHD	FMBELNR		1	N
6	FMIFIIT	FONDS	FMFINCODE	FINCODE		C	CN
7	FMIFIIT	MANDT	T000	MANDT		1	CN
8	FMIFIIT	MEINS	T006	MSEHI
9	FMIFIIT	OBJNRZ	ONR00	OBJNR	REF	1	CN
10	FMIFIIT	TWAER	TCURC	WAERS		C	CN
11	FMIFIIT	VRGNG	TJ01	VRGNG

History

Last changed by/on	SAP	20131127
SAP Release Created in