P_InspectionPartialSampleSize

DDL: P_INSPECTIONPARTIALSAMPLESIZE SQL: PINSPPRTLSMPLSZ Type: view COMPOSITE

P_InspectionPartialSampleSize is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_InspSubsetResult) and exposes 4 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_InspSubsetResult I_InspSubsetResult from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PINSPPRTLSMPLSZ view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
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 
@AbapCatalog.sqlViewName: 'PINSPPRTLSMPLSZ'
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true

define view 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