P_CnsldtnDataWCnsldtnLogic

Consolidation: Consolidated Data with Reporting Logic | view: PCDATACLOGIC | Extraction: Not supported | Component: Consolidation
Tables used: ACDOCU
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
budat Posting Date in the Document
wsdat Value Date for Currency Translation
cpudt Day On Which Accounting Document Was Entered
cputm Time of Entry
Column Name Description
rrcty Record Type Show values
docct Document Category Show values
plevl Posting Level Show values
rpflg Apportionment Show values
rtflg Currency Translation Show values
refdocct Document Category Show values
coiac Consolidation of Investments Activity Show values
Column Name Description Domain name
gl_sirid null
ryear Fiscal Year GJAHR
drcrk null
poper Posting period POPER
docnr Document Number of an Accounting Document BELNR
docln Six-Character Posting Item for Ledger DOCLN6
yracq Year of Acquisition GJAHR
pracq Period of Acquisition NUM03
updhp null
sgtxt Item Text TEXT50
autom Indicator: Automatic posting lines TEXT1
activ Business Transaction CHAR4
bvorg Number of Cross-Company Code Posting Transaction BVORG
refdocnr Document Number of an Accounting Document BELNR
refryear Original Fiscal Year GJAHR
refdocln Six-figure number of line item BUZEI6
refactiv Business Transaction CHAR4
rvsdocnr Reverse Document Number BELNR
orndocnr Number of Reversed Document BELNR
coinr Consolidation of Investments Activity Number BELNR
revyear Year of reversal document or reversed document GJAHR
awtyp Reference procedure AWTYP
aworg Reference Organizational Units AWORG
logsys Logical system LOGSYS
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
ps_pspid Project definition PS_PSPID
konzs Group key KONZS
zuonr Assignment number ZUONR
xblnr Reference Document Number XBLNR1
ps_psp_pnr Work Breakdown Structure Element (WBS Element) PS_POSNR
Master Data Relations Join Conditions
Order Number
  • Order Number
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.AUFNR == AUFK.AUFNR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == AUFK.MANDT
Industry key
  • Industry key
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.BRSCH == T016.BRSCH
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T016.MANDT
Sales District
  • Sales District
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.BZIRK == T171.BZIRK
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T171.MANDT
Investee Unit
  • Dimension
  • Investee Unit
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RDIMEN == TF160.DIMEN
  • P_CNSLDTNDATAWCNSLDTNLOGIC.COICU == TF160.BUNIT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF160.MANDT
Document Type
  • Dimension
  • Document Type
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RDIMEN == TF500.DIMEN
  • P_CNSLDTNDATAWCNSLDTNLOGIC.DOCTY == TF500.DOCTY
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF500.MANDT
Billing Type
  • Billing Type
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.FKART == TVFK.FKART
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TVFK.MANDT
Customer Group
  • Customer Group
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KDGRP == T151.KDGRP
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T151.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KOKRS == TKA01.KOKRS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TKA01.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KTOPL == T004.KTOPL
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KUNNR == KNA1.KUNNR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == KNA1.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KUNRE == KNA1.KUNNR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == KNA1.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KUNWE == KNA1.KUNNR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == KNA1.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.LAND1 == T005.LAND1
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T005.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.LIFNR == LFA1.LIFNR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == LFA1.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MATKL == T023.MATKL
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T023.MANDT
Material Group
  • Material Group
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MATKL_MM == T023.MATKL
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T023.MANDT
Material Number
  • Material Number
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MATNR == MARA.MATNR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == MARA.MANDT
Product Sold
  • Product Sold
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MATNR_COPA == MARA.MATNR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == MARA.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KOKRS == CEPC.KOKRS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.PPRCTR == CEPC.PRCTR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == CEPC.MANDT
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.[column in domain "DATBI"] == CEPC.DATBI
  • P_CNSLDTNDATAWCNSLDTNLOGIC.PRCTR == CEPC.PRCTR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KOKRS == CEPC.KOKRS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.PSEGMENT == FAGL_SEGM.SEGMENT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == FAGL_SEGM.MANDT
Account Number
  • Account Number
  • Original company code
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RACCT == SKB1.SAKNR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.ROBUKRS == SKB1.BUKRS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == SKB1.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RASSC == T880.RCOMP
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T880.MANDT
Consolidation Unit
  • Consolidation Unit
  • Dimension
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RBUNIT == TF160.BUNIT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RDIMEN == TF160.DIMEN
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF160.MANDT
Partner Unit
  • Dimension
  • Partner Unit
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RDIMEN == TF160.DIMEN
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RBUPTR == TF160.BUNIT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF160.MANDT
Business Area
  • Business Area
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RBUSA == TGSB.GSBER
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TGSB.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_CNSLDTNDATAWCNSLDTNLOGIC.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KOKRS == CSKS.KOKRS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == CSKS.MANDT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RCNTR == CSKS.KOSTL
Company
  • Company
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RCOMP == T880.RCOMP
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T880.MANDT
Consolidation Group
  • Dimension
  • Consolidation Group
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RDIMEN == TF180.DIMEN
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RCONGR == TF180.CONGR
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF180.MANDT
Dimension
  • Dimension
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RDIMEN == TF150.DIMEN
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF150.MANDT
Functional Area
  • Functional Area
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RFAREA == TFKB.FKBER
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TFKB.MANDT
Consolidation Chart of Accounts
  • Consolidation Chart of Accounts
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RITCLG == TF120.ITCLG
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF120.MANDT
Financial Statement Item
  • Financial Statement Item
  • Consolidation Chart of Accounts
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RITEM == TF100.ITEM
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RITCLG == TF100.ITCLG
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF100.MANDT
Ledger
  • Client
  • Ledger
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T881.MANDT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RLDNR == T881.RLDNR
Transaction type
  • Transaction type
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RMVCT == T856.TRTYP
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T856.MANDT
Original company code
  • Original company code
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.ROBUKRS == T001.BUKRS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RTCUR == TCURC.WAERS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RUNIT == T006.MSEHI
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T006.MANDT
Consolidation Version
  • Consolidation Version
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.RVERS == TF200.RVERS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF200.MANDT
Trading partner's business area
  • Trading partner's business area
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.SBUSA == TGSB.GSBER
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TGSB.MANDT
Sender cost center
  • ?
  • Sender cost center
  • Controlling Area
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.[column in domain "DATBI"] == CSKS.DATBI
  • P_CNSLDTNDATAWCNSLDTNLOGIC.SCNTR == CSKS.KOSTL
  • P_CNSLDTNDATAWCNSLDTNLOGIC.KOKRS == CSKS.KOKRS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == CSKS.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.SEGMENT == FAGL_SEGM.SEGMENT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == FAGL_SEGM.MANDT
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.SFAREA == TFKB.FKBER
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TFKB.MANDT
Subitem Category
  • Client
  • Subitem Category
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF110.MANDT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.SITYP == TF110.SITYP
Division
  • Division
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.SPART == TSPA.SPART
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TSPA.MANDT
Subitem
  • Subitem
  • Client
  • Subitem Category
  • P_CNSLDTNDATAWCNSLDTNLOGIC.SUBIT == TF115.SITEM
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TF115.MANDT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.SITYP == TF115.SITYP
User Name
  • User Name
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.USNAM == USR02.BNAME
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == USR02.MANDT
Sales Organization
  • Sales Organization
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.VKORG == TVKO.VKORG
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TVKO.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == TVTW.MANDT
  • P_CNSLDTNDATAWCNSLDTNLOGIC.VTWEG == TVTW.VTWEG
Plant
  • Plant
  • Client
  • P_CNSLDTNDATAWCNSLDTNLOGIC.WERKS == T001W.WERKS
  • P_CNSLDTNDATAWCNSLDTNLOGIC.MANDT == T001W.MANDT