topic Re: offset indicator on date in Application Development and Automation Discussions

offset indicator on date

Former Member — Thu, 07 Aug 2008 11:06:37 GMT

i am using offset indicator on date field, i.e.

select single * from vbak into wvbak where erdat+0(3) = '2000'.

but querry does not fetch data, what could be the solution for this.

thanx in adv

manoj

Re: offset indicator on date

Former Member — Thu, 07 Aug 2008 11:07:56 GMT

Hi ,

OFFSET won't work in the where clause.

Regards

Prabhu

Re: offset indicator on date

Former Member — Thu, 07 Aug 2008 11:08:32 GMT

select single * from vbak into wvbak where erdat0(3) = '2000'.+

we cannot use offset in query.

first fetch data than compare with offset and delete unwanted data.

Re: offset indicator on date

SuhaSaha — Thu, 07 Aug 2008 11:09:42 GMT


select single * from vbak into wvbak 
  WHERE ERDAT <= '20001231'
  or    ERDAT >  '20000101'.

I think you should be using SELECT UP TO 1 ROWS .. ENDSELECT as ERDAT is not key field in the table.

BR,

Suhas

Edited by: Suhas Saha on Aug 7, 2008 1:14 PM

Re: offset indicator on date

Former Member — Thu, 07 Aug 2008 11:12:30 GMT

hi,

select all the data into one internal table and use the following code.

loop at itab into wa.

if wa-date+0(4) eq '2000'.

move-corresponding wa to final_itab.

clear wa.

endif.

endloop.

Regards,

Satish Reddy.

Re: offset indicator on date

Former Member — Thu, 07 Aug 2008 11:13:07 GMT

Plz change ur code as per below.

Data wvbak1 like wvbak with header line.

select single * from vbak into wvbak.

Loop at wvbak

If wvbak-erdat+0(4) = '2000'.

move wvbak to wvbak1.

append wvbak1.

Clear wvbak1.

Endif.

Endloop.

rgds

rajesh

Re: offset indicator on date

SuhaSaha — Thu, 07 Aug 2008 11:19:19 GMT

Hello Satish & Rajesh,

What if we restrict the data fetch @ the time of selection )


  WHERE ERDAT <= '20001231'
  OR    ERDAT >  '20000101'.

I guess this will be more efficient performance-wise.

BR,

Suhas

Re: offset indicator on date

Former Member — Thu, 07 Aug 2008 11:24:13 GMT

hiii

select query will not work with OFFSET...

LOOP AT i_marc INTO wa_marc.
if  wa_marc-date+0(4) = '2000'.
.....
endif.
endloop.

regards

twinkal