FPC_EBEW_ETC_VIEW

@AbapCatalog.sqlViewName: 'FPCV_EBEW_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_EBEW_ETC_VIEW as 

   select key w.matnr   as matnr,
          key w.bwkey   as bwkey,
          key w.bwtar   as bwtar,
          key w.sobkz   as sobkz,
          key w.vbeln   as vbeln,
          key w.posnr   as posnr,
                 
              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.kalkz   as kalkz,
              w.kalkl   as kalkl,
              w.kalkv   as kalkv,
                            
              w.kaln1   as kaln1,
              w.bklas   as bklas,
              w.mlmaa   as mlmaa,              
              w.ekalr   as ekalr,
              w.kosgr   as kosgr,
              w.hrkft   as hrkft,
              w.hkmat   as hkmat,
//            data that exists in EBEW 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              
              
     from      v_ebew_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_EBEW_MD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/