/
ZC_ExceptionAggregationQuery.abap
52 lines (52 loc) · 1.79 KB
/
ZC_ExceptionAggregationQuery.abap
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
@AbapCatalog.sqlViewName: 'ZCEXCAGGRQ'
@EndUserText.label: 'Exception Aggregation'
@VDM.viewType: #CONSUMPTION
@Analytics.query: true
define view ZC_ExceptionAggregationQuery
as select from ZI_ExceptionAggregationCube
{
@AnalyticsDetails.query.axis: #FREE
SalesDocument,
@AnalyticsDetails.query.axis: #FREE
SalesDocumentItem,
@AnalyticsDetails.query.axis: #FREE
SalesOrganization,
@AnalyticsDetails.query.axis: #FREE
DistributionChannel,
@AnalyticsDetails.query.axis: #FREE
Division,
@AnalyticsDetails.query.axis: #FREE
SoldToParty,
@AnalyticsDetails.query.axis: #FREE
Material,
@AnalyticsDetails.query.axis: #COLUMNS
@EndUserText.label: 'Sales Document Item Count'
@AnalyticsDetails: {
exceptionAggregationSteps: [
{ exceptionAggregationBehavior: #COUNT ,
exceptionAggregationElements: ['SalesDocument','SalesDocumentItem'] }
]
}
@AnalyticsDetails.query.formula: '1' 0 as SalesDocumentItemCount,
@AnalyticsDetails.query.axis: #COLUMNS
@EndUserText.label: 'Sales Document Count'
@AnalyticsDetails: {
exceptionAggregationSteps: [
{ exceptionAggregationBehavior: #COUNT,
exceptionAggregationElements: ['SalesDocument'] }
]
}
@AnalyticsDetails.query.formula: '1' 0 as SalesDocumentCount,
@AnalyticsDetails.query.axis: #COLUMNS
@AnalyticsDetails.query.decimals: 0
@EndUserText.label: 'Sales Document Avg by Sales Org'
@AnalyticsDetails: {
exceptionAggregationSteps: [
{ exceptionAggregationBehavior: #COUNT,
exceptionAggregationElements: ['SalesDocument'] },
{ exceptionAggregationBehavior: #AVG,
exceptionAggregationElements: ['SalesOrganization'] }
]
}
@AnalyticsDetails.query.formula: '1' 0 as SalesDocumentAvgBySalesOrg
}