Show TOC

Interaction Records Query (VDM-Based) Locate this document in the navigation structure

Query Query: /CRMBW/CSAL_V01_Q0002

 

This query provides you with an overview of sales-relevant interaction records. The query contains characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Interaction Records (Based on SAP HANA VDM).

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports Based on SAP HANA VDM

This query is based on the InfoProvider /CRMBW/CSAL_V01.

To use this query, you must activate the business functions SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB) and Interactive Reporting Based on SAP HANA VDM (CRM_ANA_VDM) .

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Report Area

/CRMBW/REPORTA

Interaction Record (INTERACTIONRECORD_VDM)

Characteristic Characteristic

Private

/CRMBW/PRIVATE

SAP HANA Field: IsPrivate

Characteristic Characteristic

Selection GUID

/CRMBW/SELGUID

Technical filter that is generated at runtime
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Interaction Record ID

/CRMBW/ACT_ID

SAP HANA Field: CRMActivity

Characteristic Characteristic

Day (End Date)

0CALDAY

SAP HANA Field: EndDate

Characteristic Characteristic

Calendar Year/Week (End Date)

0CALWEEK

SAP HANA Field: EndDateYearWeek

Characteristic Characteristic

Calendar Year/Month (End Date)

0CALMONTH

SAP HANA Field: EndDateYearMonth

Characteristic Characteristic

Calendar Year/Quarter (End Date)

0CALQUARTER

SAP HANA Field: EndDateYearQuarter

Characteristic Characteristic

Calendar Year (End Date)

0CALYEAR

SAP HANA Field: EndDateYear

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA Field: ResponsibleEmployee

Characteristic Characteristic

Priority

/CRMBW/PRIORIT

SAP HANA Field: CRMActivityPriority

Characteristic Characteristic

Contact Person

/CRMBW/CONTACT

SAP HANA Field: ContactPerson

Characteristic Characteristic

Category

/CRMBW/CATEGOR

SAP HANA Field: CRMActivityCategory

Characteristic Characteristic

Account

/CRMBW/ACT_PAR

SAP HANA Field: Account

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

SAP HANA Field: CRMBusinessTransactionType

Characteristic Characteristic

Direction

/CRMBW/DIRECTI

SAP HANA Field: CRMActivityDirection

Characteristic Characteristic

Status

/CRMBW/ACT_STC

SAP HANA Field: GeneralStatus

Characteristic Characteristic

Category 1

/CRMBW/CATL11

SAP HANA Field: ResponseCategory1UUID

Characteristic Characteristic

Category 2

/CRMBW/CATL21

SAP HANA Field: ResponseCategory2UUID

Characteristic Characteristic

Category 3

/CRMBW/CATL31

SAP HANA Field: ResponseCategory3UUID

Characteristic Characteristic

Category 4

/CRMBW/CATL41

SAP HANA Field: ResponseCategory4UUID

Characteristic Characteristic

Campaign

/CRMBW/CAMPAIG

SAP HANA Field: Campaign
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Average Handling Time

/CRMBW/AVTIME_VDM

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

Key Figure Key Figure

No. of Interaction Records

/CRMBW/NUM_OF

SAP HANA Field: NumberOfCRMActivities

Key Figure Key Figure

Total Duration

/CRMBW/TW_DURA

SAP HANA Field: CRMActivityDuration