I_InspectionLotAggregate

DDL: I_INSPECTIONLOTAGGREGATE SQL: IINSPLOTAGGR Type: view COMPOSITE

Aggregation on inspection lot level

I_InspectionLotAggregate is a Composite CDS View that provides data about "Aggregation on inspection lot level" in SAP S/4HANA. It reads from 4 data sources (I_InspectionLot, P_InspectionLotAggregate1, P_InspectionLotAggregate2, P_InspectionLotAggregate3) and exposes 18 fields with key field InspectionLot.

4 data source(s) 18 fields

Data Sources (4)

SourceAliasJoin Type
I_InspectionLot I_InspectionLot from
P_InspectionLotAggregate1 P_InspectionLotAggregate1 left_outer
P_InspectionLotAggregate2 P_InspectionLotAggregate2 left_outer
P_InspectionLotAggregate3 P_InspectionLotAggregate3 left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINSPLOTAGGR view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Aggregation on inspection lot level view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionLot InspectionLot
InspCharAcceptedCount P_InspectionLotAggregate2 InspCharAcceptedCount
InspCharRejectedCount P_InspectionLotAggregate2 InspCharRejectedCount
InspCharOpenCount P_InspectionLotAggregate2 InspCharOpenCount
InspCharacteristicCount P_InspectionLotAggregate2 InspCharacteristicCount
InspCharLongTermOpenCount P_InspectionLotAggregate2 InspCharLongTermOpenCount
InspCharShortTermOpenCount P_InspectionLotAggregate2 InspCharShortTermOpenCount
NumberOfSkipInspCharcs P_InspectionLotAggregate2 NumberOfSkipInspCharcs
InspSubsetCharcAcceptedCount P_InspectionLotAggregate2 InspSubsetCharcAcceptedCount
InspSubsetCharcRejectedCount P_InspectionLotAggregate2 InspSubsetCharcRejectedCount
InspSubsetCharcOpenCount P_InspectionLotAggregate2 InspSubsetCharcOpenCount
NumberOfSkipInspSubsetCharcs P_InspectionLotAggregate2 NumberOfSkipInspSubsetCharcs
MaterialSampleCount P_InspectionLotAggregate1 MaterialSampleCount
InspOperationCount P_InspectionLotAggregate2 InspOperationCount
InspOperationCompletedCount P_InspectionLotAggregate3 InspOperationCompletedCount
Plant Plant
InspectionLotType InspectionLotType
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup 
@AbapCatalog.sqlViewName: 'IINSPLOTAGGR'
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #L, dataClass: #TRANSACTIONAL }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Aggregation on inspection lot level'
@VDM.viewType: #COMPOSITE
define view I_InspectionLotAggregate
  as select from    I_InspectionLot
    left outer join P_InspectionLotAggregate2  on I_InspectionLot.InspectionLot = P_InspectionLotAggregate2.InspectionLot
    left outer join P_InspectionLotAggregate3 on I_InspectionLot.InspectionLot = P_InspectionLotAggregate3.InspectionLot
    left outer join P_InspectionLotAggregate1 on I_InspectionLot.InspectionLot = P_InspectionLotAggregate1.InspectionLot
    
{
  key I_InspectionLot.InspectionLot,
      P_InspectionLotAggregate2.InspCharAcceptedCount,
      P_InspectionLotAggregate2.InspCharRejectedCount,
      P_InspectionLotAggregate2.InspCharOpenCount,
      P_InspectionLotAggregate2.InspCharacteristicCount,
      P_InspectionLotAggregate2.InspCharLongTermOpenCount,
      P_InspectionLotAggregate2.InspCharShortTermOpenCount,
      P_InspectionLotAggregate2.NumberOfSkipInspCharcs,
      P_InspectionLotAggregate2.InspSubsetCharcAcceptedCount,
      P_InspectionLotAggregate2.InspSubsetCharcRejectedCount,
      P_InspectionLotAggregate2.InspSubsetCharcOpenCount,
      P_InspectionLotAggregate2.NumberOfSkipInspSubsetCharcs,
      // MAX can be used since for every operation of a lot there will be the same value for MaterialSampleCount

      P_InspectionLotAggregate1.MaterialSampleCount,
      P_InspectionLotAggregate2.InspOperationCount,
      P_InspectionLotAggregate3.InspOperationCompletedCount,
      
      // for authorization check

      @Consumption.hidden: true
      Plant, 
      @Consumption.hidden: true
      InspectionLotType, 
      @Consumption.hidden: true
      MatlQualityAuthorizationGroup
}

Learn More