Show TOC

Interaction Records Query Locate this document in the navigation structure

Query Query: /CRMBW/CSAL_C01_Q0002

 

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).

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Report Area

/CRMBW/REPORTA

Interaction Records (INTERACTIONRECORD)

Characteristic Characteristic

Application Server

/CRMBW/APPLS

Application server (/CRMBW/V_APPLS)

Characteristic Characteristic

Logical System

/CRMBW/LOGSYS

Source system (/CRMBW/V_LOGSY)

Characteristic Characteristic

Selection ID

/CRMBW/SELID

Selection ID (/CRMBW/V_SELID)

Characteristic Characteristic

User Name

/CRMBW/UNAME

Current User (/CRMBW/V_UNAME)

Characteristic Characteristic

Private

/CRMBW/PRIVATE

No
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Interaction Record ID

/CRMBW/ACT_ID

Characteristic Characteristic

Day (End Date)

0CALDAY

Characteristic Characteristic

Week (End Date)

0CALWEEK

Characteristic Characteristic

Month (End Date)

0CALMONTH

Characteristic Characteristic

Quarter (End Date)

0CALQUARTER

Characteristic Characteristic

Year (End Date)

0CALYEAR

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

Characteristic Characteristic

Priority

/CRMBW/PRIORIT

Characteristic Characteristic

Contact

/CRMBW/CONTACT

Characteristic Characteristic

Category

/CRMBW/CATEGOR

Characteristic Characteristic

Account

/CRMBW/ACT_PAR

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

Characteristic Characteristic

Direction

/CRMBW/DIRECTI

Characteristic Characteristic

Status

/CRMBW/ACT_STC

Characteristic Characteristic

Category 1

/CRMBW/CATL11

Characteristic Characteristic

Category 2

/CRMBW/CATL21

Characteristic Characteristic

Category 3

/CRMBW/CATL31

Characteristic Characteristic

Category 4

/CRMBW/CATL41

Characteristic Characteristic

Campaign

/CRMBW/CAMPAIG

Filtering only
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Average Handling Time

/CRMBW/AVTIME

Total duration (/CRMBW/TW_DURA) / number of interaction records (/CRMBW/NUM_OF)

Key Figure Key Figure

No. of Interaction Records

/CRMBW/NUM_OF

—

Key Figure Key Figure

Total Duration

/CRMBW/TW_DURA

—