ICA_GENJOURNALENTRIES_C

ICA: Universal Journal Entry Line Items for Cloud | view: ICAGENJESC | Extraction: Not supported | Component: Intercompany Reconciliation

Tables used: ACDOCA, T001

🔑 Keys
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (13)
Other (28)
🔗 Relations (49)

Column Name	Description

Column Name	Description
💲 Transaction Currency (rwcur):
wsl	Amount in Transaction Currency
💲 Company Code Currency (rhcur):
hsl	Amount in Company Code Currency
💲 Global Currency (rkcur):
ksl	Amount in Global Currency

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

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

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
xreversing	Indicator: Item is Reversing Another Item	Show values
xreversed	Indicator: Item is Reversed	Show values
xtruerev	Indicator: True reversal (i.e. cancellation)	Show values
glaccount_type	Type of a General Ledger Account	Show values
drcrk	Debit/Credit Indicator	Show values
bstat	Document Status	Show values
koart	Account type	Show values
xopvw	Indicator: Open Item Management?	Show values
gkoar	Offsetting Account Type	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
augbl	Document Number of the Clearing Document	BELNR
auggj	Fiscal Year of Clearing Document	GJAHR
ref_belnr	Document Number of an Accounting Document	BELNR
ref_docln	Six-Character Posting Item for Ledger	DOCLN6
docnr_ld	Ledger specific Accounting Document Number	BELNR
aworg_rev	Reversal: Reference Organizations of Document to Be Reversed	AWORG
awref_rev	Reversal: Reference Document No. of Document to Be Reversed	AWREF
aworg	Reference Organizational Units	AWORG
awref	Reference document number	AWREF
gjahr	Fiscal Year	GJAHR
poper	Posting period	POPER
fiscyearper	Fiscal Year Period	FIS_JAHRPER_CONV
ryear	General Ledger Fiscal Year	GJAHR
zuonr	Assignment number	ZUONR
ktosl	Transaction Key	CHAR3
timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
rebzg	Document No. of the Invoice to Which the Transaction Belongs	BELNR
rebzj	Fiscal Year of the Relevant Invoice (for Credit Memo)	GJAHR
rebzz	Line Item in the Relevant Invoice	BUZEI
rbest	null
sgtxt	Item Text	TEXT50
kdpos	Item number in Sales Order	NUM06
konzs	Group key	KONZS
gkont	Offsetting Account Number	GKONT

Master Data Relations	Join Conditions
Asset Transaction Type Asset Transaction Type Client	`ICA_GENJOURNALENTRIES_C.ANBWA == TABW.BWASL` `ICA_GENJOURNALENTRIES_C.MANDT == TABW.MANDT`
Asset Class Asset Class Client	`ICA_GENJOURNALENTRIES_C.ANLKL == ANKA.ANLKL` `ICA_GENJOURNALENTRIES_C.MANDT == ANKA.MANDT`
Asset Subnumber Main Asset Number Asset Subnumber ? Client	`ICA_GENJOURNALENTRIES_C.ANLN1 == ANLA.ANLN1` `ICA_GENJOURNALENTRIES_C.ANLN2 == ANLA.ANLN2` `ICA_GENJOURNALENTRIES_C.[column in domain "BUKRS"] == ANLA.BUKRS` `ICA_GENJOURNALENTRIES_C.MANDT == ANLA.MANDT`
Document Type Client Document Type	`ICA_GENJOURNALENTRIES_C.MANDT == T003.MANDT` `ICA_GENJOURNALENTRIES_C.BLART == T003.BLART`
Industry key Industry key Client	`ICA_GENJOURNALENTRIES_C.BRSCH == T016.BRSCH` `ICA_GENJOURNALENTRIES_C.MANDT == T016.MANDT`
Posting Key Posting Key Client	`ICA_GENJOURNALENTRIES_C.BSCHL == TBSL.BSCHL` `ICA_GENJOURNALENTRIES_C.MANDT == TBSL.MANDT`
Business Transaction Category Business Transaction Category Client	`ICA_GENJOURNALENTRIES_C.BTTYPE == FINSC_BTTYPE.BTTYPE` `ICA_GENJOURNALENTRIES_C.MANDT == FINSC_BTTYPE.MANDT`
Sales District Client Sales District	`ICA_GENJOURNALENTRIES_C.MANDT == T171.MANDT` `ICA_GENJOURNALENTRIES_C.BZIRK == T171.BZIRK`
Partner profit center for elimination of internal business ? Partner profit center for elimination of internal business ? Client	`ICA_GENJOURNALENTRIES_C.[column in domain "KOKRS"] == CEPC.KOKRS` `ICA_GENJOURNALENTRIES_C.EPRCTR == CEPC.PRCTR` `ICA_GENJOURNALENTRIES_C.[column in domain "DATBI"] == CEPC.DATBI` `ICA_GENJOURNALENTRIES_C.MANDT == CEPC.MANDT`
Billing Type Billing Type Client	`ICA_GENJOURNALENTRIES_C.FKART == TVFK.FKART` `ICA_GENJOURNALENTRIES_C.MANDT == TVFK.MANDT`
Customer Group Customer Group Client	`ICA_GENJOURNALENTRIES_C.KDGRP == T151.KDGRP` `ICA_GENJOURNALENTRIES_C.MANDT == T151.MANDT`
Chart of Accounts Chart of Accounts Client	`ICA_GENJOURNALENTRIES_C.KTOPL == T004.KTOPL` `ICA_GENJOURNALENTRIES_C.MANDT == T004.MANDT`
Customer Number Customer Number Client	`ICA_GENJOURNALENTRIES_C.KUNNR == KNA1.KUNNR` `ICA_GENJOURNALENTRIES_C.MANDT == KNA1.MANDT`
Bill-to Party Client Bill-to Party	`ICA_GENJOURNALENTRIES_C.MANDT == KNA1.MANDT` `ICA_GENJOURNALENTRIES_C.KUNRE == KNA1.KUNNR`
Ship-to Party Ship-to Party Client	`ICA_GENJOURNALENTRIES_C.KUNWE == KNA1.KUNNR` `ICA_GENJOURNALENTRIES_C.MANDT == KNA1.MANDT`
Country/Region Key Country/Region Key Client	`ICA_GENJOURNALENTRIES_C.LAND1 == T005.LAND1` `ICA_GENJOURNALENTRIES_C.MANDT == T005.MANDT`
Account Number of Supplier Account Number of Supplier Client	`ICA_GENJOURNALENTRIES_C.LIFNR == LFA1.LIFNR` `ICA_GENJOURNALENTRIES_C.MANDT == LFA1.MANDT`
Item Category	`ICA_GENJOURNALENTRIES_C.LINETYPE == T8G02.LINETYPE`
Product Sold Group Client Product Sold Group	`ICA_GENJOURNALENTRIES_C.MANDT == T023.MANDT` `ICA_GENJOURNALENTRIES_C.MATKL == T023.MATKL`
Material Number Client Material Number	`ICA_GENJOURNALENTRIES_C.MANDT == MARA.MANDT` `ICA_GENJOURNALENTRIES_C.MATNR == MARA.MATNR`
Product Sold Product Sold Client	`ICA_GENJOURNALENTRIES_C.MATNR_COPA == MARA.MATNR` `ICA_GENJOURNALENTRIES_C.MANDT == MARA.MANDT`
Tax on sales/purchases code Tax on sales/purchases code ? Client	`ICA_GENJOURNALENTRIES_C.MWSKZ == T007A.MWSKZ` `ICA_GENJOURNALENTRIES_C.[column in domain "KALSM_D"] == T007A.KALSM` `ICA_GENJOURNALENTRIES_C.MANDT == T007A.MANDT`
Partner Asset Subnumber (Transfer) ? Main Number Partner Asset (Transfer) Partner Asset Subnumber (Transfer) Client	`ICA_GENJOURNALENTRIES_C.[column in domain "BUKRS"] == ANLA.BUKRS` `ICA_GENJOURNALENTRIES_C.PANL1 == ANLA.ANLN1` `ICA_GENJOURNALENTRIES_C.PANL2 == ANLA.ANLN2` `ICA_GENJOURNALENTRIES_C.MANDT == ANLA.MANDT`
Fiscal Year Variant Client Fiscal Year Variant	`ICA_GENJOURNALENTRIES_C.MANDT == T009.MANDT` `ICA_GENJOURNALENTRIES_C.PERIV == T009.PERIV`
Partner Profit Center ? ? Partner Profit Center Client	`ICA_GENJOURNALENTRIES_C.[column in domain "KOKRS"] == CEPC.KOKRS` `ICA_GENJOURNALENTRIES_C.[column in domain "DATBI"] == CEPC.DATBI` `ICA_GENJOURNALENTRIES_C.PPRCTR == CEPC.PRCTR` `ICA_GENJOURNALENTRIES_C.MANDT == CEPC.MANDT`
Profit Center ? Profit Center ? Client	`ICA_GENJOURNALENTRIES_C.[column in domain "KOKRS"] == CEPC.KOKRS` `ICA_GENJOURNALENTRIES_C.PRCTR == CEPC.PRCTR` `ICA_GENJOURNALENTRIES_C.[column in domain "DATBI"] == CEPC.DATBI` `ICA_GENJOURNALENTRIES_C.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`ICA_GENJOURNALENTRIES_C.PSEGMENT == FAGL_SEGM.SEGMENT` `ICA_GENJOURNALENTRIES_C.MANDT == FAGL_SEGM.MANDT`
Account Number Company Code Account Number Client	`ICA_GENJOURNALENTRIES_C.RBUKRS == SKB1.BUKRS` `ICA_GENJOURNALENTRIES_C.RACCT == SKB1.SAKNR` `ICA_GENJOURNALENTRIES_C.MANDT == SKB1.MANDT`
Company ID of Trading Partner Client Company ID of Trading Partner	`ICA_GENJOURNALENTRIES_C.MANDT == T880.MANDT` `ICA_GENJOURNALENTRIES_C.RASSC == T880.RCOMP`
Company Code Company Code Client	`ICA_GENJOURNALENTRIES_C.RBUKRS == T001.BUKRS` `ICA_GENJOURNALENTRIES_C.MANDT == T001.MANDT`
Cost Center ? ? Client Cost Center	`ICA_GENJOURNALENTRIES_C.[column in domain "KOKRS"] == CSKS.KOKRS` `ICA_GENJOURNALENTRIES_C.[column in domain "DATBI"] == CSKS.DATBI` `ICA_GENJOURNALENTRIES_C.MANDT == CSKS.MANDT` `ICA_GENJOURNALENTRIES_C.RCNTR == CSKS.KOSTL`
Allocation of company code to company Client Company	`ICA_GENJOURNALENTRIES_C.MANDT == T880.MANDT` `ICA_GENJOURNALENTRIES_C.RCOMP == T880.RCOMP`
Company Code Currency Client Company Code Currency	`ICA_GENJOURNALENTRIES_C.MANDT == TCURC.MANDT` `ICA_GENJOURNALENTRIES_C.RHCUR == TCURC.WAERS`
Global Currency Global Currency Client	`ICA_GENJOURNALENTRIES_C.RKCUR == TCURC.WAERS` `ICA_GENJOURNALENTRIES_C.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Client Ledger in General Ledger Accounting	`ICA_GENJOURNALENTRIES_C.MANDT == FINSC_LEDGER.MANDT` `ICA_GENJOURNALENTRIES_C.RLDNR == FINSC_LEDGER.RLDNR`
Transaction type Transaction type Client	`ICA_GENJOURNALENTRIES_C.RMVCT == T856.TRTYP` `ICA_GENJOURNALENTRIES_C.MANDT == T856.MANDT`
Base Unit of Measure Client Base Unit of Measure	`ICA_GENJOURNALENTRIES_C.MANDT == T006.MANDT` `ICA_GENJOURNALENTRIES_C.RUNIT == T006.MSEHI`
Sender cost center ? Sender cost center ? Client	`ICA_GENJOURNALENTRIES_C.[column in domain "KOKRS"] == CSKS.KOKRS` `ICA_GENJOURNALENTRIES_C.SCNTR == CSKS.KOSTL` `ICA_GENJOURNALENTRIES_C.[column in domain "DATBI"] == CSKS.DATBI` `ICA_GENJOURNALENTRIES_C.MANDT == CSKS.MANDT`
Segment for Segmental Reporting Client Segment for Segmental Reporting	`ICA_GENJOURNALENTRIES_C.MANDT == FAGL_SEGM.MANDT` `ICA_GENJOURNALENTRIES_C.SEGMENT == FAGL_SEGM.SEGMENT`
Subledger-Specific Line Item Type	`ICA_GENJOURNALENTRIES_C.SLALITTYPE == FINSTS_SLALITTY.SLALITTYPE`
Division Client Division	`ICA_GENJOURNALENTRIES_C.MANDT == TSPA.MANDT` `ICA_GENJOURNALENTRIES_C.SPART == TSPA.SPART`
Special G/L Indicator Client Account type Special G/L Indicator	`ICA_GENJOURNALENTRIES_C.MANDT == T074U.MANDT` `ICA_GENJOURNALENTRIES_C.KOART == T074U.KOART` `ICA_GENJOURNALENTRIES_C.UMSKZ == T074U.UMSKZ`
Sales Organization Sales Organization Client	`ICA_GENJOURNALENTRIES_C.VKORG == TVKO.VKORG` `ICA_GENJOURNALENTRIES_C.MANDT == TVKO.MANDT`
Distribution Channel Client Distribution Channel	`ICA_GENJOURNALENTRIES_C.MANDT == TVTW.MANDT` `ICA_GENJOURNALENTRIES_C.VTWEG == TVTW.VTWEG`
Plant Client Plant	`ICA_GENJOURNALENTRIES_C.MANDT == T001W.MANDT` `ICA_GENJOURNALENTRIES_C.WERKS == T001W.WERKS`