05-26-2009 10:59 AM
Hi all,
i want to retrieve the customer details based on the name entered in the selection screen.
but the customer name is stored in the Database like combination of CAPITAL letters and small letters and Numbers and some special characters like -(Hyphen), .(DOT), etc.
Assume name is stored in the database like: RAJA RAM.
but the selection-screen , if the i enter raja ram, or Raja Ram, it should fetch from the database.
what i am thinking that at the time of customer creation , i want conver the customer name into either CAPITALS or Small letters.
for this is there any BADI or Exit is available.?
Thanks
Vimala.
05-26-2009 11:03 AM
Hi,
You can split the name string and use like '%Some name %' in your select query.
Regards,
Prashant.
05-26-2009 11:03 AM
Hi,
You can split the name string and use like '%Some name %' in your select query.
Regards,
Prashant.
05-26-2009 11:08 AM
In what table are these customers stored? In tabel BUT000 for example, you have two columns in which the names are always stored in capitals to avoid these situations. And these columns are part of the secondary index as well. So no need to convert.
If you do want to convert, despite the above argument, you will have to tell what transaction you are using to create / change customers to find the exit / badi.
05-26-2009 11:17 AM
HI,
thanks for reply.
The transaction is XD01. Table is KNA1. field is name1.