P_INSPECTIONLOTAGGREGATE2
Aggregate on Operations
P_INSPECTIONLOTAGGREGATE2 is a CDS View in S/4HANA. Aggregate on Operations. It contains 12 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InspectionLotAggregate | view | left_outer | COMPOSITE | Aggregation on inspection lot level |
Fields (12)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| InspCharAcceptedCount | InspCharAcceptedCount | 1 | |
| InspCharacteristicCount | InspCharacteristicCount | 1 | |
| InspCharLongTermOpenCount | InspCharLongTermOpenCount | 1 | |
| InspCharOpenCount | InspCharOpenCount | 1 | |
| InspCharRejectedCount | InspCharRejectedCount | 1 | |
| InspCharShortTermOpenCount | InspCharShortTermOpenCount | 1 | |
| InspOperationCount | InspOperationCount | 1 | |
| InspSubsetCharcAcceptedCount | InspSubsetCharcAcceptedCount | 1 | |
| InspSubsetCharcOpenCount | InspSubsetCharcOpenCount | 1 | |
| InspSubsetCharcRejectedCount | InspSubsetCharcRejectedCount | 1 | |
| NumberOfSkipInspCharcs | NumberOfSkipInspCharcs | 1 | |
| NumberOfSkipInspSubsetCharcs | NumberOfSkipInspSubsetCharcs | 1 |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view entity P_InspectionLotAggregate2 as select from I_InspOperationAggregate {
key I_InspOperationAggregate.InspectionLot,
sum(I_InspOperationAggregate.InspCharAcceptedCount) as InspCharAcceptedCount,
sum(I_InspOperationAggregate.InspCharacteristicCount) as InspCharacteristicCount,
sum(I_InspOperationAggregate.InspCharOpenCount) as InspCharOpenCount,
sum(I_InspOperationAggregate.InspCharRejectedCount) as InspCharRejectedCount,
sum(I_InspOperationAggregate.InspCharLongTermOpenCount) as InspCharLongTermOpenCount,
sum(I_InspOperationAggregate.InspCharShortTermOpenCount) as InspCharShortTermOpenCount,
sum(I_InspOperationAggregate.NumberOfSkipInspCharcs) as NumberOfSkipInspCharcs,
sum(I_InspOperationAggregate.InspSubsetCharcAcceptedCount) as InspSubsetCharcAcceptedCount,
sum(I_InspOperationAggregate.InspSubsetCharcRejectedCount) as InspSubsetCharcRejectedCount,
sum(I_InspOperationAggregate.InspSubsetCharcOpenCount) as InspSubsetCharcOpenCount,
sum(I_InspOperationAggregate.NumberOfSkipInspSubsetCharcs) as NumberOfSkipInspSubsetCharcs,
count( distinct I_InspOperationAggregate.InspPlanOperationInternalID) as InspOperationCount
}
group by InspectionLot