SAP ABAP Table FMFI (Line Items from FI Documents)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-FM (Application Component) Funds Management
     ⤷ FMRP_CORE (Package) Funds Management: Information System Core Objects

Basic Data

Table Category	INTTAB	Structure
Structure	FMFI	Table Relationship Diagram
Short Description	Line Items from FI Documents

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	FMBELNR	☐	FM_BELNR	BELNR	CHAR	10	0	Document Number of FM Line Item
2	FMBUZEI	☐	FM_BUZEI	NUMC03	NUMC	3	0	Number of a posting line in a TR-FM line item
3	WRTTP	☐	FM_WRTTP	FM_WRTTP	CHAR	2	0	Value Type
4	WTEXT	☐	FM_WRTTPT	TEXT40	CHAR	40	0	Val.type name
5	BTART	☐	FM_BTART	FM_BTART	CHAR	4	0	Amount type
6	BTEXT	☐	FM_BTARTT	TEXT40	CHAR	40	0	Name of amount type
7	STATS	☐	FM_STATS	FM_STATS	CHAR	1	0	Funds Management Statistical Indicator
8	STATT	☐	FM_STATST	TEXT40	CHAR	40	0	Name of statistics indicator
9	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
10	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
11	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
12	GNJHR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
13	PERIO	☐	CO_PERIO	PERBL	NUMC	3	0	Period
14	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
15	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
16	ZHLDT	☐	FM_ZHLDT	DATUM	DATS	8	0	Funds Management - Update Date
17	PSOBT	☐	PSOBT	DATUM	DATS	8	0	Posting Day
18	TRANR	☐	FM_TRANR	CHAR16	CHAR	16	0	Funds Management Transaction Number
19	CTRNR	☐	FM_CTRNR	CHAR20	CHAR	20	0	Funds Management Control Number
20	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
21	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
22	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
23	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
24	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
25	VOGJAHR	☐	FM_VOGJAHR	GJAHR	NUMC	4	0	Fiscal year for payment document number
26	VOBELNR	☐	FM_VOBELNR	BELNR	CHAR	10	0	Payment Document Number
27	VOBUZEI	☐	FM_VOBUZEI	BUZEI	NUMC	3	0	Item for payment document number
28	KNGJAHR	☐	FM_KNGJAHR	GJAHR	NUMC	4	0	Fiscal year for FI document number
29	KNBELNR	☐	FM_KNBELNR	BELNR	CHAR	10	0	FI document number
30	KNBUZEI	☐	FM_KNBUZEI	BUZEI	NUMC	3	0	Document item for FI document number
31	FAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	TFKB
32	FTEXT	☐	FKBTX	TEXT25	CHAR	25	0	Name of the functional area
33	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
34	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
35	KTEXT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
36	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
37	ATEXT	☐	AUFTEXT	TEXT40	CHAR	40	0	Description
38	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
39	POST1	☐	PS_POST1	TEXT40	CHAR	40	0	PS: Short description (first text line)
40	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
41	PRCTRT	☐	KTEXT	TEXT20	CHAR	20	0	General Name
42	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
43	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
44	FWAER	☐	FMWAER	WAERS	CUKY	5	0	FM area currency	TCURC
45	FKBTRC	☐	FM_FKBTRCM	WERTV8	CURR	15	2	Amount to be checked against commt budget, in FM area crcy
46	FKBTRP	☐	FM_FKBTRPY	WERTV8	CURR	15	2	Amount to be checked against payment budget, in FM area crcy
47	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
48	TRBTRC	☐	FM_TRBTRCM	WERTV8	CURR	15	2	Amount to be checked against commt budget, in trans.crcy
49	TRBTRP	☐	FM_TRBTRPY	WERTV8	CURR	15	2	Amount to be checked against the paymt budget, in trans crcy
50	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
51	RDIFF	☐	RDIFF	WRTV7	CURR	13	2	Exchange Rate Gain/Loss Realized
52	XREVS	☐	STNKZ	CHAR1	CHAR	1	0	Cancelation flag
53	VRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	TJ01
54	VTEXT	☐	FM_VRGNGT	TEXT30	CHAR	30	0	Name of CO transaction
55	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
56	AWREF	☐	FM_AWREF	AWREF	CHAR	10	0	RW document number
57	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
58	AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	TBDLS
59	VREFBT	☐	FM_VREFBT	FM_REFBTYP	NUMC	3	0	Predecessor document category
60	VREFBN	☐	FM_VREFBN	BELNR	CHAR	10	0	Predecessor document number
61	VRFPOS	☐	FM_VRFPOS	NUMC05	NUMC	5	0	Predecessor document item
62	VRFKNT	☐	FM_VRFKNT	NUM05	NUMC	5	0	Predecessor account assignment
63	CF_FLAG	☐	FM_CF_FLAG	XFELD	CHAR	1	0	Carryforwards at year-end closing
64	CFSTAT	☐	FM_CFST	FM_CFST	NUMC	2	0	FM Commitment Carryforward: Status
65	CFSTATSV	☐	FM_CFSTSV	FM_CFST	NUMC	2	0	Year-End Closing: Status (Back Up)
66	CFCNT	☐	FM_CFCNT	FM_CFCNT	NUMC	2	0	Year-End Closing: Number of Transfers
67	CFLEV	☐	FM_CFLEV	FM_CFLEV	CHAR	1	0	Carryforward level
68	USERDIM	☐	FM_USERDIM	CHAR10	CHAR	10	0	Customer Field for FM Actual and Commitment Data
69	STUNR	☐	FM_STUNR	CHAR16	CHAR	16	0	Number that clearly identifies the line key in database

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMFI	AUFNR	AUFK	AUFNR
2	FMFI	AWSYS	TBDLS	LOGSYS
3	FMFI	AWTYP	TTYP	AWTYP
4	FMFI	BLART	T003	BLART
5	FMFI	BUKRS	T001	BUKRS
6	FMFI	FAREA	TFKB	FKBER
7	FMFI	FWAER	TCURC	WAERS
8	FMFI	HKONT	SKA1	SAKNR
9	FMFI	KOKRS	TKA01	KOKRS
10	FMFI	KOSTL	CSKS	KOSTL
11	FMFI	KUNNR	KNA1	KUNNR
12	FMFI	LIFNR	LFA1	LIFNR
13	FMFI	PRCTR	CEPC	PRCTR
14	FMFI	TWAER	TCURC	WAERS
15	FMFI	VRGNG	TJ01	VRGNG

History

Last changed by/on	SAP	20130529
SAP Release Created in