1.0 Introduction to Enterprise Data Archiving
Currently, a large number of enterprises use SAP R/3 as a platform for integration of business processes. The continuous usage of SAP results in huge amounts of enterprise data, which is stored in SAP R/3. With passage of time, the new and updated data is entered into the system while the old data still resides in the SAP enterprise system. Since some of the old data is critical, it cannot be deleted. The difficulty is keeping the data you want, and deleting the data you do not want. Hence, a SAP database keeps on expanding rapidly and enterprise systems, which have limited data retention abilities for a few years, suffer from problems such as data overflow, longer transaction processing times, and performance degradation. The solution of this problem has led to the concept of Data Archiving in SAP. Data Archiving removes out-of-date data from the SAP database that the R/3 system does not need online, but can be retrieved on a later date, if required. This data is known as archived data and is stored at an offline location. Data Archiving not only consistently removes data from the database but also ensures data availability for future business requirements.One rule of thumb is that in a typical SAP enterprise system, the ratio of data required to be online and instantly accessible to old data, which could be archived, and stored offline is 1:6. For example, if an enterprise has 2100 GB of SAP database, the online data, which is frequently used by SAP users will be 300 MB and the rest (1800 MB) will be scarcely used and hence can be archived.
1.1 Data Archiving – Features
- It provides a protection layer to the SAP database and resolves underperformance problems caused by huge volumes of data. It is important that SAP users should keep only minimal data to efficiently work with database and servers. Data archiving ensures that the SAP database contains only relevant and up-to-date data that meet your requirements.
- Data archiving uses hardware components such as hard disks and memory. For efficient data archiving, minimum number of disks and disk space should be used.
- It also reduces the system maintenance costs associated with the SAP database. In the SAP database there are various procedures such as, data backup, data recovery, and data upgrade.
- SAP data archiving complies with statutory data retention rules that are common and well-proven techniques.
1.2 Automotive warranty archiving description
Like standard t is possible to archive warranty claims with the standard transaction SARA for Warranty . The customer gets the possibility to write old warranty claims in an archive file, delete the claim from the online database and to display single archived claims.
1. Create a Claim
2. Call the mass change tool with Action TAR1 to set the archiving flag for this claims.-Transaction WTYMP-Run a Report to run a single action
3.Now if you go back to the claim, It will be in display mode only. Archival flag is set.
Transaction SARA object WTY_CLAIM or transaction WTY_SARA
1) Call transaction WTY_SARA (object WTY_CLAIM)
2)Select the Write Option
3)Create a new variant to put your selection criteria or use a existing variant
4)Set the Start Date as immediate and spool Parameter as ‘LOCL’
5)start the archiving run (with or without deletion)
6)Check the Message
7) Go to Job scheduling to see the status
8)Try to open the claim again in WTY Transaction and you’ll get the message
9) Call transaction WTY_ARCHIV to display single claims or claims per object and we can see the claim data again.