select statement

[Former Member]

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.

[Former Member]

have u declared lv_land1 and lv_name1

[Former Member]

It seems to compile fine for me.

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

Check the spellings

[Former Member]

hi

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

[Former Member]

Try omitting all the spaces in the parenthesis

regards,

Panayotis

[Former Member]

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

[alex_m]

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

[Former Member]

Hi,

Make sure to have a space after (.

Regards,

Rama.Pammi

[Former Member]

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