Spain VAT ID

[Former Member]

Hi All,

user is trying to give the VAT ID for a spain customer as ESJ41725920 and the sytem says the VAT registration number is invalid. When i check the same in T.Code Oy17, the length of the VAT registration number is 11 and checking rule is 3 and "other data" is marked. More over this VAT registration number is valid.

Does any one have solution of how to give this particular VAT ID number in the customer master record?

awaiting your replies.

Regards,

Anil.

[Former Member]

Anil, I hope you found the OSS notes, which expand the legal change in Spain.

if you have not, please try to find it. I have implemented such change before for 'J' in spain.

[Former Member]

The SAP OSS-note is 1157769 .

[Former Member]

Just keep ES and the number. total digits inclusing ES should be 11. Try and see.

Regards

Sai

[eduardo_hinojosa]

Hi,

Surely you have an error in a number because the validation of digit control failures.

Check function STCEG_CHECK, and in function module EU_TAX_NUMBER_CHECK check the subroutine 'perform check_digit_check_e using eu_tax_number'.

Regards,

Eduardo

PD: the better option is that the partner send you an invoice with the VAT.

Edited by: Eduardo Hinojosa on Jun 8, 2010 1:43 PM

[Former Member]

Anil

Eduardo is right on the money.

Within the Function Module that he mentioned, there is a 'perform' for checking the check digit for Spain:

PERFORM check_digit_check_e USING eu_tax_number.

Read that code with an ABAPer. Especially this piece:

• ------ Prüfverfahren bestimmen und durchführen --------------------- *

• ES = ISO-Code Spanien, L = Buchstabe (letter), D = Ziffer (digit)

*

• ESLDDDDDDDL --> Prüfung Steuernummer einer Behörde

• (1. Stelle = A, B, C, D, E, F, G, H, P, Q, S)

• --> Sonderfall Steuernummer einer nat. Person

• (1. Stelle = K, L) --> keine Prüfung oder

• --> Prüfung Steuernummer einer ausländischen nat.

• Person (1. Stelle = X)

• ESLDDDDDDDD --> Prüfung Steuernummer einer juristischen Person

• (L = A, B, C, D, E, F, G, H) oder

• --> Sonderfall Steuernummer einer ausländischen nat.

• Person (L = T) --> keine Prüfung

• ESDDDDDDDDL --> Prüfung Steuernummer einer natürlichen Person

It looks like there are 3 formats: See below: ES is of course for Spain; L = Letter; D = Digit

1) ESLDDDDDDDL

2) ESLDDDDDDDD

3) ESDDDDDDDDL

According to the code or what I read of it, the 3 rd position where you have J is wrong.

You can have A, B, C, D, E, F, G, H, P, Q, S, K, L, X or T. You canu2019t have a J there. Thatu2019s what is wrong.

Let's know your next steps. Good luck.

[Former Member]

Hi Chandra,

Thanks for your detail explanation. But what if user stick to have the VAT ID number in which the third alphabet is "J". Is there any other alternative to solve this? I have unmarked the tick in Other Data in OY17 and it worked with the VAT ID given by the customer. But am not sure what would be the other implications if i uncheck the Other data.

Is there any SAP note I can search for??

Awating your reply to solve this issue.

Regards,

Anil.

Edited by: Anilku on Jun 10, 2010 8:15 AM

[eduardo_hinojosa]

Hi,

The letter 'J' if for 'sociedades civiles' . You can see it in es.wikipedia.org/wiki/Código_de_identificación_fiscal

l, it is wrote in spanish but you have the algorithm in visual basic, etc... so, you can check how it is solved the validation of VAT ID in Spain.

I hope this helps you

Regards,

Eduardo

Edited by: Eduardo Hinojosa on Jun 10, 2010 10:33 AM

Edited by: Eduardo Hinojosa on Jun 10, 2010 10:34 AM

Edited by: Eduardo Hinojosa on Jun 10, 2010 10:35 AM

[Former Member]

Hi Eduardo,

Thanks for your time in looking this issue to be solved. Seriosly i did not understand any thing of your earlier post to which am replying. My question is what if the user wants to have the VAT ID as ESJ41725920? Is there any other alternative that i convince the user? or is there any sap note i can search for?

Awaiting your reply.

Regards,

Anil.

[Former Member]

Hello Anil

VAT Registration # for a customer has to be right, It is a filed required in legal reports ( Annual sales List etc.), doing tax free deliveries and so on. Trust me I did an Implementation as SD Lead for a Spanish/Portuguese roll-out and my entire focus had been on statutory requirements and translation (SE63) issues. I would not recommend skipping the check mark for other data in OY17 . Especially country settings supplied by SAP should not be tampered with. Try to convince your user using legal implications. However if this is a non-ES implementation meaning if it is a US implementation (example) and there are few ES customers for whom you want to skip the validation, then may be you can take the risk.