P_MPEInspIssuesByProdnOrder

DDL: P_MPEINSPISSUESBYPRODNORDER Type: view_entity CONSUMPTION Package: ODATA_MPE_MFGORDER

Inspection Issues by Production Order

P_MPEInspIssuesByProdnOrder is a Consumption CDS View that provides data about "Inspection Issues by Production Order" in SAP S/4HANA. It reads from 1 data source (P_InspIssuesByOrd) and exposes 5 fields with key field ManufacturingOrder. Part of development package ODATA_MPE_MFGORDER.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_InspIssuesByOrd _InspIssOrder from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Inspection Issues by Production Order view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder P_InspIssuesByOrd ManufacturingOrder
OrderInternalBillOfOperations P_InspIssuesByOrd OrderInternalBillOfOperations
InspHasRejectedCharc
InspHasRejectedInspSubset
InspHasRejectedInspLot 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Issues by Production Order'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_MPEInspIssuesByProdnOrder
  as select from P_InspIssuesByOrd as _InspIssOrder
{

  key _InspIssOrder.ManufacturingOrder,
      _InspIssOrder.OrderInternalBillOfOperations,
      max( _InspIssOrder.InspHasRejectedCharc )          as InspHasRejectedCharc,

      max( _InspIssOrder.InspHasRejectedInspSubset )  as InspHasRejectedInspSubset,

      max( _InspIssOrder.InspHasRejectedInspLot )          as InspHasRejectedInspLot

}
group by
  _InspIssOrder.ManufacturingOrder, 
  _InspIssOrder.OrderInternalBillOfOperations

Learn More