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
).
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Report Area |
/CRMBW/REPORTA |
Opportunities (OPPORTUNITIES) |
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) |
Object Type | Name | Technical Name | Value Restriction / Calculation | Switch |
---|---|---|---|---|
Characteristic | Analysis Phase |
/CRMBW/CNTRPH |
CRM_ANA_BOB |
|
Characteristic | Sales Cycle |
/CRMBW/SLSCYC |
CRM_ANA_BOB |
|
Characteristic | Sales Stage |
/CRMBW/CURR_PH |
Not relevant | |
Characteristic | Sales Stage Since |
/CRMBW/PHASE_S |
Not relevant | |
Characteristic | Competitor |
/CRMBW/COMPETI |
Not relevant | |
Characteristic | Opportunity |
/CRMBW/OPP_ID |
Not relevant | |
Characteristic | Opportunity Group |
/CRMBW/TYPE |
Not relevant | |
Characteristic | Opportunity Type |
/CRMBW/PROCESS |
Not relevant | |
Characteristic | Status |
/CRMBW/OPP_STC |
Not relevant | |
Characteristic | Reason |
/CRMBW/CODEC |
Not relevant | |
Characteristic | Territory |
/CRMBW/TERRITO |
Not relevant | |
Characteristic | Territory ID |
/CRMBW/TERR_ID |
CRM_ANA_BOB |
|
Characteristic | Country |
/CRMBW/COUNTRY |
Not relevant | |
Characteristic | Region |
/CRMBW/REGION |
Not relevant | |
Characteristic | Organizational Unit |
/CRMBW/SLS_RES |
Not relevant | |
Characteristic | Employee Responsible |
/CRMBW/PERSON |
Not relevant | |
Characteristic | Closing Date |
/CRMBW/EXPEND |
Not relevant | |
Characteristic | Industry |
/CRMBW/INDUSTR |
Not relevant | |
Characteristic | Origin |
/CRMBW/SOURCE |
Not relevant | |
Characteristic | Priority |
/CRMBW/IMPORTA |
Not relevant | |
Characteristic | Product |
/CRMBW/PROD_GU |
CRM_ANA_BOB |
|
Characteristic | Product Category |
/CRMBW/PRO_CAT |
CRM_ANA_BOB |
|
Characteristic | Product ID |
/CRMBW/PRODUCT |
Not relevant | |
Characteristic | Prospect |
/CRMBW/PROSP |
Not relevant | |
Characteristic | Rel. for Forecast |
/CRMBW/FORECAS |
Not relevant | |
Characteristic | Start Date |
/CRMBW/STARTDA |
Not relevant | |
Characteristic | Month (Closing Date) |
0CALMONTH |
Not relevant | |
Characteristic | Quarter (Closing Date) |
0CALQUARTER |
Not relevant | |
Characteristic | Year (Closing Date) |
0CALYEAR |
Not relevant | |
Characteristic | Currency |
/CRMBW/CURNCY |
Not relevant | |
Characteristic | Responsible Person at Partner |
/CRMBW/RES_ATP |
CRM_ANA_BOB |
|
Characteristic | Channel Partner |
/CRMBW/CHA_PAR |
CRM_ANA_BOB |
|
Characteristic | Channel Partner Program |
/CRMBW/CP_PROG |
CRM_ANA_BOB |
|
Characteristic | Channel Partner Status |
/CRMBW/CP_STAT |
CRM_ANA_BOB |
|
Characteristic | Channel Partner Type |
/CRMBW/CP_TYPE |
CRM_ANA_BOB |
Object Type | Name | Technical Name | Value Restriction / Calculation | Switch |
---|---|---|---|---|
Key Figure | Product Value (Document Currency) |
/CRMBW/NET_VAL_DC |
— |
CRM_ANA_BOB |
Key Figure | Chance of Success % |
/CRMBW/PROBABI |
— |
Not relevant |
Key Figure | Product Value |
/CRMBW/NET_VAL |
— |
Not relevant |
Key Figure | No. of Items |
/CRMBW/N_ITEM |
— |
CRM_ANA_BOB |
Key Figure | 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 |
Key Figure | No. of Opportunities |
/CRMBW/NUM_OF |
— |
Not relevant |
Key Figure | Expected Sales Volume (Document Currency) |
/CRMBW/EXPREV |
— |
Not relevant |
Key Figure | Expected Sales Volume (Weighted, Document Currency) |
/CRMBW/EXPREVW |
— |
Not relevant |
Key Figure | Expected Sales Volume |
/CRMBW/EXPREVC |
— |
Not relevant |
Key Figure | Expected Sales Volume (Weighted) |
/CRMBW/EXPRVWC |
— |
Not relevant |
Key Figure | No. of Opportunities with Sales Order as Successor |
/CRMBW/NUOPSUC |
— |
Not relevant |
Key Figure | Product Quantity in Base Unit |
/CRMBW/QUANBAS |
— |
CRM_ANA_BOB |
Key Figure | % Expected Sales Volume of all Opportunities |
CRMBW_PEXPRVI |
Not relevant | |
Key Figure | % No. of all Opportunities |
CRMBW_PEXPRVT |
— |
Not relevant |
Key Figure | Product Quantity |
/CRMBW/SLQ_QUA |
— |
CRM_ANA_BOB |