P_MATERIALINFO

CDS View

P_MATERIALINFO is a CDS View in S/4HANA. It contains 6 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 6 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BatchInfo view inner COMPOSITE
P_CustomerOrder view inner BASIC

Fields (6)

KeyField CDS FieldsUsed in Views
BaseUnitOfMeasure BaseUnitOfMeasure 1
Costprice StandardPrice 1
MaterialPriceInCoCodeCurrency MaterialPriceInCoCodeCurrency 1
Price MaterialPrice 1
PriceUnit MaterialPriceUnit 1
Umrez Umrez 1 
@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 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"MBV_MBEW",
"A304",
"KONP",
"MARA",
"MARM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More