P_Matrix_ElimDataWGroupDerived

Matrix Consolidation: Elim. Data with Group Derived | view: PMCONSELIMWGR | Extraction: Not supported | Component: Embedded Analytics

Tables used: ACDOCU, FINCS_GRPSTR, TF200

🔑 Keys
💰 Amounts (3)
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (9)
Other (30)
🔗 Relations (51)

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
💲 Group Currency (rkcur):
ksl	Amount 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
poper	Fiscal Period	POPER
fiscyearper	Fiscal Year Period	FIS_JAHRPER_CONV
poper_posting	Fiscal Period	POPER
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
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

Master Data Relations	Join Conditions
Order Number Order Number Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.AUFNR == AUFK.AUFNR` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == AUFK.MANDT`
Industry key Industry key Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.BRSCH == T016.BRSCH` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T016.MANDT`
Sales District Sales District Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.BZIRK == T171.BZIRK` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T171.MANDT`
Investee Unit Dimension Investee Unit Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RDIMEN == TF160.DIMEN` `P_MATRIX_ELIMDATAWGROUPDERIVED.COICU == TF160.BUNIT` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF160.MANDT`
Document Type Dimension Document Type Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RDIMEN == TF500.DIMEN` `P_MATRIX_ELIMDATAWGROUPDERIVED.DOCTY == TF500.DOCTY` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF500.MANDT`
Billing Type Billing Type Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.FKART == TVFK.FKART` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TVFK.MANDT`
Customer Group Customer Group Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.KDGRP == T151.KDGRP` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T151.MANDT`
Controlling Area Controlling Area Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.KOKRS == TKA01.KOKRS` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TKA01.MANDT`
Chart of Accounts Chart of Accounts Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.KTOPL == T004.KTOPL` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T004.MANDT`
Customer Number Customer Number Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.KUNNR == KNA1.KUNNR` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == KNA1.MANDT`
Bill-to Party Bill-to Party Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.KUNRE == KNA1.KUNNR` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == KNA1.MANDT`
Ship-to Party Ship-to Party Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.KUNWE == KNA1.KUNNR` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == KNA1.MANDT`
Country/Region Key Country/Region Key Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.LAND1 == T005.LAND1` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T005.MANDT`
Account Number of Supplier Account Number of Supplier Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.LIFNR == LFA1.LIFNR` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == LFA1.MANDT`
Product Sold Group Product Sold Group Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.MATKL == T023.MATKL` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T023.MANDT`
Material Group Material Group Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.MATKL_MM == T023.MATKL` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T023.MANDT`
Material Number Material Number Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.MATNR == MARA.MATNR` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == MARA.MANDT`
Product Sold Product Sold Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.MATNR_COPA == MARA.MATNR` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == MARA.MANDT`
Partner Profit Center ? Controlling Area Partner Profit Center Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.[column in domain "DATBI"] == CEPC.DATBI` `P_MATRIX_ELIMDATAWGROUPDERIVED.KOKRS == CEPC.KOKRS` `P_MATRIX_ELIMDATAWGROUPDERIVED.PPRCTR == CEPC.PRCTR` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == CEPC.MANDT`
Profit Center Profit Center ? Controlling Area Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.PRCTR == CEPC.PRCTR` `P_MATRIX_ELIMDATAWGROUPDERIVED.[column in domain "DATBI"] == CEPC.DATBI` `P_MATRIX_ELIMDATAWGROUPDERIVED.KOKRS == CEPC.KOKRS` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == CEPC.MANDT`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.PSEGMENT == FAGL_SEGM.SEGMENT` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == FAGL_SEGM.MANDT`
Account Number Account Number Original company code Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RACCT == SKB1.SAKNR` `P_MATRIX_ELIMDATAWGROUPDERIVED.ROBUKRS == SKB1.BUKRS` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == SKB1.MANDT`
Company ID of Trading Partner Company ID of Trading Partner Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RASSC == T880.RCOMP` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T880.MANDT`
Consolidation Unit Consolidation Unit Dimension Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RBUNIT == TF160.BUNIT` `P_MATRIX_ELIMDATAWGROUPDERIVED.RDIMEN == TF160.DIMEN` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF160.MANDT`
Partner Unit Partner Unit Dimension Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RBUPTR == TF160.BUNIT` `P_MATRIX_ELIMDATAWGROUPDERIVED.RDIMEN == TF160.DIMEN` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF160.MANDT`
Business Area Business Area Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RBUSA == TGSB.GSBER` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TGSB.MANDT`
Cost Center Cost Center ? Controlling Area Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RCNTR == CSKS.KOSTL` `P_MATRIX_ELIMDATAWGROUPDERIVED.[column in domain "DATBI"] == CSKS.DATBI` `P_MATRIX_ELIMDATAWGROUPDERIVED.KOKRS == CSKS.KOKRS` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == CSKS.MANDT`
Company Company Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RCOMP == T880.RCOMP` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T880.MANDT`
Consolidation Group Consolidation Group Dimension Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RCONGR == TF180.CONGR` `P_MATRIX_ELIMDATAWGROUPDERIVED.RDIMEN == TF180.DIMEN` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF180.MANDT`
Dimension Dimension Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RDIMEN == TF150.DIMEN` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF150.MANDT`
Functional Area Functional Area Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RFAREA == TFKB.FKBER` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TFKB.MANDT`
Consolidation Chart of Accounts Consolidation Chart of Accounts Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RITCLG == TF120.ITCLG` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF120.MANDT`
Financial Statement Item Consolidation Chart of Accounts Client Financial Statement Item	`P_MATRIX_ELIMDATAWGROUPDERIVED.RITCLG == TF100.ITCLG` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF100.MANDT` `P_MATRIX_ELIMDATAWGROUPDERIVED.RITEM == TF100.ITEM`
Ledger Client Ledger	`P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T881.MANDT` `P_MATRIX_ELIMDATAWGROUPDERIVED.RLDNR == T881.RLDNR`
Transaction type Transaction type Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RMVCT == T856.TRTYP` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T856.MANDT`
Original company code Original company code Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.ROBUKRS == T001.BUKRS` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T001.MANDT`
Currency Key Currency Key Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RTCUR == TCURC.WAERS` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TCURC.MANDT`
Base Unit of Measure Base Unit of Measure Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RUNIT == T006.MSEHI` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T006.MANDT`
Consolidation Version Client Consolidation Version	`P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF200.MANDT` `P_MATRIX_ELIMDATAWGROUPDERIVED.RVERS == TF200.RVERS`
Trading partner's business area Trading partner's business area Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.SBUSA == TGSB.GSBER` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TGSB.MANDT`
Sender cost center ? Controlling Area Client Sender cost center	`P_MATRIX_ELIMDATAWGROUPDERIVED.[column in domain "DATBI"] == CSKS.DATBI` `P_MATRIX_ELIMDATAWGROUPDERIVED.KOKRS == CSKS.KOKRS` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == CSKS.MANDT` `P_MATRIX_ELIMDATAWGROUPDERIVED.SCNTR == CSKS.KOSTL`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.SEGMENT == FAGL_SEGM.SEGMENT` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == FAGL_SEGM.MANDT`
Partner Functional Area Partner Functional Area Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.SFAREA == TFKB.FKBER` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TFKB.MANDT`
Subitem Category Subitem Category Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.SITYP == TF110.SITYP` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF110.MANDT`
Division Division Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.SPART == TSPA.SPART` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TSPA.MANDT`
Subitem Subitem Category Subitem Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.SITYP == TF115.SITYP` `P_MATRIX_ELIMDATAWGROUPDERIVED.SUBIT == TF115.SITEM` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF115.MANDT`
Investor Unit Dimension Investor Unit Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.RDIMEN == TF160.DIMEN` `P_MATRIX_ELIMDATAWGROUPDERIVED.UPPCU == TF160.BUNIT` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TF160.MANDT`
User Name Client User Name	`P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == USR02.MANDT` `P_MATRIX_ELIMDATAWGROUPDERIVED.USNAM == USR02.BNAME`
Sales Organization Sales Organization Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.VKORG == TVKO.VKORG` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TVKO.MANDT`
Distribution Channel Distribution Channel Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.VTWEG == TVTW.VTWEG` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == TVTW.MANDT`
Plant Plant Client	`P_MATRIX_ELIMDATAWGROUPDERIVED.WERKS == T001W.WERKS` `P_MATRIX_ELIMDATAWGROUPDERIVED.MANDT == T001W.MANDT`