Close old CRM Activities in batch

[former_member201157]

Hi Experts,

We have started data archiving for activities.

Based on some analysis , we identified that a large no of activities have been kept open in  the system (older than 4 years).

Now a prerequisite for archiving is that the activity status must be completed: I1005.

here is a screen shot from check program "CRM_ORDER_CHECK_STATUS" on one transaction type.

Business is ok with using an alternative solution to close old activities , without user intervention.

is there a method , or some batch job with which we can make the status of actvities to I1005 from (I1002)?

Has any one worked on such requirements?

Thanks & Regards,

Satya

[Former Member · Accepted solution]

You can use FM CRM_STATUS_CHANGE_INTERN_VB within simple coding. This function module add/change status in DB level. Therefore, you do not encounter any checks in BAdI's, etc.

Best Regards,

[former_member201157 · Accepted solution]

Hi Serkan,

Could you please tell me in which aspect you have used this FM?

was this something similar to the reqmnt to change status.

Thanks,

Satya

[former_member562530]

Hi Satya,

Have you evaluated the report "CRM_SET_STATUS_COMPLETED"?

You can try a copy of this one if necessary.

BR,

Gabriel Santana

[former_member201157]

Hi Gabriel,

Thanks for the quick response.

This report is for Sales orders and it cross checks for ECC status.

Is there something for activities?

Regards,

Satya

[former_member562530]

Hi Santya,

Yeah I knew that.

As I told you before, please consider create a new report using this mentioned one as a template, and removing unnecessary checks, e.g. cross check with ECC.

Regards,

Gabriel Santana