Lead Query 
Query: /CRMBW/MKTG_C01_Q0001
This query provides you with an overview of leads 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 Leads
.
For information about the report areas in SAP CRM, see Report Areas for Interactive Reports.
This query is based on the InfoProvider /CRMBW/MKTG_C01.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Application Server |
/CRMBW/APPLS |
Application server (/CRMBW/V_APPLS) |
| Logical System |
/CRMBW/LOGSYS |
Source system (/CRMBW/V_LOGSY) |
| Selection ID |
/CRMBW/SELID |
Selection ID (/CRMBW/V_SELID) |
| User Name |
/CRMBW/UNAME |
Current User (/CRMBW/V_UNAME) |
CharacteristicObject Type | Name | Technical Name | Value Restriction / Calculation | Switch |
|---|---|---|---|---|
| Week (End Date) |
0CALWEEK |
Not relevant | |
| Month (End Date) |
0CALMONTH |
Not relevant | |
| Quarter (End Date) |
0CALQUARTER |
Not relevant | |
| Year (End Date) |
0CALYEAR |
Not relevant | |
| Start Date |
/CRMBW/STARTDA |
Not relevant | |
| End Date |
/CRMBW/EXPEND |
Not relevant | |
| Lead |
/CRMBW/LEA_ID |
Not relevant | |
| Lead Type |
/CRMBW/PROCESS |
Not relevant | |
| Lead Group |
/CRMBW/LEAD_TY |
Not relevant | |
| Origin |
/CRMBW/SOURCE |
Not relevant | |
| Prospect |
/CRMBW/PROSP |
Not relevant | |
| Qualification Level |
/CRMBW/QUAL_LE |
Not relevant | |
| Priority |
/CRMBW/IMPORTA |
Not relevant | |
| Status |
/CRMBW/LEA_STC |
Not relevant | |
| Territory |
/CRMBW/TERRITO |
Not relevant | |
| Territory ID |
/CRMBW/TERR_ID |
CRM_ANA_BOB |
|
| Organizational Unit |
/CRMBW/SLS_RES |
Not relevant | |
| Campaign ID |
/CRMBW/CAMPAIG |
Not relevant | |
| Employee Responsible |
/CRMBW/PERSON |
Not relevant |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| No. of Leads |
/CRMBW/NUM_OF |
— |
Key Figure