Top Five Quotations 

Technical name: 0CRM_QUTO_Q0001

View name: Top Five Quotations (technical name:  0CRM_QUTO_Q0001_V0001)

Template name: Top Five Quotations (technical name: 0TPL_CRM_QUTO_Q0001)

 

Use

This query displays the five quotations with the highest total net value. The business transactions are grouped according to their sold-to party and displayed in descending order of their value, that is, the quotation with the highest total value at the top. It has been designed to provide an overview of forthcoming sales revenue.

View 0CRM_QUTO_Q0001_V0001 has been created for use in the role for sales representative. It displays the quotations in descending order, without grouping them by sold-to party.

Filter

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0STAONESYS0 Values: Open (10) and In processing (20)	Status
0BP_RESPPER_0USER_NAME Variable: 0P_USER	User Name
0BP_RESPPER_0USER_SYST Variable: 0P_USSYS	Name of User's System

 

Free Characteristics

InfoObject	Description
0CRM_SA_OG_R Variable: 0CRMOM	Responsible Sales Organization
0CRM_PROD	Product
0CRM_VALIDF	Start Date of Validity Period
0CRM_VALIDT	End Date of Validity Period
0CRM_OBJ_ID Variable TOPQUOT	Business transaction number

 

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0CRM_SOLDTO	Sold-to Party

 

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0NETVALORD	Quotation Value