MBV_MBEW

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'MBVMBEW'
@EndUserText.label: 'Compatibility view for MBEW table'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #AUTOMATED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
define view Mbv_Mbew
  as select from           mbew
    left outer to one join Mbv_Mbew_Base           as b      on  mbew.kaln1 = b.kaln1  //see SAP note 2620366

                                                             and mbew.mandt = b.mandt
                                                             and mbew.matnr = b.matnr  //MATNR and BWKEY are added due to performance reason,

                                                             and mbew.bwkey = b.bwkey  //see SAP note 2505119

    left outer to one join Mbv_Mbew_Mother_Segment as mother on  mother.matnr = b.matnr
                                                             and mother.bwkey = b.bwkey
                                                             and mother.mandt   = b.mandt
  association [0..1] to E_Productvaluation as _ActiveExtension on  $projection.matnr = _ActiveExtension.Product
                                                               and $projection.bwkey = _ActiveExtension.ValuationArea
                                                               and $projection.bwtar = _ActiveExtension.ValuationType
{

  key  b.mandt,
  key  b.matnr,
  key  b.bwkey,
  key  b.bwtar,
       b.lvorm,

       //LBKUM

       cast (
       case when b.bwtar = '' and b.bwtty != '' then mother.lbkum // Mother Segment

            else  COALESCE(b.lbkum, 0)
       end
       as lbkum)                                            as lbkum,

       //SALK3

       cast (
       case when b.bwtar = '' and  b.bwtty != '' then mother.salk3 // Mother Segment

            else COALESCE(b.salk3, 0)
       end
       as salk3)                                            as salk3,
       b.vprsv,
       b.verpr,
       b.stprs,
       b.peinh,
       b.bklas,

       //SALKV

       cast(COALESCE(b.salkv, 0) as salkv)                               as salkv,
       b.vmkum,
       b.vmsal,
       b.vmvpr,
       b.vmver,
       b.vmstp,
       b.vmpei,
       b.vmbkl,
       b.vmsav,
       b.vjkum,
       b.vjsal,
       b.vjvpr,
       b.vjver,
       b.vjstp,
       b.vjpei,
       b.vjbkl,
       b.vjsav,
       b.lfgja,
       b.lfmon,
       b.bwtty,
       b.stprv,
       b.laepr,
       b.zkprs,
       b.zkdat,
       b.timestamp,
       b.bwprs,
       b.bwprh,
       b.vjbws,
       b.vjbwh,
       b.vvjsl,
       b.vvjlb,
       b.vvmlb,
       b.vvsal,
       b.zplpr,
       b.zplp1,
       b.zplp2,
       b.zplp3,
       b.zpld1,
       b.zpld2,
       b.zpld3,
       b.pperz,
       b.pperl,
       b.pperv,
       b.kalkz,
       b.kalkl,
       b.kalkv,
       b.kalsc,
       b.xlifo,
       b.mypol,
       b.bwph1,
       b.bwps1,
       b.abwkz,
       b.pstat,
       b.kaln1,
       b.kalnr,
       b.bwva1,
       b.bwva2,
       b.bwva3,
       b.vers1,
       b.vers2,
       b.vers3,
       b.hrkft,
       b.kosgr,
       b.pprdz,
       b.pprdl,
       b.pprdv,
       b.pdatz,
       b.pdatl,
       b.pdatv,
       b.ekalr,
       b.vplpr,
       b.mlmaa,
       b.mlast,
       b.lplpr,

       //VKSAL

       cast (
       case when b.bwtar = '' and  b.bwtty != '' then mother.vksal // Mother Segment

            else COALESCE(b.vksal, 0)
       end
       as vksal)                                            as vksal,
       b.hkmat,
       b.sperw,
       b.kziwl,
       b.wlinl,
       b.abciw,
       b.bwspa,
       b.lplpx,
       b.vplpx,
       b.fplpx,
       b.lbwst,
       b.vbwst,
       b.fbwst,
       b.eklas,
       b.qklas,
       b.mtuse,
       b.mtorg,
       b.ownpr,
       b.xbewm,
       b.bwpei,
       b.mbrue,
       b.oklas,
       mbew.dummy_val_incl_eew_ps,

       //Joint venture

       mbew.oippinv
} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"MBV_MBEW_BASE",
"MBV_MBEW_MOTHER_SEGMENT",
"MBEW"
],
"ASSOCIATED":
[
"E_PRODUCTVALUATION"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/