Products with Highest No. of Service Requests 
Query: 0SRQ_C10_Q0007
This query provides you with an overview of the products with the highest number of service requests. The query contains a full set of all characteristics and key figures that are available for this analysis object. This makes this query especially suitable as a basis for SAP BusinessObjects enterprise server reports.
This query is based on the InfoProvider 0SRQ_C10.
By default, the results of the query are restricted to the top 10 products with the highest number of service requests. When starting the query you can change the number of query results as required, for example, to restrict the results to the top 5.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Responsible Sales Organization; Unit |
0CRMSA_OG_R |
Determine Manager's Sales Organization: 0CXPMOM |
| Status |
0STAONESYS0 |
— |
| User Name |
0BP_RESPPER__0USER_NAME |
User Name: 0P_USER |
| System of User Name |
0BP_RESPPER__0USER_SYST |
System of User Name: 0P_USSYS |
CharacteristicObject Type | Name | Technical Name |
|---|---|---|
| CRM Sales Group |
0CRM_SALGRP |
| Calendar Year |
0CALYEAR |
| Calendar Year/Month |
0CALMONTH |
| Cal. Year/Quarter |
0CALQUARTER |
| Calendar Year/Week |
0CALWEEK |
| Calendar Day |
0CALDAY |
| Responsible Sales Organzation; Unit |
0CRMSA_OG_R |
| Sales Organization |
0CRM_SALORG |
| Distribution Channel |
0DISTR_CHAN |
| Service Organization |
0CRM_SRVORG |
| Employee Responsible |
0BP_RESPPER |
| Business Transaction Type |
0CRM_PRCTYP |
| Transaction Number |
0CRM_OBJ_ID |
| Sold-To Party |
0CRM_SOLDTO |
| Country |
0CRM_SOLDTO__0COUNTRY |
| Region |
0CRM_SOLDTO__0REGION |
| Responsible Service Organization; Unit |
0CRMSE_OG_R |
| Service Team |
0CRM_SRV_TM |
| IBase Component |
0CRM_SRVGUI__0CRM_COMOTY |
| Status |
0STAONESYS0 |
| Recommended Priority |
0CRM_PRIO_R |
| Impact |
0CRM_IMPACT |
| Urgency |
0CRM_URGENC |
| Priority |
0CRM_PRIO_A |
| Communication Category |
0CRM_CAT |
| Product ID |
0CRM_REFPRI |
| Category C (Lvl 1) |
0CRMCCCAT_C__0CRMCCCAT01 |
| Category C (Lvl 2) |
0CRMCCCAT_C__0CRMCCCAT02 |
| Category C (Lvl 3) |
0CRMCCCAT_C__0CRMCCCAT03 |
| Category C (Lvl 4) |
0CRMCCCAT_C__0CRMCCCAT04 |
| Category D (Lvl 1) |
0CRMCCCAT_D__0CRMCCCAT01 |
| Category D (Lvl 2) |
0CRMCCCAT_D__0CRMCCCAT02 |
| Category D (Lvl 3) |
0CRMCCCAT_D__0CRMCCCAT03 |
| Category D (Lvl 4) |
0CRMCCCAT_D__0CRMCCCAT04 |
| Input Channel |
0CRM_INCHAN |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Reference Product |
0CRM_REFPRG |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| No. of Service Requests |
0CRM_INCI_N |
— |
Key Figure