Discounts
Technical name: 0RPA_MC03_Q0004
Use
This query provides an example for evaluating discounts on article sales on a monthly basis. When you execute the query, you can select according to store, merchandise category, promotion, reason for discount, and discount type. You must select a period of a month. All these characteristics are also available for navigation in the query.
Filters
InfoObject |
Description of the InfoObject (or Restriction or Calculation Formula) |
0CALMONTH |
Calendar year/month restricted to selection variable ‘Calendar Month’ (0CALMOSP) |
Free Characteristics
InfoObject |
Description |
0RT_LOCATIO |
Retail location with the optional selection option ‘Plant’ (0S_PLANT) |
0MATERIAL__0MATL_GROUP |
Merchandise category with the optional selection option ‘Merchandise Category’ (0S_MATG) |
0RT_PROMO |
Promotion with the optional selection option ‘Promotion’ (0S_AKTIO) |
0RPA_DRC |
Reason for discount with the optional selection option ‘Discount Reason’ (0RPADSCT) |
0RPA_DRG |
Discount Reason Group |
0RPA_DID |
Discount Identification |
0RPA_DTC |
Discount type with the optional selection option ‘Discount Type’ (0RPADSCR) |
0RPA_DTG |
Discount Type Group |
Rows
InfoObject |
Description of the InfoObject (or Restriction or Calculation Formula) |
0MATERIAL |
Material |
Columns
InfoObject |
Description of the InfoObject (or Restriction or Calculation Formula) |
0RPA_SAT |
Sales/Retail Value |
0RPA_RLQ |
Sales/Quantity (Sales Unit) |
0RPA_REA |
Discount Value |
0RPA_CCO |
Number of/Discount Items |