How to search activity by OrgData

[nisha_vinod]

Hello Experts,

In there any FM /report available to search activities that have sales org data or any FM to filter activities by org data?

Regards

Nisha

[Former Member]

Try using Function Module BAPI_BUSPROCESSND_GETLIST

The importing tables

SALES_ORG_SEL

DIS_CHANNEL_SEL

DIVISION_SEL

SALES_OFFICE_SEL

SALES_GROUP_SEL

can be used to seacrh activity based on OrgData

OBJECT_TYPE_SEL should be BUS2000126

[Former Member]

hi, if you need to develop a report to achieve this, this will be helpful

there is several tables you need to join to release this search:

crmd_order_h: this conclude the activity number, type and header guid

crmd_orgman:this conclude the org info of the document and item

crmd_link:you can combine the header guid and crmd_orgman through this table

set the join condition correctly, then you can achieve the search by one SELECT statement

[Former Member]

Hi Nisha,

Try the function module "CRM_BSP_OIC_1O_SEARCH_FROM_RF". you have to give the business object type as BUS2000126, the process type - relevant activity transaction type and the sales org / service org through the parameters - SALES_ORG_RESP or SERVICE_ORG_RESP respectively.

Put up a break point on the Function module, run a search in webui for activities giving some dummy parameters and you will understand how to call the FM.

Hope this helps.

Cheers,

Sid.

[Former Member]

Hello Nisha,

Use Function Module CRM_ORDER_READ & pass the activity numbers. You can find related Organization in Parameter ET_ORGMAN.

Regards,

Rajendra Sonawane

[nisha_vinod]

Hi Rajendra

I want to search for activities, so I dont have the set of activity no:'s with me, so I cannot actually use CRM_ORDER_READ.

Regards

Nisha

[former_member200342]

Hi Nisha,

You can use the standard transaction for Activity Monitor S_AE2_89000019 to find out the list of activities based on Sales org data.

In the selection field you can mention the sales org for which you want to search the activities.

Regards,

PP

[Former Member]

Hi Nisha,

Check this GUI based report:

AQZZ/SAPQUERY/SMCRM_REP_ACT1==

This is nothing but the action monitor report. This might be helpful to you. On UI, there i s no standard report for activities that comes from CRM. There are BI reports though.

Hope this helps.

Regds,

Raghu