This query provides you with an overview of sales-relevant interaction records. 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 Interaction Records
.
For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.
This query is based on the InfoProvider /CRMBW/CSAL_C01.
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 |
Interaction Records (INTERACTIONRECORD) |
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 | Private |
/CRMBW/PRIVATE |
No |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Interaction Record ID |
/CRMBW/ACT_ID |
|
Characteristic | Day (End Date) |
0CALDAY |
|
Characteristic | Week (End Date) |
0CALWEEK |
|
Characteristic | Month (End Date) |
0CALMONTH |
|
Characteristic | Quarter (End Date) |
0CALQUARTER |
|
Characteristic | Year (End Date) |
0CALYEAR |
|
Characteristic | Employee Responsible |
/CRMBW/PERSON |
|
Characteristic | Priority |
/CRMBW/PRIORIT |
|
Characteristic | Contact |
/CRMBW/CONTACT |
|
Characteristic | Category |
/CRMBW/CATEGOR |
|
Characteristic | Account |
/CRMBW/ACT_PAR |
|
Characteristic | Transaction Type |
/CRMBW/PROCESS |
|
Characteristic | Direction |
/CRMBW/DIRECTI |
|
Characteristic | Status |
/CRMBW/ACT_STC |
|
Characteristic | Category 1 |
/CRMBW/CATL11 |
|
Characteristic | Category 2 |
/CRMBW/CATL21 |
|
Characteristic | Category 3 |
/CRMBW/CATL31 |
|
Characteristic | Category 4 |
/CRMBW/CATL41 |
|
Characteristic | Campaign |
/CRMBW/CAMPAIG |
Filtering only |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Average Handling Time |
/CRMBW/AVTIME |
Total duration (/CRMBW/TW_DURA) / number of interaction records (/CRMBW/NUM_OF) |
Key Figure | No. of Interaction Records |
/CRMBW/NUM_OF |
— |
Key Figure | Total Duration |
/CRMBW/TW_DURA |
— |