topic Re: Code for Vendor Tax Code uniqueness in Application Development and Automation Discussions

Code for Vendor Tax Code uniqueness

xt_inergo — Thu, 18 Jun 2009 09:12:19 GMT

Hi,

When we are trying to create a new customer (transaction XD01) we would like to be informed if the Vendor Tax Code (KNA1-stcd2) is being used already.

Can you tell me what code do we have to insert and where.

Thanks.

Re: Code for Vendor Tax Code uniqueness

Former Member — Thu, 18 Jun 2009 09:56:34 GMT

Hello,

I dont there would be direct way to check this out in SAP R/3.

What you can do is create a Z-DB table , say ZTAXCODE, which has Customer,Customer Group as Key Fields and taxcode as another field.

Now when User tries to save the Customer- then u can

1) Make use of BADI - CUSTOMER_ADD_DATA (SE18/SE19)

2) Make use of User Exit - FM EXIT_SAPMF02D_001 (Customers: User Exit for Checks prior to Saving) (SMOD/CMOD)

Here, you can the entry to your newly created table and chk if the entry user tries to maintain already exists. If yes, you can display an error message to the user.

Hope this helps.

Re: Code for Vendor Tax Code uniqueness

xt_inergo — Thu, 18 Jun 2009 11:47:43 GMT

thanks for your answrer.

Can you be more specific in what to do with user exit EXIT_SAPMF02D_001

thanks.

Re: Code for Vendor Tax Code uniqueness

Former Member — Thu, 29 Sep 2011 08:03:05 GMT

Use sm30 view V_TFKTAXNUMTYPEC to customize the duplicity check. It is not necessary to develop anything.

Svetlin