Report to display activities of individal sales persons

[Former Member]

Hi Experts,

My requirement is to display the list all activities of individal sales persons that has been made in the CRM system.

This report is to be used by the sales manager to review the all notes that have been made in the CRM system by each individual sales person.

The selection screen parameters has :

BP Type of Employee Responsible -

Employee (Mandatory)

Created Date (Mandatory)

Please let me know the FMs or tables to look into.

Please let me know how to go about it.

Regards,

Sangeeta.

[Former Member]

Hi Sangeeta,

Use Tcode: S_AE2_89000019.

Hope it'll resolve your query.

Regards,

Ankush

[Former Member]

Hello Sangeeta,

You need to write a small report/program which queries CRM table CRMD_ORDERADM_H for activities.

You can use field OBJECT_TYPE = 'BUS2000125' (task) and 'BUS2000126' (Business Activity),

which covers all CRM Online activities of all types.

You can additionally use fields CREATED_BY (or/and CHANGED_BY) to list down the activities

created /changed by that user.

So a simple select query will solve your purpose.

Hope this helps!

Thanks and Best Regards,

Shanthala Kudva.

[Former Member]

Hi,

Please let me know any FMs or BAPIs are there or not....

Regards,

Sangeeta.

[Former Member]

Hi Sangeeta,

You Can use FM--- CRM_ORDER_READ

Regards

Pavan.A

[Former Member]

Hello Sangeeta,

You can write your own program using the select query instead of using standard FM.

Once you have the query then you have to take care of only display logic in your report.

A very small program would do.

Thanks and Best Regards,

Shanthala Kudva.

[Former Member]

Hi Sangeeta,

You can use the CRM_ORDER_READ FM to get this or you can use BAPI_ACTIVITYDisplay BAPI to get the detailed information..

Also you can pass the 100+ records in one internal table and then pass the same to BAPI Guid Internal table.

Hope this helps