SPL Delta file upload purge process

[Former Member]

Please indicate how GTS tables are purged prior to running the SPL delta file upload batch.

[Former Member · Accepted solution]

Hi, I am not sure I understand your question,

The Tables do not need to be purged prior to uploading delta files, as changes will overwrite the existing Data. If you want to delete entries you need to follow the instructions as they where given to my by Chris Koniecny and that would be the following:

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.

Yet as I said you do not need to purge the data prior to every upload of delta files but you must know the following. Some Providers will give you delta files with entries of expired Sanction Parties with a validity date in the past so that you can upload delta files. Some will not do that and on their delta files, the expired parties are just not in anymore. With these you are obliged to load the full data set everytime and can not work with delta.

Hope that helps.