topic select within the case statement... in Application Development and Automation Discussions

select within the case statement...

Former Member — Thu, 13 Dec 2007 02:33:12 GMT

Is it possible to declare a select within a case statement?

I got an error.. I declared the CASE under my WHEN statement...

Please advise... Thanks!

regards,

Mark

Re: select within the case statement...

Former Member — Thu, 13 Dec 2007 02:37:48 GMT

Hi Mark,

Here is a sample

case decision_field.

when something.

select * etc......

when something_else.

when others.

endcase.

thanks.

Jamie

Re: select within the case statement...

Former Member — Thu, 13 Dec 2007 02:51:03 GMT

Thanks Jamie,,,

But thats the code I used when I encounter an error ...

Seem not to work..

Re: select within the case statement...

Former Member — Thu, 13 Dec 2007 03:05:34 GMT

Hi,

check this sample code..

TABLES: MARA,

MVKE.

CASE sy-subrc.

WHEN 0.

SELECT SINGLE * FROM MARA where MATNR = 'TEST'.

WHEN 1.

SELECT SINGLE * FROM MVKE WHERE MATNR = 'TEST'.

ENDCASE.

Also please post your code..

Thanks

Naren

Re: select within the case statement...

Former Member — Thu, 13 Dec 2007 04:37:40 GMT

Hi Mark,

can u paste the code where u get error?

Also tell us what is the error u get?

Re: select within the case statement...

Former Member — Thu, 13 Dec 2007 04:40:43 GMT

if you use select * ... use ENDSELECT incase not importing to internal table...

other wise it will work perfectly.

Re: select within the case statement...

Former Member — Thu, 13 Dec 2007 05:20:53 GMT

are you using endselect with select statement without into any internal table

just add error in this thread for more clear picture

Re: select within the case statement...

Former Member — Thu, 13 Dec 2007 05:34:38 GMT

hi mark,

if u use select statement fetching the data into an internal table then u won't have this problem

select * from trans_table into table itab where cond.

eg:

case 'X'.

when 0.

select statement.

when 1.

select statement.

when others .

select statement.

end case.

hope this helps u.

regards,

sohi

Re: select within the case statement...

Former Member — Thu, 13 Dec 2007 05:45:13 GMT

Hi Mark,

Why did you get error it is perfectly work.

Try this code.

Data t_table type table of spfli with header line.

data w_temp type c value 'X'.

Case w_temp.

when 'X'.

Select * from spfli into table t_table.

endcase.

Plz Reward if useful,

Mahi.