Show TOC

Sales Quotation Query Locate this document in the navigation structure

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 Characteristic

Report Area

/CRMBW/REPORTA

Sales Quotation (SALESQUOTATION)

Characteristic Characteristic

Application Server

/CRMBW/APPLS

Application server (/CRMBW/V_APPLS)

Characteristic Characteristic

Logical System

/CRMBW/LOGSYS

Source system (/CRMBW/V_LOGSY)

Characteristic Characteristic

Selection ID

/CRMBW/SELID

Selection ID (/CRMBW/V_SELID)

Characteristic Characteristic

User Name

/CRMBW/UNAME

Current User (/CRMBW/V_UNAME)
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Sales Quotation

/CRMBW/SLQ_GUI

Characteristic Characteristic

Sales Quotation ID

/CRMBW/SLQ_ID

Characteristic Characteristic

Responsible Sales Org. Unit

/CRMBW/SLS_RES

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

Characteristic Characteristic

Division

/CRMBW/DIVISIO

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

Characteristic Characteristic

Territory

/CRMBW/TERRITO

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

Characteristic Characteristic

Sold-To Party

/CRMBW/SLO_STP

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

Characteristic Characteristic

Country

/CRMBW/SOL_COU

Characteristic Characteristic

Region

/CRMBW/SLQ_REG

Characteristic Characteristic

External Reference Number

/CRMBW/PO_NUMB

Characteristic Characteristic

Channel Partner

/CRMBW/CHA_PAR

Characteristic Characteristic

Channel Partner Program

/CRMBW/CP_PROG

Characteristic Characteristic

Channel Partner Status

/CRMBW/CP_STAT

Characteristic Characteristic

Responsible Person at Partner

/CRMBW/RES_ATP

Characteristic Characteristic

Channel Partner Type

/CRMBW/CP_TYPE

Characteristic Characteristic

Contact

/CRMBW/CONTACT

Characteristic Characteristic

Week (Valid To)

0CALWEEK

Characteristic Characteristic

Month (Valid To)

0CALMONTH

Characteristic Characteristic

Quarter (Valid To)

0CALQUARTER

Characteristic Characteristic

Year (Valid To)

0CALYEAR

Characteristic Characteristic

Posting Date

/CRMBW/POSTING

Characteristic Characteristic

Valid From

/CRMBW/VALID_F

Characteristic Characteristic

Valid To

/CRMBW/VALID_T

Characteristic Characteristic

Created On

/CRMBW/CREA_AT

Characteristic Characteristic

Reference Date

/CRMBW/REF_DAT

Characteristic Characteristic

Product

/CRMBW/PROD_GU

Characteristic Characteristic

Product Category

/CRMBW/PRO_CAT

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

Characteristic Characteristic

Currency

/CRMBW/CURNCY

Characteristic Characteristic

Status

/CRMBW/QUO_STC

Characteristic Characteristic

Status: Credit Not OK

/CRMBW/STAT_C0

Characteristic Characteristic

Status: Credit OK

/CRMBW/STAT_CR

Characteristic Characteristic

Base Unit

/CRMBW/BASE_UN

Characteristic Characteristic

Sales Unit

/CRMBW/UNIT_PR
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure 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 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 Key Figure

Net Value of Accepted Quotation Items (Document Currency)

/CRMBW/NV_AQI_DC

—

Key Figure Key Figure

Net Value of Expired Quotation Items (Document Currency)

/CRMBW/NV_EQI_DC

—

Key Figure Key Figure

Net Value of Open Quotation Items (Document Currency)

/CRMBW/NV_OQI_DC

—

Key Figure Key Figure

Net Value of Rejected Quotation Items (Document Currency)

/CRMBW/NV_RQI_DC

—

Key Figure Key Figure

Gross Value Quotation Items (Document Currency)

/CRMBW/GR_QUOI_DC

—

Key Figure 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 Key Figure

Success Rate

/CRMBW/SUCCRAT

Net value of accepted quotation items / net value of quotation items (/CRMBW/NETQUO)

Key Figure Key Figure

Average Net Value of Quotation Items

/CRMBW/AVNETVALQIT

Net value of quotation items / number of quotation items

Key Figure 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 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 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 Key Figure

Net Value Quotation Items (Document Currency)

/CRMBW/NV_QUO_I_DC

—

Key Figure Key Figure

Order Quantity in Base Unit

/CRMBW/QUANBAS

—

Key Figure Key Figure

Gross Value Quotation Items

/CRMBW/GR_QUOI

—

Key Figure Key Figure

Net Value Quotation Items

/CRMBW/NET_QUO

—

Key Figure Key Figure

No. of Quotation Items

/CRMBW/NUM_QIT

—

Key Figure Key Figure

No. of Quotations

/CRMBW/NUM_QUO

—

Key Figure Key Figure

Order Quantity

/CRMBW/SLQ_QUA

—

Key Figure Key Figure

Net Value of Accepted Quotation Items

CRMBW_NETVAQI

—

Key Figure Key Figure

Net Value of Expired Quotation Items

CRMBW_NETVEQI

—

Key Figure Key Figure

Net Value of Open Quotation Items

CRMBW_NETVOQI

—

Key Figure Key Figure

Net Value of Rejected Quotation Items

CRMBW_NETRQI

—

Key Figure Key Figure

No. of Accepted Quotation Items

CRMBW_NUMAQI

—

Key Figure Key Figure

No. of Expired Quotation Items

CRMBW_NUMEQI

—

Key Figure Key Figure

No. of Open Quotation Items

CRMBW_NUMOQI

—

Key Figure Key Figure

No. of Rejected Quotation Items

CRMBW_NUMTRQI

—