P_MPEInspIssuesByProdnOrder

DDL: P_MPEINSPISSUESBYPRODNORDER Type: view_entity CONSUMPTION

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 2 data sources (P_MfgOrderAORList, I_InspectionIssuesByOrder) and exposes 5 fields with key field ManufacturingOrder.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
P_MfgOrderAORList _AORList inner
I_InspectionIssuesByOrder _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 I_InspectionIssuesByOrder ManufacturingOrder
OrderInternalBillOfOperations I_InspectionIssuesByOrder 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 I_InspectionIssuesByOrder as _InspIssOrder
  inner join P_MfgOrderAORList as _AORList on _AORList.OrderID = _InspIssOrder.ManufacturingOrder
{

  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

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONISSUESBYORDER",
"P_MFGORDERAORLIST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More