topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Tue, 25 Sep 2007 13:53:09 GMT

hi,

Iam retreiving cust.number, first name nd last name with respect to last name using table kna1.

select cust.no firstname lastname into table itab from kna1 where lastname = usergiven last name.

this does not retreives any data. though on the table the user given last name exist .

can anyone tell me what could be the problem.

Regards,

Phyrose.

Re: select statement

Former Member — Tue, 25 Sep 2007 13:55:26 GMT

Convert your last name to Capital before querying the table

This should solve the problem

Re: select statement

Former Member — Tue, 25 Sep 2007 13:56:00 GMT

HI,

Have u given the correct parameter name for user given last nam.

Hw do y get the User given LAst Name.

Regards,

Padmam.

Re: select statement

varma_narayana — Tue, 25 Sep 2007 14:03:40 GMT

hi Camila.

This may be bcoz of the UPPERCASE / Lower case.

TRANSLATE V_LASTNAME TO UPPER CASE.

select KUNNR NAME1 UPPER( name2 ) into table itab from kna1 where name2 = V_LASTNAME.

Message was edited by:

Alvaro Tejada Galindo

Re: select statement

Former Member — Tue, 25 Sep 2007 14:21:42 GMT

Don't select on NAME1 and NAME2. these are in mixed upper and lowere case. Instead use the fields created for this purpose - MCOD1 and MCOD2. They are already in upper case.

Rob