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
).
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Report Area |
/CRMBW/REPORTA |
Opportunities and Sales Orders (OPPORT_SALES) |
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) |
Characteristic |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Prospect/Sold-To Party |
/CRMBW/COMPROS |
|
Characteristic | Territory |
/CRMBW/TERRITO |
|
Characteristic | Territory ID |
/CRMBW/TERR_ID |
|
Characteristic | Country |
/CRMBW/COUNTRY |
|
Characteristic | Region |
/CRMBW/REGION |
|
Characteristic | Industry |
/CRMBW/INDUSTR |
|
Characteristic | Date Opp./Sales Ord. |
/CRMBW/COMDATE |
|
Characteristic | Week |
0CALWEEK |
|
Characteristic | Month |
0CALMONTH |
|
Characteristic | Quarter |
0CALQUARTER |
|
Characteristic | Year |
0CALYEAR |
|
Characteristic | Employee Responsible |
/CRMBW/PERSON |
|
Characteristic | Sales Organization |
/CRMBW/SLS_ORG |
|
Characteristic | Division |
/CRMBW/DIVISIO |
|
Characteristic | Distribution Channel |
/CRMBW/DIS_CHA |
|
Characteristic | Channel Partner |
/CRMBW/CHA_PAR |
|
Characteristic | Channel Partner Program |
/CRMBW/CP_PROG |
|
Characteristic | Channel Partner Status |
/CRMBW/CP_STAT |
|
Characteristic | Channel Partner Type |
/CRMBW/CP_TYPE |
|
Characteristic | Responsible Person at Partner |
/CRMBW/RES_ATP |
|
Characteristic | Product |
/CRMBW/PROD_GU |
|
Characteristic | Product ID |
/CRMBW/PRODUCT |
|
Characteristic | Base Unit |
/CRMBW/BASE_UN |
|
Characteristic | Status (Opportunity) |
/CRMBW/OPP_STC |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | No. of Opportunities |
/CRMBW/NUM_OF |
— |
Key Figure | No. of Sales Orders |
/CRMBW/NUM_SLO |
— |
Key Figure | Product Quantity |
/CRMBW/SLQ_QUA |
— |
Key Figure | Product Quantity in Base Unit |
/CRMBW/QUANBAS |
— |
Key Figure | Product Value |
/CRMBW/NET_VAL |
— |
Key Figure | Product Value (Document Currency) |
/CRMBW/PR_VAL_DC |
— |
Key Figure | Net Value |
/CRMBW/SO_NETV |
— |
Key Figure | Net Value (Document Currency) |
/CRMBW/SO_NETV_DC |
— |
Key Figure | Gross Value |
/CRMBW/GROSS_V |
— |
Key Figure | Gross Value (Document Currency) |
/CRMBW/GR_VAL_DC |
— |
Key Figure | Expected Sales Volume (Document Currency) |
/CRMBW/EXPREV |
— |
Key Figure | Expected Sales Volume (Weighted, Document Currency) |
/CRMBW/EXPREVW |
— |
Key Figure | Expected Sales Volume |
/CRMBW/EXPREVC |
— |
Key Figure | Expected Sales Volume (Weighted) |
/CRMBW/EXPRVWC |
— |
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 | No. of Opportunities with Sales Order as Successor |
/CRMBW/NUOPSUC |
— |
Key Figure | Weighted Prod. Value |
/CRMBW/NETVALW |
— |
Key Figure | Weighted Prod. Value (Document Currency) |
/CRMBW/NETVALW_DC |
— |