Start of Content Area

Query Sales Volume Development for My Objects Year on Year  Locate the document in its SAP Library structure

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).

 

Caution 

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

User name

Usage: Determine the user who has logged on

0CYEAR

Current calendar year

Usage: Determine current year from today’s date

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

 

 

End of Content Area