@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
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,
/* industry-specific fields */
// financial services
fs_product_group as FinancialServicesProductGroup,
branch_id as FinancialServicesBranch,
datasource_id as FinancialDataSource,
// public sector
fikrs as FinancialManagementArea,
rfund as Fund,
sfund as PartnerFund,
rgrant_nbr as GrantID,
re_ktopl as CnsldtnCashLedgerChartOfAccts,
re_account as CashLedgerAccount,
// greenhouse gas
ghgscope as GHGScope,
ghgcategory as GHGCategory,
ghgscp2calcmeth as GHGScope2CalculationMethod,
ghgscp2contrinstr as GHGScope2ContractualInstrument,
susmodeoftransport as SustainabilityModeOfTransport,
ghgdtaqltycharc as GHGDataQualityCharacteristic,
ghgenergyclass as GHGEnergyClassification,
ghgenergymix as GHGEnergyMix,
ghgengysrcgtype as GHGEnergySourcingType
}
where
rdimen = :p_rdimen
and ritclg = :p_ritclg
// and rvers = :p_rvers
// and rldnr = :p_rldnr
and ryear = :p_ryear
and poper <= :p_poper