ICA_GENJOURNALENTRIES_2

ICA: Universal Journal Entry Line Items for OP | view: ICAGENJES2 | Extraction: Not supported | Component: Intercompany Reconciliation
Tables used: ACDOCA, T001, T009, FINSC_FISC_DATE
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 Fiscal Period POPER
fiscyearper Fiscal Year Period FIS_JAHRPER_CONV
ryear 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
  • Client
  • Asset Transaction Type
  • ICA_GENJOURNALENTRIES_2.MANDT == TABW.MANDT
  • ICA_GENJOURNALENTRIES_2.ANBWA == TABW.BWASL
Asset Class
  • Client
  • Asset Class
  • ICA_GENJOURNALENTRIES_2.MANDT == ANKA.MANDT
  • ICA_GENJOURNALENTRIES_2.ANLKL == ANKA.ANLKL
Asset Subnumber
  • Main Asset Number
  • Client
  • Asset Subnumber
  • ?
  • ICA_GENJOURNALENTRIES_2.ANLN1 == ANLA.ANLN1
  • ICA_GENJOURNALENTRIES_2.MANDT == ANLA.MANDT
  • ICA_GENJOURNALENTRIES_2.ANLN2 == ANLA.ANLN2
  • ICA_GENJOURNALENTRIES_2.[column in domain "BUKRS"] == ANLA.BUKRS
Document Type
  • Client
  • Document Type
  • ICA_GENJOURNALENTRIES_2.MANDT == T003.MANDT
  • ICA_GENJOURNALENTRIES_2.BLART == T003.BLART
Industry key
  • Industry key
  • Client
  • ICA_GENJOURNALENTRIES_2.BRSCH == T016.BRSCH
  • ICA_GENJOURNALENTRIES_2.MANDT == T016.MANDT
Posting Key
  • Client
  • Posting Key
  • ICA_GENJOURNALENTRIES_2.MANDT == TBSL.MANDT
  • ICA_GENJOURNALENTRIES_2.BSCHL == TBSL.BSCHL
Business Transaction Category
  • Client
  • Business Transaction Category
Sales District
  • Sales District
  • Client
  • ICA_GENJOURNALENTRIES_2.BZIRK == T171.BZIRK
  • ICA_GENJOURNALENTRIES_2.MANDT == T171.MANDT
Partner profit center for elimination of internal business
  • Client
  • Controlling Area
  • ?
  • Partner profit center for elimination of internal business
  • ICA_GENJOURNALENTRIES_2.MANDT == CEPC.MANDT
  • ICA_GENJOURNALENTRIES_2.KOKRS == CEPC.KOKRS
  • ICA_GENJOURNALENTRIES_2.[column in domain "DATBI"] == CEPC.DATBI
  • ICA_GENJOURNALENTRIES_2.EPRCTR == CEPC.PRCTR
Billing Type
  • Billing Type
  • Client
  • ICA_GENJOURNALENTRIES_2.FKART == TVFK.FKART
  • ICA_GENJOURNALENTRIES_2.MANDT == TVFK.MANDT
Customer Group
  • Customer Group
  • Client
  • ICA_GENJOURNALENTRIES_2.KDGRP == T151.KDGRP
  • ICA_GENJOURNALENTRIES_2.MANDT == T151.MANDT
Controlling Area
  • Client
  • Controlling Area
  • ICA_GENJOURNALENTRIES_2.MANDT == TKA01.MANDT
  • ICA_GENJOURNALENTRIES_2.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • ICA_GENJOURNALENTRIES_2.MANDT == T004.MANDT
  • ICA_GENJOURNALENTRIES_2.KTOPL == T004.KTOPL
Customer Number
  • Client
  • Customer Number
  • ICA_GENJOURNALENTRIES_2.MANDT == KNA1.MANDT
  • ICA_GENJOURNALENTRIES_2.KUNNR == KNA1.KUNNR
Bill-to Party
  • Client
  • Bill-to Party
  • ICA_GENJOURNALENTRIES_2.MANDT == KNA1.MANDT
  • ICA_GENJOURNALENTRIES_2.KUNRE == KNA1.KUNNR
Ship-to Party
  • Ship-to Party
  • Client
  • ICA_GENJOURNALENTRIES_2.KUNWE == KNA1.KUNNR
  • ICA_GENJOURNALENTRIES_2.MANDT == KNA1.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • ICA_GENJOURNALENTRIES_2.LAND1 == T005.LAND1
  • ICA_GENJOURNALENTRIES_2.MANDT == T005.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • ICA_GENJOURNALENTRIES_2.LIFNR == LFA1.LIFNR
  • ICA_GENJOURNALENTRIES_2.MANDT == LFA1.MANDT
Item Category ICA_GENJOURNALENTRIES_2.LINETYPE == T8G02.LINETYPE
Product Sold Group
  • Product Sold Group
  • Client
  • ICA_GENJOURNALENTRIES_2.MATKL == T023.MATKL
  • ICA_GENJOURNALENTRIES_2.MANDT == T023.MANDT
Material Number
  • Client
  • Material Number
  • ICA_GENJOURNALENTRIES_2.MANDT == MARA.MANDT
  • ICA_GENJOURNALENTRIES_2.MATNR == MARA.MATNR
Product Sold
  • Client
  • Product Sold
  • ICA_GENJOURNALENTRIES_2.MANDT == MARA.MANDT
  • ICA_GENJOURNALENTRIES_2.MATNR_COPA == MARA.MATNR
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • ICA_GENJOURNALENTRIES_2.[column in domain "KALSM_D"] == T007A.KALSM
  • ICA_GENJOURNALENTRIES_2.MWSKZ == T007A.MWSKZ
  • ICA_GENJOURNALENTRIES_2.MANDT == T007A.MANDT
Partner Asset Subnumber (Transfer)
  • Partner Asset Subnumber (Transfer)
  • Client
  • Main Number Partner Asset (Transfer)
  • ?
  • ICA_GENJOURNALENTRIES_2.PANL2 == ANLA.ANLN2
  • ICA_GENJOURNALENTRIES_2.MANDT == ANLA.MANDT
  • ICA_GENJOURNALENTRIES_2.PANL1 == ANLA.ANLN1
  • ICA_GENJOURNALENTRIES_2.[column in domain "BUKRS"] == ANLA.BUKRS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • ICA_GENJOURNALENTRIES_2.PERIV == T009.PERIV
  • ICA_GENJOURNALENTRIES_2.MANDT == T009.MANDT
Partner Profit Center
  • Partner Profit Center
  • Client
  • Controlling Area
  • ?
  • ICA_GENJOURNALENTRIES_2.PPRCTR == CEPC.PRCTR
  • ICA_GENJOURNALENTRIES_2.MANDT == CEPC.MANDT
  • ICA_GENJOURNALENTRIES_2.KOKRS == CEPC.KOKRS
  • ICA_GENJOURNALENTRIES_2.[column in domain "DATBI"] == CEPC.DATBI
Profit Center
  • Client
  • Controlling Area
  • Profit Center
  • ?
  • ICA_GENJOURNALENTRIES_2.MANDT == CEPC.MANDT
  • ICA_GENJOURNALENTRIES_2.KOKRS == CEPC.KOKRS
  • ICA_GENJOURNALENTRIES_2.PRCTR == CEPC.PRCTR
  • ICA_GENJOURNALENTRIES_2.[column in domain "DATBI"] == CEPC.DATBI
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • ICA_GENJOURNALENTRIES_2.PSEGMENT == FAGL_SEGM.SEGMENT
  • ICA_GENJOURNALENTRIES_2.MANDT == FAGL_SEGM.MANDT
Account Number
  • Account Number
  • Company Code
  • Client
  • ICA_GENJOURNALENTRIES_2.RACCT == SKB1.SAKNR
  • ICA_GENJOURNALENTRIES_2.RBUKRS == SKB1.BUKRS
  • ICA_GENJOURNALENTRIES_2.MANDT == SKB1.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • ICA_GENJOURNALENTRIES_2.RASSC == T880.RCOMP
  • ICA_GENJOURNALENTRIES_2.MANDT == T880.MANDT
Company Code
  • Company Code
  • Client
  • ICA_GENJOURNALENTRIES_2.RBUKRS == T001.BUKRS
  • ICA_GENJOURNALENTRIES_2.MANDT == T001.MANDT
Cost Center
  • Client
  • Controlling Area
  • Cost Center
  • ?
  • ICA_GENJOURNALENTRIES_2.MANDT == CSKS.MANDT
  • ICA_GENJOURNALENTRIES_2.KOKRS == CSKS.KOKRS
  • ICA_GENJOURNALENTRIES_2.RCNTR == CSKS.KOSTL
  • ICA_GENJOURNALENTRIES_2.[column in domain "DATBI"] == CSKS.DATBI
Allocation of company code to company
  • Client
  • Company
  • ICA_GENJOURNALENTRIES_2.MANDT == T880.MANDT
  • ICA_GENJOURNALENTRIES_2.RCOMP == T880.RCOMP
Company Code Currency
  • Client
  • Company Code Currency
  • ICA_GENJOURNALENTRIES_2.MANDT == TCURC.MANDT
  • ICA_GENJOURNALENTRIES_2.RHCUR == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • ICA_GENJOURNALENTRIES_2.MANDT == TCURC.MANDT
  • ICA_GENJOURNALENTRIES_2.RKCUR == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Transaction type
  • Client
  • Transaction type
  • ICA_GENJOURNALENTRIES_2.MANDT == T856.MANDT
  • ICA_GENJOURNALENTRIES_2.RMVCT == T856.TRTYP
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ICA_GENJOURNALENTRIES_2.MANDT == T006.MANDT
  • ICA_GENJOURNALENTRIES_2.RUNIT == T006.MSEHI
Transaction Currency
  • Client
  • Transaction Currency
  • ICA_GENJOURNALENTRIES_2.MANDT == TCURC.MANDT
  • ICA_GENJOURNALENTRIES_2.RWCUR == TCURC.WAERS
Sender cost center
  • Client
  • Controlling Area
  • ?
  • Sender cost center
  • ICA_GENJOURNALENTRIES_2.MANDT == CSKS.MANDT
  • ICA_GENJOURNALENTRIES_2.KOKRS == CSKS.KOKRS
  • ICA_GENJOURNALENTRIES_2.[column in domain "DATBI"] == CSKS.DATBI
  • ICA_GENJOURNALENTRIES_2.SCNTR == CSKS.KOSTL
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • ICA_GENJOURNALENTRIES_2.MANDT == FAGL_SEGM.MANDT
  • ICA_GENJOURNALENTRIES_2.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type ICA_GENJOURNALENTRIES_2.SLALITTYPE == FINSTS_SLALITTY.SLALITTYPE
Division
  • Division
  • Client
  • ICA_GENJOURNALENTRIES_2.SPART == TSPA.SPART
  • ICA_GENJOURNALENTRIES_2.MANDT == TSPA.MANDT
Special G/L Indicator
  • Client
  • Account type
  • Special G/L Indicator
  • ICA_GENJOURNALENTRIES_2.MANDT == T074U.MANDT
  • ICA_GENJOURNALENTRIES_2.KOART == T074U.KOART
  • ICA_GENJOURNALENTRIES_2.UMSKZ == T074U.UMSKZ
Sales Organization
  • Client
  • Sales Organization
  • ICA_GENJOURNALENTRIES_2.MANDT == TVKO.MANDT
  • ICA_GENJOURNALENTRIES_2.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • ICA_GENJOURNALENTRIES_2.VTWEG == TVTW.VTWEG
  • ICA_GENJOURNALENTRIES_2.MANDT == TVTW.MANDT
Plant
  • Client
  • Plant
  • ICA_GENJOURNALENTRIES_2.MANDT == T001W.MANDT
  • ICA_GENJOURNALENTRIES_2.WERKS == T001W.WERKS