Show TOC

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

Query Query: /CRMBW/MKTG_V01_Q0001

 

This query provides you with an overview of leads 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 Leads (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/MKTG_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

Selection GUID

/CRMBW/SELGUID

Technical filter that is generated at runtime
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Has Errors

/CRMBW/HAS_ERR

SAP HANA VDM Field: HasError

Characteristic Characteristic

Calendar Year/Week (End Date)

0CALWEEK

SAP HANA VDM Field: EndDateYearWeek

Characteristic Characteristic

Calendar Year/Month (End Date)

0CALMONTH

SAP HANA VDM Field: EndDateYearMonth

Characteristic Characteristic

Calendar Year/Quarter (End Date)

0CALQUARTER

SAP HANA VDM Field: EndDateYearQuarter

Characteristic Characteristic

Calendar Year (End Date)

0CALYEAR

SAP HANA VDM Field: EndDateYear

Characteristic Characteristic

Start Date

/CRMBW/STARTDA

SAP HANA VDM Field: StartDate

Characteristic Characteristic

End Date

/CRMBW/EXPEND

SAP HANA VDM Field: EndDate

Characteristic Characteristic

Lead

/CRMBW/LEA_ID

SAP HANA VDM Field: Lead

Characteristic Characteristic

Lead Type

/CRMBW/PROCESS

SAP HANA VDM Field: CRMBusinessTransactionType

Characteristic Characteristic

Lead Group

/CRMBW/LEAD_TY

SAP HANA VDM Field: LeadGroup

Characteristic Characteristic

Origin

/CRMBW/SOURCE

SAP HANA VDM Field: LeadOrigin

Characteristic Characteristic

Prospect

/CRMBW/PROSP

SAP HANA VDM Field: Prospect

Characteristic Characteristic

Qualification Level

/CRMBW/QUAL_LE

SAP HANA VDM Field: LeadQualificationLevel

Characteristic Characteristic

Priority

/CRMBW/IMPORTA

SAP HANA VDM Field: LeadPriority

Characteristic Characteristic

Status

/CRMBW/LEA_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Territory

/CRMBW/TERRITO

SAP HANA VDM Field: Territory

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

Campaign ID

/CRMBW/CAMPAIG

SAP HANA VDM Field: Campaign

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA VDM Field: ResponsibleEmployee
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

No. of Leads

/CRMBW/NUM_OF

SAP HANA VDM Field: NumberOfLeads

Key Figure Key Figure

Lead Duration

CRMBW_AVG_LEA_DUR

Lead Duration (/CRMBW/LEA_DUR) / Number of Leads (/CRMBW/NUM_OF)

Key Figure Key Figure

Conversion Rate: Leads to Opportunities: Conversion Rate

CRMBW_LTO_O

Conversion Rate: Lead Follow Up: Opportunities (/CRMBW/LTO_O) % Number of Leads (/CRMBW/NUM_OF)

Key Figure Key Figure

Conversion Rate: Leads to Won Opportunities: Conversion Rate

CRMBW_LTO_WO

Conversion Rate: Lead Follow Up: Won Opportunities (/CRMBW/LTO_O) % Number of Leads (/CRMBW/NUM_OF)