Code for Vendor Tax Code uniqueness

[xt_inergo]

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.

[Former Member]

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.

[xt_inergo]

thanks for your answrer.

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

thanks.

[Former Member]

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

Svetlin