ICA_CONSJOURNALENTRIES_5

ICA: Consolidation Journal Entry Line Items | view: ICACONSJES5 | Extraction: Not supported | Component: Intercompany Reconciliation

Tables used: ACDOCA, ACDOCU, FINCS_BUNIT, FINCS_BUNIT_ATVD, FINCS_FSIASSGMT, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, FINSC_FISC_DATE, FINSC_LEDGER_REP

🔑 Keys
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (3)
☰ Categorical (12)
Other (29)
🔗 Relations (46)

Column Name	Description

Column Name	Description
💲 Currency Key (rtcur):
tsl	Value in Transaction Currency
💲 Currency key of the local currency (rhcur):
hsl	Value in Local Currency
💲 Currency key of the ledger currency (rkcur):
ksl	Value in Group Currency

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

Column Name	Description
DUE_DATE	Due Date
budat	Posting Date in the Document
augdt	Clearing Date

Column Name	Description
PSTAT	Processing Status	Show values
CSTAT	Communication Status	Show values
CLEARING_STATUS	Clearing Status of Open Items	Show values
rrcty	Record Type	Show values
drcrk	Debit/Credit Indicator	Show values
docct	Document Category	Show values
plevl	Posting Level	Show values
rtflg	Currency Translation	Show values
koart	Account type	Show values
xopvw	Indicator: Open Item Management?	Show values
XREVERSING	Indicator: Item is Reversing Another Item	Show values
XREVERSED	Indicator: Item is Reversed	Show values

Column Name	Description	Domain name
method_id	Matching Method ID	ICA_METHOD_ID
DOCNR	Matching Document Number	ICA_DOCNR
DOCLN	Matching Document Line Item Number	ICA_DOCLN
GRREF	Assignment Number	ICA_GRREF
fiscyearper	Fiscal Year/Period	FINS_JAHRPER
ryear	Fiscal Year	GJAHR
gjahr	Fiscal Year	GJAHR
ref_belnr	Document Number of an Accounting Document	BELNR
ref_docln	Six-Character Posting Item for Ledger	DOCLN6
BTTYPE	Business Transaction Category	FINS_BTTYPE
poper	Posting period	POPER
sa_role	null
sa_elimination	null
blart	Document Type	BLART
sgtxt	Item Text	TEXT50
timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
awtyp	Reference procedure	AWTYP
aworg	Reference Organizational Units	AWORG
zuonr	Assignment number	ZUONR
umskz	Special G/L Indicator	UMSKZ
mwskz	Tax on sales/purchases code	MWSKZ
augbl	Document Number of the Clearing Document	BELNR
auggj	Fiscal Year of Clearing Document	GJAHR
ps_psp_pnr	Work Breakdown Structure Element (WBS Element)	PS_POSNR
ps_posid	Work Breakdown Structure Element (WBS Element)	PS_POSID
ps_pspid	Project definition	PS_PSPID
konzs	Group key	KONZS
awref	Reference document number	AWREF
AWREF_REV	Reversal: Reference Document No. of Document to Be Reversed	AWREF

Master Data Relations	Join Conditions
Order Number Client Order Number	`ICA_CONSJOURNALENTRIES_5.MANDT == AUFK.MANDT` `ICA_CONSJOURNALENTRIES_5.AUFNR == AUFK.AUFNR`
Industry key Client Industry key	`ICA_CONSJOURNALENTRIES_5.MANDT == T016.MANDT` `ICA_CONSJOURNALENTRIES_5.BRSCH == T016.BRSCH`
Sales District Client Sales District	`ICA_CONSJOURNALENTRIES_5.MANDT == T171.MANDT` `ICA_CONSJOURNALENTRIES_5.BZIRK == T171.BZIRK`
Document Type Client Dimension Document Type	`ICA_CONSJOURNALENTRIES_5.MANDT == TF500.MANDT` `ICA_CONSJOURNALENTRIES_5.RDIMEN == TF500.DIMEN` `ICA_CONSJOURNALENTRIES_5.DOCTY == TF500.DOCTY`
Billing Type Client Billing Type	`ICA_CONSJOURNALENTRIES_5.MANDT == TVFK.MANDT` `ICA_CONSJOURNALENTRIES_5.FKART == TVFK.FKART`
Customer Group Client Customer Group	`ICA_CONSJOURNALENTRIES_5.MANDT == T151.MANDT` `ICA_CONSJOURNALENTRIES_5.KDGRP == T151.KDGRP`
Controlling Area Client Controlling Area	`ICA_CONSJOURNALENTRIES_5.MANDT == TKA01.MANDT` `ICA_CONSJOURNALENTRIES_5.KOKRS == TKA01.KOKRS`
Chart of Accounts Client Chart of Accounts	`ICA_CONSJOURNALENTRIES_5.MANDT == T004.MANDT` `ICA_CONSJOURNALENTRIES_5.KTOPL == T004.KTOPL`
Customer Number Client Customer Number	`ICA_CONSJOURNALENTRIES_5.MANDT == KNA1.MANDT` `ICA_CONSJOURNALENTRIES_5.KUNNR == KNA1.KUNNR`
Bill-to Party Client Bill-to Party	`ICA_CONSJOURNALENTRIES_5.MANDT == KNA1.MANDT` `ICA_CONSJOURNALENTRIES_5.KUNRE == KNA1.KUNNR`
Ship-to Party Client Ship-to Party	`ICA_CONSJOURNALENTRIES_5.MANDT == KNA1.MANDT` `ICA_CONSJOURNALENTRIES_5.KUNWE == KNA1.KUNNR`
Country/Region Key Client Country/Region Key	`ICA_CONSJOURNALENTRIES_5.MANDT == T005.MANDT` `ICA_CONSJOURNALENTRIES_5.LAND1 == T005.LAND1`
Account Number of Supplier Account Number of Supplier Client	`ICA_CONSJOURNALENTRIES_5.LIFNR == LFA1.LIFNR` `ICA_CONSJOURNALENTRIES_5.MANDT == LFA1.MANDT`
Product Sold Group Client Product Sold Group	`ICA_CONSJOURNALENTRIES_5.MANDT == T023.MANDT` `ICA_CONSJOURNALENTRIES_5.MATKL == T023.MATKL`
Material Group Material Group Client	`ICA_CONSJOURNALENTRIES_5.MATKL_MM == T023.MATKL` `ICA_CONSJOURNALENTRIES_5.MANDT == T023.MANDT`
Material Number Client Material Number	`ICA_CONSJOURNALENTRIES_5.MANDT == MARA.MANDT` `ICA_CONSJOURNALENTRIES_5.MATNR == MARA.MATNR`
Product Sold Client Product Sold	`ICA_CONSJOURNALENTRIES_5.MANDT == MARA.MANDT` `ICA_CONSJOURNALENTRIES_5.MATNR_COPA == MARA.MATNR`
Partner Profit Center Client Controlling Area Partner Profit Center ?	`ICA_CONSJOURNALENTRIES_5.MANDT == CEPC.MANDT` `ICA_CONSJOURNALENTRIES_5.KOKRS == CEPC.KOKRS` `ICA_CONSJOURNALENTRIES_5.PPRCTR == CEPC.PRCTR` `ICA_CONSJOURNALENTRIES_5.[column in domain "DATBI"] == CEPC.DATBI`
Profit Center Client Controlling Area Profit Center ?	`ICA_CONSJOURNALENTRIES_5.MANDT == CEPC.MANDT` `ICA_CONSJOURNALENTRIES_5.KOKRS == CEPC.KOKRS` `ICA_CONSJOURNALENTRIES_5.PRCTR == CEPC.PRCTR` `ICA_CONSJOURNALENTRIES_5.[column in domain "DATBI"] == CEPC.DATBI`
Partner Segment for Segmental Reporting Client Partner Segment for Segmental Reporting	`ICA_CONSJOURNALENTRIES_5.MANDT == FAGL_SEGM.MANDT` `ICA_CONSJOURNALENTRIES_5.PSEGMENT == FAGL_SEGM.SEGMENT`
Account Number Client Account Number Original company code	`ICA_CONSJOURNALENTRIES_5.MANDT == SKB1.MANDT` `ICA_CONSJOURNALENTRIES_5.RACCT == SKB1.SAKNR` `ICA_CONSJOURNALENTRIES_5.ROBUKRS == SKB1.BUKRS`
Company ID of Trading Partner Company ID of Trading Partner Client	`ICA_CONSJOURNALENTRIES_5.RASSC == T880.RCOMP` `ICA_CONSJOURNALENTRIES_5.MANDT == T880.MANDT`
Consolidation Unit Client Dimension Consolidation Unit	`ICA_CONSJOURNALENTRIES_5.MANDT == TF160.MANDT` `ICA_CONSJOURNALENTRIES_5.RDIMEN == TF160.DIMEN` `ICA_CONSJOURNALENTRIES_5.RBUNIT == TF160.BUNIT`
Partner Unit Client Dimension Partner Unit	`ICA_CONSJOURNALENTRIES_5.MANDT == TF160.MANDT` `ICA_CONSJOURNALENTRIES_5.RDIMEN == TF160.DIMEN` `ICA_CONSJOURNALENTRIES_5.RBUPTR == TF160.BUNIT`
Cost Center Client Controlling Area ? Cost Center	`ICA_CONSJOURNALENTRIES_5.MANDT == CSKS.MANDT` `ICA_CONSJOURNALENTRIES_5.KOKRS == CSKS.KOKRS` `ICA_CONSJOURNALENTRIES_5.[column in domain "DATBI"] == CSKS.DATBI` `ICA_CONSJOURNALENTRIES_5.RCNTR == CSKS.KOSTL`
Company Client Company	`ICA_CONSJOURNALENTRIES_5.MANDT == T880.MANDT` `ICA_CONSJOURNALENTRIES_5.RCOMP == T880.RCOMP`
Consolidation Group Client Dimension Consolidation Group	`ICA_CONSJOURNALENTRIES_5.MANDT == TF180.MANDT` `ICA_CONSJOURNALENTRIES_5.RDIMEN == TF180.DIMEN` `ICA_CONSJOURNALENTRIES_5.RCONGR == TF180.CONGR`
Dimension Client Dimension	`ICA_CONSJOURNALENTRIES_5.MANDT == TF150.MANDT` `ICA_CONSJOURNALENTRIES_5.RDIMEN == TF150.DIMEN`
Functional Area Client Functional Area	`ICA_CONSJOURNALENTRIES_5.MANDT == TFKB.MANDT` `ICA_CONSJOURNALENTRIES_5.RFAREA == TFKB.FKBER`
Consolidation Chart of Accounts Client Consolidation Chart of Accounts	`ICA_CONSJOURNALENTRIES_5.MANDT == TF120.MANDT` `ICA_CONSJOURNALENTRIES_5.RITCLG == TF120.ITCLG`
Financial Statement Item Client Consolidation Chart of Accounts Financial Statement Item	`ICA_CONSJOURNALENTRIES_5.MANDT == TF100.MANDT` `ICA_CONSJOURNALENTRIES_5.RITCLG == TF100.ITCLG` `ICA_CONSJOURNALENTRIES_5.RITEM == TF100.ITEM`
Ledger Client Ledger	`ICA_CONSJOURNALENTRIES_5.MANDT == T881.MANDT` `ICA_CONSJOURNALENTRIES_5.RLDNR == T881.RLDNR`
Transaction type Client Transaction type	`ICA_CONSJOURNALENTRIES_5.MANDT == T856.MANDT` `ICA_CONSJOURNALENTRIES_5.RMVCT == T856.TRTYP`
Original company code Client Original company code	`ICA_CONSJOURNALENTRIES_5.MANDT == T001.MANDT` `ICA_CONSJOURNALENTRIES_5.ROBUKRS == T001.BUKRS`
Currency Key Client Currency Key	`ICA_CONSJOURNALENTRIES_5.MANDT == TCURC.MANDT` `ICA_CONSJOURNALENTRIES_5.RTCUR == TCURC.WAERS`
Base Unit of Measure Client Base Unit of Measure	`ICA_CONSJOURNALENTRIES_5.MANDT == T006.MANDT` `ICA_CONSJOURNALENTRIES_5.RUNIT == T006.MSEHI`
Consolidation Version Client Consolidation Version	`ICA_CONSJOURNALENTRIES_5.MANDT == TF200.MANDT` `ICA_CONSJOURNALENTRIES_5.RVERS == TF200.RVERS`
Sender cost center Client Sender cost center Controlling Area ?	`ICA_CONSJOURNALENTRIES_5.MANDT == CSKS.MANDT` `ICA_CONSJOURNALENTRIES_5.SCNTR == CSKS.KOSTL` `ICA_CONSJOURNALENTRIES_5.KOKRS == CSKS.KOKRS` `ICA_CONSJOURNALENTRIES_5.[column in domain "DATBI"] == CSKS.DATBI`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`ICA_CONSJOURNALENTRIES_5.MANDT == FAGL_SEGM.MANDT` `ICA_CONSJOURNALENTRIES_5.SEGMENT == FAGL_SEGM.SEGMENT`
Partner Functional Area Client Partner Functional Area	`ICA_CONSJOURNALENTRIES_5.MANDT == TFKB.MANDT` `ICA_CONSJOURNALENTRIES_5.SFAREA == TFKB.FKBER`
Subitem Category Client Subitem Category	`ICA_CONSJOURNALENTRIES_5.MANDT == TF110.MANDT` `ICA_CONSJOURNALENTRIES_5.SITYP == TF110.SITYP`
Division Client Division	`ICA_CONSJOURNALENTRIES_5.MANDT == TSPA.MANDT` `ICA_CONSJOURNALENTRIES_5.SPART == TSPA.SPART`
Subitem Client Subitem Category Subitem	`ICA_CONSJOURNALENTRIES_5.MANDT == TF115.MANDT` `ICA_CONSJOURNALENTRIES_5.SITYP == TF115.SITYP` `ICA_CONSJOURNALENTRIES_5.SUBIT == TF115.SITEM`
Sales Organization Client Sales Organization	`ICA_CONSJOURNALENTRIES_5.MANDT == TVKO.MANDT` `ICA_CONSJOURNALENTRIES_5.VKORG == TVKO.VKORG`
Distribution Channel Client Distribution Channel	`ICA_CONSJOURNALENTRIES_5.MANDT == TVTW.MANDT` `ICA_CONSJOURNALENTRIES_5.VTWEG == TVTW.VTWEG`
Plant Client Plant	`ICA_CONSJOURNALENTRIES_5.MANDT == T001W.MANDT` `ICA_CONSJOURNALENTRIES_5.WERKS == T001W.WERKS`