My Team's Planned Activities (SAP Library - Customer Relationship Management)

My Team's Planned Activities

Technical Name: 0CSAL_C01_Q0013

Use

This query can be used by sales managers who need to gain a quick overview of activities in their sales team. It lists the overdue activities as well as completed activities by activity partner.

Note The views 0CSAL_C01_Q0013_V001 and 0CSAL_C01_Q0013_V002 have been designed for use in the Sales Manager Portal.

Filter

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0STAONESYS1	Status - planned
0BP_RESPPER_0USER_NAME Variable: 0P_USER	User name
0BP_RESPPER_0USER_SYST Variable: 0P_USSYS	Name of user's system

Free Characteristics

InfoObject	Description
0CALWEEK	Calendar week
0CALMONTH	Calendar month
0CALYEAR	Calendar year
0CRM_CAT	Activity category
0CRM_SA_OG_R Variable: 0CRMOM	Responsible sales organization
0CRM_CAT_0CRM_CLASS	Activity class

Rows

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0BP_ACTIVIT	Activity partner

Note Note that if you wish to link to this query using the report/report interface from the Sales, Activities and Opportunities; Numbers and Sales Volume query in the Sales Manager Portal, you must maintain the characteristics 0REGION and 0COUNTRY as free or main characteristics.

Columns

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0CRM_NO_ACT	Number of activities
Calculation formula: planned completion date is equal or higher than current date	In-time activities
Calculation formula: planned completion date is lower than current date	Overdue activities

Note For more information about the Sales Manager Portal, see the SAP Library under SAP Net Weaver ® mySAP Enterprise Portal ®Portal Content ®Content Catalog ®Specialist ®Sales ®Business Package for mySAP CRM 3.1 ®Solution for Sales Manager orSolution for Sales Representative.