Duplicate Check by Tax Number

[Former Member]

Hi Experts,

I have a requirement to check BP duplictaes by Tax number. In other words, any time a BP is being created and has the same Tax Numer as an existing one, the system must not allow the creation of the new BP.

I have realized that in these scenarios SAP gives an Info message saying that there is already a BP with this number, but it allows the user to skip the message and still save the BP. Is there anyway to transform this Info message to an error message? Have you had this requirement before?

The message code is BUPA_TAX400.

Thank you very much in advace,

Best Regards,

LUCAS

[chaiphon · Accepted solution]

SAP-Standard part, table T100s

Transaction 'SM31', Table/View 'T100s', Maintain, New Entries, add following entry:

Application area: BUPA_TAX

MsgNo: 400

Allowed: WEIS-

Standard: I

Switch off:

Customer specific part, table T100c

Transaction 'OBA5', Application Area 'BUPA_TAX', enter, add following entry to set an error for the message 'BUPA_TAX 400':

MsgNo: 400

Online: E

BatchI: E

Please send e-mail to my profile e-mail if solution works.

Cheers,

Chaiphon

[Former Member]

It works!!

[Former Member]

Hi Chaiphon,

I need som help with a similar case related to this post.

I need the system to show an error message when i enter a non valid value in the struct.city field.

These r the steps i followed:

Transaction 'SM31', Table/View 'T100s', Maintain, New Entries, add following entry:

Application area: R5

MsgNo: 517

Allowed: WEIS-

Standard: I

Switch off:

Customer specific part, table T100c

Transaction 'OBA5', Application Area 'R5', enter, add following entry to set an error for the message 'R5 517':

MsgNo: 517

Online: E

BatchI: E

Any idea?

Thanks!!

[Former Member]

Hi Chaiphon,

I implemented the same process but did not get an error message, not even a warning message upon creating a new customer with id 643 having the same Tax number 1, Tax number 2 and Tax Number 5 as the one created before having id 642.

I have already the following error message in sm30 , table/view V_T100C and Application area F2 :

Msg 273 Customers with same VAT Registration number found

This is working!

But what I want is a check on Tax Number 1, Tax Number 2 and Tax Number 5. It wont seem to work with the solution that you provided.

Kindly help.

[Former Member]

Please check this t.code BUPA_TAXNUMTYPE where you will have to set the Duplicate Check ON for your specific category.

[Former Member]

Hi Yuvaraj,

Thank you for your reply. I want to add a new entry in BUPA_TAXNUMTYPE but I cant seem to find my Country listed there. Is it possible that the Tax number fields are linked to some other Country's Tax Number Category?

[Former Member]

Yes add your own category and turn on the duplicate check.  When creating BP you will use the category you created and from thereon duplicate BP creations would get the message.

[Former Member]

Nope! not working.

[Former Member]

Please go to SM30 and maintain this view V_TFKTAXNUMTYPE, where you can add your own custom function module for the tax category you had created.  The custom function module should be a copy of BUPA_TAX_NUMBER_CHECK.  In this function module you can throw the required error message.

[former_member1203934]

Hi All

Its working

Thanks

Noman

[former_member804423]

Hi ALI, did you solved?

[DirkM]

Just to let you know. We have an Issue with IDOC CREMAS and BUPA_TAX 200 whereas this solution approach did not help unfortunately.
Brgds