Puzzle_ShutterstockSince the companies in Brazil must not have 2 partners to the same CNPJ and/or State Inscription (IE), or CPF, you can prevent that 2 customer master records or 2 vendors created to the same Tax ID using SAP Standard (Configuration). Some time ago, this was only possible with coding / user exit.

First, let me explain about the TAX IDs:

Tax Number 1 (STCD1) – CNPJ — Only for legal entities (companies)
Tax Number 2 (STCD2) – CPF — Only for Natural Person
Tax Number 3 (STCD3) – State Inscription — Only for legal entities (companies)
If exempt, must contain word “ISENTO”
Tax Number 4 (STCD4) – Municipal Inscription — It can contain RG (ID) if vendor is Natural Person
If exempt, must contain word “ISENTO”
Sole Proprietr (STKZN) – Natural Person indicator — Must be active when vendor is not a legal entity but a Natural Person

tAX iD

To activate the duplicity check, first go to transaction BUPA_TAXNUMTYPE and turn on the Tax ID’s that you want the validation active:

BUPA_TAXNUMTYPE

Then go to transaction OBA5 (Change Message Control) to turn the error message on (you can choose between Warning or Error, but it is strongly recommended that you select as an Error when user goes to XK01 or XD01 for example, to create the customer or vendor). You can also select the message behavior based on an user.

You have to select area 8B and message No. 011, 012, 013, 014

OBA5
If you enter a specific user, for instance, end users receive the standard error message but a user in the SAP Support group only receives a warning and is able to by pass the error.

You may also check transaction OBMSG to the same area 8B and messages and do the following:

Enter the adjustable message types in the “Allowed” column (“S” = success message, “I” = Information message, “W” = warning message, “E” = error message, “A” = termination message; an example entry could be SIWE).

OBMSG

Once those settings are in place, when someone try to create a record for a partner that already exist, it will look like this:

When you try to create the register, the system will show that a customer/vendor already exist to a given Tax ID:
Vendor validation

And then it will issue a message, error or warning, depending on what was configured:
Vendor validation 2

Not having customers and vendors in duplicity is mandatory for SPED Reporting. You can check this information on contributor guide for SPED Fiscal (EFD) and Contributions.

Copyright Notice: © Leandro da Pia Nascimento and SAPBR.COM (SAP BRAZIL) WordPress Blog, 2013 to 2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Leandro da Pia Nascimento and SAPBR.COM with appropriate and specific direction to the original content.

Advertisements