P_InspSubsetCharcAgg

DDL: P_INSPSUBSETCHARCAGG Type: view_entity COMPOSITE Package: ODATA_QM_INSPSUBSET_RR

RRIP: Characteristics aggregates

P_InspSubsetCharcAgg is a Composite CDS View that provides data about "RRIP: Characteristics aggregates" in SAP S/4HANA. It reads from 1 data source (I_InspSubsetCharacteristic) and exposes 9 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. Part of development package ODATA_QM_INSPSUBSET_RR.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_InspSubsetCharacteristic InspSubsetCharacteristic from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspSubsetCharacteristic InspectionLot
KEY InspPlanOperationInternalID I_InspSubsetCharacteristic InspPlanOperationInternalID
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic
Plant
InspectionLotType
InspectionSubsetType
MatlQualityAuthorizationGroup
IsBusinessPurposeCompleted
WorkCenter 
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view entity P_InspSubsetCharcAgg
  as select from           I_InspSubsetCharacteristic as InspSubsetCharacteristic
    left outer to one join I_InspectionSubset         as InspectionSubset on  InspSubsetCharacteristic.InspectionLot               = InspectionSubset.InspectionLot
                                                                          and InspSubsetCharacteristic.InspectionSubsetInternalID  = InspectionSubset.InspectionSubsetInternalID
                                                                          and InspSubsetCharacteristic.InspPlanOperationInternalID = InspectionSubset.InspPlanOperationInternalID
    left outer to one join I_InspSubsetResult         as InspSubsetResult on  InspSubsetCharacteristic.InspectionLot               = InspSubsetResult.InspectionLot
                                                                          and InspSubsetCharacteristic.InspPlanOperationInternalID = InspSubsetResult.InspPlanOperationInternalID
                                                                          and InspSubsetCharacteristic.InspectionCharacteristic    = InspSubsetResult.InspectionCharacteristic
                                                                          and InspSubsetCharacteristic.InspectionSubsetInternalID  = InspSubsetResult.InspectionSubsetInternalID
  //  association[0..1] to I_InspectionResultStatus as _InspectionResultStatus on $projection.inspectionresultstatus = _InspectionResultStatus.InspectionResultStatus

{
  key InspSubsetCharacteristic.InspectionLot,
  key InspSubsetCharacteristic.InspPlanOperationInternalID,
  key InspSubsetCharacteristic.InspectionCharacteristic,
      //  key InspSubsetCharacteristic.InspectionSubsetInternalID,

      sum( case
        when InspSubsetResult.InspectionValuationResult = 'A' then 1
        else 0 end ) as InspCharAcceptedCount,
      sum( case
        when InspSubsetResult.InspectionValuationResult = 'R' then 1
        else 0 end ) as InspCharRejectedCount,
      
      
     InspSubsetCharacteristic._InspectionLot.Plant,
     InspSubsetCharacteristic._InspectionLot.InspectionLotType,
     InspSubsetCharacteristic._InspectionLot.InspectionSubsetType,
     InspSubsetCharacteristic._InspectionLot.MatlQualityAuthorizationGroup,
     InspSubsetCharacteristic._InspectionLot.IsBusinessPurposeCompleted,
     InspSubsetCharacteristic._InspectionOperation._WorkCenter.WorkCenter     
      //      InspectionCharacteristicStatus,

      //      InspectionResultMeanValue,

      //      InspectionValuationResult,

      //      InspectionResultStatus,

      ////      _InspectionResultStatus._Text[1:Language=$session.system_language].InspectionResultStatusText,

      //      InspSubsetUsageDcsnValuation,

      //      InspectionSubsetDate,

      //      InspectionSubsetTime

}
where
     InspectionSubset.InspSubsetUsageDcsnValuation = 'A'
  or InspectionSubset.InspSubsetUsageDcsnValuation = 'R'
group by
  InspSubsetCharacteristic.InspectionLot,
  InspSubsetCharacteristic.InspPlanOperationInternalID,
  InspSubsetCharacteristic.InspectionCharacteristic,
  InspSubsetCharacteristic._InspectionLot.Plant,
  InspSubsetCharacteristic._InspectionLot.InspectionLotType,
  InspSubsetCharacteristic._InspectionLot.InspectionSubsetType,
  InspSubsetCharacteristic._InspectionLot.MatlQualityAuthorizationGroup,
  InspSubsetCharacteristic._InspectionLot.IsBusinessPurposeCompleted,
  InspSubsetCharacteristic._InspectionOperation._WorkCenter.WorkCenter

Learn More