P_MPEProdnOrdOpMatlIsMissing

DDL: P_MPEPRODNORDOPMATLISMISSING Type: view_entity CONSUMPTION Package: ODATA_MPE_MFGORDER

Production Order Operation Missing Material

P_MPEProdnOrdOpMatlIsMissing is a Consumption CDS View that provides data about "Production Order Operation Missing Material" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 3 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem. 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
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem
MaterialComponentIsMissing 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view entity P_MPEProdnOrdOpMatlIsMissing
  as select from I_MfgOrderOperationComponent
{
  key OrderInternalBillOfOperations,
  key OrderIntBillOfOperationsItem,
      max(MaterialComponentIsMissing)         as MaterialComponentIsMissing
}
where ReservationIsFinallyIssued = ''
group by
  OrderInternalBillOfOperations,
  OrderIntBillOfOperationsItem;

Learn More