Title Reporting: Sales/Revenue Analysis (Title)
Technical name: 0ME_TLC04_Q0007
Use
This query can be used to perform a sales analysis for one or more media issues and the title using a
sales/revenue evaluation
.
Various hierarchies can be accessed for the media issues and title selection, so that data for a media issue 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)
.
The Key Figure Scheme for Sales/Revenue Analysis (0ME_TLC4_QT003) is used to display the results.
Note
This query supports the
Do Not
Observe Price Fixing
scenario. The initial value used to calculate the value key figures within the key figure scheme used does not include a tax rate.
Queries in which the tax rate is not observed are used in scenarios in which no price fixing is available (price fixing can apply to books for instance).
Filters
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|---|---|
0COMP_CODE |
Company code Variable: Company code, (single value entry, required) (0P_COCD) |
0CURTYPE |
Currency type Variable: Currency type, (single value entry, required) (0P_CURRT) |
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) |
Free Characteristics
InfoObject |
Description |
|---|---|
0ME_MED_ISS |
Media issue Variables: Media issues hierarchy (0H_MEDBP) media issue (0H_MEDH2) Display attributes: Identification code (0ME_ID_CODE) Publication date (0ME_PUB_DAT) Answer code for request (0ME_DELIVTY) |
0IPM_TITLE |
Media title (IP) Variables: Title (0H_TTL04) Title hierarchy (0H_TTL03) Display attribute: Media title (ID) (0IPM_TTL_ID) |
Variables Used
Variable |
Description |
|---|---|
0P_COCD |
Company code (Single value entry, required) Usage: Selection variable |
0P_CURRT |
Currency type (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
Usage: Determine restricted key figures |
0P_DOCT6 |
Sales document type (returns
Usage: Determine restricted key figures |
0P_DOCT7 |
Sales document type (free copies
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 |
0H_TTL03 |
Title hierarchy Usage: Selection variable for selecting a title hierarchy |
0H_TTL04 |
Title Usage: Selection variable for selecting a title |
Note
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
The Key Figure Scheme for Sales/Revenue Analysis (0ME_TLC4_QT003) structure is used to display the key figures.
Structure |
Description of the Structure |
|---|---|
0ME_TLC4_QT003 |
Key figure scheme for sales/revenue analysis |
Columns
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|---|---|
0FISCYEAR |
Fiscal year Variable: Fiscal year single value, optional (0SFYEAR) |
0FISCPER3 |
Posting period |