P_InspectionPartialSampleSize

DDL: P_INSPECTIONPARTIALSAMPLESIZE Type: view_entity COMPOSITE Package: ODATA_QM_INSPECTION_ANALYTICS

Number of Samples for Insp. Charac.

P_InspectionPartialSampleSize is a Composite CDS View that provides data about "Number of Samples for Insp. Charac." in SAP S/4HANA. It reads from 1 data source (I_InspSubsetResult) and exposes 4 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. Part of development package ODATA_QM_INSPECTION_ANALYTICS.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_InspSubsetResult I_InspSubsetResult from

Annotations (3)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspSubsetResult InspectionLot
KEY InspPlanOperationInternalID I_InspSubsetResult InspPlanOperationInternalID
KEY InspectionCharacteristic I_InspSubsetResult InspectionCharacteristic
InspectionPartialSampleSize 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true

define view entity P_InspectionPartialSampleSize as select from I_InspSubsetResult 

{ 
  key I_InspSubsetResult.InspectionLot,
  key I_InspSubsetResult.InspPlanOperationInternalID,
  key I_InspSubsetResult.InspectionCharacteristic,
    
  cast( count( * ) as qanzstipro) as InspectionPartialSampleSize
    
} 
where
    I_InspSubsetResult.InspectionResultStatus = '3' or
    I_InspSubsetResult.InspectionResultStatus = '5'
group by 
    I_InspSubsetResult.InspectionLot,
    I_InspSubsetResult.InspPlanOperationInternalID,
    I_InspSubsetResult.InspectionCharacteristic

Learn More