Show TOC

Opportunity Sales Query Locate this document in the navigation structure

Query Query: /CRMBW/CRM_C04I_Q004

 

This query enables you to compare opportunities and sales orders in sales. 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 Opportunities/Sales Orders.

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

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

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

Opportunities and Sales Orders (OPPORT_SALES)

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)

Characteristic Characteristic

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Prospect/Sold-To Party

/CRMBW/COMPROS

Characteristic Characteristic

Territory

/CRMBW/TERRITO

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

Characteristic Characteristic

Country

/CRMBW/COUNTRY

Characteristic Characteristic

Region

/CRMBW/REGION

Characteristic Characteristic

Industry

/CRMBW/INDUSTR

Characteristic Characteristic

Date Opp./Sales Ord.

/CRMBW/COMDATE

Characteristic Characteristic

Week

0CALWEEK

Characteristic Characteristic

Month

0CALMONTH

Characteristic Characteristic

Quarter

0CALQUARTER

Characteristic Characteristic

Year

0CALYEAR

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

Characteristic Characteristic

Division

/CRMBW/DIVISIO

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

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

Channel Partner Type

/CRMBW/CP_TYPE

Characteristic Characteristic

Responsible Person at Partner

/CRMBW/RES_ATP

Characteristic Characteristic

Product

/CRMBW/PROD_GU

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

Characteristic Characteristic

Base Unit

/CRMBW/BASE_UN

Characteristic Characteristic

Status (Opportunity)

/CRMBW/OPP_STC
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

No. of Opportunities

/CRMBW/NUM_OF

—

Key Figure Key Figure

No. of Sales Orders

/CRMBW/NUM_SLO

—

Key Figure Key Figure

Product Quantity

/CRMBW/SLQ_QUA

—

Key Figure Key Figure

Product Quantity in Base Unit

/CRMBW/QUANBAS

—

Key Figure Key Figure

Product Value

/CRMBW/NET_VAL

—

Key Figure Key Figure

Product Value (Document Currency)

/CRMBW/PR_VAL_DC

—

Key Figure Key Figure

Net Value

/CRMBW/SO_NETV

—

Key Figure Key Figure

Net Value (Document Currency)

/CRMBW/SO_NETV_DC

—

Key Figure Key Figure

Gross Value

/CRMBW/GROSS_V

—

Key Figure Key Figure

Gross Value (Document Currency)

/CRMBW/GR_VAL_DC

—

Key Figure Key Figure

Expected Sales Volume (Document Currency)

/CRMBW/EXPREV

—

Key Figure Key Figure

Expected Sales Volume (Weighted, Document Currency)

/CRMBW/EXPREVW

—

Key Figure Key Figure

Expected Sales Volume

/CRMBW/EXPREVC

—

Key Figure Key Figure

Expected Sales Volume (Weighted)

/CRMBW/EXPRVWC

—

Key Figure Key Figure

Opportunity to Order Conversion Rate

/CRMBW/OPPTOSO

Number of opportunities with sales order as successor (/CRMBW/NUOPSUC) / number of opportunities (/CRMBW/NUM_OF) * 100

Key Figure Key Figure

No. of Opportunities with Sales Order as Successor

/CRMBW/NUOPSUC

—

Key Figure Key Figure

Weighted Prod. Value

/CRMBW/NETVALW

—

Key Figure Key Figure

Weighted Prod. Value (Document Currency)

/CRMBW/NETVALW_DC

—