PaPM - How to delete old data from Y tables

[jimmyk]

I run every month a writer function that add new records to a model table.

I would like to use a moving time window in order to erase the old data (after 24 months)

How can we do it with PaPM?

Thanks,

Jimmy

[emanuele_fumeo]

Hi Jimmy,

first of all, I think this might be a super risky task - please be very sure of what you are going to do. Moreover, please consider that SAP PaPM is not a data management solution but rather a calculation engine, therefore you should not use it to store data like in a data warehouse, but you should always write results to a target system.

Given that, you could check if a "selective" delete and insert of a writer function (where you only exploit the "delete" phase) could help you. You can find more information in the following blog post: https://blogs.sap.com/2020/09/28/papm-writer-delete-and-insert/

Hope it helps

KR,
Emanuele

[jimmyk]

Great, thanks a lot Emanuelle