P_VECStandardizedData
P_VECStandardizedData is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CnsldtnGlobalSetting, P_StandardizedData) and exposes 81 fields.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_CnsldtnGlobalSetting | _GlobalSetting | inner |
| P_StandardizedData | P_StandardizedData | from |
Parameters (8)
| Name | Type | Default |
|---|---|---|
| p_rdimen | fc_dimen | |
| p_ritclg | fc_itclg | |
| p_rvers | fc_rvers | |
| p_rldnr | rldnr | |
| p_ryear | gjahr | |
| p_pyear | gjahr | |
| p_poper | poper | |
| p_CURTYPE | vec_curtype |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PVECSTDDATA | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.private | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (81)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| OpeningBalanceAmount | ||||
| YearToDateAmount | ||||
| YearToDateAmountInPriorPeriod | ||||
| YearToDateAmountInPriorYear | ||||
| PeriodAmountInPriorPeriod | ||||
| PeriodAmountInPriorYear | ||||
| TaskType | ||||
| CurrencyType | ||||
| Currency | rkcur | |||
| TransactionCurrency | rtcur | |||
| ConsolidationVersion | rvers | |||
| ConsolidationDimension | rdimen | |||
| ConsolidationLedger | rldnr | |||
| DocumentCategory | docct | |||
| ConsolidationDocumentNumber | docnr | |||
| ConsolidationPostingItem | docln | |||
| Company | rcomp | |||
| Entity | rbunit | |||
| ConsolidationUnit | rbunit | |||
| ConsolidationChartOfAccounts | ritclg | |||
| FinancialStatementItem | ritem | |||
| PartnerConsolidationUnit | rbuptr | |||
| SubItemCategory | sityp | |||
| SubItem | subit | |||
| PostingFiscalPeriod | poper | |||
| FiscalYear | ryear | |||
| CurrentPeriodAmount | ksl | |||
| PeriodAmountInTransacCrcy | tsl | |||
| RecordType | rrcty | |||
| PostingLevel | plevl | |||
| ConsolidationDocumentType | docty | |||
| ConsolidationAcquisitionYear | yracq | |||
| ConsolidationAcquisitionPeriod | pracq | |||
| InvesteeConsolidationUnit | coicu | |||
| ConsolidationPostgItemAutoFlag | autom | |||
| RefConsolidationDocumentType | refdocct | |||
| InvestmentActivityType | coiac | |||
| InvestmentActivity | coinr | |||
| ChartOfAccounts | ktopl | |||
| GLAccount | racct | |||
| BaseUnit | runit | |||
| CurrentPeriodQuantity | msl | |||
| CostCenter | rcntr | |||
| ProfitCenter | prctr | |||
| FunctionalArea | rfarea | |||
| BusinessArea | rbusa | |||
| ControllingArea | kokrs | |||
| Segment | segment | |||
| PartnerCostCenter | scntr | |||
| PartnerProfitCenter | pprctr | |||
| PartnerFunctionalArea | sfarea | |||
| PartnerBusinessArea | sbusa | |||
| PartnerCompany | rassc | |||
| PartnerSegment | psegment | |||
| MaterialGroup | matkl_mm | |||
| Plant | werks | |||
| FinancialTransactionType | rmvct | |||
| WBSElementExternalID | ps_posid | |||
| Project | ps_pspid | |||
| BillingDocumentType | fkart | |||
| SalesOrganization | vkorg | |||
| DistributionChannel | vtweg | |||
| OrganizationDivision | spart | |||
| SoldProductGroup | matkl | |||
| CustomerGroup | kdgrp | |||
| CustomerSupplierCountry | land1 | |||
| CustomerSupplierIndustry | brsch | |||
| SalesDistrict | bzirk | |||
| CustomerSupplierCorporateGroup | konzs | |||
| CreationDateTime | timestamp | |||
| CompanyCode | robukrs | |||
| ShipToParty | kunwe | |||
| BillToParty | kunre | |||
| Material | matnr | |||
| SoldProduct | matnr_copa | |||
| CurrencyConversionsDiffType | rtflg | |||
| OrderID | aufnr | |||
| Customer | kunnr | |||
| Supplier | lifnr | |||
| CnsldtnAdhocItem | adhocitem | |||
| CnsldtnAdhocSet | adhocset |
@AbapCatalog.sqlViewName: 'PVECSTDDATA'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm:#SESSION_VARIABLE
//@AccessControl.authorizationCheck: #NOT_ALLOWED
//@EndUserText.label: 'Consolidation Validation: Standardized Data'
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
define view P_VECStandardizedData
with parameters
p_rdimen : fc_dimen,
p_ritclg : fc_itclg,
p_rvers : fc_rvers,
p_rldnr : rldnr,
p_ryear : gjahr,
p_pyear : gjahr,
p_poper : poper,
p_CURTYPE : vec_curtype
// as select from P_StandardizedData
// inner join I_CnsldtnGlobalSetting as _GlobalSetting on _GlobalSetting.SequenceNumber = '1'
//{
////****obeselote fields for compatible reason
// @Semantics.amount.currencyCode: 'Currency'
// '' as OpeningBalanceAmount,
// @Semantics.amount.currencyCode: 'Currency'
// '' as YearToDateAmount,
// @Semantics.amount.currencyCode: 'Currency'
// '' as YearToDateAmountInPriorPeriod,
// @Semantics.amount.currencyCode: 'Currency'
// '' as YearToDateAmountInPriorYear,
// @Semantics.amount.currencyCode: 'Currency'
// '' as PeriodAmountInPriorPeriod,
// @Semantics.amount.currencyCode: 'Currency'
// '' as PeriodAmountInPriorYear,
////****obeselote fields for compatible reason
// '02' as TaskType,
// 'GC' as CurrencyType,
// @Semantics.currencyCode
// rkcur as Currency,
// @Semantics.currencyCode
// rtcur as TransactionCurrency,
// rvers as ConsolidationVersion,
// rdimen as ConsolidationDimension,
// rldnr as ConsolidationLedger,
// docct as DocumentCategory,
// docnr as ConsolidationDocumentNumber,
// docln as ConsolidationPostingItem,
// rcomp as Company,
// rbunit as Entity,
// rbunit as ConsolidationUnit,
// ritclg as ConsolidationChartOfAccounts,
// ritem as FinancialStatementItem,
// rbuptr as PartnerConsolidationUnit,
// sityp as SubItemCategory,
// subit as SubItem,
// poper as PostingFiscalPeriod,
// ryear as FiscalYear,
// @Semantics.amount.currencyCode: 'Currency'
// ksl as CurrentPeriodAmount,
// @Semantics.amount.currencyCode: 'TransactionCurrency'
// tsl as PeriodAmountInTransacCrcy,
// rrcty as RecordType,
// plevl as PostingLevel,
// docty as ConsolidationDocumentType,
// yracq as ConsolidationAcquisitionYear,
// pracq as ConsolidationAcquisitionPeriod,
// coicu as InvesteeConsolidationUnit,
// autom as ConsolidationPostgItemAutoFlag,
// refdocct as RefConsolidationDocumentType,
// coiac as InvestmentActivityType,
// coinr as InvestmentActivity,
// ktopl as ChartOfAccounts,
// racct as GLAccount,
// @Semantics.unitOfMeasure: true
// runit as BaseUnit,
// @Semantics.quantity.unitOfMeasure: 'BaseUnit'
// msl as CurrentPeriodQuantity,
// rcntr as CostCenter,
// prctr as ProfitCenter,
// rfarea as FunctionalArea,
// rbusa as BusinessArea,
// kokrs as ControllingArea,
// segment as Segment,
// scntr as PartnerCostCenter,
// pprctr as PartnerProfitCenter,
// sfarea as PartnerFunctionalArea,
// sbusa as PartnerBusinessArea,
// rassc as PartnerCompany,
// psegment as PartnerSegment,
// matkl_mm as MaterialGroup,
// werks as Plant,
// rmvct as FinancialTransactionType,
// ps_posid as WBSElementExternalID,
// ps_pspid as Project,
// fkart as BillingDocumentType,
// vkorg as SalesOrganization,
// vtweg as DistributionChannel,
// spart as OrganizationDivision,
// matkl as SoldProductGroup,
// kdgrp as CustomerGroup,
// land1 as CustomerSupplierCountry,
// brsch as CustomerSupplierIndustry,
// bzirk as SalesDistrict,
// konzs as CustomerSupplierCorporateGroup,
// timestamp as CreationDateTime,
// robukrs as CompanyCode,
// kunwe as ShipToParty,
// kunre as BillToParty,
// matnr as Material,
// matnr_copa as SoldProduct,
// rtflg as CurrencyConversionsDiffType,
// aufnr as OrderID,
// kunnr as Customer,
// lifnr as Supplier,
// adhocitem as CnsldtnAdhocItem,
// adhocset as CnsldtnAdhocSet
//}where
// rdimen = :p_rdimen
// and ritclg = :p_ritclg
// and rvers = :p_rvers
// and rldnr = :p_rldnr
// and ryear = :p_ryear
// and poper <= :p_poper
// and ( _GlobalSetting.CnsldtnFrmYrForNewGrpRptgLogic = '0000' or
// _GlobalSetting.CnsldtnFrmYrForNewGrpRptgLogic is null or
// _GlobalSetting.CnsldtnFrmYrForNewGrpRptgLogic > :p_ryear )
//union all
as select from P_StandardizedData
inner join I_CnsldtnGlobalSetting as _GlobalSetting on _GlobalSetting.SequenceNumber = '1'
join P_VecVersionMapping( P_ConsolidationVersion : :p_rvers ) as Version_Stack on P_StandardizedData.rvers = Version_Stack.ConsolidationVersionElement
{
//****obeselote fields for compatible reason
@Semantics.amount.currencyCode: 'Currency'
'' as OpeningBalanceAmount,
@Semantics.amount.currencyCode: 'Currency'
'' as YearToDateAmount,
@Semantics.amount.currencyCode: 'Currency'
'' as YearToDateAmountInPriorPeriod,
@Semantics.amount.currencyCode: 'Currency'
'' as YearToDateAmountInPriorYear,
@Semantics.amount.currencyCode: 'Currency'
'' as PeriodAmountInPriorPeriod,
@Semantics.amount.currencyCode: 'Currency'
'' as PeriodAmountInPriorYear,
//****obeselote fields for compatible reason
'02' as TaskType,
'GC' as CurrencyType,
@Semantics.currencyCode
rkcur as Currency,
@Semantics.currencyCode
rtcur as TransactionCurrency,
rvers as ConsolidationVersion,
rdimen as ConsolidationDimension,
rldnr as ConsolidationLedger,
docct as DocumentCategory,
docnr as ConsolidationDocumentNumber,
docln as ConsolidationPostingItem,
rcomp as Company,
rbunit as Entity,
rbunit as ConsolidationUnit,
ritclg as ConsolidationChartOfAccounts,
ritem as FinancialStatementItem,
rbuptr as PartnerConsolidationUnit,
sityp as SubItemCategory,
subit as SubItem,
poper as PostingFiscalPeriod,
ryear as FiscalYear,
@Semantics.amount.currencyCode: 'Currency'
ksl as CurrentPeriodAmount,
@Semantics.amount.currencyCode: 'TransactionCurrency'
tsl as PeriodAmountInTransacCrcy,
rrcty as RecordType,
plevl as PostingLevel,
docty as ConsolidationDocumentType,
yracq as ConsolidationAcquisitionYear,
pracq as ConsolidationAcquisitionPeriod,
coicu as InvesteeConsolidationUnit,
autom as ConsolidationPostgItemAutoFlag,
refdocct as RefConsolidationDocumentType,
coiac as InvestmentActivityType,
coinr as InvestmentActivity,
ktopl as ChartOfAccounts,
racct as GLAccount,
@Semantics.unitOfMeasure: true
runit as BaseUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
msl as CurrentPeriodQuantity,
rcntr as CostCenter,
prctr as ProfitCenter,
rfarea as FunctionalArea,
rbusa as BusinessArea,
kokrs as ControllingArea,
segment as Segment,
scntr as PartnerCostCenter,
pprctr as PartnerProfitCenter,
sfarea as PartnerFunctionalArea,
sbusa as PartnerBusinessArea,
rassc as PartnerCompany,
psegment as PartnerSegment,
matkl_mm as MaterialGroup,
werks as Plant,
rmvct as FinancialTransactionType,
ps_posid as WBSElementExternalID,
ps_pspid as Project,
fkart as BillingDocumentType,
vkorg as SalesOrganization,
vtweg as DistributionChannel,
spart as OrganizationDivision,
matkl as SoldProductGroup,
kdgrp as CustomerGroup,
land1 as CustomerSupplierCountry,
brsch as CustomerSupplierIndustry,
bzirk as SalesDistrict,
konzs as CustomerSupplierCorporateGroup,
timestamp as CreationDateTime,
robukrs as CompanyCode,
kunwe as ShipToParty,
kunre as BillToParty,
matnr as Material,
matnr_copa as SoldProduct,
rtflg as CurrencyConversionsDiffType,
aufnr as OrderID,
kunnr as Customer,
lifnr as Supplier,
adhocitem as CnsldtnAdhocItem,
adhocset as CnsldtnAdhocSet
}
where
rdimen = :p_rdimen
and ritclg = :p_ritclg
and ryear = :p_ryear
and poper <= :p_poper
and(
(
_GlobalSetting.CnsldtnFrmYrForNewGrpRptgLogic != '0000'
and _GlobalSetting.CnsldtnFrmYrForNewGrpRptgLogic is not null
and _GlobalSetting.CnsldtnFrmYrForNewGrpRptgLogic <= :p_ryear
)
or(
rvers = :p_rvers
and rldnr = :p_rldnr
)
)
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA