P_VECStandardizedData_01

Get Standardized Data per Year | view: PVECSTDD_01 | Extraction: Not supported | Component: Validation Engine

Tables used: ACDOCU

🔑 Keys
💰 Amounts (18)
∑ Quantities (1)
📅 Dates
☰ Categorical (5)
Other (10)
🔗 Relations (39)

Column Name	Description

Column Name	Description
💲 Currency key of the ledger currency (cons_cur):
cons_slvt	null
cons_sl01	null
cons_sl02	null
cons_sl03	null
cons_sl04	null
cons_sl05	null
cons_sl06	null
cons_sl07	null
cons_sl08	null
cons_sl09	null
cons_sl10	null
cons_sl11	null
cons_sl12	null
cons_sl13	null
cons_sl14	null
cons_sl15	null
cons_sl16	null
💲 Currency Key (rtcur):
tsl	null

Column Name	Description
📏 Base Unit of Measure (runit):
msl	null

Column Name	Description

Column Name	Description
docct	Document Category	Show values
rrcty	Record Type	Show values
plevl	Posting Level	Show values
refdocct	Document Category	Show values
coiac	Consolidation of Investments Activity	Show values

Column Name	Description	Domain name
ryear	Fiscal Year	GJAHR
currency_type	null
yracq	Year of Acquisition	GJAHR
pracq	Period of Acquisition	NUM03
autom	Indicator: Automatic posting lines	TEXT1
coinr	Consolidation of Investments Activity Number	BELNR
ps_posid	Work Breakdown Structure Element (WBS Element)	PS_POSID
ps_pspid	Project definition	PS_PSPID
konzs	Group key	KONZS
timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS

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