SPL Data Reset

[Former Member]

Hi,

We loaded SPL Data from one Dataprovider and now we are loading other lists from the same Data Provider. So now we would like to Delete all former list entryes (or at least make them inactive).

Does any one know how this is to be done?,

Thanks in advance for your Help,

Marc

[Former Member · Accepted solution]

If I understand the question correctly, you will have to archive the old SPL Master Data using the SPL_MD archiving object. This archiving object will allow you to create an archive of your current SPL Master Data (e.g. flat file) and then allow you to delete all data from the /SAPSLL/TSPL, /SAPSLL/TSPLA and /SAPSLL/TSPLN tables -- these tables are part of the SPL_MD archiving object. Once you have archived and deleted the prior SPL Master Data, you ought to be able to load the new SPL Master Data without any problems.

This method of course has pitfalls. If you're upgrading your SPL Master Data from the non-extended XML data to the extended XML data of the SPL entities, your audit trails will lose some details (e.g. which SPL entity matched on a specific business partner). Another pitfall is the amount of time it takes to rescreen all of the business partners against the new SPL Master Data. You may also encounter a large amount of blocked business partners as a result. My advice is to definitely test in a non-production environment.

[Former Member · Accepted solution]

Hi Chris,

Thanks a lot for the help. There is still some small issues but what you indicated seems to be the solution.

Thank you for your help.

Regards,

Marc