...
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
| Note |
|---|
For the first-time deletion, it’s recommended to split the deletion process into a few parts, based on age. |
Automation of monitoring processes
...
Tables storing technical data can quickly grow and hence should be reduced regularly in order to optimize performance.
| Note |
|---|
For the first-time deletion, it’s recommended to split the deletion process into a few parts, based on age. |
Administration activity | Program | Interval / range | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Delete entries from table /PACG/ECM_MIDMAP - Mapping of the message ID to the idoc number | Program /PACG/ECM_DELETE_MIDMAP, transaction /PACG/ECM_DEL_MIDMAP - Delete table /PACG/ECM_MIDMAP | Entries can be deleted if older than the number of days set in /PACG/ECM_CPROP - General Properties of FSM Cloud Connector, field Unconf.IdocsAge. Learn more: https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/75464857/PACG+ECM+DEL+MIDMAP+-+Delete+table+PACG+ECM+MIDMAP#Execution-recommendations | |||||||||||
Delete entries from table /PACG/ECM_EOBREF - SAP -> external object reference | Program /PACG/ECM_DELETE_EOBREF, transaction /PACG/ECM_DEL_EOBREF - Delete table /PACG/ECM_EOBREF | Delete entries older than a year. | |||||||||||
Delete entries from table /PACG/ECM_MSIDIM - Incoming message mapping | Program /PACG/ECM_DELETE_MSIDIM, transaction /PACG/ECM_DEL_MSIDIM - Delete table /PACG/ECM_MSIDIM | Delete entries without error status after 2 days. | |||||||||||
Delete entries from table /PACG/ECM_ARMAT - E4C: Reseved Materials Stock | Program /PACG/ECM_DELETE_ARMAT, transaction /PACG/ECM_DEL_ARMAT - Delete table /PACG/ECM_ARMAT | Preferably, delete entries based on order status (relevant for business process completion). | |||||||||||
Delete FSM Logs | Program /PACG/ECM_FSMLGH_DELETE, transaction /PACG/ECM_LOG_DELETE - Delete FSM logs or SBAL_DELETE, transaction SLG2 - Application Log: Delete logs, depending on settings in /PACG/ECM_CUSLOG, field Log Type | Delete entries older than 3 months or according to your company rules for data retention | |||||||||||
Delete unneeded IDOCs (and idoc data for the Cockpit in table /PACG/ECM_CIDOCS)
| For idoc deletion, use WE11. Learn more: Deleting unneeded IDOCs For deletion of idoc data used by /PACG/ECM_COCKPIT - FSM Connector Cockpit, see program /PACG/ECM_DELETE_CIDOCS, transaction /PACG/ECM_DEL_CIDOCS - Delete table /PACG/ECM_CIDOCS | Delete entries older than 3 months or according to your company rules for data retention | |||||||||||
Delete entries from table /PACG/ECM_ALTEW - Not booked Time Effort and Work Time | Program /PACG/ECM_DELETE_ALTEW, transaction /PACG/ECM_DEL_ALTEW - Delete table /PACG/ECM_ALTEW | The table stores all inbound time efforts therefore can grow to significant size. Deletion frequency and criteria should depend on whether time efforts are updated in FSM after synchronization (see Time efforts updated in SAP FSM) and whether the functionality of parking is used (see /PACG/ECM_POST_TIMEF - Rebooking of not booked Work Time and Time Effort). | |||||||||||
Delete entries from table /PACG/ECM_CIDOCS - Cockpit relevant Idocs | Program /PACG/ECM_DELETE_CIDOCS, transaction /PACG/ECM_DEL_CIDOCS - Delete table /PACG/ECM_CIDOCS | Idoc data is written to this table during inbound/outbound idoc processing, so that it can be later used by /PACG/ECM_COCKPIT2 - FSM Connector Cockpit (new). Delete entries with the same interval as idocs. |
...