help in select single

[Former Member]

hallow

i have erorr when i do this select what i miss

        DATA: l_ennda TYPE endda,
              emp_status TYPE stat2.

        SELECT single endda stat2
          FROM pa0000
          INTO (l_endda , emp_status)
          WHERE stat2 = 0
          AND begda LE so_date-high
         AND endda GE so_date-low.

the erorr is :

The list "(L_ENDDA" after "INTO" is not of the the form (f1, ...,fn),

or contains an undefined field. the form (f1, ...,fn), or contains an

undefined field. the form (f1, ...,fn), or contains an undefined field.

efined field. the form (f1,

reagrds

[Former Member]

never use pa0000 use p0000 reward points if use full

[gopal_jee]

Hi Ricardo,

The error is coming because you have done one spelling mistake. In the declaration you have decalred 'l_ennda' but in the select statement you are using 'l_endda'.

Kindly copy the below select statement:

SELECT single endda stat2

FROM pa0000

INTO (l_ennda, emp_status)

WHERE stat2 = 0

AND begda LE so_date-high

AND endda GE so_date-low.

<b>Reward the point if reply is useful.</b>

Regards,

Gopal.

[Former Member]

give a space between open bracket and l_endda lik dis

( l_endda , emp_status )

hope dis helps..

Reward all helpful queries

[Former Member]

try this...

SELECT single endda stat2 INTO (l_endda , emp_status)

FROM pa0000

WHERE stat2 = 0

AND begda LE so_date-high

AND endda GE so_date-low.

[Former Member]

Hi.

Give open and close brackets.

Reward if its helpfull.

Regards.

Jay

[Former Member]

it should be

(l_endda, emp_status)

in between l_endda and , no space.

one space between , and emp_status

regards

shiba dutta

[Former Member]

hi

i try it exactly but i have the same erorr

i copy paste it and the other select from in the replays but nothing change

what is wrong?

Regards

[Former Member]

Hi,

DATA: l_ennda TYPE endda,

emp_status TYPE stat2.

SELECT single endda stat2

FROM pa0000

INTO (l_endda , emp_status)

WHERE stat2 = 0

AND begda LE so_date-high

AND endda GE so_date-low.

The syntax is correct, (l_endda , emp_status). don't leave any space after( and before end of ).

Regards,

Vani.