Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Delete entries from table /PACG/ECM_MSIDM - Incoming message mapping in order to optimize system performance.

Table of Contents

Purpose of the affected table

Table /PACG/ECM_MSIDIM is used for storing messages from inbound processing​.

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.

Info

For the first-time deletion, it’s recommended to split the deletion process into a few parts, based on age.