C_InspCharcDefectCntRsltRecg

DDL: C_INSPCHARCDEFECTCNTRSLTRECG SQL: CCHARDEFCOUNT Type: view CONSUMPTION

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.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_DefectUnion I_DefectUnion from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCHARDEFCOUNT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
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
AbapCatalog.preserveKey true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
KEY MaterialSample MaterialSample
NumberOfDefects 
@AbapCatalog.sqlViewName: 'CCHARDEFCOUNT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@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
@AbapCatalog.preserveKey:true 


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

Learn More