Data Consistancy KNA1-STCEG / VAT Number IntraCom with European Website VIES

[former_member587788]

Hi

We need to cleanse our customer master data to comply with the next requirements related to France 2024 Electronic Invoice

In our project, we need to check in mass the data consistency of the VAT Intracom Number stored here : KNA1-STCEG

First question : Is there a way to check a whole list (VIES website only allows you to check the numbers one by one)

Second question : is there a tool in SAP / Transaction that allows you to check (with the country origin of the customer for instance), if the code stored in KNA1-STCEG is consistant both in terms of format and in terms of accuracy ?

Thanks

Stéphane

[rob_ariaans]

I am not aware of a standard functionality; we use a custom build enhancement in Include MF02DFEX to check the value of KNA1-STCEG against VIES each time a change is made to the customer master data and store the reply from VIES in the GOS atachment list. In case response from VIES is negative, we automatically put a block on the customer and send an email to responsible department.

[former_member587788]

Hi

Thanks for the feedback

How did you connect yourself to VIES ? Who did you contact @ VIES to get this connection enabled ?

Therefore, did you heard or managed yourslef with downloading bulk data from VIES so we could at some extend make some checkes on our own with Excel ?

Thanks

[rob_ariaans]

We make use of the SOAP service (https://ec.europa.eu/taxation_customs/vies/services/checkVatService.wsdl).

For a one-time check you could also download the relevant data from KNA1 table and connect to the web service via excel macro or a (python) program or something similar.