Trend in Brand Shipments
Query: 0CP_SLSCA_Q0014
This query shows sales in the current fiscal year per brand. This query differentiates between sales from trade promotions and sales not from trade promotions.
Structure
| Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Fiscal Year Variant | 0FISCVARNT | restricted to 'K4' |
|
| Fiscal Year | 0FISCYEAR | restricted to 0FYEAR |
|
| Area | 0BP_GRP_A01 | ||
| Request ID | 0REQUID | restricted to 0S_RQMRC |
| Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Brand | 0CP_BRND |
without those with value # |
|
| Posting Period | 0FISCPER3 | restricted to 0P_PPER3 |
| Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Planned Volume | For more information about the structure, see Query Designer. |
||
| Actual Volume | For more information about the structure, see Query Designer. |
||
| Actual Promoted Volume | For more information about the structure, see Query Designer. |