P_InspectionLotAggregate3

DDL: P_INSPECTIONLOTAGGREGATE3 SQL: PINSPLOTAGR3 Type: view COMPOSITE

P_InspectionLotAggregate3 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_InspOperationUsageDecision) and exposes 2 fields with key field InspectionLot.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_InspOperationUsageDecision I_InspOperationUsageDecision from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PINSPLOTAGR3 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspOperationUsageDecision InspectionLot
InspOperationCompletedCount 
@AbapCatalog.sqlViewName: 'PINSPLOTAGR3'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view P_InspectionLotAggregate3 as select from I_InspOperationUsageDecision {
    key I_InspOperationUsageDecision.InspectionLot,
    count( distinct I_InspOperationUsageDecision.InspPlanOperationInternalID) as InspOperationCompletedCount
}
group by InspectionLot

Learn More