cancel
Showing results for 
Search instead for 
Did you mean: 

How to archive COVP in S/4hana?

SAPSupport
Employee
Employee
0 Kudos

It's found that there're huge data volume in COVP in s/4hana, for example, more than 1 billion. This'll seriously impact the system performance, especially the data extraction of CO_OM datasources. It's needed to archive COVP. How to?


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.
View Entire Topic
SAPSupport
Employee
Employee
0 Kudos

Archiving a table in SAP S/4HANA is a series of systematic processes because data from sensitive tables like COVP cannot simply be deleted due to business and legal requirements. Here is the general archival process in SAP:

  1. Identify archiving objects: In this case, the archiving object is "CO_ITEM", which includes the COVP table.

  2. Set Archive Development Kit (ADK): This is a tool used for data archiving in SAP. Set it up as per your business requirements.

  3. Customizing: Ensure your system's customizing settings will allow data archiving. Use the transaction SPRO to perform the necessary customizing.

  4. Write phase: In this stage, data is selected and written to an archive file.

    Transaction Code: SARA or SARI Object Name: CO_ITEM Write

  5. Validation: This stage involves the re-checking of archived data.

  6. Delete phase: During this phase, the original data is deleted from the database.

    Transaction Code: SARA or SARI Object Name: CO_ITEM Delete

  7. Post Processing: This includes activities such as reorganizing the database, recovering the freed-up space, or resetting statistics.

Please note that you must check and ensure that you have a full, valid backup of your SAP system before you start the archiving process. Plus, it's also recommendable to verify the company's data retention requirements and also make necessary arrangements to access archived data in case it's needed in future.

Also, do keep in mind that COVP is a virtual table / cluster table that gets data from several other tables such as COEP, COBK etc. These tables have their own archiving objects and should be considered during archiving.