P_Inspoperationaggregate2

DDL: P_INSPOPERATIONAGGREGATE2 SQL: PINSPOPAGGR2 Type: view COMPOSITE Package: VDM_QM_INSPECTION

Aggregation on inspection operation

P_Inspoperationaggregate2 is a Composite CDS View that provides data about "Aggregation on inspection operation" in SAP S/4HANA. It reads from 1 data source (I_InspectionCharacteristic) and exposes 3 fields with key fields InspectionLot, InspPlanOperationInternalID. Part of development package VDM_QM_INSPECTION.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionCharacteristic I_InspectionCharacteristic from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PINSPOPAGGR2 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionCharacteristic InspectionLot
KEY InspPlanOperationInternalID I_InspectionCharacteristic InspPlanOperationInternalID
InspCharacteristicCount 
@AbapCatalog.sqlViewName: 'PINSPOPAGGR2'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view P_Inspoperationaggregate2 as select from I_InspectionCharacteristic {
    key I_InspectionCharacteristic.InspectionLot,
    key I_InspectionCharacteristic.InspPlanOperationInternalID,
    sum(case 
     when ( ( I_InspectionCharacteristic._InspectionResult.InspectionValuationResult is null or 
          I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = ' ' or 
          I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = 'F' )
          and (I_InspectionCharacteristic.InspectionCharacteristicStatus <> '4') ) then 1
     when I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = '+' then 999999 //to force int4-type      

     else 0 end) as  InspCharOpenCount,
    sum(case 
     when (I_InspectionCharacteristic._InspectionResult.InspectionValuationResult is null or 
          I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = ' ' or 
          I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = 'F' )
          and (I_InspectionCharacteristic.InspSpecIsLongTermInspection = 'X')  then 1
     when I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = '+' then 999999 //to force int4-type      

     else 0 end) as  InspCharLongTermOpenCount,
    sum(case 
     when (I_InspectionCharacteristic._InspectionResult.InspectionValuationResult is null or 
          I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = ' ' or 
          I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = 'F' )
          and (I_InspectionCharacteristic.InspSpecIsLongTermInspection != 'X')  then 1
     when I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = '+' then 999999 //to force int4-type      

     else 0 end) as  InspCharShortTermOpenCount,
    sum(case 
     when I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = 'A' then 1 
     when I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = '+' then 999999 //to force int4-type      

     else 0 end) as InspCharAcceptedCount,
    sum(case when I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = 'R' then 1 
     when I_InspectionCharacteristic._InspectionResult.InspectionValuationResult = '+' then 999999 //to force int4-type      

     else 0 end) as InspCharRejectedCount,
     count( distinct I_InspectionCharacteristic.InspectionCharacteristic) as InspCharacteristicCount,
     sum(case when ( (I_InspectionCharacteristic.InspectionCharacteristicStatus = '4') and ( _InspectionResult.InspectionCharacteristic is null ) )
     then 1
     else 0 end) as NumberOfSkipInspCharcs
}
group by I_InspectionCharacteristic.InspectionLot,
         I_InspectionCharacteristic.InspPlanOperationInternalID

Learn More