P_MPEProdnOrdOperMissMatCount

DDL: P_MPEPRODNORDOPERMISSMATCOUNT Type: view_entity CONSUMPTION

Production Order Operation Missing Mat Count, private View

P_MPEProdnOrdOperMissMatCount is a Consumption CDS View that provides data about "Production Order Operation Missing Mat Count, private View" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationComponent) and exposes 5 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationComponent I_MfgOrderOperationComponent from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Production Order Operation Missing Mat Count, private View view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations OrderInternalBillOfOperations
KEY OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem
ManufacturingOrder ManufacturingOrder
ManufacturingOrderCategory ManufacturingOrderCategory
NumberOfMissingMatlComp
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Production Order Operation Missing Mat Count, private View'
@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view entity P_MPEProdnOrdOperMissMatCount as select from I_MfgOrderOperationComponent {
  key OrderInternalBillOfOperations,
  key OrderIntBillOfOperationsItem,
      ManufacturingOrder,
      ManufacturingOrderCategory,
      count(*) as NumberOfMissingMatlComp
}
where MaterialComponentIsMissing = 'X' and ReservationIsFinallyIssued = ''
group by OrderInternalBillOfOperations,
        OrderIntBillOfOperationsItem,
        ManufacturingOrder,
        ManufacturingOrderCategory,
        MaterialComponentIsMissing;