ICA_CONSJOURNALENTRIES_2

ICA: Consolidation Journal Entry Line Items | view: ICACONSJES2 | Extraction: Not supported | Component: Intercompany Reconciliation
Tables used: ACDOCU, ACDOCA, FINCS_FSIASSGMT, TF200, FINCS_BUNIT, FINCS_BUNIT_ATVD, FINCS_FSITEM, TF110, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, TF040, TF103A, FINSC_FISC_DATE, FINSC_LEDGER_REP, TF103A
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
  • Order Number
  • Client
  • ICA_CONSJOURNALENTRIES_2.AUFNR == AUFK.AUFNR
  • ICA_CONSJOURNALENTRIES_2.MANDT == AUFK.MANDT
Industry key
  • Industry key
  • Client
  • ICA_CONSJOURNALENTRIES_2.BRSCH == T016.BRSCH
  • ICA_CONSJOURNALENTRIES_2.MANDT == T016.MANDT
Sales District
  • Sales District
  • Client
  • ICA_CONSJOURNALENTRIES_2.BZIRK == T171.BZIRK
  • ICA_CONSJOURNALENTRIES_2.MANDT == T171.MANDT
Document Type
  • Document Type
  • Client
  • Dimension
  • ICA_CONSJOURNALENTRIES_2.DOCTY == TF500.DOCTY
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF500.MANDT
  • ICA_CONSJOURNALENTRIES_2.RDIMEN == TF500.DIMEN
Billing Type
  • Billing Type
  • Client
  • ICA_CONSJOURNALENTRIES_2.FKART == TVFK.FKART
  • ICA_CONSJOURNALENTRIES_2.MANDT == TVFK.MANDT
Customer Group
  • Customer Group
  • Client
  • ICA_CONSJOURNALENTRIES_2.KDGRP == T151.KDGRP
  • ICA_CONSJOURNALENTRIES_2.MANDT == T151.MANDT
Controlling Area
  • Controlling Area
  • Client
  • ICA_CONSJOURNALENTRIES_2.KOKRS == TKA01.KOKRS
  • ICA_CONSJOURNALENTRIES_2.MANDT == TKA01.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • ICA_CONSJOURNALENTRIES_2.KTOPL == T004.KTOPL
  • ICA_CONSJOURNALENTRIES_2.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • ICA_CONSJOURNALENTRIES_2.KUNNR == KNA1.KUNNR
  • ICA_CONSJOURNALENTRIES_2.MANDT == KNA1.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • ICA_CONSJOURNALENTRIES_2.KUNRE == KNA1.KUNNR
  • ICA_CONSJOURNALENTRIES_2.MANDT == KNA1.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • ICA_CONSJOURNALENTRIES_2.KUNWE == KNA1.KUNNR
  • ICA_CONSJOURNALENTRIES_2.MANDT == KNA1.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • ICA_CONSJOURNALENTRIES_2.LAND1 == T005.LAND1
  • ICA_CONSJOURNALENTRIES_2.MANDT == T005.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • ICA_CONSJOURNALENTRIES_2.LIFNR == LFA1.LIFNR
  • ICA_CONSJOURNALENTRIES_2.MANDT == LFA1.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • ICA_CONSJOURNALENTRIES_2.MATKL == T023.MATKL
  • ICA_CONSJOURNALENTRIES_2.MANDT == T023.MANDT
Material Group
  • Material Group
  • Client
  • ICA_CONSJOURNALENTRIES_2.MATKL_MM == T023.MATKL
  • ICA_CONSJOURNALENTRIES_2.MANDT == T023.MANDT
Material Number
  • Material Number
  • Client
  • ICA_CONSJOURNALENTRIES_2.MATNR == MARA.MATNR
  • ICA_CONSJOURNALENTRIES_2.MANDT == MARA.MANDT
Product Sold
  • Product Sold
  • Client
  • ICA_CONSJOURNALENTRIES_2.MATNR_COPA == MARA.MATNR
  • ICA_CONSJOURNALENTRIES_2.MANDT == MARA.MANDT
Partner Profit Center
  • Controlling Area
  • ?
  • Partner Profit Center
  • Client
  • ICA_CONSJOURNALENTRIES_2.KOKRS == CEPC.KOKRS
  • ICA_CONSJOURNALENTRIES_2.[column in domain "DATBI"] == CEPC.DATBI
  • ICA_CONSJOURNALENTRIES_2.PPRCTR == CEPC.PRCTR
  • ICA_CONSJOURNALENTRIES_2.MANDT == CEPC.MANDT
Profit Center
  • Controlling Area
  • ?
  • Profit Center
  • Client
  • ICA_CONSJOURNALENTRIES_2.KOKRS == CEPC.KOKRS
  • ICA_CONSJOURNALENTRIES_2.[column in domain "DATBI"] == CEPC.DATBI
  • ICA_CONSJOURNALENTRIES_2.PRCTR == CEPC.PRCTR
  • ICA_CONSJOURNALENTRIES_2.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • ICA_CONSJOURNALENTRIES_2.PSEGMENT == FAGL_SEGM.SEGMENT
  • ICA_CONSJOURNALENTRIES_2.MANDT == FAGL_SEGM.MANDT
Account Number
  • Account Number
  • Original company code
  • Client
  • ICA_CONSJOURNALENTRIES_2.RACCT == SKB1.SAKNR
  • ICA_CONSJOURNALENTRIES_2.ROBUKRS == SKB1.BUKRS
  • ICA_CONSJOURNALENTRIES_2.MANDT == SKB1.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • ICA_CONSJOURNALENTRIES_2.RASSC == T880.RCOMP
  • ICA_CONSJOURNALENTRIES_2.MANDT == T880.MANDT
Consolidation Unit
  • Consolidation Unit
  • Client
  • Dimension
  • ICA_CONSJOURNALENTRIES_2.RBUNIT == TF160.BUNIT
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF160.MANDT
  • ICA_CONSJOURNALENTRIES_2.RDIMEN == TF160.DIMEN
Partner Unit
  • Partner Unit
  • Client
  • Dimension
  • ICA_CONSJOURNALENTRIES_2.RBUPTR == TF160.BUNIT
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF160.MANDT
  • ICA_CONSJOURNALENTRIES_2.RDIMEN == TF160.DIMEN
Cost Center
  • Controlling Area
  • Cost Center
  • ?
  • Client
  • ICA_CONSJOURNALENTRIES_2.KOKRS == CSKS.KOKRS
  • ICA_CONSJOURNALENTRIES_2.RCNTR == CSKS.KOSTL
  • ICA_CONSJOURNALENTRIES_2.[column in domain "DATBI"] == CSKS.DATBI
  • ICA_CONSJOURNALENTRIES_2.MANDT == CSKS.MANDT
Company
  • Company
  • Client
  • ICA_CONSJOURNALENTRIES_2.RCOMP == T880.RCOMP
  • ICA_CONSJOURNALENTRIES_2.MANDT == T880.MANDT
Consolidation Group
  • Consolidation Group
  • Client
  • Dimension
  • ICA_CONSJOURNALENTRIES_2.RCONGR == TF180.CONGR
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF180.MANDT
  • ICA_CONSJOURNALENTRIES_2.RDIMEN == TF180.DIMEN
Dimension
  • Client
  • Dimension
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF150.MANDT
  • ICA_CONSJOURNALENTRIES_2.RDIMEN == TF150.DIMEN
Functional Area
  • Functional Area
  • Client
  • ICA_CONSJOURNALENTRIES_2.RFAREA == TFKB.FKBER
  • ICA_CONSJOURNALENTRIES_2.MANDT == TFKB.MANDT
Consolidation Chart of Accounts
  • Consolidation Chart of Accounts
  • Client
  • ICA_CONSJOURNALENTRIES_2.RITCLG == TF120.ITCLG
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF120.MANDT
Financial Statement Item
  • Consolidation Chart of Accounts
  • Financial Statement Item
  • Client
  • ICA_CONSJOURNALENTRIES_2.RITCLG == TF100.ITCLG
  • ICA_CONSJOURNALENTRIES_2.RITEM == TF100.ITEM
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF100.MANDT
Ledger
  • Ledger
  • Client
  • ICA_CONSJOURNALENTRIES_2.RLDNR == T881.RLDNR
  • ICA_CONSJOURNALENTRIES_2.MANDT == T881.MANDT
Transaction type
  • Client
  • Transaction type
  • ICA_CONSJOURNALENTRIES_2.MANDT == T856.MANDT
  • ICA_CONSJOURNALENTRIES_2.RMVCT == T856.TRTYP
Original company code
  • Original company code
  • Client
  • ICA_CONSJOURNALENTRIES_2.ROBUKRS == T001.BUKRS
  • ICA_CONSJOURNALENTRIES_2.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • ICA_CONSJOURNALENTRIES_2.RTCUR == TCURC.WAERS
  • ICA_CONSJOURNALENTRIES_2.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • ICA_CONSJOURNALENTRIES_2.RUNIT == T006.MSEHI
  • ICA_CONSJOURNALENTRIES_2.MANDT == T006.MANDT
Consolidation Version
  • Consolidation Version
  • Client
  • ICA_CONSJOURNALENTRIES_2.RVERS == TF200.RVERS
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF200.MANDT
Sender cost center
  • Controlling Area
  • ?
  • Sender cost center
  • Client
  • ICA_CONSJOURNALENTRIES_2.KOKRS == CSKS.KOKRS
  • ICA_CONSJOURNALENTRIES_2.[column in domain "DATBI"] == CSKS.DATBI
  • ICA_CONSJOURNALENTRIES_2.SCNTR == CSKS.KOSTL
  • ICA_CONSJOURNALENTRIES_2.MANDT == CSKS.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • ICA_CONSJOURNALENTRIES_2.SEGMENT == FAGL_SEGM.SEGMENT
  • ICA_CONSJOURNALENTRIES_2.MANDT == FAGL_SEGM.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • ICA_CONSJOURNALENTRIES_2.SFAREA == TFKB.FKBER
  • ICA_CONSJOURNALENTRIES_2.MANDT == TFKB.MANDT
Subitem Category
  • Subitem Category
  • Client
  • ICA_CONSJOURNALENTRIES_2.SITYP == TF110.SITYP
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF110.MANDT
Division
  • Division
  • Client
  • ICA_CONSJOURNALENTRIES_2.SPART == TSPA.SPART
  • ICA_CONSJOURNALENTRIES_2.MANDT == TSPA.MANDT
Subitem
  • Subitem Category
  • Subitem
  • Client
  • ICA_CONSJOURNALENTRIES_2.SITYP == TF115.SITYP
  • ICA_CONSJOURNALENTRIES_2.SUBIT == TF115.SITEM
  • ICA_CONSJOURNALENTRIES_2.MANDT == TF115.MANDT
Sales Organization
  • Client
  • Sales Organization
  • ICA_CONSJOURNALENTRIES_2.MANDT == TVKO.MANDT
  • ICA_CONSJOURNALENTRIES_2.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • ICA_CONSJOURNALENTRIES_2.MANDT == TVTW.MANDT
  • ICA_CONSJOURNALENTRIES_2.VTWEG == TVTW.VTWEG
Plant
  • Plant
  • Client
  • ICA_CONSJOURNALENTRIES_2.WERKS == T001W.WERKS
  • ICA_CONSJOURNALENTRIES_2.MANDT == T001W.MANDT