topic Re: help in select single in Application Development and Automation Discussions

help in select single

Former Member — Mon, 26 Nov 2007 10:22:18 GMT

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

Re: help in select single

Former Member — Mon, 26 Nov 2007 10:24:07 GMT

never use pa0000 use p0000 reward points if use full

Re: help in select single

Former Member — Mon, 26 Nov 2007 10:26:38 GMT

give a space between open bracket and l_endda lik dis

( l_endda , emp_status )

hope dis helps..

Reward all helpful queries

Re: help in select single

Former Member — Mon, 26 Nov 2007 10:27:57 GMT

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.

Re: help in select single

Former Member — Mon, 26 Nov 2007 10:28:51 GMT

Hi.

Give open and close brackets.

Reward if its helpfull.

Regards.

Jay

Re: help in select single

Former Member — Mon, 26 Nov 2007 10:28:52 GMT

it should be


(l_endda, emp_status)

in between l_endda and , no space.

one space between , and emp_status

regards

shiba dutta

Re: help in select single

Former Member — Mon, 26 Nov 2007 10:33:31 GMT

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.

Re: help in select single

Former Member — Mon, 26 Nov 2007 10:41:08 GMT

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

Re: help in select single

gopal_jee — Mon, 26 Nov 2007 10:47:05 GMT

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.