Introduction
Remove activities from SAP ECC/S4 and send deletion requests to SAP FSM for all activities:
whose status is ‘5’ (closed)
which fit in the selection criteria
which are closed (i.e. last modified) since the specified number of days (field ‘Older than in days’)
Deletion requests are sent in packages of 50 and only for objects which have not already been deleted.
Primarily the ‘changed on’ date (AEDAT) in table /PACG/ECM_ACTI is used to calculate which objects are relevant for deletion. If no ‘changed on’ date is found for an object, ‘created on’ date (ERDAT) is used instead.
Affected tables
The activity data will be removed from the following SAP ECC/S4 tables:
/PACG/ECM_ACTI – E4C Activity
/PACG/ECM_ACTSP - E4C: Support Persons for Activity object
/PACG/ECM_ACTRE - E4C: Internal Remarks for Activity object
/PACG/ECM_ACTIR - E4C Activity reference
Additionally, attachments and attachment references will be removed from SAP and SAP FSM, unless the selection screen field ‘Delete attachments’ is unchecked.
All deleted objects are added to table /PACG/ECM_OBJDEL after deletion request had been sent and they will be omitted in future executions of this transaction.
Process overview
By default, after filling selection screen data and executing, a list of all objects relevant for deletion will be displayed. The list allows the user to additionally filter the objects and finally confirm which objects are relevant for deletion.
Successful deletion is confirmed by logs.
To skip the confirmation screen and perform the deletion process right away, check the ‘Delete without confirmation’ field.
Object deletion request is sent in idocs of type /PACG/ECM_ITYPE_OPERATION.
Activity archiving
Alternatively, Activities can be archived instead of deleted. This provided the possibility of restore. Learn more: Custom Data Archiving - E4C activities