SAP ABAP Table FCINTAB (Structure for Screen Fields of FUGR FCIN)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ EC-CS (Application Component) Consolidation
     ⤷ FCIN_UC (Package) Cons: Integration

Basic Data

Table Category	INTTAB	Structure
Structure	FCINTAB	Table Relationship Diagram
Short Description	Structure for Screen Fields of FUGR FCIN

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
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	RLDNR	☐	FC_RLDNR	RLDNR	CHAR	2	0	Ledger	T881
3	DIMEN	☐	FC_DIMEN	FC_DIMEN	CHAR	2	0	Dimension	TF150
4	BUNIT	☐	FC_BUNIT	FC_BUNIT	CHAR	18	0	Consolidation unit	TF160
5	ITCLG	☐	FC_ITCLG	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts	TF120
6	ITEM	☐	FC_ITEM	FC_ITEM	CHAR	10	0	Financial statement item	TF100
7	RVERS	☐	FC_RVERS	FC_RVERS	CHAR	3	0	Consolidation (end-result) version	TF200
8	POPER	☐	FC_PERID	PERDE	NUMC	3	0	Period
9	RYEAR	☐	FC_RYEAR	GJAHR	NUMC	4	0	Fiscal year
10	CAX0_KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
11	CAX0_KKTPL	☐	KKTPL	KTOPL	CHAR	4	0	Group Chart of Accts	T004
12	CAX0_ISSAK	☐	FC_ISSAKNR	FLAG	CHAR	1	0	Accounts
13	CAX0_ISKST	☐	FC_ISKSTAR	FLAG	CHAR	1	0	Cost Elements
14	CAX0_KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
15	CAX0_DATUM	☐	FC_DATUM	DATUM	DATS	8	0	Date of Last Change
16	CAX0_DATTX	☐	FC_DATTEXT	TEXT20	CHAR	20	0	Formatted key date
17	CAX0_LANGU	☐	FC_LANGU	SPRAS	LANG	1	0	Language key	T002
18	CAX0_ITCLG	☐	FC_ITCGNEW	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts to be created	TF120
19	CAX0_ITTXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
20	CAX0_ITLGH	☐	FC_ITLGH	NUMC02	NUMC	2	0	Output length of FS items
21	CAX0_UPD	☐	FC_UPDATE	FLAG	CHAR	1	0	Copy changes only
22	CAX0_OVR	☐	FC_OVERWR	FLAG	CHAR	1	0	Overwrite
23	CAX0_PROT	☐	FC_PROT	X	CHAR	1	0	Display a log
24	CAX0_TEST	☐	FC_TESTRUN	CHAR1_X	CHAR	1	0	Test run
25	CAX0_REFTX	☐	FC_REFTEXT	TEXT20	CHAR	20	0	Sources for transferring a G/L chart to a Cons chart/accts
26	CAX0_COMTX	☐	FC_COMTEXT	TEXT20	CHAR	20	0	Source of accounts/cost elements in chart/accts comparison
27	CAX0_TOTIT	☐	FC_TOTITM	CHAR1_X	CHAR	1	0	Include totals items in comparison
28	CAX0_TITTX	☐	FC_TITTEXT	TEXT20	CHAR	20	0	Text for including totals items in Acct/FS item comparison
29	CAX0_MODTX	☐	FC_CPMODTX	TEXT20	CHAR	20	0	Treatment of already existing FS items
30	CAX0_RUNTX	☐	FC_RUNTEXT	TEXT20	CHAR	20	0	Type of program execution
31	CAX0_ICGTX	☐	FC_ITCLGTX	TEXT20	CHAR	20	0	New description of a consolidation chart of accounts
32	SYST_TXT	☐	FC_TEXT	CHAR80	CHAR	80	0	Text field
33	SYST_3X	☐	FC_SYST3X	CHAR1_X	CHAR	1	0	Use "upload" to collect data
34	SYST_4X	☐	FC_SYST4X	CHAR1_X	CHAR	1	0	Collect data from same SAP System
35	PGRPIND	☐	FC_PGRPIND	CHAR1_X	CHAR	1	0	Hierarchy grouped by profit center groups
36	GESIND	☐	FC_GESIND	CHAR1_X	CHAR	1	0	Hierarchy grouped by companies
37	BAIND	☐	FC_BAIND	CHAR1_X	CHAR	1	0	Ind.: Hierarchy grouped by business areas
38	DELTIND	☐	FC_DELTIND	CHAR1_X	CHAR	1	0	Copy only new organizational units
39	OK_CODE	☐	OK_CODE	OK_CODE	CHAR	4	0	Entry in OK code field
40	TESTRUNTXT	☐	FC_TESTTXT	TEXT20	CHAR	20	0	Text for executing the program in test mode
41	UPDARUNTXT	☐	FC_UPDATXT	TEXT20	CHAR	20	0	Text for executing the program in update mode
42	CONTP	☐	FC_CONTYP	FC_CONTYP	CHAR	1	0	Consolidation type for integration purposes only	TFIN003
43	FILENAME	☐	FC_PHYSFIL	LOCALFILE	CHAR	128	0	Physical file name
44	TESTRUN	☐	FC_TESTRUN	CHAR1_X	CHAR	1	0	Test run
45	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
46	LMANDT	☐	FC_LMANDT	MANDT	CLNT	3	0	Client of the local SAP System	T000
47	SMANDT	☐	FC_RMANDT	SYCHAR03	CHAR	3	0	Client of the Logical System
48	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
49	RCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	T880
50	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
51	GSBER_KONS	☐	GSBER_KONS	GSBER_KONS	CHAR	4	0	Consolidation business area	TGSBK
52	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
53	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	CEPC
54	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date	CEPC
55	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
56	FLG_ROIND	☐	FC_FLGROND	CHAR1_X	CHAR	1	0	Also select rollup consolidation units
57	PRCTRGRP	☐	FC_PCGRP	FC_SETID	CHAR	34	0	Profit center group
58	FLG_DELDAT	☐	FC_DELDAT	CHAR1_X	CHAR	1	0	Delete data
59	SITYP	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	*
60	FLG_DELSIT	☐	FC_DELSIT	CHAR1_X	CHAR	1	0	Delete existing subitems
61	FLG_COMP	☐	FC_CONTP1	CHAR1_X	CHAR	1	0	Extraction at the company level
62	FLG_GSBER	☐	FC_CONTP2	CHAR1_X	CHAR	1	0	Extraction at the cons business area level
63	FLG_PRES	☐	FC_PRES	FLAG	CHAR	1	0	Presentation server
64	FLG_APPL	☐	FC_APPL	FLAG	CHAR	1	0	Application Server
65	DOCNR	☐	FC_DOCNR	BELNR	CHAR	10	0	Document number for the consolidation document
66	FLG_ALLDG	☐	FC_ALLDG	CHAR1_X	CHAR	1	0	Select all ledgers
67	INRLDNR	☐	FC_INRLDNR	FC_INRLDNR	CHAR	2	0	Reconciliation ledger
68	FMPERI	☐	FC_FMPERI	PERDE	NUMC	3	0	From period
69	FLG_REL_POST46	☐	FC_REL_POST46	X	CHAR	1	0	File for sender system with release 4.6 or higher
70	FLG_REL_PRE46	☐	FC_REL_PRE46	X	CHAR	1	0	File for sender system with release 4.5 or less
71	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
72	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
73	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
74	GLVOR	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
75	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
76	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	T004
77	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
78	KKTPL	☐	KKTPL	KTOPL	CHAR	4	0	Group Chart of Accts	T004
79	ALTKT	☐	BILKT_SKA1	SAKNR	CHAR	10	0	Group Account Number	SKA1
80	FLG_RECONCILE	☐	FC_RECONCILE	CHAR1_X	CHAR	1	0	Execute reconciliation run
81	FLG_SCAN	☐	FC_DOCSCAN	CHAR1_X	CHAR	1	0	Determine Document Volume for Reconciliation
82	FLG_DOWNLOAD	☐	FC_DOWNLOAD	CHAR1_X	CHAR	1	0	Export results to file
83	FLG_DWNLDBLK	☐	FC_BLKDWNLD	CHAR1_X	CHAR	1	0	Export data by block
84	FLG_RECERR	☐	FC_RECERR	CHAR1_X	CHAR	1	0	Only display irregularities
85	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
86	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
87	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
88	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
89	LCURR_FI	☐	FC_LCURR_FI	WAERS	CUKY	5	0	Local currency or parallel local currency of company code	*
90	CURTP_FI	☐	CURRTYP	CURRTYP	CHAR	2	0	Currency Type
91	VALUTYP_FI	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
92	PERID	☐	FC_PERID	PERDE	NUMC	3	0	Period
93	LCURR_CS	☐	FC_CURR	WAERS	CUKY	5	0	Local currency	*
94	LCURR_DIFF	☐	FC_CURR	WAERS	CUKY	5	0	Local currency	*
95	DOCSPERBLOCK	☐	FC_DOCPRBLK		INT4	10	0	Reconciliation General Ledger/Cons: No. Documents per Block
96	LORIG	☐	FC_LORIG	X	CHAR	1	0	Display original list
97	PROT	☐	FC_PROT	X	CHAR	1	0	Display a log
98	RFCDEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	RFCDES
99	AS4LOCAL	☐	AS4LOCAL	AS4LOCAL	CHAR	1	0	Activation Status of a Repository Object
100	AS4VERS	☐	AS4VERS	AS4VERS	NUMC	4	0	Version of the entry (not used)
101	STAB	☐	GLTAB	AS4TAB	CHAR	30	0	Totals Table	DD02L
102	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
103	PLEVL	☐	FC_PLEVL	FC_PLEVL	CHAR	2	0	Posting level
104	FLG_TSL	☐	FC_TSLCMP	CHAR1_X	CHAR	1	0	Reconciliation: Compare Values in Transaction Currency
105	FLG_HSL	☐	FC_HSLCMP	CHAR1_X	CHAR	1	0	Reconciliation: Compare Values in Second Currency
106	FLG_KSL	☐	FC_KSLCMP	CHAR1_X	CHAR	1	0	Reconciliation: Compare Values in Third Currency
107	FLG_MSL	☐	FC_MSLCMP	CHAR1_X	CHAR	1	0	Reconciliation: Compare Quantities
108	FLG_CUMUL	☐	FC_CUMVAL	CHAR1_X	CHAR	1	0	Reconciliation: Accumulate Values
109	FLG_DIFF	☐	FC_DIFFIND	CHAR1_X	CHAR	1	0	Display Reconciliation Differences Only
110	FLG_CUDRV	☐	FC_CUDERIVE	CHAR1_X	CHAR	1	0	Reconciliation: Derive Cons Units from Oper. Org Units
111	FLG_ITEMDRV	☐	FC_ITEMDERIVE	CHAR1_X	CHAR	1	0	Reconciliation: Derive FS Items from Accounts/Cost Elements
112	FLG_YPERDRV	☐	FC_YEARPERDERIVE	CHAR1_X	CHAR	1	0	Reconciliation: Derive Time Frame of Consolidation
113	RLDNR1	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
114	RVERS1	☐	RVERS	RVERS	CHAR	3	0	Version	T894
115	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKA1
116	RYEAR_FROM	☐	FC_FMYEAR	GJAHR	NUMC	4	0	From fiscal year
117	RYEAR_TO	☐	FC_TYEAR	GJAHR	NUMC	4	0	Effective until (fiscal) year
118	PERID_FROM	☐	FC_FMPERI	PERDE	NUMC	3	0	From period
119	PERID_TO	☐	FC_TPERI	PERDE	NUMC	3	0	Effective until period
120	RYEAR1	☐	FC_RYEAR	GJAHR	NUMC	4	0	Fiscal year
121	PERID1	☐	FC_PERID	PERDE	NUMC	3	0	Period
122	RYEAR2	☐	FC_RYEAR	GJAHR	NUMC	4	0	Fiscal year
123	PERID2	☐	FC_PERID	PERDE	NUMC	3	0	Period
124	RBUNIT	☐	FC_BUNIT	FC_BUNIT	CHAR	18	0	Consolidation unit	*
125	RTCUR	☐	FC_RTCUR	WAERS	CUKY	5	0	Transaction currency	*
126	LCURR	☐	FC_CURR	WAERS	CUKY	5	0	Local currency	*
127	GCURR	☐	FC_CGGCURR	WAERS	CUKY	5	0	Group currency	*
128	RUNIT	☐	FC_RUNIT	MEINS	UNIT	3	0	Quantity unit of measure for Consolidation	*
129	VALUTYP1	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
130	VALUTYP2	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
131	CURT1	☐	CURRTYP	CURRTYP	CHAR	2	0	Currency Type
132	CURT2	☐	CURRTYP	CURRTYP	CHAR	2	0	Currency Type
133	RUL_SET	☐	FC_RULSET	CHAR1_X	CHAR	1	0	Set Lock Mode During Rollup into Consolidation
134	RUL_SHOW	☐	FC_RULSHOW	CHAR1_X	CHAR	1	0	Display Lock Mode Entries for Rollups into Consolidation
135	RUL_MATCH	☐	FC_RULMATCH	CHAR1_X	CHAR	1	0	Reconcile Lock Mode Entries for Rollups in Consolidation
136	RUL_DELE	☐	FC_RULDELE	CHAR1_X	CHAR	1	0	Delete Lock Mode Entries for Rollups in Consolidation
137	RULOCK	☐	FC_RULOCK	FC_RULOCK	NUMC	1	0	Lock Modes for Rollup into Consolidation
138	FILENAME1	☐	FC_PHYSFIL1	LOCALFILE	CHAR	128	0	Path and Name of File for Hierarchy Information
139	FILENAME2	☐	FC_PHYSFIL2	LOCALFILE	CHAR	128	0	Path and Name of File for Organizational Units
140	PERYEAR	☐	CHAR8	CHAR8	CHAR	8	0	Character field, 8 characters long
141	PERIV	☐	FC_PERIV	PERIV	CHAR	2	0	Fiscal year variant	*
142	ORDER	☐	TRKORR	TRKORR	CHAR	20	0	Request/Task	*
143	ACTIVITY	☐	ACTI1	ACTIVITY	CHAR	4	0	FI-SL Business Transaction	T022
144	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
145	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
146	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
147	FLG_XCOCD	☐	FC_XCOCDIND	CHAR1_X	CHAR	1	0	Check Cross-Company Code Transaction Completely
148	FLG_ERRON	☐	FC_ERRONLY	CHAR1_X	CHAR	1	0	Show Only Transactions with Errors
149	LCIND_FI	☐	FC_LCIND_FI	FC_LCIND_FI	CHAR	1	0	FI Local Currency
150	FLG1	☐	FC_FLG	CHAR1	CHAR	1	0	General indicator, SAP Consolidation
151	FLG2	☐	FC_FLG	CHAR1	CHAR	1	0	General indicator, SAP Consolidation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FCINTAB	ACTIVITY	T022	ACTIVITY
2	FCINTAB	ALTKT	SKA1	SAKNR
3	FCINTAB	BUKRS	T001	BUKRS		1	CN
4	FCINTAB	BUNIT	TF160	BUNIT
5	FCINTAB	CAX0_ITCLG	TF120	ITCLG
6	FCINTAB	CAX0_KKTPL	T004	KTOPL
7	FCINTAB	CAX0_KOKRS	TKA01	KOKRS
8	FCINTAB	CAX0_KTOPL	T004	KTOPL
9	FCINTAB	CAX0_LANGU	T002	SPRAS
10	FCINTAB	CONTP	TFIN003	CONTP		1	CN
11	FCINTAB	DATBI	CEPC	DATBI
12	FCINTAB	DIMEN	TF150	DIMEN
13	FCINTAB	GSBER_KONS	TGSBK	GSBER_KONS	REF	1	CN
14	FCINTAB	HKONT	SKA1	SAKNR
15	FCINTAB	ITCLG	TF120	ITCLG
16	FCINTAB	ITEM	TF100	ITEM
17	FCINTAB	KKTPL	T004	KTOPL
18	FCINTAB	KOKRS	CEPC	KOKRS
19	FCINTAB	KTOPL	T004	KTOPL
20	FCINTAB	LMANDT	T000	MANDT	REF	1	CN
21	FCINTAB	LOGSYS	TBDLS	LOGSYS	REF	1	CN
22	FCINTAB	MANDT	T000	MANDT
23	FCINTAB	PRCTR	CEPC	PRCTR
24	FCINTAB	RACCT	SKA1	SAKNR
25	FCINTAB	RCOMP	T880	RCOMP	REF	1	CN
26	FCINTAB	RFCDEST	RFCDES	RFCDEST
27	FCINTAB	RLDNR	T881	RLDNR
28	FCINTAB	RLDNR1	T881	RLDNR
29	FCINTAB	RVERS	TF200	RVERS
30	FCINTAB	RVERS1	T894	RVERS
31	FCINTAB	STAB	DD02L	TABNAME

History

Last changed by/on	SAP	20130529
SAP Release Created in