SAP ABAP Table FMIP (Plan Line Items 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	FMIP	Table Relationship Diagram
Short Description	Plan Line Items 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	RPMAX	☐	RPMAX	RPMAX	NUMC	3	0	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	RFIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
16	RWRTTP	☐	FM_WRTTP	FM_WRTTP	CHAR	2	0	Value Type
17	RBTART	☐	FM_BTART	FM_BTART	CHAR	4	0	Amount type
18	RGNJHR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
19	RHKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
20	RSTATS	☐	FM_STATS	FM_STATS	CHAR	1	0	Funds Management Statistical Indicator
21	RCFLEV	☐	FM_CFLEV	FM_CFLEV	CHAR	1	0	Carryforward level
22	ROBJNRZ	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
23	RVRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	*
24	RUSERDIM	☐	FM_USERDIM	CHAR10	CHAR	10	0	Customer Field for FM Actual and Commitment Data
25	RFAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	*
26	RMEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
27	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
28	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
29	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
30	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
31	TSLVT	☐	TSLVT9	WERTV9	CURR	17	2	Balance carried forward in transaction currency
32	TSL01	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
33	TSL02	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
34	TSL03	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
35	TSL04	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
36	TSL05	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
37	TSL06	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
38	TSL07	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
39	TSL08	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
40	TSL09	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
41	TSL10	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
42	TSL11	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
43	TSL12	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
44	TSL13	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
45	TSL14	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
46	TSL15	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
47	TSL16	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
48	HSLVT	☐	HSLVT9	WERTV9	CURR	17	2	Balance carried forward in local currency
49	HSL01	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
50	HSL02	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
51	HSL03	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
52	HSL04	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
53	HSL05	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
54	HSL06	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
55	HSL07	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
56	HSL08	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
57	HSL09	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
58	HSL10	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
59	HSL11	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
60	HSL12	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
61	HSL13	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
62	HSL14	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
63	HSL15	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
64	HSL16	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
65	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
66	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
67	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
68	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
69	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
70	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
71	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
72	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
73	REFDOCLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
74	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
75	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
76	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
77	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
78	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
79	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
80	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in