Skip to Content
0
Former Member
Dec 14, 2006 at 03:32 AM

Problem when use KNA1-NAME1 as select condition

428 Views

Hi , dear guys ,

I'm develping a RFC to communicate with B2B . We need get the ship-to partner code from table kna1 . The select condition is that KNA1-NAME1 equals the customer name imported from RFC parameter . The problem is the kna1-name1 differ between the upper and lower case . Even all the character is the same. Like my parameter is 'NOKIA' , while in the table kna1 the kna1-name1 is 'Nokia' . Because of this , the program can't get data from table kna1 . So my question is --- Is there any funtion to use so that I don't need consider the upper and lower case ? Thank you guys in advance !

the code is :

  • Get ship-to partner information

select single kunnr into shipto

from kna1 where name1 = z3a4_items-name1.