topic Re: Retrieving Data in Application Development and Automation Discussions

Retrieving Data

Former Member — Tue, 07 Oct 2008 05:29:07 GMT

Hi,

I have to read a table itab in which if i give some date say 10.08.2008 time 11:00 am i want a record which is just before that record ...say 10.08.2008 time 10.30am record ( ITAB has got 100 records till date ).

Waiting for ur reply. ....

Regards

Srinath

Re: Retrieving Data

Former Member — Tue, 07 Oct 2008 05:33:54 GMT

Hi,

Try this.

READ TABLE itab <your condition>

index = sy-tabix - 1.

READ TABLE INDEX index.

Re: Retrieving Data

naveen_inuganti2 — Tue, 07 Oct 2008 05:34:26 GMT

Hi...


  data: tabix like sy-tabix.
  loop at itab.
   if date = your date.
     tabix = sy-tabix.
     exit.
   endif.
 endloop.

tabix = tabix - 1.

read table itab index tabix.

It should work.

Thanks,

Naveen.I

Re: Retrieving Data

Former Member — Tue, 07 Oct 2008 05:36:17 GMT

Hi Srinath,

Get the record with specified DATE and TIME.

Get its index.

Reduce the index by one.

Get the record with this index.


  READ ITAB ... WITH KEY DATE = ' ' TIME = ''.
  IF SY-SUBRC = 0.
    V_INDEX = SY-TABIX - 1.
    READ ITAB ... INDEX V_INDEX.
  ENDIF.

Regards,

R.Nagarajan.

We can -

Re: Retrieving Data

Former Member — Fri, 31 Oct 2008 12:30:01 GMT

Thanx All....