C_InspCharcDefectCntRsltRecg

DDL: C_INSPCHARCDEFECTCNTRSLTRECG Type: view_entity CONSUMPTION Package: ODATA_QM_RSLT_RECG

Inspection Characteristic Defect Count

C_InspCharcDefectCntRsltRecg is a Consumption CDS View that provides data about "Inspection Characteristic Defect Count" in SAP S/4HANA. It reads from 1 data source (I_DefectUnion) and exposes 5 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, MaterialSample. Part of development package ODATA_QM_RSLT_RECG.

Data Sources (1)

SourceAliasJoin Type
I_DefectUnion I_DefectUnion from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Inspection Characteristic Defect Count view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
KEY MaterialSample MaterialSample
NumberOfDefects
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Characteristic Defect Count'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:  #C
@ObjectModel.usageType.sizeCategory: #S
define view entity C_InspCharcDefectCntRsltRecg as select from I_DefectUnion { 
     key InspectionLot,
     key InspPlanOperationInternalID,  
     key InspectionCharacteristic,
     key MaterialSample,
    cast (sum(NumberOfDefects) as vdm_numberofdefects) as NumberOfDefects
 
}

group by InspectionLot,InspPlanOperationInternalID,InspectionCharacteristic,MaterialSample