P_ECMCA

SAP Journal Entry Table | view: PCCECMCA | Extraction: Not supported | Component: S4HANA Financial Consolidation[Cloud]

Tables used: ECMCA

🔑 Keys (1)
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (8)
Other (22)
🔗 Relations (17)

Column Name	Description
gl_sirid	Record number of the line item record

Column Name	Description
💲 Currency Key (rtcur):
tsl	Value in Transaction Currency
hsl	Value in Local Currency
ksl	Value in Group Currency

Column Name	Description
📏 Base Unit of Measure (runit):
msl	Quantity

Column Name	Description
budat	Posting Date in the Document
wsdat	Value Date for Currency Translation
cpudt	Day On Which Accounting Document Was Entered
cputm	Time of Entry

Column Name	Description
rrcty	Record Type	Show values
drcrk	Debit/Credit Indicator	Show values
docct	Document Category	Show values
plevl	Posting Level	Show values
rpflg	Apportionment	Show values
rtflg	Currency Translation	Show values
refdocct	Document Category	Show values
coiac	Consolidation of Investments Activity	Show values

Column Name	Description	Domain name
ryear	Fiscal Year	GJAHR
poper	Posting period	POPER
docnr	Document Number of an Accounting Document	BELNR
docln	Six-Character Posting Item for Ledger	DOCLN6
yracq	Year of Acquisition	GJAHR
pracq	Period of Acquisition	NUM03
updhp	Highest update period	POPER
sgtxt	Item Text	TEXT50
autom	Indicator: Automatic posting lines	TEXT1
activ	Business Transaction	CHAR4
bvorg	Number of Cross-Company Code Posting Transaction	BVORG
refdocnr	Document Number of an Accounting Document	BELNR
refryear	Fiscal Year	GJAHR
refdocln	Six-figure number of line item	BUZEI6
refactiv	Business Transaction	CHAR4
rvsdocnr	Reverse Document Number	BELNR
orndocnr	Number of Reversed Document	BELNR
coinr	Consolidation of Investments Activity Number	BELNR
revyear	Year of reversal document or reversed document	GJAHR
awtyp	Reference procedure	AWTYP
aworg	Reference Organizational Units	AWORG
logsys	Logical system	LOGSYS

Master Data Relations	Join Conditions
Investee Unit Client Dimension Investee Unit	`P_ECMCA.MANDT == TF160.MANDT` `P_ECMCA.RDIMEN == TF160.DIMEN` `P_ECMCA.COICU == TF160.BUNIT`
Document Type Client Document Type Dimension	`P_ECMCA.MANDT == TF500.MANDT` `P_ECMCA.DOCTY == TF500.DOCTY` `P_ECMCA.RDIMEN == TF500.DIMEN`
Consolidation Unit Client Consolidation Unit Dimension	`P_ECMCA.MANDT == TF160.MANDT` `P_ECMCA.RBUNIT == TF160.BUNIT` `P_ECMCA.RDIMEN == TF160.DIMEN`
Partner Unit Client Partner Unit Dimension	`P_ECMCA.MANDT == TF160.MANDT` `P_ECMCA.RBUPTR == TF160.BUNIT` `P_ECMCA.RDIMEN == TF160.DIMEN`
Company Company Client	`P_ECMCA.RCOMP == T880.RCOMP` `P_ECMCA.MANDT == T880.MANDT`
Consolidation Group Client Consolidation Group Dimension	`P_ECMCA.MANDT == TF180.MANDT` `P_ECMCA.RCONGR == TF180.CONGR` `P_ECMCA.RDIMEN == TF180.DIMEN`
Dimension Client Dimension	`P_ECMCA.MANDT == TF150.MANDT` `P_ECMCA.RDIMEN == TF150.DIMEN`
Consolidation Chart of Accounts Client Consolidation Chart of Accounts	`P_ECMCA.MANDT == TF120.MANDT` `P_ECMCA.RITCLG == TF120.ITCLG`
Financial Statement Item Client Consolidation Chart of Accounts Financial Statement Item	`P_ECMCA.MANDT == TF100.MANDT` `P_ECMCA.RITCLG == TF100.ITCLG` `P_ECMCA.RITEM == TF100.ITEM`
Ledger Ledger Client	`P_ECMCA.RLDNR == T881.RLDNR` `P_ECMCA.MANDT == T881.MANDT`
Original company code Original company code Client	`P_ECMCA.ROBUKRS == T001.BUKRS` `P_ECMCA.MANDT == T001.MANDT`
Currency Key Client Currency Key	`P_ECMCA.MANDT == TCURC.MANDT` `P_ECMCA.RTCUR == TCURC.WAERS`
Base Unit of Measure Base Unit of Measure Client	`P_ECMCA.RUNIT == T006.MSEHI` `P_ECMCA.MANDT == T006.MANDT`
Version Ledger Version Client	`P_ECMCA.RLDNR == T894.RLDNR` `P_ECMCA.RVERS == T894.RVERS` `P_ECMCA.MANDT == T894.MANDT`
Subitem Category Subitem Category Client	`P_ECMCA.SITYP == TF110.SITYP` `P_ECMCA.MANDT == TF110.MANDT`
Subitem Subitem Category Client Subitem	`P_ECMCA.SITYP == TF115.SITYP` `P_ECMCA.MANDT == TF115.MANDT` `P_ECMCA.SUBIT == TF115.SITEM`
User Name Client User Name	`P_ECMCA.MANDT == USR02.MANDT` `P_ECMCA.USNAM == USR02.BNAME`