topic Re: select statement problem in Application Development and Automation Discussions

select statement problem

Former Member — Thu, 12 Oct 2006 13:09:53 GMT

Hi,

I am getting problem in select statement.

Plz let me know what's the problem

SELECT SINGLE KUNNR LAND1 NAME1

INTO (LV_KUNNR, LV_LAND1, LV_NAME1)

FROM KNA1.

Former Member — Thu, 12 Oct 2006 13:12:49 GMT

Hi Salil,

I don't see any issue with the Select statement.

Hope you have defined the variables properly.

May be some issue before this statement. Check.

Manish

Message was edited by: Manish Kumar

Former Member — Thu, 12 Oct 2006 13:13:48 GMT

pls post ur error

Former Member — Thu, 12 Oct 2006 13:17:53 GMT

Hi Singh,

I dont find any problem with this select.have u decleared LV_KUNNR, LV_LAND1, LV_NAME1 these variables?

Thanks

Vikranth Khimavath

Former Member — Thu, 12 Oct 2006 13:19:40 GMT

with or without space it's the same.

2 possibilities :

you did have a LV Structure so the field is LV-KUNNR

you did forget to define LV_KUNNR and the other 2.

the Statement is correct. check your coding before the select statement.

Former Member — Thu, 12 Oct 2006 13:33:49 GMT

Hi Salil

I copied your code and wrote it in abap editor and i am getting the output , see the below code

data: lv_kunnr like kna1-kunnr.

data: lv_land1 like kna1-land1.

data: lv_name1 like kna1-name1.

select single kunnr land1 name1

into (lv_kunnr, lv_land1, lv_name1)

from kna1.

write: / lv_kunnr,

lv_land1,

lv_name1.

Thanks