Opportunity Query (Max.) 
Query: /CRMBW/CRM_C04I_Q001
This query provides you with an overview of opportunities 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
.
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
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Report Area |
/CRMBW/REPORTA |
Opportunities (OPPORTUNITIES) |
| Application Server |
/CRMBW/APPLS |
Application server (/CRMBW/V_APPLS) |
| Logical System |
/CRMBW/LOGSYS |
Source system (/CRMBW/V_LOGSY) |
| Selection ID |
/CRMBW/SELID |
Selection ID (/CRMBW/V_SELID) |
| User Name |
/CRMBW/UNAME |
Current User (/CRMBW/V_UNAME) |
CharacteristicObject Type | Name | Technical Name | Value Restriction / Calculation | Switch |
|---|---|---|---|---|
| Analysis Phase |
/CRMBW/CNTRPH |
CRM_ANA_BOB |
|
| Sales Cycle |
/CRMBW/SLSCYC |
CRM_ANA_BOB |
|
| Sales Stage |
/CRMBW/CURR_PH |
Not relevant | |
| Sales Stage Since |
/CRMBW/PHASE_S |
Not relevant | |
| Competitor |
/CRMBW/COMPETI |
Not relevant | |
| Opportunity |
/CRMBW/OPP_ID |
Not relevant | |
| Opportunity Group |
/CRMBW/TYPE |
Not relevant | |
| Opportunity Type |
/CRMBW/PROCESS |
Not relevant | |
| Status |
/CRMBW/OPP_STC |
Not relevant | |
| Reason |
/CRMBW/CODEC |
Not relevant | |
| Territory |
/CRMBW/TERRITO |
Not relevant | |
| Territory ID |
/CRMBW/TERR_ID |
CRM_ANA_BOB |
|
| Country |
/CRMBW/COUNTRY |
Not relevant | |
| Region |
/CRMBW/REGION |
Not relevant | |
| Organizational Unit |
/CRMBW/SLS_RES |
Not relevant | |
| Employee Responsible |
/CRMBW/PERSON |
Not relevant | |
| Closing Date |
/CRMBW/EXPEND |
Not relevant | |
| Industry |
/CRMBW/INDUSTR |
Not relevant | |
| Origin |
/CRMBW/SOURCE |
Not relevant | |
| Priority |
/CRMBW/IMPORTA |
Not relevant | |
| Product |
/CRMBW/PROD_GU |
CRM_ANA_BOB |
|
| Product Category |
/CRMBW/PRO_CAT |
CRM_ANA_BOB |
|
| Product ID |
/CRMBW/PRODUCT |
Not relevant | |
| Prospect |
/CRMBW/PROSP |
Not relevant | |
| Rel. for Forecast |
/CRMBW/FORECAS |
Not relevant | |
| Start Date |
/CRMBW/STARTDA |
Not relevant | |
| Month (Closing Date) |
0CALMONTH |
Not relevant | |
| Quarter (Closing Date) |
0CALQUARTER |
Not relevant | |
| Year (Closing Date) |
0CALYEAR |
Not relevant | |
| Currency |
/CRMBW/CURNCY |
Not relevant | |
| Responsible Person at Partner |
/CRMBW/RES_ATP |
CRM_ANA_BOB |
|
| Channel Partner |
/CRMBW/CHA_PAR |
CRM_ANA_BOB |
|
| Channel Partner Program |
/CRMBW/CP_PROG |
CRM_ANA_BOB |
|
| Channel Partner Status |
/CRMBW/CP_STAT |
CRM_ANA_BOB |
|
| Channel Partner Type |
/CRMBW/CP_TYPE |
CRM_ANA_BOB |
Object Type | Name | Technical Name | Value Restriction / Calculation | Switch |
|---|---|---|---|---|
| Product Value (Document Currency) |
/CRMBW/NET_VAL_DC |
— |
CRM_ANA_BOB |
| Chance of Success % |
/CRMBW/PROBABI |
— |
Not relevant |
| Product Value |
/CRMBW/NET_VAL |
— |
Not relevant |
| No. of Items |
/CRMBW/N_ITEM |
— |
CRM_ANA_BOB |
| Conversion Rate: Opportunity to Order |
/CRMBW/OPPTOSLO |
Number of opportunities with sales order as successor (/CRMBW/NUOPSUC) / number of opportunities (/CRMBW/NUM_OF) * 100 |
CRM_ANA_BOB |
| No. of Opportunities |
/CRMBW/NUM_OF |
— |
Not relevant |
| Expected Sales Volume (Document Currency) |
/CRMBW/EXPREV |
— |
Not relevant |
| Expected Sales Volume (Weighted, Document Currency) |
/CRMBW/EXPREVW |
— |
Not relevant |
| Expected Sales Volume |
/CRMBW/EXPREVC |
— |
Not relevant |
| Expected Sales Volume (Weighted) |
/CRMBW/EXPRVWC |
— |
Not relevant |
| No. of Opportunities with Sales Order as Successor |
/CRMBW/NUOPSUC |
— |
Not relevant |
| Product Quantity in Base Unit |
/CRMBW/QUANBAS |
— |
CRM_ANA_BOB |
| % Expected Sales Volume of all Opportunities |
CRMBW_PEXPRVI |
Not relevant | |
| % No. of all Opportunities |
CRMBW_PEXPRVT |
— |
Not relevant |
| Product Quantity |
/CRMBW/SLQ_QUA |
— |
CRM_ANA_BOB |
Key Figure