Mbv_Obew

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'MBVOBEW'
@EndUserText.label: 'Compatibility view for OBEW table'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #AUTOMATED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
define view Mbv_Obew
  as select from           obew
  
    inner join R_MatlPriceDataMigrationStatus as tf on ( tf.MatlPriceDataMigrationStatus = 'X' ) 
                                                    or ( tf.MatlPriceDataMigrationStatus = 'R' )
                                                    or ( tf.MatlPriceDataMigrationStatus = 'F' )

    left outer to one join V_ML_ACDOC_EX_UL_DDL as ext on  ext.rclnt = obew.mandt
                                                       and ext.kalnr = obew.kaln1

    left outer to one join FMLV_XBEW_CKMLCR_SALKV as matprice   on  matprice.mandt = obew.mandt
                                                            and matprice.kalnr = obew.kaln1
                                                            and ( ( ( tf.MatlPriceDataMigrationStatus = 'X' or  tf.MatlPriceDataMigrationStatus = 'R' )
                                                                and matprice.bdatj = obew.lfgja
                                                                and matprice.lfmonp = concat('0', obew.lfmon ) ) 
                                                                or ( ( tf.MatlPriceDataMigrationStatus = 'R' or tf.MatlPriceDataMigrationStatus = 'F' )  and matprice.bdatj = '9999' ) )
{
  key obew.mandt,
  key obew.matnr,
  key obew.bwkey,
  key obew.bwtar,
  key obew.sobkz,
  key obew.lifnr,

      //LBKUM from acdoca extract table

      cast(COALESCE(ext.vmsl, 0) as lbkum)   as lbkum,

      //SALK3 from acdoca extract table

      cast(COALESCE(ext.hsl, 0) as salk3)    as salk3,
      obew.vprsv,
      verpr,
      obew.stprs,
      obew.peinh,
      bklas,

      //SALKV from CR table

      cast(COALESCE(matprice.salkv, 0) as salkv)   as salkv,
      vmkum,
      vmsal,
      vmvpr,
      vmver,
      vmstp,
      vmpei,
      vmbkl,
      vmsav,
      vjkum,
      vjsal,
      vjvpr,
      vjver,
      vjstp,
      vjpei,
      vjbkl,
      vjsav,
      lfgja,
      lfmon,
      bwtty,
      stprv,
      laepr,
      zkprs,
      zkdat,
      timestamp,
      zplpr,
      kalkz,
      kalkl,
      kalkv,
      kaln1,
      bwva1,
      bwva2,
      bwva3,
      vers1,
      vers2,
      vers3,
      hrkft,
      kosgr,
      pprdz,
      pprdl,
      pprdv,
      pdatz,
      pdatl,
      pdatv,
      ekalr,
      vplpr,
      mlmaa,
      mlast,
      lplpr,

      //VKSAL from acdoca extract table

      cast(COALESCE(ext.hvkwrt, 0) as vksal) as vksal,
      hkmat,
      bwspa,
      lplpx,
      vplpx,
      fplpx,
      lbwst,
      vbwst,
      fbwst,
      mbrue,
      oklas
} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FMLV_XBEW_CKMLCR_SALKV",
"R_MATLPRICEDATAMIGRATIONSTATUS",
"V_ML_ACDOC_EX_UL_DDL",
"OBEW"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/