P_MPEProdnOrdOpMatlIsMissing

DDL: P_MPEPRODNORDOPMATLISMISSING Type: view_entity CONSUMPTION

P_MPEProdnOrdOpMatlIsMissing is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 3 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem.

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;                               
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDEROPERATIONCOMPONENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More