P_MPEProdnOrdMatlIsMissing

DDL: P_MPEPRODNORDMATLISMISSING Type: view_entity CONSUMPTION Package: ODATA_MPE_MFGORDER

Production Order Missing Material

P_MPEProdnOrdMatlIsMissing is a Consumption CDS View that provides data about "Production Order Missing Material" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 3 fields with key field OrderInternalBillOfOperations. Part of development package ODATA_MPE_MFGORDER.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationComponent I_MfgOrderOperationComponent from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations OrderInternalBillOfOperations
ManufacturingOrder ManufacturingOrder
MaterialComponentIsMissing 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_MPEProdnOrdMatlIsMissing
  as select from I_MfgOrderOperationComponent
{
  key OrderInternalBillOfOperations,
      ManufacturingOrder,
      max(MaterialComponentIsMissing)         as MaterialComponentIsMissing
}
where ManufacturingOrderCategory = '10'
group by
  OrderInternalBillOfOperations,
  ManufacturingOrder;

Learn More