Sales Quotation Query

Query Query: /CRMBW/SLQ_C01_001

This query provides you with an overview of sales-relevant quotations. The query contains a full set of all characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Sales Quotations.

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.

This query is based on the InfoProvider /CRMBW/SLQ_C01.

To use this query, you must activate the business function SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB).

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Report Area	`/CRMBW/REPORTA`	Sales Quotation (SALESQUOTATION)
Characteristic	Application Server	`/CRMBW/APPLS`	Application server (/CRMBW/V_APPLS)
Characteristic	Logical System	`/CRMBW/LOGSYS`	Source system (/CRMBW/V_LOGSY)
Characteristic	Selection ID	`/CRMBW/SELID`	Selection ID (/CRMBW/V_SELID)
Characteristic	User Name	`/CRMBW/UNAME`	Current User (/CRMBW/V_UNAME)

Rows
Object Type	Name	Technical Name
Characteristic	Sales Quotation	`/CRMBW/SLQ_GUI`
Characteristic	Sales Quotation ID	`/CRMBW/SLQ_ID`
Characteristic	Responsible Sales Org. Unit	`/CRMBW/SLS_RES`
Characteristic	Sales Organization	`/CRMBW/SLS_ORG`
Characteristic	Distribution Channel	`/CRMBW/DIS_CHA`
Characteristic	Division	`/CRMBW/DIVISIO`
Characteristic	Employee Responsible	`/CRMBW/PERSON`
Characteristic	Territory	`/CRMBW/TERRITO`
Characteristic	Transaction Type	`/CRMBW/PROCESS`
Characteristic	Sold-To Party	`/CRMBW/SLO_STP`
Characteristic	Territory ID	`/CRMBW/TERR_ID`
Characteristic	Country	`/CRMBW/SOL_COU`
Characteristic	Region	`/CRMBW/SLQ_REG`
Characteristic	External Reference Number	`/CRMBW/PO_NUMB`
Characteristic	Channel Partner	`/CRMBW/CHA_PAR`
Characteristic	Channel Partner Program	`/CRMBW/CP_PROG`
Characteristic	Channel Partner Status	`/CRMBW/CP_STAT`
Characteristic	Responsible Person at Partner	`/CRMBW/RES_ATP`
Characteristic	Channel Partner Type	`/CRMBW/CP_TYPE`
Characteristic	Contact	`/CRMBW/CONTACT`
Characteristic	Week (Valid To)	`0CALWEEK`
Characteristic	Month (Valid To)	`0CALMONTH`
Characteristic	Quarter (Valid To)	`0CALQUARTER`
Characteristic	Year (Valid To)	`0CALYEAR`
Characteristic	Posting Date	`/CRMBW/POSTING`
Characteristic	Valid From	`/CRMBW/VALID_F`
Characteristic	Valid To	`/CRMBW/VALID_T`
Characteristic	Created On	`/CRMBW/CREA_AT`
Characteristic	Reference Date	`/CRMBW/REF_DAT`
Characteristic	Product	`/CRMBW/PROD_GU`
Characteristic	Product Category	`/CRMBW/PRO_CAT`
Characteristic	Product ID	`/CRMBW/PRODUCT`
Characteristic	Currency	`/CRMBW/CURNCY`
Characteristic	Status	`/CRMBW/QUO_STC`
Characteristic	Status: Credit Not OK	`/CRMBW/STAT_C0`
Characteristic	Status: Credit OK	`/CRMBW/STAT_CR`
Characteristic	Base Unit	`/CRMBW/BASE_UN`
Characteristic	Sales Unit	`/CRMBW/UNIT_PR`

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Average Net Value of Accepted Quotation Items	`/CRMBW/AVG_NV_AQI`	Net value of accepted quotation items (CRMBW_NVAQI) / number of accepted quotation items (CRMBW_NUAQ)
Key Figure	Avg. Net Value of Acc. Quotation Items (Document Currency)	`/CRMBW/AVG_NC_AQI_DC`	Net value of accepted quotation items in document currency / number of accepted quotation items
Key Figure	Net Value of Accepted Quotation Items (Document Currency)	`/CRMBW/NV_AQI_DC`	—
Key Figure	Net Value of Expired Quotation Items (Document Currency)	`/CRMBW/NV_EQI_DC`	—
Key Figure	Net Value of Open Quotation Items (Document Currency)	`/CRMBW/NV_OQI_DC`	—
Key Figure	Net Value of Rejected Quotation Items (Document Currency)	`/CRMBW/NV_RQI_DC`	—
Key Figure	Gross Value Quotation Items (Document Currency)	`/CRMBW/GR_QUOI_DC`	—
Key Figure	Average Net Value of Quotation Items (Document Currency)	`/CRMBW/ANV_QIT_DC`	Net value of quotation items in document currency (/CRMBW_W/NET_QDC) / number of quotation items (/CRMBW_NUMQIT)
Key Figure	Success Rate	`/CRMBW/SUCCRATE`	Net value of accepted quotation items / net value of quotation items (/CRMBW/NETQUO)
Key Figure	Average Net Value of Quotation Items	`/CRMBW/AVNETVALQIT`	Net value of quotation items / number of quotation items
Key Figure	Rate of Rejected Quotation Items	`CRMBW_RATEREQI`	Net value of rejected quotation items (CRMBW_NVRQI) / net value of quotation items * 100
Key Figure	Rate of Expired Quotation Items	`CRMBW_RATEEXQI`	Net value of expired quotation items (CRMBW_NVEQI) / net value of quotation items * 100
Key Figure	Rate of Open Quotation Items	`CRMBW_RATEOPQI`	Net value of open quotation items (CRMBW_NVOQI) / net value of quotation items * 100
Key Figure	Net Value Quotation Items (Document Currency)	`/CRMBW/NV_QUO_I_DC`	—
Key Figure	Order Quantity in Base Unit	`/CRMBW/QUANBAS`	—
Key Figure	Gross Value Quotation Items	`/CRMBW/GR_QUOI`	—
Key Figure	Net Value Quotation Items	`/CRMBW/NET_QUO`	—
Key Figure	No. of Quotation Items	`/CRMBW/NUM_QIT`	—
Key Figure	No. of Quotations	`/CRMBW/NUM_QUO`	—
Key Figure	Order Quantity	`/CRMBW/SLQ_QUA`	—
Key Figure	Net Value of Accepted Quotation Items	`CRMBW_NETVAQI`	—
Key Figure	Net Value of Expired Quotation Items	`CRMBW_NETVEQI`	—
Key Figure	Net Value of Open Quotation Items	`CRMBW_NETVOQI`	—
Key Figure	Net Value of Rejected Quotation Items	`CRMBW_NETRQI`	—
Key Figure	No. of Accepted Quotation Items	`CRMBW_NUMAQI`	—
Key Figure	No. of Expired Quotation Items	`CRMBW_NUMEQI`	—
Key Figure	No. of Open Quotation Items	`CRMBW_NUMOQI`	—
Key Figure	No. of Rejected Quotation Items	`CRMBW_NUMTRQI`	—