How to avoid duplicate customers creation?
Submitted by Anonymous (not verified) on Mon, 05/13/2013 - 08:48
1. Using LSMW , XD01
want to test data, before loading with a RADIO button option to user.
a) 'Radio button' TEST -- To test for errors in data file
b) Display Error records in excel file
c) 'Radio button' Create customer
d) Display created records in excel file
2. How to avoid duplicate customers creation -- Internal number range.
e)Say if customer with "ex: check if KNA1-legacy number is existing, then don't commit the data, go to next record.
How to code these requirements in LSMW
Thanks
Nik
Duration:
1 month
Comments
Using parameters and queries to prevent duplicates.
Hi Nik,
The option to turn off testing for errors is a novel idea, but can be done easily enough with the snippet from this article.
https://www.saplsmw.com/Add_parameters_to_an_LSMW_object_and_describe_them
A simple query and an
if
statement will suffice to prevent the creation of duplicate records based on theALTKN
field inKNA1
. If your source structure is calledXD01S
and the parameter isp_check
then the code would look like this: