FPC_MBEW_ETC_VIEW

@AbapCatalog.sqlViewName: 'FPCV_MBEW_ETC'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Projection on MM data for PCP'

@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck:     #NOT_REQUIRED
//@ObjectModel.usageType.serviceQuality: #C      leads to ATC errors

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.type: #CLIENT_DEPENDENT

define view FPC_MBEW_ETC_VIEW as 

   select key w.matnr   as matnr,
          key w.bwkey   as bwkey,
          key w.bwtar   as bwtar,
                 
              a.mtart   as mtart,
              a.kzkfg   as KZKFG,
              a.meins   as MEINS,
              a.spart   as SPART,
              a.disst   as DISST,
              c.lvorm   as LVORM,
              c.bwtty   as BWTTY,
              c.sbdkz   as sbdkz,
              c.losgr   as losgr,
              c.sobsk   as SOBSK,
              c.sobsl   as SOBSL,
              c.stdpd   as STDPD,
              c.cuobj   as CUOBJ,
              c.sauft   as SAUFT,
              c.sfepr   as SFEPR,
              c.usequ   as USEQU,
              c.prctr   as PRCTR,
              c.ncost   as NCOST,
              
              w.kaln1   as kaln1,
              w.kalnr   as kalnr,
              w.mlmaa   as mlmaa,
              w.bklas   as bklas,
              w.eklas   as eklas,
              w.qklas   as qklas,
              w.ekalr   as ekalr,
              w.kosgr   as kosgr,
              w.hrkft   as hrkft,
              w.hkmat   as hkmat,
             
              w.kalkz   as kalkz,
              w.kalkl   as kalkl,
              w.kalkv   as kalkv,
              
              w.zplp1   as ZPLP1,
              w.zplp2   as ZPLP2,
              w.zplp3   as ZPLP3,
              w.zpld1   as ZPLD1,
              w.zpld2   as ZPLD2,               
              w.zpld3   as ZPLD3,
//            data that exists in MBEW Master Data and can also be persisted in FMLT_PRICE: 

              w.vprsv   as VPRSV,
              w.verpr   as VERPR,
              w.stprs   as STPRS,
              w.peinh   as PEINH,
              w.vmvpr   as VMVPR,
              w.vmver   as VMVER,
              w.vmstp   as VMSTP,
              w.vmpei   as VMPEI,
              w.vjvpr   as VJVPR,
              w.vjver   as VJVER,
              w.vjstp   as VJSTP,
              w.vjpei   as VJPEI,    
//            ... and are related to PCP              

              w.bwva1   as BWVA1,
              w.bwva2   as BWVA2,
              w.bwva3   as BWVA3,
              w.vers1   as VERS1,
              w.vers2   as VERS2,
              w.vers3   as VERS3,
              w.pprdz   as PPRDZ,
              w.pprdl   as PPRDL,
              w.pprdv   as PPRDV,              
              w.pdatz   as PDATZ,
              w.pdatl   as PDATL,              
              w.pdatv   as PDATV,
              w.zplpr   as ZPLPR,
              w.fplpx   as FPLPX,
              w.vplpr   as VPLPR,
              w.vplpx   as VPLPX,   
              w.lplpr   as LPLPR,
              w.lplpx   as LPLPX,
              w.fbwst   as FBWST,
              w.vbwst   as VBWST,
              w.lbwst   as LBWST,
//            prices not relevant for Cloud:

              w.bwprs   as BWPRS,     
              w.bwps1   as BWPS1,
              w.vjbws   as VJBWS,
              w.bwprh   as BWPRH,
              w.bwph1   as BWPH1,
              w.vjbwh   as VJBWH,
              w.bwpei   as BWPEI
              
     from      v_mbew_md   as w
//    inner join nsdm_e_marc as c                 leads to ATC errors

    inner join marc        as c
                           on c.matnr = w.matnr
                          and c.werks = w.bwkey                                                    
    inner join mara        as a 
                           on a.matnr = w.matnr
    ;   
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARA",
"MARC",
"V_MBEW_MD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/