Show TOC

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

Query Query: /CRMBW/CRM_MCV1_Q0001

 

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

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

Selection GUID

/CRMBW/SELGUID

Technical filter that is generated at runtime

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Campaign ID

/CRMBW/CAMPAIG

SAP HANA Field: Campaign

Characteristic Characteristic

Campaign Type

/CRMBW/CAM_TYP

SAP HANA Field: CampaignType

Characteristic Characteristic

Week (Follow-Up Created On)

0CALWEEK

SAP HANA Field: CreationDateYearWeek

Characteristic Characteristic

Month (Follow-Up Created On)

0CALMONTH

Calendar Year (0CALYEAR)

Valid From (0DATEFROM)

SAP HANA Field: CreationDateYearMonth

Characteristic Characteristic

Quarter (Follow-Up Created On)

0CALQUARTER

Quarter (0CALQUART1)

SAP HANA Field: CreationDateYearQuarter

Characteristic Characteristic

Planned Start

/CRMBW/STARTDA

SAP HANA Field: PlannedStartDate

Characteristic Characteristic

Planned End

/CRMBW/EXPEND

SAP HANA Field: PlannedEndDate

Characteristic Characteristic

Follow-Up Created On

/CRMBW/CREA_AT

SAP HANA Field: CreationDate

Characteristic Characteristic

Status

/CRMBW/STATUS0

SAP HANA Field: Status

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA Field: ResponsibleEmployee

Characteristic Characteristic

Approved

/CRMBW/MKT_STA

SAP HANA Field: IsApproved

Characteristic Characteristic

In Process

/CRMBW/MKT_STP

SAP HANA Field: IsInProcess

Characteristic Characteristic

Locked

/CRMBW/MKT_STL

SAP HANA Field: IsLocked

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

No. of Contacts

/CRMBW/NUM_OUB

SAP HANA Field: CmpgnFollowUpNmbrOfOutbCtcts

Key Figure Key Figure

No. of Leads

/CRMBW/NUM_LEA

SAP HANA Field: CampaignFollowUpNumberOfLeads

Key Figure Key Figure

No. of Opportunities

/CRMBW/NUM_OPP

SAP HANA Field: CampaignFollowUpNumberOfOppty

Key Figure Key Figure

No. of Responses

/CRMBW/NUM_INB

SAP HANA Field: CmpgnFollowUpNmbrOfInbContacts