I_InspCharcValidValueAggr

DDL: I_INSPCHARCVALIDVALUEAGGR SQL: IINSPCHAVVLAGGR Type: view COMPOSITE

Insp. Characteristic Value Aggregate

I_InspCharcValidValueAggr is a Composite CDS View (Fact) that provides data about "Insp. Characteristic Value Aggregate" in SAP S/4HANA. It reads from 1 data source (I_InspectionResultValue) and exposes 6 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionResultValue I_InspectionResultValue from

Annotations (8)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
InspResultValueCount
InspectionResultMaximumValue
InspectionResultMinimumValue 
@EndUserText.label: 'Insp. Characteristic Value Aggregate'
@Analytics.dataCategory: #FACT
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'IINSPCHAVVLAGGR'
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #D
}
define view I_InspCharcValidValueAggr
  as select from I_InspectionResultValue
{
  key InspectionLot,
  key InspPlanOperationInternalID,
  key InspectionCharacteristic,

      count(*)                           as InspResultValueCount,
      max(InspectionResultMeasuredValue) as InspectionResultMaximumValue,
      min(InspectionResultMeasuredValue) as InspectionResultMinimumValue
}
where
     I_InspectionResultValue.InspectionResultAttribute = ''
  or I_InspectionResultValue.InspectionResultAttribute = '<'
  or I_InspectionResultValue.InspectionResultAttribute = '>'
  or I_InspectionResultValue.InspectionResultAttribute = '?'
  or I_InspectionResultValue.InspectionResultAttribute = '*'
  or I_InspectionResultValue.InspectionResultAttribute = '('
  or I_InspectionResultValue.InspectionResultAttribute = '['
  or I_InspectionResultValue.InspectionResultAttribute = '{'
  or I_InspectionResultValue.InspectionResultAttribute = '~'
  or I_InspectionResultValue.InspectionResultAttribute = '#'
  or I_InspectionResultValue.InspectionResultAttribute = 'U'
  or I_InspectionResultValue.InspectionResultAttribute = 'V'
  or I_InspectionResultValue.InspectionResultAttribute = 'W'
group by
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic     
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONRESULTVALUE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More