topic Re: select single * statement in Application Development and Automation Discussions

select single * statement

Former Member — Mon, 05 Jun 2006 19:27:03 GMT

Hi everyone,

I have the follwing two codes .The first one works fine but the second one gives me an error.

Please let me know what is the error.

1)The below code works fine

loop at itab.

select single * from zxyz

where zorder = itab-zorder.

if zxyz-id is initial.

---

endif.

endloop.

2)This one doesn't work

select single * from zac

where userid = sy-uname.

if sy-subrc eq 0.

endif.

Iam getting this error please let me know

The INTO clause is missing at select, or the from addition at either DELETE,INSERT,MODIFY OR UPDATE IS MISSING.

Thanks in advance.

Deepthi

Re: select single * statement

sridhar_k1 — Mon, 05 Jun 2006 19:30:44 GMT

Do u have TABLES statement for table ZAC in the program?

Re: select single * statement

Former Member — Mon, 05 Jun 2006 19:31:40 GMT

can u give the complete code

Re: select single * statement

Former Member — Mon, 05 Jun 2006 19:31:41 GMT

Hi Deepthi,

You must declare either the table or an work area in your program.

You can do that with either of the below methods:

1. Tables: ZAC. (or)

2. Data: w_zac like ZAC.

Change your select statement to the following when you use the option 2:

select single *

from zac

into w_zac

where userid = sy-uname.

Hope this helps.

Regards,

Sumant.

Message was edited by: Sumant Sura

Re: select single * statement

Former Member — Mon, 05 Jun 2006 20:06:22 GMT

Thanks everyone.

I got that fixed. I some how forgot to mention the tables statment.

Thanks again.