Delete requests in PSA only between 1 and 10 days automatically

[former_member204345]

Hi experts,

in our company we face the following problem:

- every month data is loaded into PSA on the 1st and the 8th working-day. --> 2 or more requests with almost same data

- we would like to keep "old" data in PSA

- we would like to use a process chain for doing this.

I found a possibility of how to delete requests "older than x days" - but that´s too much of deletion!

Only requests of the last, say 10 days should be deleted.

Have you got an idea how tho solve this?

Thx a lot and all the best,

Thomas

[MGrob · Accepted solution]

Hi Thomas

At the same place where you found the delete older than x days you can also add a routine defining the deletion.  "Request deletion through routine" will help in your specific case.

Martin

[former_member204345 · Accepted solution]

Hi Martin,

is this possible for PSA as well? Only found it for infocubes up to now.

Danke,

Thomas

[Former Member]

Add   Process type “Deletion Of Request From PSA” in Process chain, in that you need to select the “Older Than(No of days/date). If you select Older than ‘0’ days so that all request older than current day will be deleted.

[former_member182196]

Hi,

If your data source support only full load then you can delete PSA request before a new load.

This option we used here to avoids data duplication while update the data target.

or

If your data source support delta load then with the help of "older than x days" option just provide 10 so automatically 10 days old psa request will be deleted from PSA.

Regards,

SM

[former_member182470]

When you enter 10 in "Older Than" in the process chain, it will delete all the requests till last 10th day. That means last 10 days requests from today will only be available in PSA.

How do you want to delete now? If you want to do some custom deletion, you need to create either custom process type or ABAP program to  delete requests from PSA tables. But this is tricky. Don't go for this. I suggest you to fix for some period and enter that No. of days in the process chain. This would be easy.

[former_member204345]

Hello Suman,

our idea was to delete only requests  newer than 10 days and keep all other requests older than 10 days.

This is possible with infocube, as Martin Grob suggested, but I couldn´t find it with PSA.

Thanks

Thomas

[RamanKorrapati]

Hi Thomas,

In your case its not possible.because you runs request 1st and 8th working day of the month. for next time your process chain runs on next month first working day.first to next month 1 date you may gap of 30days( or lesser but not 10days). if you give as 10 days then there is no request available to delete. if your doing daily loads then it will work.

Ex: Nov1st and 8th you loaded.

next you will run on dec 2nd(monday). here nov 8 to dec 2 , you will get gap of more than days .

Nov 1 - Dec 2 - 30days gap

Nov 8th - Dec 2 - 24 days, there is no request to delete older than 10days.

You need to rethink about your deletion conditions. other wise need to go with abap code.

Thanks

[RamanKorrapati]

Hi Thomas,

If your data source doesn't support delta then there is no use of having old PSA request. its leads duplication while loading to your target.

Other wise you can delete the PSA request before loading. for this we can use 0 days.

if its suits your needs you can 0 days. its delete psa request before loading.

Thanks