P_MPE_MaterialMrpAreaStock

DDL: P_MPE_MATERIALMRPAREASTOCK Type: view_entity CONSUMPTION

Stock data for Material Plant MrpArea

P_MPE_MaterialMrpAreaStock is a Consumption CDS View that provides data about "Stock data for Material Plant MrpArea" in SAP S/4HANA. It reads from 1 data source (matdoc) and exposes 5 fields with key fields matnr, werks, berid.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
matdoc mat from

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Stock data for Material Plant MrpArea view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY matnr matdoc matbf
KEY werks matdoc werks
KEY berid matdoc berid
VltdUnrestrictedUseStkQty
BaseUnit matdoc meins 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@EndUserText.label: 'Stock data for Material Plant MrpArea'
@Metadata.ignorePropagatedAnnotations: true
define view entity P_MPE_MaterialMrpAreaStock as select from matdoc as mat

{

  key mat.matbf                                                                                     as matnr,
  key mat.werks                                                                                     as werks,
  key mat.berid                                                                                     as berid,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(sum(mat.stock_qty) as nsdm_stock_qty)                                                 as VltdUnrestrictedUseStkQty,
      mat.meins as BaseUnit
}
group by
  mat.matbf,
  mat.werks,
  mat.berid,
  mat.meins

Learn More