Average Sales Cycle - SAP Documentation

Average Sales Cycle

Query Query: 0CRM_C04_Q3030

This query provides you with an overview of the average sales cycle duration and the closing rate of opportunities for each quarter over the last 8 quarters.

This query is based on the MultiProvider 0CRM_C04.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	User Name	`0BP_RESPPER__0USER_NAME`	User Name: 0P_USER
Characteristic	System of User Name	`0BP_RESPPER__0USER_SYST`	System of User Name: 0P_USSYS
Characteristic	Resp. Sales Org.	`0CRMSA_OG_R`	Determine Manager's Sales Organization: 0CXPMOM

Free Characteristics
Object Type	Name	Technical Name
Characteristic	CRM Sales Org.	`0CRM_SALORG`
Characteristic	Industry Code	`0CRM_PROSPE__0IND_CODE`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	No. of Document Headers	`0CRM_NUMDOC`	—
Key Figure	Number of Closed Opportunities		Number of document headers with life cycle status Completed
Key Figure	Closure Rate		Number of closed opportunities / number of document headers
Key Figure	Closure Rate
Key Figure	Sales Cycle Length (Sum)		Opportunity closing date (0F_OPP_CLOSEDATE) minus opportunity start date (0F_OPP_STARTDATE) * number of document headers
Key Figure	Average Sales Cycle Length (Original)		Sales cycle length (sum) / number of document headers
Key Figure	Sales Cycle

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Variable	Current Quarter	`&0T_CQUARTER&`	Current quarter (0CQUART)
Variable	Quarter 2 (Previous)	`&0T_CQUARTER&`	Current quarter minus 1
Variable	Quarter 3 (Previous)	`&0T_CQUARTER&`	Current quarter minus 2
Variable	Quarter 4 (Previous)	`&0T_CQUARTER&`	Current quarter minus 3
Variable	Quarter 5 (Previous)	`&0T_CQUARTER&`	Current quarter minus 4
Variable	Quarter 6 (Previous)	`&0T_CQUARTER&`	Current quarter minus 5
Variable	Quarter 7 (Previous)	`&0T_CQUARTER&`	Current quarter minus 6
Variable	Quarter 8 (Previous)	`&0T_CQUARTER&`	Current quarter minus 7