Background:

  1. We often need to do selective deletion from any of the Info-providers including ODSO and Info-cubes. Often it is required to delete the data based on selections in a Process Chain.
  2. Also there are scenarios where the data is very huge and it takes huge amount of time in Selective deletion. But if we segregate the selections in small-small selections it takes lesser amount of time.


Solution:

  1. This Program can be used to do selective deletion and can be used with Variants in any of the Process Chains,
  2. We can choose to delete the data in a Loop and the program will delete data one by one. E.g. If selection given for CALMONTH 01.2012 to 12.2012, the program will delete the data in a loop first for 01.2012 then for 02.2012 till 12.2012.


Working of the Program:

Step 1: Execute the Program

/wp-content/uploads/2014/08/1_525686.png

Step 2: Enter the Info-provider info-cube or ODSO or select from F4 Help.

/wp-content/uploads/2014/08/2_525687.png

Step 3: Select the Info-Object for which you want to do selective deletion as the F4 help will give only Info-objects of the Info-provider entered

/wp-content/uploads/2014/08/3_525688.png

Step 4: Enter the values in the Selections

/wp-content/uploads/2014/08/4_525695.png

Step 5: Check the Perform Deletion in Loop checkbox only the first row for selections will be input ready all others will be greyed out

/wp-content/uploads/2014/08/5_525696.png

Step 6: If you now click on F4 Help you will only see the Time Characteristics for selections/wp-content/uploads/2014/08/6_525697.png

Step 7: Choose the Info-Object and enter selection values

/wp-content/uploads/2014/08/7_525698.png

Precautions while using the Program:

The program can be potentially delete data from any Info-Provider and should be used carefully. Authorization to execute the program should be given only to the selected users.

Source Code Attached:

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. AFM-BW AFM-BW

    Great !

    But the program does not generate logs for selective deletion, nor works on DSO objects… I made some changes to make it work for DSOs, but still no logs:(

    But this is really great !

    (0) 
  2. Praku Kns

    Yes, this works nice. But it won’t support for external type values we need to give internal values.

    for ex. for date 29.10.2014 we will have to give 20141029. this need to take it up.

    (0) 
  3. Prashanth konduru

    Really helpful share… Thanks for your effort.

    This can be used in some scenarios even though logs are not captured. Gr8 and keep posting…

    Have a good day 🙂

    Regards

    KP

    (0) 

Leave a Reply