P_VECFINCSUNION_01

Union Reported and Standard and Consolidated Task | view: PVECUNION01 | Extraction: Not supported | Component: Validation Engine
Tables used: FINCS_REF_VERS_R, ACDOCU, ACDOCU, ACDOCU, ACDOCU, ACDOCU, FINCS_GRPSTR, TF200, TF001
Column Name Description
Column Name Description
💲 Currency key of the local currency (Currency):
CurrentPeriodAmount Value in Local 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
ConsolidationDocumentNumber Document Number of an Accounting Document BELNR
ConsolidationPostingItem Six-Character Posting Item for Ledger DOCLN6
PostingFiscalPeriod Posting period POPER
FiscalYear Fiscal Year GJAHR
OpeningBalanceAmount null
YearToDateAmount null
YearToDateAmountInPriorPeriod null
YearToDateAmountInPriorYear null
PeriodAmountInPriorPeriod null
PeriodAmountInPriorYear null
ConsolidationGroup Consolidation Group FC_CONGR
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_VECFINCSUNION_01.BASEUNIT == T006.MSEHI
  • P_VECFINCSUNION_01.MANDT == T006.MANDT
Billing Type
  • Billing Type
  • Client
  • P_VECFINCSUNION_01.BILLINGDOCUMENTTYPE == TVFK.FKART
  • P_VECFINCSUNION_01.MANDT == TVFK.MANDT
Business Area
  • Client
  • Business Area
  • P_VECFINCSUNION_01.MANDT == TGSB.MANDT
  • P_VECFINCSUNION_01.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_VECFINCSUNION_01.MANDT == T004.MANDT
  • P_VECFINCSUNION_01.CHARTOFACCOUNTS == T004.KTOPL
Company
  • Client
  • Company
  • P_VECFINCSUNION_01.MANDT == T880.MANDT
  • P_VECFINCSUNION_01.COMPANY == T880.RCOMP
Original company code
  • Original company code
  • Client
  • P_VECFINCSUNION_01.COMPANYCODE == T001.BUKRS
  • P_VECFINCSUNION_01.MANDT == T001.MANDT
Consolidation Chart of Accounts
  • Consolidation Chart of Accounts
  • Client
  • P_VECFINCSUNION_01.CONSOLIDATIONCHARTOFACCOUNTS == TF120.ITCLG
  • P_VECFINCSUNION_01.MANDT == TF120.MANDT
Dimension
  • Client
  • Dimension
  • P_VECFINCSUNION_01.MANDT == TF150.MANDT
  • P_VECFINCSUNION_01.CONSOLIDATIONDIMENSION == TF150.DIMEN
Document Type
  • Client
  • Dimension
  • Document Type
  • P_VECFINCSUNION_01.MANDT == TF500.MANDT
  • P_VECFINCSUNION_01.CONSOLIDATIONDIMENSION == TF500.DIMEN
  • P_VECFINCSUNION_01.CONSOLIDATIONDOCUMENTTYPE == TF500.DOCTY
Ledger
  • Ledger
  • Client
  • P_VECFINCSUNION_01.CONSOLIDATIONLEDGER == T881.RLDNR
  • P_VECFINCSUNION_01.MANDT == T881.MANDT
Consolidation Unit
  • Client
  • Dimension
  • Consolidation Unit
  • Consolidation Unit
  • P_VECFINCSUNION_01.MANDT == TF160.MANDT
  • P_VECFINCSUNION_01.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_VECFINCSUNION_01.CONSOLIDATIONUNIT == TF160.BUNIT
  • P_VECFINCSUNION_01.ENTITY == TF160.BUNIT
Controlling Area
  • Client
  • Controlling Area
  • P_VECFINCSUNION_01.MANDT == TKA01.MANDT
  • P_VECFINCSUNION_01.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • P_VECFINCSUNION_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_VECFINCSUNION_01.MANDT == CSKS.MANDT
  • P_VECFINCSUNION_01.COSTCENTER == CSKS.KOSTL
  • P_VECFINCSUNION_01.CONTROLLINGAREA == CSKS.KOKRS
Customer Group
  • Client
  • Customer Group
  • P_VECFINCSUNION_01.MANDT == T151.MANDT
  • P_VECFINCSUNION_01.CUSTOMERGROUP == T151.KDGRP
Country/Region Key
  • Country/Region Key
  • Client
  • P_VECFINCSUNION_01.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • P_VECFINCSUNION_01.MANDT == T005.MANDT
Industry key
  • Industry key
  • Client
  • P_VECFINCSUNION_01.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • P_VECFINCSUNION_01.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • P_VECFINCSUNION_01.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • P_VECFINCSUNION_01.MANDT == TVTW.MANDT
Consolidation Unit
  • Client
  • Dimension
  • Consolidation Unit
  • Consolidation Unit
  • P_VECFINCSUNION_01.MANDT == TF160.MANDT
  • P_VECFINCSUNION_01.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_VECFINCSUNION_01.CONSOLIDATIONUNIT == TF160.BUNIT
  • P_VECFINCSUNION_01.ENTITY == TF160.BUNIT
Financial Statement Item
  • Consolidation Chart of Accounts
  • Client
  • Financial Statement Item
  • P_VECFINCSUNION_01.CONSOLIDATIONCHARTOFACCOUNTS == TF100.ITCLG
  • P_VECFINCSUNION_01.MANDT == TF100.MANDT
  • P_VECFINCSUNION_01.FINANCIALSTATEMENTITEM == TF100.ITEM
Transaction type
  • Client
  • Transaction type
  • P_VECFINCSUNION_01.MANDT == T856.MANDT
  • P_VECFINCSUNION_01.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Functional Area
  • Functional Area
  • Client
  • P_VECFINCSUNION_01.FUNCTIONALAREA == TFKB.FKBER
  • P_VECFINCSUNION_01.MANDT == TFKB.MANDT
Account Number
  • Original company code
  • Client
  • Account Number
  • P_VECFINCSUNION_01.COMPANYCODE == SKB1.BUKRS
  • P_VECFINCSUNION_01.MANDT == SKB1.MANDT
  • P_VECFINCSUNION_01.GLACCOUNT == SKB1.SAKNR
Investee Unit
  • Investee Unit
  • Client
  • Dimension
  • P_VECFINCSUNION_01.INVESTEECONSOLIDATIONUNIT == TF160.BUNIT
  • P_VECFINCSUNION_01.MANDT == TF160.MANDT
  • P_VECFINCSUNION_01.CONSOLIDATIONDIMENSION == TF160.DIMEN
Material Group
  • Material Group
  • Client
  • P_VECFINCSUNION_01.MATERIALGROUP == T023.MATKL
  • P_VECFINCSUNION_01.MANDT == T023.MANDT
Division
  • Client
  • Division
  • P_VECFINCSUNION_01.MANDT == TSPA.MANDT
  • P_VECFINCSUNION_01.ORGANIZATIONDIVISION == TSPA.SPART
Trading partner's business area
  • Client
  • Trading partner's business area
  • P_VECFINCSUNION_01.MANDT == TGSB.MANDT
  • P_VECFINCSUNION_01.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_VECFINCSUNION_01.PARTNERCOMPANY == T880.RCOMP
  • P_VECFINCSUNION_01.MANDT == T880.MANDT
Partner Unit
  • Client
  • Dimension
  • Partner Unit
  • P_VECFINCSUNION_01.MANDT == TF160.MANDT
  • P_VECFINCSUNION_01.CONSOLIDATIONDIMENSION == TF160.DIMEN
  • P_VECFINCSUNION_01.PARTNERCONSOLIDATIONUNIT == TF160.BUNIT
Sender cost center
  • ?
  • Sender cost center
  • Client
  • Controlling Area
  • P_VECFINCSUNION_01.[column in domain "DATBI"] == CSKS.DATBI
  • P_VECFINCSUNION_01.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_VECFINCSUNION_01.MANDT == CSKS.MANDT
  • P_VECFINCSUNION_01.CONTROLLINGAREA == CSKS.KOKRS
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_VECFINCSUNION_01.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_VECFINCSUNION_01.MANDT == TFKB.MANDT
Partner Profit Center
  • ?
  • Partner Profit Center
  • Client
  • Controlling Area
  • P_VECFINCSUNION_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_VECFINCSUNION_01.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_VECFINCSUNION_01.MANDT == CEPC.MANDT
  • P_VECFINCSUNION_01.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_VECFINCSUNION_01.MANDT == FAGL_SEGM.MANDT
  • P_VECFINCSUNION_01.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • P_VECFINCSUNION_01.MANDT == T001W.MANDT
  • P_VECFINCSUNION_01.PLANT == T001W.WERKS
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • P_VECFINCSUNION_01.[column in domain "DATBI"] == CEPC.DATBI
  • P_VECFINCSUNION_01.PROFITCENTER == CEPC.PRCTR
  • P_VECFINCSUNION_01.MANDT == CEPC.MANDT
  • P_VECFINCSUNION_01.CONTROLLINGAREA == CEPC.KOKRS
Sales District
  • Client
  • Sales District
  • P_VECFINCSUNION_01.MANDT == T171.MANDT
  • P_VECFINCSUNION_01.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • P_VECFINCSUNION_01.MANDT == TVKO.MANDT
  • P_VECFINCSUNION_01.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_VECFINCSUNION_01.MANDT == FAGL_SEGM.MANDT
  • P_VECFINCSUNION_01.SEGMENT == FAGL_SEGM.SEGMENT
Product Sold Group
  • Product Sold Group
  • Client
  • P_VECFINCSUNION_01.SOLDPRODUCTGROUP == T023.MATKL
  • P_VECFINCSUNION_01.MANDT == T023.MANDT
Subitem
  • Subitem Category
  • Client
  • Subitem
  • P_VECFINCSUNION_01.SUBITEMCATEGORY == TF115.SITYP
  • P_VECFINCSUNION_01.MANDT == TF115.MANDT
  • P_VECFINCSUNION_01.SUBITEM == TF115.SITEM
Subitem Category
  • Subitem Category
  • Client
  • P_VECFINCSUNION_01.SUBITEMCATEGORY == TF110.SITYP
  • P_VECFINCSUNION_01.MANDT == TF110.MANDT
Currency Key
  • Client
  • Currency Key
  • P_VECFINCSUNION_01.MANDT == TCURC.MANDT
  • P_VECFINCSUNION_01.TRANSACTIONCURRENCY == TCURC.WAERS