P_VECStandardizedData_02

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