SPL - Mass check - MS Excel file

[Former Member]

Hello!

We have an Excel sheet with about 30.000 customers and delivery addresses. These must be checked against our SPL lists. How can we upload this data, and check it, keeping a protocol?

Advise is appreciated!

Thanks very much in advance!

t.

[Former Member]

You can use the Offline Screening functionnality, but to use it you have to transform the Excell file into the appropriate XML Format for GTS.

Marc

[Former Member]

Hello Marc

yes I found /SAPSLL/SPL_CHSO3 meanwhile

Will check how to convert .xls to .xml

Thank you anyways!

[Former Member]

Hi Tzunami,

If you have a solution how to convert MS Excel into needed XML file

would appreciate if you can share this information with us.

Thanks

Regards

Dieter

[Former Member]

Dieter,

Check this link:

http://www.sdn.sap.com/irj/scn/articles-grc-all

There should be an article called

SAP GRC GLOBAL TRADE SERVICES 7.2

OFFLINE SANCTIONED PARTY LIST SCREENING GUIDE

If it has been removed, I'd suggest you ask your account manager to contact GTS solution management for the document.

[Former Member]

Randy,

Thanks I have checked the article you mentioned, but it was removed.

So the question remains how can one convert MS Excel into needed XML file?

Thanks

Regards

Dieter