SAP ABAP Table FMIA (Actual Line Item Table for 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	FMIA	Table Relationship Diagram
Short Description	Actual Line Item Table for 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	RCLNT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GL_SIRID	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
3	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
4	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
5	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
6	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
8	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
9	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
10	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
11	DOCLN	☐	DOCLN	DOCLN	CHAR	3	0	Document line
12	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
13	RFISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
14	RFONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
15	PFONDS	☐	FM_PFUND	BP_GEBER	CHAR	10	0	Partner Fund	*
16	RFIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
17	RWRTTP	☐	FM_WRTTP	FM_WRTTP	CHAR	2	0	Value Type
18	RBTART	☐	FM_BTART	FM_BTART	CHAR	4	0	Amount type
19	RGNJHR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
20	RHKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
21	RSTATS	☐	FM_STATS	FM_STATS	CHAR	1	0	Funds Management Statistical Indicator
22	RCFLEV	☐	FM_CFLEV	FM_CFLEV	CHAR	1	0	Carryforward level
23	ROBJNRZ	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
24	RVRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	*
25	RUSERDIM	☐	FM_USERDIM	CHAR10	CHAR	10	0	Customer Field for FM Actual and Commitment Data
26	RFAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	*
27	RMEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
28	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
29	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
30	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
31	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
32	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
33	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
34	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
35	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
36	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
37	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
38	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
39	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
40	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
41	REFDOCLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
42	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
43	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
44	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
45	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
46	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
47	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
48	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
49	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
50	DISTKEY	☐	FM_DISTKEY	FM_DISTKEY	CHAR	4	0	Distribution keys
51	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
52	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
53	.INCLUDE	☐				0	0
54	.INCLU--AP	☐				0	0	Appended fields for EA-PS
55	RVBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMIA	AWTYP	TTYP	AWTYP	REF	C	CN
2	FMIA	DOCTY	T889	DOCTY	REF	C	CN
3	FMIA	LOGSYS	TBDLS	LOGSYS	REF	C	CN
4	FMIA	RBUKRS	T001	BUKRS	REF	C	CN
5	FMIA	RBUSA	TGSB	GSBER	REF	C	CN
6	FMIA	RCLNT	T000	MANDT	KEY	1	CN
7	FMIA	RLDNR	T881	RLDNR	REF	C	CN
8	FMIA	RTCUR	TCURC	WAERS	REF	C	CN
9	FMIA	RVERS	T894	RVERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in