Show TOC

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

Query Query: /CRMBW/CSAL_V01_Q0001

 

This query provides you with an overview of sales-relevant activities. The query contains characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Activities (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

Activities (ACTIVITIES_VDM)

Characteristic Characteristic

Selection GUID

/CRMBW/SELGUID

Technical filter that is generated at runtime
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Start Date

/CRMBW/STARTDA

SAP HANA VDM Field: StartDate

Characteristic Characteristic

End Date

/CRMBW/EXPEND

SAP HANA VDM Field: EndDate

Characteristic Characteristic

Calendar Year/Week

0CALWEEK

SAP HANA VDM Field: EndDateYearWeek

Characteristic Characteristic

Calendar Year/Month

0CALMONTH

SAP HANA VDM Field: EndDateYearMonth

Characteristic Characteristic

Calendar Year/Quarter

0CALQUARTER

SAP HANA VDM Field: EndDateYearQuarter

Characteristic Characteristic

Calendar Year

0CALYEAR

SAP HANA VDM Field: EndDateYear

Characteristic Characteristic

Status

/CRMBW/ACT_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Activity

/CRMBW/ACT_ID

SAP HANA VDM Field: CRMActivity

Characteristic Characteristic

Activity Type

/CRMBW/PROCESS

SAP HANA VDM Field: CRMBusinessTransactionType

Characteristic Characteristic

Territory

/CRMBW/TERRITO

SAP HANA VDM Field: TerritoryName

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

SAP HANA VDM Field: Territory

Characteristic Characteristic

Organizational Unit

/CRMBW/SLS_RES

SAP HANA VDM Field: ResponsibleSalesOrganization

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA VDM Field: ResponsibleEmployee

Characteristic Characteristic

Priority

/CRMBW/PRIORIT

SAP HANA VDM Field: CRMActivityPriority

Characteristic Characteristic

Direction

/CRMBW/DIRECTI

SAP HANA VDM Field: CRMActivityDirection

Characteristic Characteristic

Contact

/CRMBW/CONTACT

SAP HANA VDM Field: ContactPerson

Characteristic Characteristic

Category

/CRMBW/CATEGOR

SAP HANA VDM Field: CRMActivityCategory

Characteristic Characteristic

Account

/CRMBW/ACT_PAR

SAP HANA VDM Field: Account

Characteristic Characteristic

Channel Partner

/CRMBW/CHA_PAR

SAP HANA VDM Field: ChannelPartner

Characteristic Characteristic

Channel Partner Program

/CRMBW/CP_PROG

SAP HANA VDM Field: ChannelPartnerProgram

Characteristic Characteristic

Channel Partner Status

/CRMBW/CP_STAT

SAP HANA VDM Field: ChannelPartnerStatus

Characteristic Characteristic

Responsible Person at Partner

/CRMBW/RES_ATP

SAP HANA VDM Field: ResponsibleEmployeeAtPartner

Characteristic Characteristic

Channel Partner Type

/CRMBW/CP_TYPE

SAP HANA VDM Field: ChannelPartnerType
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

No. of Activities

/CRMBW/NUM_OF

SAP HANA VDM Field: NumberOfCRMActivities