select single * statement

[Former Member]

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

[sridhar_k1]

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

[Former Member]

can u give the complete code

[Former Member]

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

[Former Member]

Thanks everyone.

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

Thanks again.