How to delete request without data?

Former Member — Mon, 16 Mar 2015 07:21:04 GMT

Hey folks,

I want to delete all requests in DSO and InfoCube which do not contain any data..

Somethimes I have selective deletings which delete all data of a request (so there is no more data of it) or requests which did not transport any data (select but not inserted).

In my Housekeeping Process Chain I need something which deletes this kind of requests (completely deleted data in one request or requests which data is not inserted).

I don't care if this will be a regular step in my ProcessChain or a program I have to write myself. But I don't find anything to do this task.

Can you tell me a step or program to realize this request-deletion?

Thank you for your help.

Kind regards.

Matthias

Edit:

If it is possible to get a requestnumber by it's filtercriteria I could delete the request that way. But how would I get the requestnumber through filtercriteria and how do I delete a request by it's number?

Re: How to delete request without data?

Former Member — Tue, 17 Mar 2015 09:52:37 GMT

I found a way to get requests IDs by request selection criteria.

In table RSKBSELECT is for every request ID stored which criteria was given.

For example Request ID 123456 got selection on field "0calday" with low "01012010".

When you have all IDs you can get all entries RSSTATMANPART which contains this request IDs in Partnr. Additionally you should select on DTA (target). In this table is a field called RNR which contains the Requestnumber (e.g. DTP_123435456567). With this number you can call funtion RSSM_PROCESS_REQUDEL_CUBE which deletes requests based on given requestnumber.

topic How to delete request without data? in Application Development and Automation Discussions

How to delete request without data?

Re: How to delete request without data?