Show TOC

New Opportunities by Quarter Locate this document in the navigation structure

Query Query: 0CRM_C04_Q3021

 

This query provides you with an overview of the number and sales volume of new opportunities per quarter over the last 8 quarters including the current quarter.

This query is based on the MultiProvider 0CRM_C04.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

User Name

0BP_RESPPER__0USER_NAME

User Name: 0P_USER

Characteristic Characteristic

System of User Name

0BP_RESPPER__0USER_SYST

System of User Name: 0P_USSYS

Characteristic Characteristic

Resp. Sales Org.

0CRMSA_OG_R

Determine Manager's Sales Organization: 0CXPMOM
Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

CRM Sales Org.

0CRM_SALORG

Characteristic Characteristic

Industry Code

0CRM_PROSPE__0IND_CODE

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Expected Revenue (Weighted Revenue in Reference Currrency)

0CRMREVEXPC

—

Key Figure Key Figure

Number of Opportunities

0CRM_NUMDOC

—
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Variable Variable

Current Quarter

&0T_CQUARTER&

Current quarter (0CQUART)

Variable Variable

Quarter 2 (Previous)

&0T_CQUARTER&

Current quarter minus 1

Variable Variable

Quarter 3 (Previous)

&0T_CQUARTER&

Current quarter minus 2

Variable Variable

Quarter 4 (Previous)

&0T_CQUARTER&

Current quarter minus 3

Variable Variable

Quarter 5 (Previous)

&0T_CQUARTER&

Current quarter minus 4

Variable Variable

Quarter 6 (Previous)

&0T_CQUARTER&

Current quarter minus 5

Variable Variable

Quarter 7 (Previous)

&0T_CQUARTER&

Current quarter minus 6

Variable Variable

Quarter 8 (Previous)

&0T_CQUARTER&

Current quarter minus 7