SAP ABAP Table FIMC (SAP Cons.: Database Structure for Consolidation Reporting)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ EC-CS (Application Component) Consolidation
     ⤷ FC07_UC (Package) Cons: Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	FIMC	Table Relationship Diagram
Short Description	SAP Cons.: Database Structure for Consolidation Reporting

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	RCLNT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☐				0	0	Characteristics for Consolidation
3	RVERS	☐	FC_RVERS	FC_RVERS	CHAR	3	0	Consolidation (end-result) version	TF200
4	RYEAR	☐	FC_RYEAR	GJAHR	NUMC	4	0	Fiscal year
5	RTCUR	☐	FC_RTCUR	WAERS	CUKY	5	0	Transaction currency	TCURC
6	RUNIT	☐	FC_RUNIT	MEINS	UNIT	3	0	Quantity unit of measure for Consolidation	T006
7	RDIMEN	☐	FC_DIMEN	FC_DIMEN	CHAR	2	0	Dimension	TF150
8	RBUNIT	☐	FC_BUNIT	FC_BUNIT	CHAR	18	0	Consolidation unit	TF160
9	RITCLG	☐	FC_ITCLG	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts	TF120
10	RITEM	☐	FC_ITEM	FC_ITEM	CHAR	10	0	Financial statement item	TF100
11	SITYP	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
12	SUBIT	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
13	RBUPTR	☐	FC_BUPTR	FC_BUNIT	CHAR	18	0	Partner unit	TF160
14	RTFLG	☐	FC_RTFLG	FC_RTFLG	NUMC	1	0	Currency translation
15	RPFLG	☐	FC_RPFLG	FC_RPFLG	NUMC	1	0	Apportionment
16	PLEVL	☐	FC_PLEVL	FC_PLEVL	CHAR	2	0	Posting level
17	DOCTY	☐	FC_DOCTY	FC_DOCTY	CHAR	2	0	Document type	TF500
18	RCONGR	☐	FC_CONGR	FC_CONGR	CHAR	18	0	Consolidation group	TF180
19	COICU	☐	FC_COICU	FC_BUNIT	CHAR	18	0	Investee unit	TF160
20	YRACQ	☐	FC_RYACQ	GJAHR	NUMC	4	0	Year of acquisition
21	PRACQ	☐	RPACQ	NUM03	NUMC	3	0	Period of Acquisition
22	.INCLUDE	☐				0	0
23	.INCLUDE	☐				0	0	Attributes of Consolidation (Characteristics w/o Trans.Data)
24	.INCLUDE	☐				0	0	Attributes of Consolidation for Consolidation Unit
25	RBUNIT__CNTRY	☐	FC_BUNIT_CNTRY	LAND1	CHAR	3	0	Country of consolidation unit	T005
26	RBUNIT__RCOMP	☐	FC_BUNIT_RCOMP	RCOMP	CHAR	6	0	Company of the consolidation unit	T880
27	RBUNIT__GSBER_KONS	☐	FC_BUNIT_GSBER_KONS	GSBER_KONS	CHAR	4	0	Consolidation business area of the consolidation unit	TGSBK
28	RBUNIT__KOKRS	☐	FC_BUNIT_KOKRS	CACCD	CHAR	4	0	Controlling area of the consolidation unit	TKA01
29	RBUNIT__PRCTR	☐	FC_BUNIT_PRCTR	PRCTR	CHAR	10	0	Profit center of the consolidation unit	CEPC
30	.INCLUDE	☐				0	0
31	.INCLUDE	☐				0	0	Attributes of Consolidation for Partner Unit
32	RBUPTR__CNTRY	☐	FC_BUPTR_CNTRY	LAND1	CHAR	3	0	Country of the partner unit	T005
33	RBUPTR__RCOMP	☐	FC_BUPTR_RCOMP	RCOMP	CHAR	6	0	Company of partner unit	T880
34	RBUPTR__GSBER_KONS	☐	FC_BUPTR_GSBER_KONS	GSBER_KONS	CHAR	4	0	Consolidation business area of the partner unit	TGSBK
35	RBUPTR__KOKRS	☐	FC_BUPTR_KOKRS	CACCD	CHAR	4	0	Controlling area of the partner unit	TKA01
36	RBUPTR__PRCTR	☐	FC_BUPTR_PRCTR	PRCTR	CHAR	10	0	Profit center of the partner unit	CEPC
37	.INCLUDE	☐				0	0
38	.INCLUDE	☐				0	0	Attributes of Consolidation for Investee Unit
39	COICU__CNTRY	☐	FC_COICU_CNTRY	LAND1	CHAR	3	0	Country of the investee unit	T005
40	COICU__RCOMP	☐	FC_COICU_RCOMP	RCOMP	CHAR	6	0	Company of investee unit	T880
41	COICU__GSBER_KONS	☐	FC_COICU_GSBER_KONS	GSBER_KONS	CHAR	4	0	Consolidation business area of the investee unit	TGSBK
42	COICU__KOKRS	☐	FC_COICU_KOKRS	CACCD	CHAR	4	0	Controlling area of the investee unit	TKA01
43	COICU__PRCTR	☐	FC_COICU_PRCTR	PRCTR	CHAR	10	0	Profit center of the investee unit	CEPC
44	.INCLUDE	☐				0	0
45	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
46	RPMAX	☐	RPMAX	RPMAX	NUMC	3	0	Period
47	INICG	☐	FC_INICG	FC_CONGR	CHAR	18	0	Consolidation group	TF180
48	ROBUNIT	☐	FC_OBUNIT	FC_BUNIT	CHAR	18	0	Original consolidation unit	TF160
49	ROBUPTR	☐	FC_OBUPTR	FC_BUNIT	CHAR	18	0	Original partner consolidation unit	TF160
50	ACUNIT	☐	FC_ACUNIT	FC_BUNIT	CHAR	18	0	Alternative consolidation unit for reporting	TF160
51	AITEM	☐	FC_AITEM	FC_ITEM	CHAR	10	0	Alternative item for reporting	TF100
52	CGYEAR	☐	FC_CGYEAR	GJAHR	NUMC	4	0	Fiscal year for the consolidation group breakdown
53	PERID	☐	FC_CGPER	FC_PERID	NUMC	3	0	Period for consolidation group breakdown
54	LEVEL	☐	FC_EXPLVL	CHAR2	CHAR	2	0	Level of expansion of the hierarchy
55	HLEVL	☐	FC_TOHLEVL	FC_HLEVL	CHAR	2	0	End processing at this hierarchy level	TF195
56	LCURR	☐	LCURR	WAERS	CUKY	5	0	Currency key of the local currency	TCURC
57	TSLVT	☐	TSLVT9	WERTV9	CURR	17	2	Balance carried forward in transaction currency
58	TSL01	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
59	TSL02	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
60	TSL03	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
61	TSL04	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
62	TSL05	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
63	TSL06	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
64	TSL07	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
65	TSL08	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
66	TSL09	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
67	TSL10	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
68	TSL11	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
69	TSL12	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
70	TSL13	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
71	TSL14	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
72	TSL15	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
73	TSL16	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
74	HSLVT	☐	HSLVT9	WERTV9	CURR	17	2	Balance carried forward in local currency
75	HSL01	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
76	HSL02	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
77	HSL03	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
78	HSL04	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
79	HSL05	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
80	HSL06	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
81	HSL07	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
82	HSL08	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
83	HSL09	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
84	HSL10	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
85	HSL11	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
86	HSL12	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
87	HSL13	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
88	HSL14	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
89	HSL15	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
90	HSL16	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
91	KSLVT	☐	KSLVT9	WERTV9	CURR	17	2	Balance carried forward in group currency
92	KSL01	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
93	KSL02	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
94	KSL03	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
95	KSL04	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
96	KSL05	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
97	KSL06	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
98	KSL07	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
99	KSL08	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
100	KSL09	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
101	KSL10	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
102	KSL11	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
103	KSL12	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
104	KSL13	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
105	KSL14	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
106	KSL15	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
107	KSL16	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
108	MSLVT	☐	MSLVT	MENGV8	QUAN	15	3	Balance carried forward of quantity
109	MSL01	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
110	MSL02	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
111	MSL03	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
112	MSL04	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
113	MSL05	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
114	MSL06	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
115	MSL07	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
116	MSL08	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
117	MSL09	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
118	MSL10	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
119	MSL11	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
120	MSL12	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
121	MSL13	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
122	MSL14	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
123	MSL15	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
124	MSL16	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FIMC	ACUNIT	TF160	BUNIT
2	FIMC	AITEM	TF100	ITEM
3	FIMC	COICU	TF160	BUNIT
4	FIMC	COICU__CNTRY	T005	LAND1
5	FIMC	COICU__GSBER_KONS	TGSBK	GSBER_KONS
6	FIMC	COICU__KOKRS	TKA01	KOKRS
7	FIMC	COICU__PRCTR	CEPC	PRCTR
8	FIMC	COICU__RCOMP	T880	RCOMP
9	FIMC	DOCTY	TF500	DOCTY
10	FIMC	HLEVL	TF195	HLEVL
11	FIMC	INICG	TF180	CONGR
12	FIMC	LCURR	TCURC	WAERS
13	FIMC	RBUNIT	TF160	BUNIT
14	FIMC	RBUNIT__CNTRY	T005	LAND1
15	FIMC	RBUNIT__GSBER_KONS	TGSBK	GSBER_KONS
16	FIMC	RBUNIT__KOKRS	TKA01	KOKRS
17	FIMC	RBUNIT__PRCTR	CEPC	PRCTR
18	FIMC	RBUNIT__RCOMP	T880	RCOMP
19	FIMC	RBUPTR	TF160	BUNIT
20	FIMC	RBUPTR__CNTRY	T005	LAND1
21	FIMC	RBUPTR__GSBER_KONS	TGSBK	GSBER_KONS
22	FIMC	RBUPTR__KOKRS	TKA01	KOKRS
23	FIMC	RBUPTR__PRCTR	CEPC	PRCTR
24	FIMC	RBUPTR__RCOMP	T880	RCOMP
25	FIMC	RCLNT	T000	MANDT
26	FIMC	RCONGR	TF180	CONGR
27	FIMC	RDIMEN	TF150	DIMEN
28	FIMC	RITCLG	TF120	ITCLG
29	FIMC	RITEM	TF100	ITEM
30	FIMC	RLDNR	T881	RLDNR
31	FIMC	ROBUNIT	TF160	BUNIT
32	FIMC	ROBUPTR	TF160	BUNIT
33	FIMC	RTCUR	TCURC	WAERS
34	FIMC	RUNIT	T006	MSEHI
35	FIMC	RVERS	TF200	RVERS
36	FIMC	SITYP	TF110	SITYP
37	FIMC	SUBIT	TF115	SITEM

History

Last changed by/on	SAP	20110901
SAP Release Created in