I_InspCharcValueAggregate

DDL: I_INSPCHARCVALUEAGGREGATE SQL: IINSPCHAVLAGGR Type: view COMPOSITE Package: VDM_QM_INSPECTION

Insp. Characteristic Value Aggregate

I_InspCharcValueAggregate is a Composite CDS View (Fact) that provides data about "Insp. Characteristic Value Aggregate" in SAP S/4HANA. It reads from 2 data sources (I_InspectionCharacteristic, I_InspectionResultValue) and exposes 5 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. Part of development package VDM_QM_INSPECTION.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_InspectionCharacteristic I_InspectionCharacteristic from
I_InspectionResultValue I_InspectionResultValue inner

Annotations (8)

NameValueLevelField
EndUserText.label Insp. Characteristic Value Aggregate view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataCategory #FACT view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IINSPCHAVLAGGR view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionCharacteristic InspectionLot
KEY InspPlanOperationInternalID I_InspectionCharacteristic InspPlanOperationInternalID
KEY InspectionCharacteristic I_InspectionCharacteristic InspectionCharacteristic
InspectionSubsetInternalID I_InspectionResultValue InspectionSubsetInternalID
InspResultValueCount 
@EndUserText.label: 'Insp. Characteristic Value Aggregate'
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #M, dataClass: #TRANSACTIONAL }
@Analytics.dataCategory: #FACT
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'IINSPCHAVLAGGR'
define view I_InspCharcValueAggregate
  as select from I_InspectionCharacteristic
    inner join   I_InspectionResultValue on  I_InspectionCharacteristic.InspectionLot               = I_InspectionResultValue.InspectionLot
                                         and I_InspectionCharacteristic.InspPlanOperationInternalID = I_InspectionResultValue.InspPlanOperationInternalID
                                         and I_InspectionCharacteristic.InspectionCharacteristic    = I_InspectionResultValue.InspectionCharacteristic

{
  key I_InspectionCharacteristic.InspectionLot,
  key I_InspectionCharacteristic.InspPlanOperationInternalID,
  key I_InspectionCharacteristic.InspectionCharacteristic,
      I_InspectionResultValue.InspectionSubsetInternalID,

      count(*) as InspResultValueCount
}
group by
  I_InspectionCharacteristic.InspectionLot,
  I_InspectionCharacteristic.InspPlanOperationInternalID,
  I_InspectionCharacteristic.InspectionCharacteristic,
  I_InspectionResultValue.InspectionSubsetInternalID

Learn More