Data Purging Process in BW4HANA

[Valeti]

Hello Experts,

We have a requirement to purge the data in all adso's with retention period of 15 yrs.

For ADSO with time char, came across below option to design a solution for purging the data.

Option:

1. Create a config table with ADSO names, Time char and org units. Creating an org table to maintain its values( If available, Cocode, Plant)
2. Write an ABAP or AMDP program considering the above two tables data and system date for  deriving  period.
3. Maintaining a log table to track deletion of ADSO data.
4. Calling the program in Process chain to execute as a yearly activity.

Note: Stored procedure option is not preferred in our case as all jobs are scheduled in Process chains.

Could you please assist or help if above option is ok or is there any other better option available for better and efficient way. we have around 200 ADSOs to purge now.

Thanks,

Shyamala.

[roland_szajko]

Hi Shyamala

The manual manipulation of the data in BW Infoprovider tables is not supported. So having a program which practically does simply a DELETE FROM is problematic.
The official way of removing data selectively based on a time parameter from ADSO-s is one of these or their combination:

• Selective deletion (requires a date field in the ADSO which can be used to delete the data)
• Request Cleanup
  • Takes the date of the loading request
  • Can be used only for certain types of ADSO-s (clean up CL table or AQ table of inbound only ADSO or activate requests in cube like ADSO)
• In case you also have COLD store data to be deleted:
  • https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/adece7bde084468dbb0d20fa3b2cd...
  • https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/b912a621e66c4da3a0a577da178ba...

Also check:

3232938 [BW Central KBA] How-To: Data Management for BW Infoprovider tables

br

Roland

[SHYAMALA_V]

Hi Roland,

Thanks for your input.

We are performing house keeping activities  yearly to clean up the data in CL table.

However we must purge the historical data in Active table of ADSO as a part of compliance based on retention period. 

So, based on above suggestion, do we need to go for selective deletion for ACT table to drop the table for all ADSO's.

Thanks,

Shyamala.