I_InspLotCharcNumberOfDefects

DDL: I_INSPLOTCHARCNUMBEROFDEFECTS Type: view_entity COMPOSITE

Number of Defects for Inspection Charc

I_InspLotCharcNumberOfDefects is a Composite CDS View that provides data about "Number of Defects for Inspection Charc" in SAP S/4HANA. It reads from 3 data sources (I_Defect, I_NotificationItem, I_QltyNotification) and exposes 8 fields.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_Defect I_Defect union
I_NotificationItem I_NotificationItem from
I_QltyNotification I_QltyNotification inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Number of Defects for Inspection Charc view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (8)

KeyFieldSource TableSource FieldDescription
InspectionLot I_QltyNotification InspectionLot
InspPlanOperationInternalID I_NotificationItem InspPlanOperationInternalID
InspectionCharacteristic I_NotificationItem InspectionCharacteristic
InspectionSubsetInternalID I_NotificationItem InspectionSubsetInternalID
InspPlanOperationInternalID InspPlanOperationInternalID
InspectionCharacteristic InspectionCharacteristic
InspectionSubsetInternalID I_Defect InspectionSubsetInternalID
NumberOfDefects 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Number of Defects for Inspection Charc'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #COMPOSITE
define view entity I_InspLotCharcNumberOfDefects 
  as select from I_NotificationItem
    inner join   I_QltyNotification on I_NotificationItem.Notification = I_QltyNotification.QualityNotification
{
  I_QltyNotification.InspectionLot,
  I_NotificationItem.InspPlanOperationInternalID,
  I_NotificationItem.InspectionCharacteristic,
  I_NotificationItem.InspectionSubsetInternalID,
  sum(I_NotificationItem.NumberOfDefects) as NumberOfDefects
}
where
  I_QltyNotification.InspectionLot is not initial
group by
  I_QltyNotification.InspectionLot,
  I_NotificationItem.InspPlanOperationInternalID,
  I_NotificationItem.InspectionCharacteristic,
  I_NotificationItem.InspectionSubsetInternalID
union select from I_Defect
{
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  I_Defect.InspectionSubsetInternalID,
  sum(NumberOfDefects) as NumberOfDefects
}
where
  I_Defect.InspectionLot is not initial
group by
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSubsetInternalID

Learn More