SAP ABAP Table FILCA (FI-LC: Actual journal entry table with 2 object tables)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LC-LC (Application Component) Basic Functions
     ⤷ FKUC (Package) FI-LC Consolidation: Unicode-Capable Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FILCA	Table Relationship Diagram
Short Description	FI-LC: Actual journal entry table with 2 object tables

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	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
10	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
11	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
12	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
13	DOCLN	☐	DOCLN	DOCLN	CHAR	3	0	Document line
14	RCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	T880
15	RACCT	☐	RITEM	RITEM	CHAR	10	0	Consolidation item	T854
16	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
17	RASSC	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
18	ROBUKRS	☐	OBUKR	BUKRS	CHAR	4	0	Original company code	T001
19	RLEVL	☐	RLEVL	RLEVL	CHAR	1	0	Posting level
20	DOCTY	☐	DOCTY	DOCTY	CHAR	2	0	FI-SL Document Type	T889
21	RSUBD	☐	RSUBD	RSUBD	CHAR	3	0	Subgroup	T852
22	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
23	RYACQ	☐	RYACQ	CJAHR	CHAR	4	0	Year of acquisition
24	RPACQ	☐	RPACQ	NUM03	NUMC	3	0	Period of Acquisition
25	OCLNT	☐	OCLNT	NUM3	NUMC	3	0	Original client
26	ADFLD1	☐	ADFLD1	ADFLD1	CHAR	10	0	First additional field for user-defined account assignments	T85A
27	ADFLD2	☐	ADFLD2	ADFLD2	CHAR	10	0	Second additional field for user-defined account assignments	T85B
28	ADFLD3	☐	ADFLD3	ADFLD3	CHAR	10	0	Third additional field for user-defined account assignments	T85C
29	SCOMP	☐	SCOMP_D	RCOMP	CHAR	6	0	Company	T880
30	SACCT	☐	S_ITEM	RITEM	CHAR	10	0	Consolidation item	T854
31	SBUSA	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
32	SASSC	☐	SASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
33	UPDHP	☐	UPDHP	POPER	NUMC	3	0	Highest update period
34	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
35	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
36	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
37	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
38	ASL	☐	QUAN2	MENG8	QUAN	15	3	Additional Quantity
39	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
40	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
41	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
42	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
43	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
44	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
45	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
46	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
47	REFRYEAR	☐	REFGJAHR	GJAHR	NUMC	4	0	Reference fiscal year
48	REFDOCLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
49	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
50	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
51	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
52	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
53	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
54	RVSDOCNR	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
55	ORNDOCNR	☐	STBLN	BELNR	CHAR	10	0	Document number of reversed document
56	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
57	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
58	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FILCA	ADFLD1	T85A	ADFLD1
2	FILCA	ADFLD2	T85B	ADFLD2
3	FILCA	ADFLD3	T85C	ADFLD3
4	FILCA	AUNIT	T006	MSEHI	REF	C	CN
5	FILCA	DOCTY	T889	DOCTY	REF	C	CN
6	FILCA	RACCT	T854	ITEM	REF	C	CN
7	FILCA	RBUSA	TGSB	GSBER	REF	C	CN
8	FILCA	RCLNT	T000	MANDT	KEY	1	CN
9	FILCA	RCOMP	T880	RCOMP	REF	C	CN
10	FILCA	RLDNR	T881	RLDNR	REF	C	CN
11	FILCA	RMVCT	T856	TRTYP	REF	C	CN
12	FILCA	ROBUKRS	T001	BUKRS	REF	C	CN
13	FILCA	RSUBD	T852	RSUBD	REF	C	CN
14	FILCA	RTCUR	TCURC	WAERS	REF	C	CN
15	FILCA	RUNIT	T006	MSEHI	REF	C	CN
16	FILCA	RVERS	T894	RVERS	REF	C	CN
17	FILCA	SACCT	T854	ITEM	REF	C	CN
18	FILCA	SASSC	T880	RCOMP		C	CN
19	FILCA	SBUSA	TGSB	GSBER	REF	C	CN
20	FILCA	SCOMP	T880	RCOMP	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in