SAP Mail Archiving

SAP Mail Archiving – Archive outgoing e-mails

How to unravel your database and create security

SAP Mail Archiving – when sending e-mails from the SAP system, the storage of the mails and their attachments is often carried out today via SAPOffice technology. The contents and attachments are stored in the SOFFCONT1 table by default. After a reorganization of this storage, access to the data stored there is no longer guaranteed. With regular use of this method, the database also grows rapidly in a short time. The storage of the data in the system database is expensive and expensive for today’s conditions. Relieving the database usually leads to significant cost savings.

SAP Mail Archiving – Investment list for an order

SAP Mail Archiving – Hit List of Filed Documents

Why e-mail archiving?

The advantages of mail archiving via ArchiveLink are obvious. Sap databases and system administration are relieved. The reduced database size does not only become interesting with the in-memory database HANA (keyword: document-free ERP). This is because less memory means significant savings in memory costs. In addition, existing installations benefit from a leaner database.

The ArchiveLink interface is a well-known and future-proof technology. The e-mails are stored as a whole via the ArchiveLink interface when sent. The maintainability of the SAP system is also improved and the reorganization of the SAPOffice table is considerably simplified. Simple, safe and without additional effort.

Which emails need to be archived?

In fact, about 90 of all ERP systems do exactly the opposite. The storage of the mails happens exactly via this table. The SAPOffice functions are often unknown in detail. As a result, the SOFFCONT1 table is in the top 10 of the largest tables in virtually every ERP system. By outsourcing the content to an HTTP Content Server as indicated 530792, you move parts of the content (the attachments). However, the mail texts remain in the SAP database. These texts could be moved separately to ArchiveLink via transaction SOY8. This means that they are stored separately from the attachments. All in all, a procedure that is used in practice almost nowhere.

The result in practice:
Mail texts are never archived. The audit security of the e-mail storage system is more than questionable, although of course there are various standards for daily e-mail traffic. In addition, the nature of the storage creates difficulties in maintenance and reorganization. In addition, the databases grow through SAPOffice objects. Performance difficulties arise for mail attachments on content servers. Ultimately, SAPOffice technology is a discontinued model that is no longer further developed by SAP AG.
What is the solution?

MailCenter Archiving for mails from SAP

With MailCenter Archiving, you archive outgoing e-mails directly via the well-known ArchiveLink interface. This means that the complete e-mail including attachments is completely available in the archive system. As a result, no data is stored permanently in the SAPOffice tables.