ICA_P_CONSJOURNALENTRIES_01

ICA: Consolidation Journal Entry Line Items from ACDOCA | view: ICAPCJES01 | Extraction: Not supported | Component: Intercompany Reconciliation
Tables used: ACDOCA, FINCS_BUNIT, FINCS_BUNIT_ATVD, FINCS_FSITEM, TF110, TF200, T001, TKA02, FINCS_FSIMAPASSG, FINCS_FSIMAPITM, FINSC_FISC_DATE, FINSC_LEDGER_REP, TF103A
Column Name Description
Column Name Description
💲 Transaction Currency (rwcur):
wsl Amount in Transaction Currency
💲 Balance Transaction Currency (rtcur):
tsl Amount in Balance Transaction Currency
💲 Company Code Currency (rhcur):
hsl Amount in Freely Defined Currency 8
💲 Global Currency (rkcur):
ksl Amount in Freely Defined Currency 8
Column Name Description
📏 Base Unit of Measure (runit):
msl Quantity
Column Name Description
budat Posting Date in the Document
augdt Clearing Date
Column Name Description
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
rldnr Consolidation version ledger FC_RLDNR_CONS
rdimen Dimension FC_DIMEN
ryear Fiscal Year GJAHR
gjahr Fiscal Year GJAHR
fiscyearper Fiscal Year Period FINS_JAHRPER
ref_belnr Document Number of an Accounting Document BELNR
ref_docln Six-Character Posting Item for Ledger DOCLN6
rvers Consolidation Version FC_RVERS
poper Fiscal Period POPER
rbunit Consolidation Unit FINCS_MD_BUNIT
ritclg null
ritem null
rbuptr null
rcongr Consolidation Group FC_CONGR
itbrkdwn Breakdown Category FC_ITGRP
sityp Fixed value for a subitem category-like characteristic CHAR10
subit Functional Area FKBER
docty Document Type FC_DOCTY
sgtxt Item Text TEXT50
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
aworg Reference Organizational Units AWORG
zuonr Assignment number ZUONR
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_P_CONSJOURNALENTRIES_01.AUFNR == AUFK.AUFNR
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == AUFK.MANDT
Reference procedure ICA_P_CONSJOURNALENTRIES_01.AWTYP == TTYP.AWTYP
Document Type
  • Document Type
  • Client
  • ICA_P_CONSJOURNALENTRIES_01.BLART == T003.BLART
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T003.MANDT
Industry key
  • Client
  • Industry key
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T016.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.BRSCH == T016.BRSCH
Business Transaction Category
  • Client
  • Business Transaction Category
Sales District
  • Client
  • Sales District
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T171.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.BZIRK == T171.BZIRK
Billing Type
  • Client
  • Billing Type
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TVFK.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.FKART == TVFK.FKART
FS Item Attributes Version
  • FS Item Attributes Version
  • Client
  • ICA_P_CONSJOURNALENTRIES_01.IATVS == TF23C.IATVS
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TF23C.MANDT
Customer Group
  • Client
  • Customer Group
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T151.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KDGRP == T151.KDGRP
Controlling Area
  • Client
  • Controlling Area
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TKA01.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KOKRS == TKA01.KOKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T004.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KTOPL == T004.KTOPL
Customer Number
  • Client
  • Customer Number
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == KNA1.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KUNNR == KNA1.KUNNR
Bill-to Party
  • Client
  • Bill-to Party
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == KNA1.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KUNRE == KNA1.KUNNR
Ship-to Party
  • Client
  • Ship-to Party
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == KNA1.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KUNWE == KNA1.KUNNR
Country/Region Key
  • Client
  • Country/Region Key
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T005.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.LAND1 == T005.LAND1
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == LFA1.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.LIFNR == LFA1.LIFNR
Product Sold Group
  • Client
  • Product Sold Group
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T023.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.MATKL == T023.MATKL
Material Group
  • Client
  • Material Group
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T023.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.MATKL_MM == T023.MATKL
Material Number
  • Client
  • Material Number
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == MARA.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.MATNR == MARA.MATNR
Product Sold
  • Client
  • Product Sold
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == MARA.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.MATNR_COPA == MARA.MATNR
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • ICA_P_CONSJOURNALENTRIES_01.[column in domain "KALSM_D"] == T007A.KALSM
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T007A.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.MWSKZ == T007A.MWSKZ
Partner Profit Center
  • ?
  • Client
  • Controlling Area
  • Partner Profit Center
  • ICA_P_CONSJOURNALENTRIES_01.[column in domain "DATBI"] == CEPC.DATBI
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == CEPC.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KOKRS == CEPC.KOKRS
  • ICA_P_CONSJOURNALENTRIES_01.PPRCTR == CEPC.PRCTR
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • ICA_P_CONSJOURNALENTRIES_01.[column in domain "DATBI"] == CEPC.DATBI
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == CEPC.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KOKRS == CEPC.KOKRS
  • ICA_P_CONSJOURNALENTRIES_01.PRCTR == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == FAGL_SEGM.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.PSEGMENT == FAGL_SEGM.SEGMENT
Account Number
  • Account Number
  • Company Code
  • Client
  • ICA_P_CONSJOURNALENTRIES_01.RACCT == SKB1.SAKNR
  • ICA_P_CONSJOURNALENTRIES_01.ROBUKRS == SKB1.BUKRS
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == SKB1.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T880.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.RASSC == T880.RCOMP
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • ICA_P_CONSJOURNALENTRIES_01.[column in domain "DATBI"] == CSKS.DATBI
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == CSKS.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KOKRS == CSKS.KOKRS
  • ICA_P_CONSJOURNALENTRIES_01.RCNTR == CSKS.KOSTL
Allocation of company code to company
  • Client
  • Company
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T880.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.RCOMP == T880.RCOMP
Functional Area
  • Client
  • Functional Area
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TFKB.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.RFAREA == TFKB.FKBER
Transaction type
  • Client
  • Transaction type
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T856.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.RMVCT == T856.TRTYP
Company Code
  • Company Code
  • Client
  • ICA_P_CONSJOURNALENTRIES_01.ROBUKRS == T001.BUKRS
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T001.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TCURC.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.RTCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T006.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.RUNIT == T006.MSEHI
Transaction Currency
  • Client
  • Transaction Currency
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TCURC.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.RWCUR == TCURC.WAERS
Sender cost center
  • ?
  • Client
  • Controlling Area
  • Sender cost center
  • ICA_P_CONSJOURNALENTRIES_01.[column in domain "DATBI"] == CSKS.DATBI
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == CSKS.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.KOKRS == CSKS.KOKRS
  • ICA_P_CONSJOURNALENTRIES_01.SCNTR == CSKS.KOSTL
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == FAGL_SEGM.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.SEGMENT == FAGL_SEGM.SEGMENT
Partner Functional Area
  • Client
  • Partner Functional Area
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TFKB.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.SFAREA == TFKB.FKBER
Division
  • Client
  • Division
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TSPA.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.SPART == TSPA.SPART
Special G/L Indicator
  • Account type
  • Client
  • Special G/L Indicator
  • ICA_P_CONSJOURNALENTRIES_01.KOART == T074U.KOART
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T074U.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.UMSKZ == T074U.UMSKZ
Sales Organization
  • Client
  • Sales Organization
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TVKO.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == TVTW.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • ICA_P_CONSJOURNALENTRIES_01.MANDT == T001W.MANDT
  • ICA_P_CONSJOURNALENTRIES_01.WERKS == T001W.WERKS