P_Matrix_CnsldtnFoundationYTD

Matrix Consolidation: Foundation View | view: PMCONSFNDVYTD | Extraction: Not supported | Component: Embedded Analytics
Tables used: ACDOCU, FINCS_REF_VERS_R, FINCS_GRPSTR, TF200, HRRP_NODE, FINSC_PERIOD
Column Name Description
Column Name Description
💲 Currency Key (rtcur):
tsl Amount in Transaction Currency
💲 Currency key of the local currency (rhcur):
hsl Amount in Local Currency
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
drcrk Debit/Credit Indicator Show values
period_mode Period Mode 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
ryear Fiscal Year GJAHR
docnr Group Journal Entry BELNR
docln Group Journal Entry Item DOCLN6
rvers Consolidation Version FC_RVERS
FiscalYearVariant Fiscal Year Variant PERIV
poper Reporting Period POPER
year_period Fiscal Year + Fiscal Period FINS_FYEARPERIOD
poper_posting Fiscal Period POPER
rbunit_eliminated Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
yracq Year of Acquisition GJAHR
pracq Period of Acquisition NUM03
sgtxt Item Text TEXT50
autom Indicator: Automatic posting lines TEXT1
activ Business Transaction CHAR4
bvorg null
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
timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
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
xblnr null
zuonr Assignment number ZUONR
prctr_eliminated Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
segment_eliminated Consolidation Elimination Member FINCS_ELIMINATION_MEMBER
ps_psp_pnr WBS Element PS_S4_PSPNR
ps_posid Work Breakdown Structure Element (WBS Element) PS_POSID
ps_pspid Project definition PS_PSPID
konzs Group key KONZS
orig_ref Origin Reference FINCS_ORIG_REF
bunnr Document Bundle Number FINCS_BUNNR
Master Data Relations Join Conditions
Ad Hoc Item
  • Client
  • ?
  • Ad Hoc Item
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == FINCS_ADHITM.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.[column in domain "FC_ITCLG"] == FINCS_ADHITM.ITCLG
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.ADHOCITEM == FINCS_ADHITM.ADHOCITEM
Ad Hoc Set
  • Client
  • ?
  • Ad Hoc Set
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == FINCS_ADHSET.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.[column in domain "FC_ITCLG"] == FINCS_ADHSET.ITCLG
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.ADHOCSET == FINCS_ADHSET.ADHOCSET
Ad Hoc Set Item
  • Client
  • ?
  • Ad Hoc Set
  • Ad Hoc Set Item
Order Number
  • Client
  • Order Number
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == AUFK.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.AUFNR == AUFK.AUFNR
Industry key
  • Client
  • Industry key
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T016.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.BRSCH == T016.BRSCH
Sales District
  • Client
  • Sales District
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T171.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.BZIRK == T171.BZIRK
Investee Unit
  • Client
  • Dimension
  • Investee Unit
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF160.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RDIMEN == TF160.DIMEN
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.COICU == TF160.BUNIT
Consolidation Version
  • Client
  • Consolidation Version
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF200.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.CONSOLIDATIONVERSIONELEMENT == TF200.RVERS
Document Type
  • Client
  • Dimension
  • Document Type
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF500.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RDIMEN == TF500.DIMEN
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.DOCTY == TF500.DOCTY
Billing Type
  • Billing Type
  • Client
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.FKART == TVFK.FKART
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TVFK.MANDT
Customer Group
  • Client
  • Customer Group
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T151.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KDGRP == T151.KDGRP
Controlling Area
  • Controlling Area
  • Client
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KOKRS == TKA01.KOKRS
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TKA01.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T004.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KTOPL == T004.KTOPL
Customer Number
  • Client
  • Customer Number
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == KNA1.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KUNNR == KNA1.KUNNR
Bill-to Party
  • Bill-to Party
  • Client
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KUNRE == KNA1.KUNNR
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == KNA1.MANDT
Ship-to Party
  • Client
  • Ship-to Party
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == KNA1.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KUNWE == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.LAND1 == T005.LAND1
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T005.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == LFA1.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.LIFNR == LFA1.LIFNR
Product Sold Group
  • Client
  • Product Sold Group
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T023.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MATKL == T023.MATKL
Material Group
  • Client
  • Material Group
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T023.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MATKL_MM == T023.MATKL
Material Number
  • Client
  • Material Number
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == MARA.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MATNR == MARA.MATNR
Product Sold
  • Product Sold
  • Client
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MATNR_COPA == MARA.MATNR
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == MARA.MANDT
Partner Profit Center
  • Controlling Area
  • Client
  • Partner Profit Center
  • ?
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KOKRS == CEPC.KOKRS
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == CEPC.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.PPRCTR == CEPC.PRCTR
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.[column in domain "DATBI"] == CEPC.DATBI
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KOKRS == CEPC.KOKRS
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == CEPC.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.[column in domain "DATBI"] == CEPC.DATBI
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.PRCTR == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == FAGL_SEGM.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.PSEGMENT == FAGL_SEGM.SEGMENT
Account Number
  • Client
  • Original company code
  • Account Number
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == SKB1.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.ROBUKRS == SKB1.BUKRS
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RACCT == SKB1.SAKNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T880.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RASSC == T880.RCOMP
Consolidation Unit
  • Client
  • Dimension
  • Consolidation Unit
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF160.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RDIMEN == TF160.DIMEN
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RBUNIT == TF160.BUNIT
Partner Unit
  • Client
  • Dimension
  • Partner Unit
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF160.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RDIMEN == TF160.DIMEN
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RBUPTR == TF160.BUNIT
Business Area
  • Business Area
  • Client
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RBUSA == TGSB.GSBER
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TGSB.MANDT
Cost Center
  • Controlling Area
  • Client
  • ?
  • Cost Center
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KOKRS == CSKS.KOKRS
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == CSKS.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.[column in domain "DATBI"] == CSKS.DATBI
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RCNTR == CSKS.KOSTL
Reason Code
  • Client
  • Reason Code
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == ICA_RC.RCLNT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RCODE == ICA_RC.RCODE
Company
  • Client
  • Company
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T880.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RCOMP == T880.RCOMP
Consolidation Group
  • Client
  • Consolidation Group
  • Dimension
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF180.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RCONGR == TF180.CONGR
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RDIMEN == TF180.DIMEN
Dimension
  • Client
  • Dimension
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF150.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RDIMEN == TF150.DIMEN
Functional Area
  • Client
  • Functional Area
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TFKB.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RFAREA == TFKB.FKBER
Consolidation Chart of Accounts
  • Client
  • Consolidation Chart of Accounts
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF120.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RITCLG == TF120.ITCLG
Financial Statement Item
  • Client
  • Consolidation Chart of Accounts
  • Financial Statement Item
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF100.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RITCLG == TF100.ITCLG
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RITEM == TF100.ITEM
Ledger
  • Client
  • Ledger
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T881.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RLDNR == T881.RLDNR
Transaction type
  • Client
  • Transaction type
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T856.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RMVCT == T856.TRTYP
Original company code
  • Client
  • Original company code
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T001.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.ROBUKRS == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TCURC.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RTCUR == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T006.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RUNIT == T006.MSEHI
Trading partner's business area
  • Client
  • Trading partner's business area
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TGSB.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.SBUSA == TGSB.GSBER
Sender cost center
  • Controlling Area
  • Client
  • Sender cost center
  • ?
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.KOKRS == CSKS.KOKRS
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == CSKS.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.SCNTR == CSKS.KOSTL
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.[column in domain "DATBI"] == CSKS.DATBI
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == FAGL_SEGM.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.SEGMENT == FAGL_SEGM.SEGMENT
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TFKB.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.SFAREA == TFKB.FKBER
Subitem Category
  • Client
  • Subitem Category
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF110.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.SITYP == TF110.SITYP
Division
  • Client
  • Division
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TSPA.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.SPART == TSPA.SPART
Subitem
  • Client
  • Subitem Category
  • Subitem
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF115.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.SITYP == TF115.SITYP
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.SUBIT == TF115.SITEM
Investor Unit
  • Client
  • Investor Unit
  • Dimension
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TF160.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.UPPCU == TF160.BUNIT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.RDIMEN == TF160.DIMEN
User Name
  • Client
  • User Name
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == USR02.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.USNAM == USR02.BNAME
Sales Organization
  • Client
  • Sales Organization
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TVKO.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.VKORG == TVKO.VKORG
Distribution Channel
  • Client
  • Distribution Channel
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == TVTW.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.VTWEG == TVTW.VTWEG
Plant
  • Client
  • Plant
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.MANDT == T001W.MANDT
  • P_MATRIX_CNSLDTNFOUNDATIONYTD.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Origin Type P_MATRIX_CNSLDTNFOUNDATIONYTD.ORIG_TYPE == FINCS_ORIGTYPE.ORIG_TYPE