Title Reporting: Sales Curve
Technical name: 0ME_TLC04_Q0004
Use
This query is used as the basis for displaying sales quantities using a sales curve.
Various hierarchies can be accessed for the media issues selection, so that data can for instance be restricted to the business partner (e.g. the author) or the media product hierarchy (media product family, media product, media issue).
Filters
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
0COMP_CODE |
Company code Variable: Company code, (single value entry, required) (0P_COCD) |
0FISCVARNT |
Fiscal year variant Variable: Fiscal year variant (SAP exit) ( 0P_FVAEX) |
0VALUATION |
Valuation view Variable: Valuation layer (single value, optional) (0P_VALU) |
0VERSION |
Version There is no restriction to the version. |
0REC_TYPE |
Transaction type Variables: Transaction type (Default: 'B') (0P_REC_1) Transaction type (Default: ‘C') (0P_REC_2) Transaction type (Default: ‘D') (0P_REC_3) Transaction type (Default: ‘F') (0P_REC_4) |
0VTYPE |
Value type Restriction to fixed value: Actual value (10) |
0ME_MED_ISS__0ME_ID_CODE |
Identification code Variable: ID code (single value, optional) (0P_ISBN) |
0ME_MED_ISS__0ME_PUB_DAT |
Publication date Variable: Publication date (range, optional) (0I_PDAT3) |
0ME_MED_ISS__0ME_DELIVTY |
Answer code for request Variable: Answer code for request (selection option, optional) (0S_VMN1) |
0ME_MED_ISS |
Media issue Variables: Media issues hierarchy (0H_MEDBP) media issue (0H_MEDH2) |
Variables Used
Variable |
Description |
0P_COCD |
Company code (Single value entry, required) Usage: Selection variable |
0H_MEDBP |
Media issues hierarchy Usage: Selection variable for the media issues hierarchy |
0H_MEDH2 |
Media issue Usage: Selection variable for the media issues selection |
0I_PDAT3 |
Publication date (range, optional) Usage: Selection variable |
0SFYEAR |
Fiscal year single value, optional Usage: Selection variable |
0P_VALU |
Valuation view (single value, optional) Usage: Selection variable |
0P_DOCT5 |
Sales document type (order) (several single values) Usage: Determine restricted key figures |
0P_DOCT6 |
Sales document type (returns) (several single values) Usage: Determine restricted key figures |
0P_DOCT7 |
Sales document type (free copies) (several single values) Usage: Determine restricted key figures |
0P_FVAEX |
Fiscal year variant (SAP exit) Usage: Selection variable, determines the fiscal year variant in the background |
0P_REC_1 |
Transaction type (Default: 'B') Usage: Selection variable, restricted to fixed value, not available for input |
0P_REC_2 |
Transaction type (Default: 'C') Usage: Selection variable, restricted to fixed value, not available for input |
0P_REC_3 |
Transaction type (Default: 'D') Usage: Selection variable, restricted to fixed value, not available for input |
0P_REC_4 |
Transaction type (Default: 'F') Usage: Selection variable, restricted to fixed value, not available for input |
Adapt Reporting Variables for the Sales Document Type to Determine Restricted Key Figures
Restriction to sales document types (0DOC_TYPE) is necessary to ensure that individual key figures are determined correctly. To avoid having to make the entries for the sales document types several times on the selection screen, you can define default variables with fixed values for the respective sales document type and make the variables unavailable for input if necessary. The variable is then executed in the background with the default sales document type defined. Variables used:
· Sales document type (order) (several single values) (0P_DOCT5)
· Sales document type (returns) (several single values) (0P_DOCT6)
· Sales document type (free copies) (several single values) (0P_DOCT7)
Rows
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
0FISCYEAR |
Fiscal year Variable: Fiscal year single value, optional (0SFYEAR) |
0FISCPER3 |
Posting period |
Columns
InfoObject/ Key Figure |
Description of the InfoObject (and Restriction or Calculation Formula) |
0ME_TLC04_RK002 |
Copies returned Key figure is not displayed |
0ME_TLC04_CK003 |
Net Sales (Copies) |
Sales minus returns |
Formula: ‘Net Sales (Copies)’ – ABS ( ‘Copies Returned') |