Sales Volume Development for My Objects
Year on Year
Technical name: 0IPM_C01_Q0036
Use
Query for displaying sales volume development for the license sales contract year ion year cumulated for all objects (such as the IP, rights characteristics).
This Query is personalized (“My …”). It only displays data where the Query user corresponds to the person responsible in the license sales contract. The name of the user who is logged on is transferred for data selection by means of the variable “User Name” (0P_USER).
This query is used as the basis for additional views (different views of the characteristics used) and Web templates (for the use of these views).
Do not change the query, since doing so means that the views become inactive and web templates cannot be executed. If adjustments are required, we advise you to make changes to a copy of the query.
Views based on the query:
● 0IPM_C01_Q0036_V001 Sales Volume Development for My Objects Year on Year
Filters
InfoObject |
Description of InfoObject (and restriction or calculation formula) |
0BP_RESPPER__0USER_NAME |
User name Restriction to: Variable 0P_USER |
Freely Defined Characteristics
InfoObject |
Description |
0CALMONTH2 |
Calendar month |
0CALYEAR |
Calendar year Restriction to: Variable 0CYEAR, 0CYEAR-1 |
Variables Used
Variable |
Description |
0P_USER |
|
0CYEAR |
|
0CYEAR-1 |
Previous year (current calendar year-1) Usage: Determine previous year from today’s date Current calendar year (0CYEAR) with use of an offset (-1) |
0T_CYEAR |
Text variable replaced by 0CYEAR Usage: Display date |
Lines
InfoObject |
Description of InfoObject (and restriction or calculation formula) |
0CALMONTH2 |
Calendar month |
Columns
InfoObject |
Description of InfoObject (and restriction or calculation formula) |
Net value CY (&0T_CYEAR&) |
Billed net value for current year Restriction to: 0IPM_C01_CK002 Net value 0CALYEAR Calendar year, used to select current calendar year, variable 0CYEAR |
Net value PY (&0T_CYEAR&) 2 |
Billed net value for previous year Restriction to: 0IPM_SALNET Billed net value 0CALYEAR Calendar year, used to select preceding calendar year, variable 0CYEAR |