ICA_CONSJOURNALENTRIES_3

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