P_MaterialInfo

@AbapCatalog.sqlViewName: 'P_MATINFO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MASTER}
define view P_MaterialInfo
  as select from    mara     as mara
    left outer join a304     as a304    on  mara.matnr = a304.matnr
                                        and a304.kschl = 'PR00'
    left outer join konp     as konp    on  a304.matnr = mara.matnr
                                        and a304.knumh = konp.knumh
    inner join      marm     as marm    on  marm.matnr = mara.matnr
                                        and marm.meinh = mara.meins
    left outer join Mbv_Mbew as mbvmbew on mara.matnr = mbvmbew.matnr


{
  mara.matnr           as Material,
  mara.mtart           as MaterialType,

  case
  when mara.mhdhb <> 0 then mara.mhdhb
  else
  100 end              as TotalSLDays,

  case
  when konp.kbetr <> 0 then konp.kbetr
  else 1
  end                  as Price, //Material Price maintained for pricing condition

  konp.konwa           as PriceUnit,

  //  case when konp.konwa <> matdoc.waers

  //  then

  //  case when konp.kbetr <> 0 then konp.kbetr  else 1 end

  //  else 1 // convert konp.kbetr to company code currency

  //  end                  as Price,

  //In company code currency

  avg (mbvmbew.stprs)  as Costprice, //Material Standard Price

  mbvmbew.verpr        as MaterialPriceInCoCodeCurrency, //Material Moving Average Price


  marm.umrez           as Umrez,
  mara.meins           as BaseUnitOfMeasure,
  a304.datab,
  a304.datbi,
  $session.system_date as todaysdate


}
/*where
      a304.datab <= $session.system_date
  and a304.datbi >= $session.system_date */
group by
  mara.matnr,
  mara.mtart,
  mara.mhdhb,
  konp.kbetr,
  konp.konwa,

  mbvmbew.verpr,
  marm.umrez,
  mara.meins,
  a304.datab,
  a304.datbi