Campaigns Query

Query Query: /CRMBW/CRM_MC07_Q0001

This query provides you with an overview of campaigns in marketing. 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 Campaigns.

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.

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

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
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)

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Campaign ID	`/CRMBW/CAMPAIG`
Characteristic	Campaign Type	`/CRMBW/CAM_TYP`
Characteristic	Week (Follow-Up Created On)	`0CALWEEK`
Characteristic	Month (Follow-Up Created On)	`0CALMONTH`	Calendar Year (0CALYEAR) Valid From (0DATEFROM)
Characteristic	Quarter (Follow-Up Created On)	`0CALQUARTER`	Quarter (0CALQUART1)
Characteristic	Planned Start	`/CRMBW/STARTDA`
Characteristic	Planned End	`/CRMBW/EXPEND`
Characteristic	Follow-Up Created On	`/CRMBW/CREA_AT`
Characteristic	Status	`/CRMBW/STATUS0`
Characteristic	Employee Responsible	`/CRMBW/PERSON`
Characteristic	Approved	`/CRMBW/MKT_STA`
Characteristic	In Process	`/CRMBW/MKT_STP`
Characteristic	Locked	`/CRMBW/MKT_STL`

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	No. of Contacts	`/CRMBW/NUM_OUB`	—
Key Figure	No. of Leads	`/CRMBW/NUM_LEA`	—
Key Figure	No. of Opportunities	`/CRMBW/NUM_OPP`	—
Key Figure	No. of Responses	`/CRMBW/NUM_INB`	—