P_VECRepFinData_01

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