topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 17 May 2007 10:16:45 GMT

Hi,

I am getting one error in following select statement

select single land1 name1 from lfa1 into (lv_land1, lv_name1) where lifnr in s_lifnr.

the error is " the list (lv_land1" after "into" is not of the form (f1,...,fn), or contains an undefined field.

Could anybody will tell me what is the error here??

I have declared all the necessary fields.

Re: select statement

Former Member — Thu, 17 May 2007 10:24:16 GMT

have u declared lv_land1 and lv_name1

Re: select statement

Former Member — Thu, 17 May 2007 10:24:24 GMT

It seems to compile fine for me.

I think one of these lv_land1, lv_name1 is not declared properly.

Check the spellings

Re: select statement

Former Member — Thu, 17 May 2007 10:24:58 GMT

select single land1 name1 from lfa1 into (lv_land1, lv_name1)

lv_land1, lv_name1 declare these field as

lv_land1 like lfa1-land1.

rgds

Deepak

Re: select statement

Former Member — Thu, 17 May 2007 10:26:01 GMT

Hi neha

Your declaration is wrong inthe select statement u have topass all the values into a single internal table


DATA: BEGIN OF ITAB OCCURS 0,
              LAND1 LIKE LFA1-LAND1,
               NAME1 LIKE LFA1-NAME1,
      END OF ITAB.


select  land1 name1 from lfa1 into ITAB
           where lifnr in s_lifnr.

Rewards if helpfull

Regards

Pavan

Re: select statement

alex_m — Thu, 17 May 2007 10:26:45 GMT

The select statement is perfect, but the variable u should check, whether its already declared.

Re: select statement

Former Member — Thu, 17 May 2007 10:27:02 GMT

Hi,

Make sure to have a space after (.

Regards,

Rama.Pammi

Re: select statement

Former Member — Thu, 17 May 2007 10:27:08 GMT

Try omitting all the spaces in the parenthesis

regards,

Panayotis

Re: select statement

Former Member — Thu, 17 May 2007 10:27:19 GMT

hi,

chk this code with ur program.

tables : lfa1.
select-options : s_lifnr for lfa1-lifnr.
data : lv_land1 like lfa1-land1,
        lv_name1 like lfa1-name1.
select single land1 name1 from lfa1 into (lv_land1, lv_name1) where lifnr in s_lifnr.

Regards

Reshma