P_MPEOrdInspLotOpenCharcCount

DDL: P_MPEORDINSPLOTOPENCHARCCOUNT Type: view_entity CONSUMPTION Package: ODATA_MPE_MFGORDER

Number of Open Characteristics in Inspection Lot

P_MPEOrdInspLotOpenCharcCount is a Consumption CDS View that provides data about "Number of Open Characteristics in Inspection Lot" in SAP S/4HANA. It reads from 2 data sources (I_InspectionCharacteristic, I_InspectionResult) and exposes 2 fields with key field InspectionLot. Part of development package ODATA_MPE_MFGORDER.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_InspectionCharacteristic I_InspectionCharacteristic from
I_InspectionResult I_InspectionResult left_outer

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Number of Open Characteristics in Inspection Lot view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionCharacteristic InspectionLot
InspOpenCount 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Number of Open Characteristics in Inspection Lot'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_MPEOrdInspLotOpenCharcCount
as select from I_InspectionCharacteristic
  left outer join I_InspectionResult on I_InspectionCharacteristic.InspectionLot = I_InspectionResult.InspectionLot
                                     and I_InspectionCharacteristic.InspPlanOperationInternalID = I_InspectionResult.InspPlanOperationInternalID
                                     and I_InspectionCharacteristic.InspectionCharacteristic = I_InspectionResult.InspectionCharacteristic
{
  key I_InspectionCharacteristic.InspectionLot,
     count(*) as InspOpenCount
}
where
     I_InspectionResult.InspectionResultStatus is null
  or I_InspectionResult.InspectionResultStatus = '0'
  or I_InspectionResult.InspectionResultStatus = '1'
  or I_InspectionResult.InspectionResultStatus = '2'
  or I_InspectionResult.InspectionResultStatus = '3'
  or I_InspectionResult.InspectionResultStatus = '4'
group by
  I_InspectionCharacteristic.InspectionLot

Learn More