Channel Mgmt.: Top-n Lost Leads (Current Year) (SAP Library

Channel Mgmt.: Top-n Lost Leads (Current Year)

Technical Name: 0MKTG_C01_Q0101

Based on InfoCube: 0MKTG_C01(Lead Management)

Use

In a Channel ManagerPortal, this query provides an analysis of the leads lost by a Channel Manager over the past 12 months. Channel Managers can also view the leads lost by their Channel Partners.

In a Partner Portal, this query shows the top-n unsuccessful leads distributed by a Channel Manager to a Channel Partner. Partner Managers can see the lost leads of the Partner Employees over the year. Partner Employees can view their lost leads over the year.

Views created for this query:

View	Description
0MKTG_C01_Q0101_V001	Top n lost Leads
0MKTG_C01_Q0101_V003	Top n lost Leads (Partner)

Filter

InfoObject	Description
0BP_RESPPER__0USER_SYST	User Name System
0BP_RESPPER__0USER_NAME	User Name
0CALMONTH	Cal. Year/Month
0CRMSA_OG_R	Resp. Sales Org.
0CRM_SALESP	Sales partners

Free Characteristics

InfoObject	Description
0CALQUARTER	Cal. Year/Quarter
0CALMONTH	Cal. Year/Month
0CRM_SALESP__0CRM_CPTYPE	Channel Partner Type
0CRM_SALESP__0CRM_CPPROG	Channel Partner Prog
0CRM_SALOFF	Sales Office CRM
0CRM_SALGRP	CRM Sales Group
0CRM_OBJ_ID	Transaction Number
0CRM_LEAGUI__0CRM_LEATYP	Lead Cat.
0CRM_LEAGUI__0CRM_QUALEV	Qual.Level:Lead
0CRM_LEAGUI__0STAONESYS4	Status Lead
0CRM_LEAGUI_0CRM_LEADCR	Lead Creation Date
0CRM_LEAGUI_0CRM_0SOURCE	Origin Lead

Variables Used

Variable	Description
0P_USSYS	0P_USSYS
0P_USER	0P_USER
0CML12CM	Last 12 Months Including Current Month
0CRMOM (ORGEH, 000)	Org. Hierarchy Node For Users (ORGEH, 000)
0P_RS_ID	Reseller ID From Relationships

Rows

InfoObject	Description
0CRMSA_OG_R	Resp. Sales Org.
0CRM_SALESP	Sales partners

Columns

InfoObject	Description
0CRM_NUMDOC	No. of Leads
0MKTG_C01_RK001	Lost Leads
0CRM_LDOQV	Exp.OrderQty:SlsUnit
	Rate of Lost Leads
0CRM_DURLEA	Duration of Lead
0CRM_NUMCHL	Number of Changes in Qualification Level