GTS BP clean up program performance

[Former Member]

Hi Friends,

We have around 2.6 million unwanted vendors in GTS and would like to delete them.

We are following the 2 step process.

1 We are first running running BUPA_DEL and it is successfully deleting the record from BUT000.

2 Then we ran program /SAPSLL/BP_DATA_CLEANUP to do clean up but it is showing below error.

Error in Step 2: Archive the listed objects manually /SAPSLL/SPLAUD.

Query 1: Is there any step which need to be done before running the clean up program which will remove entry from table /SAPSLL/SPLAUD?

In the interest of time, we created a deletion program to delete desired BPs from SPLAUD table and then we ran the clean up program mentioned in step 2 and it completed successfully.

Now, since we have 2.6 millions, we started doing this test for only 10K vendors.

Step 1 BUPA_DEL for 10K BPs as batch- Completed in 5 mins

Step 2 Run Custom program ZDEL_SPLAUD for 10 K BPs as batch- Completed in 20 mins

Step 3 Run clean up program /SAPSLL/BP_DATA_CLEANUP for 10 K BPs batch- Still running

It has been 3 days and still the step 3 job is running, I checked with the DBAs and as per them it is still doing backend processing.

Query 2: Is it OK to use a custom program to delete entries from SPLAUD(These are unwanted vendors so business is OK from AUDIT perspective to delete these entries)

Query 3 what can be done for performance on Clean up program as it will take ages to do this for 2.6 million vendors.

Your suggestion will be appreciated!

Regards,

Naveen Rajora

[shrinivas_hosmani]

Hi Naveen,

If you run the program /SAPSLL/BP_DATA_CLEANUP in simulation mode, it is supposed to show the details of which records can be/cannot be processed. You may want to try it.

The error you are referring to should occur only if GTS tables /SAPSLL/PNTBP (mapping table of BP) are not archived with CA_BUPA. Refer this note 2162902 - Unable to archive business partner with GTS specified content

On the order versions this issue used to occur due to inconsistent entries being present in table /SAPSLLPNTBP which didn't exist in BUT000. There must be a note around this as well. You may want to check if note is active for your version.

From a performance standpoint, you may want to check the below note which was released to improve the performance of the BP delete.

1788340 - Performance enhancement: /SAPSLL/BP_DATA_CLEANUP

Thanks,
Shrini