@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PSTANDARDDATENHC'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm:#SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
define view P_StandardizedDataEnhC
as select from P_StandardizedData as StandardizedData
inner join I_CnsldtnVersionRelation as CnsldtnVersionRelation on CnsldtnVersionRelation.ConsolidationVersionElement = StandardizedData.rvers
inner join I_CnsldtnVersion as CnsldtnVersion on CnsldtnVersion.ConsolidationVersion = CnsldtnVersionRelation.ConsolidationVersion
and CnsldtnVersion.GroupCurrency = StandardizedData.rkcur
{
StandardizedData.rclnt,
StandardizedData.gl_sirid,
StandardizedData.rldnr,
StandardizedData.rrcty,
StandardizedData.rvers,
CnsldtnVersionRelation.ConsolidationVersion,
StandardizedData.ryear,
StandardizedData.rtcur,
StandardizedData.rhcur,
StandardizedData.rkcur,
StandardizedData.runit,
StandardizedData.drcrk,
StandardizedData.poper,
StandardizedData.fiscyearper,
StandardizedData.docct,
StandardizedData.docnr,
StandardizedData.docln,
StandardizedData.rcomp,
StandardizedData.rdimen,
StandardizedData.rbunit,
StandardizedData.ritclg,
StandardizedData.ritem,
StandardizedData.rbuptr,
StandardizedData.rcongr,
StandardizedData.robukrs,
StandardizedData.sityp,
StandardizedData.subit,
StandardizedData.plevl,
StandardizedData.rpflg,
StandardizedData.rtflg,
StandardizedData.docty,
StandardizedData.yracq,
StandardizedData.pracq,
StandardizedData.coicu,
StandardizedData.uppcu,
StandardizedData.updhp,
StandardizedData.tsl,
StandardizedData.hsl,
StandardizedData.ksl,
StandardizedData.msl,
StandardizedData.sgtxt,
StandardizedData.autom,
StandardizedData.activ,
StandardizedData.bvorg,
StandardizedData.budat,
StandardizedData.wsdat,
StandardizedData.refdocnr,
StandardizedData.refryear,
StandardizedData.refdocln,
StandardizedData.refdocct,
StandardizedData.refactiv,
StandardizedData.cpudt,
StandardizedData.cputm,
StandardizedData.usnam,
StandardizedData.rvsdocnr,
StandardizedData.orndocnr,
StandardizedData.coiac,
StandardizedData.coinr,
StandardizedData.revyear,
StandardizedData.awtyp,
StandardizedData.aworg,
StandardizedData.logsys,
StandardizedData.timestamp,
StandardizedData.racct,
StandardizedData.rcntr,
StandardizedData.prctr,
StandardizedData.rfarea,
StandardizedData.rbusa,
StandardizedData.kokrs,
StandardizedData.segment,
StandardizedData.scntr,
StandardizedData.pprctr,
StandardizedData.sfarea,
StandardizedData.sbusa,
StandardizedData.rassc,
StandardizedData.psegment,
StandardizedData.rmvct,
StandardizedData.matnr,
StandardizedData.werks,
StandardizedData.kunnr,
StandardizedData.lifnr,
StandardizedData.ps_posid,
StandardizedData.ps_pspid,
StandardizedData.fkart,
StandardizedData.vkorg,
StandardizedData.vtweg,
StandardizedData.spart,
StandardizedData.matnr_copa,
StandardizedData.matkl,
StandardizedData.kdgrp,
StandardizedData.land1,
StandardizedData.brsch,
StandardizedData.bzirk,
StandardizedData.kunre,
StandardizedData.kunwe,
StandardizedData.konzs,
StandardizedData.zuonr,
StandardizedData.aufnr,
StandardizedData.xblnr,
StandardizedData.matkl_mm,
StandardizedData.ps_psp_pnr,
StandardizedData.ktopl,
StandardizedData.adhocitem,
StandardizedData.adhocset,
StandardizedData.adhocsetitem,
StandardizedData.rcode,
StandardizedData.orig_type,
StandardizedData.orig_ref,
StandardizedData.bunnr
}
union all select from P_StandardizedData as StandardizedData
inner join I_CnsldtnVersionRelation as CnsldtnVersionRelation on CnsldtnVersionRelation.ConsolidationVersionElement = StandardizedData.rvers
inner join I_CnsldtnVersion as CnsldtnVersion on CnsldtnVersion.ConsolidationVersion = CnsldtnVersionRelation.ConsolidationVersion
and CnsldtnVersion.GroupCurrency <> StandardizedData.rkcur
{
StandardizedData.rclnt,
StandardizedData.gl_sirid,
StandardizedData.rldnr,
StandardizedData.rrcty,
StandardizedData.rvers,
CnsldtnVersionRelation.ConsolidationVersion,
StandardizedData.ryear,
StandardizedData.rtcur,
StandardizedData.rhcur,
cast('' as fincs_ui_gcurr) as rkcur,
StandardizedData.runit,
StandardizedData.drcrk,
StandardizedData.poper,
StandardizedData.fiscyearper,
StandardizedData.docct,
StandardizedData.docnr,
StandardizedData.docln,
StandardizedData.rcomp,
StandardizedData.rdimen,
StandardizedData.rbunit,
StandardizedData.ritclg,
StandardizedData.ritem,
StandardizedData.rbuptr,
StandardizedData.rcongr,
StandardizedData.robukrs,
StandardizedData.sityp,
StandardizedData.subit,
StandardizedData.plevl,
StandardizedData.rpflg,
StandardizedData.rtflg,
StandardizedData.docty,
StandardizedData.yracq,
StandardizedData.pracq,
StandardizedData.coicu,
StandardizedData.uppcu,
StandardizedData.updhp,
StandardizedData.tsl,
StandardizedData.hsl,
cast( '0' as fincs_ksl ) as ksl,
StandardizedData.msl,
StandardizedData.sgtxt,
StandardizedData.autom,
StandardizedData.activ,
StandardizedData.bvorg,
StandardizedData.budat,
StandardizedData.wsdat,
StandardizedData.refdocnr,
StandardizedData.refryear,
StandardizedData.refdocln,
StandardizedData.refdocct,
StandardizedData.refactiv,
StandardizedData.cpudt,
StandardizedData.cputm,
StandardizedData.usnam,
StandardizedData.rvsdocnr,
StandardizedData.orndocnr,
StandardizedData.coiac,
StandardizedData.coinr,
StandardizedData.revyear,
StandardizedData.awtyp,
StandardizedData.aworg,
StandardizedData.logsys,
StandardizedData.timestamp,
StandardizedData.racct,
StandardizedData.rcntr,
StandardizedData.prctr,
StandardizedData.rfarea,
StandardizedData.rbusa,
StandardizedData.kokrs,
StandardizedData.segment,
StandardizedData.scntr,
StandardizedData.pprctr,
StandardizedData.sfarea,
StandardizedData.sbusa,
StandardizedData.rassc,
StandardizedData.psegment,
StandardizedData.rmvct,
StandardizedData.matnr,
StandardizedData.werks,
StandardizedData.kunnr,
StandardizedData.lifnr,
StandardizedData.ps_posid,
StandardizedData.ps_pspid,
StandardizedData.fkart,
StandardizedData.vkorg,
StandardizedData.vtweg,
StandardizedData.spart,
StandardizedData.matnr_copa,
StandardizedData.matkl,
StandardizedData.kdgrp,
StandardizedData.land1,
StandardizedData.brsch,
StandardizedData.bzirk,
StandardizedData.kunre,
StandardizedData.kunwe,
StandardizedData.konzs,
StandardizedData.zuonr,
StandardizedData.aufnr,
StandardizedData.xblnr,
StandardizedData.matkl_mm,
StandardizedData.ps_psp_pnr,
StandardizedData.ktopl,
StandardizedData.adhocitem,
StandardizedData.adhocset,
StandardizedData.adhocsetitem,
StandardizedData.rcode,
StandardizedData.orig_type,
StandardizedData.orig_ref,
StandardizedData.bunnr
}