topic Re: data load in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/data-load/m-p/6985685#M1493217 <HTML><HEAD></HEAD><BODY><P>Hi pooja,</P><P></P><P>First get all the customer name, city, address, pincode, customer pricing procedure from the tables using for all ertries into internal table</P><P>Then read that table in the loop, If sy-subrc equal 0 the entry exist.</P><P></P><P>Regards,</P><P>Sri</P></BODY></HTML> Thu, 24 Jun 2010 10:52:02 GMT Former Member 2010-06-24T10:52:02Z data load https://community.sap.com/t5/application-development-and-automation-discussions/data-load/m-p/6985684#M1493216 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 24 Jun 2010 10:05:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-load/m-p/6985684#M1493216 Former Member 2010-06-24T10:05:24Z Re: data load https://community.sap.com/t5/application-development-and-automation-discussions/data-load/m-p/6985685#M1493217 <HTML><HEAD></HEAD><BODY><P>Hi pooja,</P><P></P><P>First get all the customer name, city, address, pincode, customer pricing procedure from the tables using for all ertries into internal table</P><P>Then read that table in the loop, If sy-subrc equal 0 the entry exist.</P><P></P><P>Regards,</P><P>Sri</P></BODY></HTML> Thu, 24 Jun 2010 10:52:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-load/m-p/6985685#M1493217 Former Member 2010-06-24T10:52:02Z Re: data load https://community.sap.com/t5/application-development-and-automation-discussions/data-load/m-p/6985686#M1493218 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="red" __jive_macro_name="color">Moderator message - Please do not post your requirements and ask the forum to do your work for you - post locked Rob</SPAN></P></BODY></HTML> Thu, 24 Jun 2010 14:49:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/data-load/m-p/6985686#M1493218 Former Member 2010-06-24T14:49:45Z