SAP ABAP Table ECMCA (SAP Cons.: Journal Entry Table (Actual))

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ECMCA	Table Relationship Diagram
Short Description	SAP Cons.: Journal Entry Table (Actual)

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	☐	DOCLN6	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
14	RCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	T880
15	RDIMEN	☐	FC_DIMEN	FC_DIMEN	CHAR	2	0	Dimension	TF150
16	RBUNIT	☐	FC_BUNIT	FC_BUNIT	CHAR	18	0	Consolidation unit	TF160
17	RITCLG	☐	FC_ITCLG	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts	TF120
18	RITEM	☐	FC_ITEM	FC_ITEM	CHAR	10	0	Financial statement item	TF100
19	RBUPTR	☐	FC_BUPTR	FC_BUNIT	CHAR	18	0	Partner unit	TF160
20	RCONGR	☐	FC_CONGR	FC_CONGR	CHAR	18	0	Consolidation group	TF180
21	ROBUKRS	☐	OBUKR	BUKRS	CHAR	4	0	Original company code	T001
22	SITYP	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	TF110
23	SUBIT	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	TF115
24	PLEVL	☐	FC_PLEVL	FC_PLEVL	CHAR	2	0	Posting level
25	RPFLG	☐	FC_RPFLG	FC_RPFLG	NUMC	1	0	Apportionment
26	RTFLG	☐	FC_RTFLG	FC_RTFLG	NUMC	1	0	Currency translation
27	DOCTY	☐	FC_DOCTY	FC_DOCTY	CHAR	2	0	Document type	TF500
28	YRACQ	☐	FC_RYACQ	GJAHR	NUMC	4	0	Year of acquisition
29	PRACQ	☐	RPACQ	NUM03	NUMC	3	0	Period of Acquisition
30	COICU	☐	FC_COICU	FC_BUNIT	CHAR	18	0	Investee unit	TF160
31	.INCLUDE	☐				0	0
32	UPDHP	☐	UPDHP	POPER	NUMC	3	0	Highest update period
33	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
34	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
35	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
36	MSL	☐	QUAN1_9	MENGV9	QUAN	17	3	Quantity
37	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
38	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
39	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
40	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
41	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
42	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
43	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
44	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
45	REFDOCLN	☐	BUZEI6	BUZEI6	NUMC	6	0	Six-figure number of line item
46	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
47	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
48	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
49	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
50	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	USR02
51	RVSDOCNR	☐	STBLG	BELNR	CHAR	10	0	Reverse Document Number
52	ORNDOCNR	☐	STBLN	BELNR	CHAR	10	0	Document number of reversed document
53	COIAC	☐	FC_COIAC	FC_COIAC	CHAR	2	0	Activity for consolidation of investments
54	COINR	☐	FC_COINR	BELNR	CHAR	10	0	Consolidation of investments activity number
55	REVYEAR	☐	FC_REVYEAR	GJAHR	NUMC	4	0	Year of reversal document or 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	ECMCA	COICU	TF160	BUNIT	REF	C	CN
2	ECMCA	DOCTY	TF500	DOCTY	REF	C	CN
3	ECMCA	RBUNIT	TF160	BUNIT	REF	C	CN
4	ECMCA	RBUPTR	TF160	BUNIT	REF	C	CN
5	ECMCA	RCLNT	T000	MANDT	KEY	1	CN
6	ECMCA	RCOMP	T880	RCOMP	REF	C	CN
7	ECMCA	RCONGR	TF180	CONGR	REF	C	CN
8	ECMCA	RDIMEN	TF150	DIMEN	REF	C	CN
9	ECMCA	RITCLG	TF120	ITCLG	REF	C	CN
10	ECMCA	RITEM	TF100	ITEM	REF	C	CN
11	ECMCA	RLDNR	T881	RLDNR	REF	C	CN
12	ECMCA	ROBUKRS	T001	BUKRS	REF	C	CN
13	ECMCA	RTCUR	TCURC	WAERS	REF	C	CN
14	ECMCA	RUNIT	T006	MSEHI	REF	C	CN
15	ECMCA	RVERS	T894	RVERS	REF	C	CN
16	ECMCA	SITYP	TF110	SITYP	REF	C	CN
17	ECMCA	SUBIT	TF115	SITEM	REF	C	CN
18	ECMCA	USNAM	USR02	BNAME	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in