data load

[Former Member]

We are using the excel file for uploading the customer master. We want to validate the excel file which contains customer name, city, address, pincode, customer pricing procedure with the data that exists in SAP in KNA1 table and KNVV. This is to avoid duplicate customers being created. Please provide solution as to where to write the validation rule and how to.

[Former Member]

Hi pooja,

First get all the customer name, city, address, pincode, customer pricing procedure from the tables using for all ertries into internal table

Then read that table in the loop, If sy-subrc equal 0 the entry exist.

Regards,

Sri

[Former Member]

Moderator message - Please do not post your requirements and ask the forum to do your work for you - post locked Rob