Delete entries from table /PACG/ECM_MSIDM - Incoming message mapping.
Purpose of the affected table
Table /PACG/ECM_MSIDIM is used for storing messages from inbound processing.
Transaction GUID | FSM Company ID | Message ID | Cloud object GUID | Cloud message type | Message class | Message Type | Message Number | Message variable | Message variable | Message variable | Message variable | Inc. message status | Created on | Time | Created by |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
000TOukwL5hX0000h10o3m | 5016 | 861 | 6E50764F39554ED99359E3B7AEFCDCC4 | EQUIPMENT | /PACG/ECM_MAIN | I | 042 | 861 | 2 | 11.09.2022 | 13:00:04 | SMR |
Expected results after execution
Performance optimization.
Execution recommendations
The table is relatively big-sized. Execute the program periodically via a background job.
Without error status Message Status = 2 Idoc created | With error status Message Status = 1 Processing error |
|---|---|
Delete after 2 days | Entries with processing errors should not be deleted, as failed inbound IDOCs exist. If there is a maximum timeframe for inbound messages in error status, where they won’t be handled anymore, entries in this message status can be deleted. |
For the first-time deletion, it’s recommended to split the deletion process into a few parts, based on age.