topic Re: loop query in Application Development and Automation Discussions

loop query

Former Member — Sun, 09 Dec 2007 01:32:31 GMT

i have a simple loop query. I want to get same data from 3 different tables into a single internal table like

if tab1 data is not available then tab2 then tab3.

now when i use my internal table how do i fill data into my internal table and what will be my loop condition.

i have already written select statement.

a sample code will be of great help

Re: loop query

Former Member — Sun, 09 Dec 2007 02:27:54 GMT

Hi,

Paste your code here which you have written, so that it will be easy for us to guide you.

Regards,

Satish

Re: loop query

Former Member — Sun, 09 Dec 2007 05:32:58 GMT

to get data from different table into one table use following code

select * from ztab1 into table itab where <...>.

select * from ztab2 appending table itab where <.....>.

Re: loop query

Former Member — Sun, 09 Dec 2007 06:27:14 GMT

paste ur code here so that problem can b understood clearly

for getting data

first select

if sy-subrc <> 0 " in case of not getting data in first select

put here 2nd select

then again

put if sy-subrc <> 0 " in case of not getting data in 2nd and first select

put third select statement

if u provide ur code then may b we can help a little more

regards

Re: loop query

Former Member — Sun, 09 Dec 2007 09:16:11 GMT

Hi, sample code below:

select * into ITAB from TAB1 where <conditions>.
  append ITAB.
endselect.

if sy-subrc <> 0.
  select * into ITAB from TAB2 where <conditions>.
    append ITAB.
  endselect.

  if sy-subrc <> 0.
    select * into ITAB from TAB3 where <conditions>.
      append ITAB.
    endselect.
  endif.
endif.

Re: loop query

Former Member — Sun, 09 Dec 2007 10:31:17 GMT

Hi,

The above said code I think it doesn't work properly because in the select statement from table name placed after the internal table and also no need of append statement.

Use like this...(itab-Internal table name)

Select * from tab1 into table itab

where (condition).

if sy-subrc <> 0.

Select * from tab2 into table itab

where(condition).

if sy-subrc <> 0.

Select * from tab3 into table itab

where (condition).

endif.

Now you will get value in the internal table itab.Three different tables where tab1,tab2,tab3.

Thanks,

Sakthi C

*Rewards if useful--*

Re: loop query

Former Member — Sun, 09 Dec 2007 18:56:06 GMT

Thanks for your help guys.

I was able to resolve it looking at the sample code provided.

I have awarded points

Regards