P_VECConsolidatedData

Consolidation Validation: Consolidated Data | view: PVECCONSDATA | Extraction: Not supported | Component: Validation Engine

Tables used: FINCS_REF_VERS_R, ACDOCU, ACDOCU, ACDOCU, ACDOCU, FINCS_GRPSTR, TF200, TF001

🔑 Keys
💰 Amounts (2)
∑ Quantities (1)
📅 Dates
☰ Categorical (5)
Other (20)
🔗 Relations (42)

Column Name	Description

Column Name	Description
💲 Currency key of the ledger currency (Currency):
CurrentPeriodAmount	Value in Group Currency
💲 Currency Key (TransactionCurrency):
PeriodAmountInTransacCrcy	Value in Transaction Currency

Column Name	Description
📏 Base Unit of Measure (BaseUnit):
CurrentPeriodQuantity	Quantity

Column Name	Description

Column Name	Description
DocumentCategory	Document Category	Show values
RecordType	Record Type	Show values
PostingLevel	Posting Level	Show values
RefConsolidationDocumentType	Document Category	Show values
InvestmentActivityType	Consolidation of Investments Activity	Show values

Column Name	Description	Domain name
OpeningBalanceAmount	null
YearToDateAmount	null
YearToDateAmountInPriorPeriod	null
YearToDateAmountInPriorYear	null
PeriodAmountInPriorPeriod	null
PeriodAmountInPriorYear	null
TaskType	null
CurrencyType	null
PostingFiscalPeriod	Posting period	POPER
FiscalYear	Fiscal Year	GJAHR
ConsolidationDocumentNumber	Document Number of an Accounting Document	BELNR
ConsolidationPostingItem	Six-Character Posting Item for Ledger	DOCLN6
ConsolidationAcquisitionYear	Year of Acquisition	GJAHR
ConsolidationAcquisitionPeriod	Period of Acquisition	NUM03
ConsolidationPostgItemAutoFlag	Indicator: Automatic posting lines	TEXT1
InvestmentActivity	Consolidation of Investments Activity Number	BELNR
WBSElementExternalID	Work Breakdown Structure Element (WBS Element)	PS_POSID
Project	Project definition	PS_PSPID
CustomerSupplierCorporateGroup	Group key	KONZS
CreationDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`P_VECCONSOLIDATEDDATA.BASEUNIT == T006.MSEHI` `P_VECCONSOLIDATEDDATA.MANDT == T006.MANDT`
Billing Type Billing Type Client	`P_VECCONSOLIDATEDDATA.BILLINGDOCUMENTTYPE == TVFK.FKART` `P_VECCONSOLIDATEDDATA.MANDT == TVFK.MANDT`
Business Area Business Area Client	`P_VECCONSOLIDATEDDATA.BUSINESSAREA == TGSB.GSBER` `P_VECCONSOLIDATEDDATA.MANDT == TGSB.MANDT`
Chart of Accounts Chart of Accounts Client	`P_VECCONSOLIDATEDDATA.CHARTOFACCOUNTS == T004.KTOPL` `P_VECCONSOLIDATEDDATA.MANDT == T004.MANDT`
Company Client Company	`P_VECCONSOLIDATEDDATA.MANDT == T880.MANDT` `P_VECCONSOLIDATEDDATA.COMPANY == T880.RCOMP`
Original company code Client Original company code	`P_VECCONSOLIDATEDDATA.MANDT == T001.MANDT` `P_VECCONSOLIDATEDDATA.COMPANYCODE == T001.BUKRS`
Consolidation Chart of Accounts Consolidation Chart of Accounts Client	`P_VECCONSOLIDATEDDATA.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG` `P_VECCONSOLIDATEDDATA.MANDT == TF120.MANDT`
Dimension Client Dimension	`P_VECCONSOLIDATEDDATA.MANDT == TF150.MANDT` `P_VECCONSOLIDATEDDATA.CONSOLIDATIONDIMENSION == TF150.DIMEN`
Document Type Client Dimension Document Type	`P_VECCONSOLIDATEDDATA.MANDT == TF500.MANDT` `P_VECCONSOLIDATEDDATA.CONSOLIDATIONDIMENSION == TF500.DIMEN` `P_VECCONSOLIDATEDDATA.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY`
Consolidation Group Consolidation Group Consolidation Group Client Dimension	`P_VECCONSOLIDATEDDATA.CONSOLIDATIONGROUP == TF180.CONGR` `P_VECCONSOLIDATEDDATA.ENTITY == TF180.CONGR` `P_VECCONSOLIDATEDDATA.MANDT == TF180.MANDT` `P_VECCONSOLIDATEDDATA.CONSOLIDATIONDIMENSION == TF180.DIMEN`
Ledger Ledger Client	`P_VECCONSOLIDATEDDATA.CONSOLIDATIONLEDGER == T881.RLDNR` `P_VECCONSOLIDATEDDATA.MANDT == T881.MANDT`
Consolidation Unit Consolidation Unit Client Dimension	`P_VECCONSOLIDATEDDATA.CONSOLIDATIONUNIT == TF160.BUNIT` `P_VECCONSOLIDATEDDATA.MANDT == TF160.MANDT` `P_VECCONSOLIDATEDDATA.CONSOLIDATIONDIMENSION == TF160.DIMEN`
Controlling Area Controlling Area Client	`P_VECCONSOLIDATEDDATA.CONTROLLINGAREA == TKA01.KOKRS` `P_VECCONSOLIDATEDDATA.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Client Cost Center	`P_VECCONSOLIDATEDDATA.[column in domain "DATBI"] == CSKS.DATBI` `P_VECCONSOLIDATEDDATA.CONTROLLINGAREA == CSKS.KOKRS` `P_VECCONSOLIDATEDDATA.MANDT == CSKS.MANDT` `P_VECCONSOLIDATEDDATA.COSTCENTER == CSKS.KOSTL`
Customer Group Customer Group Client	`P_VECCONSOLIDATEDDATA.CUSTOMERGROUP == T151.KDGRP` `P_VECCONSOLIDATEDDATA.MANDT == T151.MANDT`
Country/Region Key Country/Region Key Client	`P_VECCONSOLIDATEDDATA.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1` `P_VECCONSOLIDATEDDATA.MANDT == T005.MANDT`
Industry key Client Industry key	`P_VECCONSOLIDATEDDATA.MANDT == T016.MANDT` `P_VECCONSOLIDATEDDATA.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH`
Distribution Channel Distribution Channel Client	`P_VECCONSOLIDATEDDATA.DISTRIBUTIONCHANNEL == TVTW.VTWEG` `P_VECCONSOLIDATEDDATA.MANDT == TVTW.MANDT`
Consolidation Group Consolidation Group Consolidation Group Client Dimension	`P_VECCONSOLIDATEDDATA.CONSOLIDATIONGROUP == TF180.CONGR` `P_VECCONSOLIDATEDDATA.ENTITY == TF180.CONGR` `P_VECCONSOLIDATEDDATA.MANDT == TF180.MANDT` `P_VECCONSOLIDATEDDATA.CONSOLIDATIONDIMENSION == TF180.DIMEN`
Financial Statement Item Consolidation Chart of Accounts Client Financial Statement Item	`P_VECCONSOLIDATEDDATA.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG` `P_VECCONSOLIDATEDDATA.MANDT == TF100.MANDT` `P_VECCONSOLIDATEDDATA.FINANCIALSTATEMENTITEM == TF100.ITEM`
Transaction type Client Transaction type	`P_VECCONSOLIDATEDDATA.MANDT == T856.MANDT` `P_VECCONSOLIDATEDDATA.FINANCIALTRANSACTIONTYPE == T856.TRTYP`
Functional Area Functional Area Client	`P_VECCONSOLIDATEDDATA.FUNCTIONALAREA == TFKB.FKBER` `P_VECCONSOLIDATEDDATA.MANDT == TFKB.MANDT`
Account Number Account Number Client Original company code	`P_VECCONSOLIDATEDDATA.GLACCOUNT == SKB1.SAKNR` `P_VECCONSOLIDATEDDATA.MANDT == SKB1.MANDT` `P_VECCONSOLIDATEDDATA.COMPANYCODE == SKB1.BUKRS`
Investee Unit Client Dimension Investee Unit	`P_VECCONSOLIDATEDDATA.MANDT == TF160.MANDT` `P_VECCONSOLIDATEDDATA.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_VECCONSOLIDATEDDATA.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT`
Material Group Client Material Group	`P_VECCONSOLIDATEDDATA.MANDT == T023.MANDT` `P_VECCONSOLIDATEDDATA.MATERIALGROUP == T023.MATKL`
Division Client Division	`P_VECCONSOLIDATEDDATA.MANDT == TSPA.MANDT` `P_VECCONSOLIDATEDDATA.ORGANIZATIONDIVISION == TSPA.SPART`
Trading partner's business area Client Trading partner's business area	`P_VECCONSOLIDATEDDATA.MANDT == TGSB.MANDT` `P_VECCONSOLIDATEDDATA.PARTNERBUSINESSAREA == TGSB.GSBER`
Company ID of Trading Partner Client Company ID of Trading Partner	`P_VECCONSOLIDATEDDATA.MANDT == T880.MANDT` `P_VECCONSOLIDATEDDATA.PARTNERCOMPANY == T880.RCOMP`
Partner Unit Client Dimension Partner Unit	`P_VECCONSOLIDATEDDATA.MANDT == TF160.MANDT` `P_VECCONSOLIDATEDDATA.CONSOLIDATIONDIMENSION == TF160.DIMEN` `P_VECCONSOLIDATEDDATA.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT`
Sender cost center Sender cost center ? Controlling Area Client	`P_VECCONSOLIDATEDDATA.PARTNERCOSTCENTER == CSKS.KOSTL` `P_VECCONSOLIDATEDDATA.[column in domain "DATBI"] == CSKS.DATBI` `P_VECCONSOLIDATEDDATA.CONTROLLINGAREA == CSKS.KOKRS` `P_VECCONSOLIDATEDDATA.MANDT == CSKS.MANDT`
Partner Functional Area Partner Functional Area Client	`P_VECCONSOLIDATEDDATA.PARTNERFUNCTIONALAREA == TFKB.FKBER` `P_VECCONSOLIDATEDDATA.MANDT == TFKB.MANDT`
Partner Profit Center ? Controlling Area Client Partner Profit Center	`P_VECCONSOLIDATEDDATA.[column in domain "DATBI"] == CEPC.DATBI` `P_VECCONSOLIDATEDDATA.CONTROLLINGAREA == CEPC.KOKRS` `P_VECCONSOLIDATEDDATA.MANDT == CEPC.MANDT` `P_VECCONSOLIDATEDDATA.PARTNERPROFITCENTER == CEPC.PRCTR`
Partner Segment for Segmental Reporting Partner Segment for Segmental Reporting Client	`P_VECCONSOLIDATEDDATA.PARTNERSEGMENT == FAGL_SEGM.SEGMENT` `P_VECCONSOLIDATEDDATA.MANDT == FAGL_SEGM.MANDT`
Plant Client Plant	`P_VECCONSOLIDATEDDATA.MANDT == T001W.MANDT` `P_VECCONSOLIDATEDDATA.PLANT == T001W.WERKS`
Profit Center ? Profit Center Controlling Area Client	`P_VECCONSOLIDATEDDATA.[column in domain "DATBI"] == CEPC.DATBI` `P_VECCONSOLIDATEDDATA.PROFITCENTER == CEPC.PRCTR` `P_VECCONSOLIDATEDDATA.CONTROLLINGAREA == CEPC.KOKRS` `P_VECCONSOLIDATEDDATA.MANDT == CEPC.MANDT`
Sales District Sales District Client	`P_VECCONSOLIDATEDDATA.SALESDISTRICT == T171.BZIRK` `P_VECCONSOLIDATEDDATA.MANDT == T171.MANDT`
Sales Organization Client Sales Organization	`P_VECCONSOLIDATEDDATA.MANDT == TVKO.MANDT` `P_VECCONSOLIDATEDDATA.SALESORGANIZATION == TVKO.VKORG`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`P_VECCONSOLIDATEDDATA.SEGMENT == FAGL_SEGM.SEGMENT` `P_VECCONSOLIDATEDDATA.MANDT == FAGL_SEGM.MANDT`
Product Sold Group Product Sold Group Client	`P_VECCONSOLIDATEDDATA.SOLDPRODUCTGROUP == T023.MATKL` `P_VECCONSOLIDATEDDATA.MANDT == T023.MANDT`
Subitem Subitem Subitem Category Client	`P_VECCONSOLIDATEDDATA.SUBITEM == TF115.SITEM` `P_VECCONSOLIDATEDDATA.SUBITEMCATEGORY == TF115.SITYP` `P_VECCONSOLIDATEDDATA.MANDT == TF115.MANDT`
Subitem Category Subitem Category Client	`P_VECCONSOLIDATEDDATA.SUBITEMCATEGORY == TF110.SITYP` `P_VECCONSOLIDATEDDATA.MANDT == TF110.MANDT`
Currency Key Client Currency Key	`P_VECCONSOLIDATEDDATA.MANDT == TCURC.MANDT` `P_VECCONSOLIDATEDDATA.TRANSACTIONCURRENCY == TCURC.WAERS`