CDQ Data Quality as Service

During Brexit the EU VAT ID prefix XI has been introduced by the European Union to implement the requirements of the Norther Ireland Treaty Protocol.

Northern Ireland is still part of the UK (United Kingdom of Great Britain and Northern Ireland) and has not received an official own ISO country code. Country code XI does not officially exist (only in EU statistical reporting and for fulfilment of the NIT protocol). Hence, procedure for XI - Northern Ireland provides a wrong picture as no such country exists. NI is still a region of GB.

CDQ further maintains the validation procedures for the EU_VAT_ID_XI under country code XI. There should be no business partner in country XI (explanation given above); at least not in our systems. If address is in the UK, ISO country code GB has to be used but XI VAT ID might be available for business partners sitting in other EU countries for tax prceedings to the UK.

To avoid misunderstandings, remapping of data and allow correct validation of the XI VAT IDs, I suggest to investigate the existing setup and rules.

SAP stores the XI VAT ID in S4 Data Model in Tax Number Category GB6 (DFKKBPTAXNUM) or in LFA1/LFAS for vendors or KNA1/KNAS for customers in field STCD6.

I request investigation and correction. Please let me know if more input is required.

Many thanks