Channel Mgt.: Closed Activities 
Query: 0CSAL_C01_Q0103
This query provides you with information on activities which have been completed and also whether these were a success or a failure.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Channel Partners |
0CRMS_SALESP |
= 0P_RS_ID (Reseller ID from Relationships) |
| Activity Status |
0CRM_RG |
= ACT00003 = ACT00004 |
| Status |
=STAONESYS0 |
= 40 (Closed) |
Object Type | Name | Technical Name |
|---|---|---|
| Reason (Code) |
0CRM_RSN_CO |
| Reason (Code Group) |
0CRM_RSN_GR |
| Reason (Catalog) |
0CRM_RSN_TY |
| Reason |
0CRM_RCO |
| Current Code Group |
0CRM_RG |
| Current Category Reasons |
0CRM_RCA |
| Status |
0STAONESYS0 |
| Calendar Year/Month |
0CALMONTH |
| Calendar Year/Quarter |
0CALQUARTER |
| Calendar Day |
0CALDAY |
| Category |
0CRM_CAT |
| Channel Partner Program |
0CRM_SALESP__0CRM_CPPROG |
| Channel Partner Status |
0CRM_SALESP__0CRM_CPSTAT |
| Channel Partner Type |
0CRM_SALESP__0CRM_CPTYPE |
| Region of Channel Partner |
0CRM_SALESP__0REGION |
| Country of Channel Partner |
0CRM_SALESP__0COUNTRY |
| Channel Partners |
0CRM_SALESP |
| Region of Activity Partner |
0BP_ACTIVIT_0REGION |
| Country of Activity Partner |
0BP_ACTIVIT__0COUNTRY |
| Contact Partner |
0BP_ACTIVIT |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Target |
0CRM_OBJECT |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Number of Activities |
0CRM_NO_ACT |
— |
| Duration |
0CRM_DUR |
|
| Face to Face Duration |
0CRM_DURFTF |