P_VECRepFinData_02

Union 2 years Reported Financial Data | view: PVECREPFD_02 | Extraction: Not supported | Component: Validation Engine

Tables used: ACDOCU

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

Column Name	Description

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