P_InspSubsetValnAggregate

DDL: P_INSPSUBSETVALNAGGREGATE SQL: PSUBSETVALNAGGR Type: view CONSUMPTION

P_InspSubsetValnAggregate is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_InspectionSubset) and exposes 4 fields with key fields InspectionLot, InspPlanOperationInternalID.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionSubset I_InspectionSubset from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSUBSETVALNAGGR view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation 
@AbapCatalog.sqlViewName: 'PSUBSETVALNAGGR'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@VDM.private: true


define view P_InspSubsetValnAggregate as 
  select from I_InspectionSubset 
{
    key InspectionLot,
    key InspPlanOperationInternalID,
    sum(case 
      when InspSubsetUsageDcsnValuation = 'A' then 1      
      else 0 end) as InspSubsetAcceptedCount,
    sum(case when InspSubsetUsageDcsnValuation = 'R' then 1    
      else 0 end) as InspSubsetRejectedCount,
      
      
      _InspectionLot,
     _InspectionOperation
    
} group by InspectionLot, InspPlanOperationInternalID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONSUBSET"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION"
],
"BASE":
[
"I_INSPECTIONSUBSET"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More