RSSOADRDUP: Deletes Duplicate Addresses from Address Management

The report RSSOADRDUP is used to deletes duplicate addresses from the address management that were created when sending, and reassigns the references to send requests to ensure a consistent state is maintained.

Purpose

Performance is becoming worse and worse when sending e-mails or faxes. This can occur in particular for certain recipient or sender addresses.

Selection

Fax Addresses
- The report deletes duplicate fax addresses.
E-Mail Addresses
- The report deletes duplicate e-mail addresses.
E-Mail Address or Fax
- You can enter a restriction here for the fax numbers or e-mail addresses to be checked, depending on your selection above.
Show All Deleted Records
- If you select this field, a list of all deleted duplicate addresses appears as output from the report. An address is described by its person number in address management. If the field is empty (default setting), only the number of deleted duplicate fax numbers and/or e-mail addresses is displayed.
Test Mode
- If this field is selected, no changes are made in the database, but the complete result of the report is output. If this field is not set, the deletions are performed. In online mode (but not in background processing), a confirmation prompt appears in this case.

Notes

Performance:
- You might have to create the following database indexes to run the report:
  - Table SOES, field ADRNR
  - Table SOMG, field RCP_ID_NO
Only duplicate entries that belong to direct addresses are deleted. These are always from the send/receive area. The addresses were, for example, entered directly on the send screen, or they are senders of inbound messages that do not have any other references in the system. They do not, for example, have addresses that belong to business partners.
Never manually delete entries from address management tables, since this leads to severe inconsistencies in address management. However, if this has happened, first execute the report contained in SAP Note 436119 to restore the deleted records (if possible) before running the report described here. Only then is it possible to delete the data consistently.