topic Re: Read statment issue in Application Development and Automation Discussions

Read statment issue

Former Member — Thu, 16 Aug 2007 14:54:38 GMT

Hi all,

can anyone tel lme how to read the record

itab.

f1 f2 f3

1 1 a

1 2 a

1 4 a

1 5 a

2 7 b

2 5 b

3 1 c

3 2 c

loop at itab2 into wa2.

read table itab into wa1 with key f1 = wa-f1

f3 = wa-f3.

i want the max f2 one say if f1 = 1, f3 = a i want 1 5 a

and if f1 =2 AND F3 = B I WANT THIS RECORD IN WA1 2 7 b

endloop.

Thanks

Re: Read statment issue

Former Member — Thu, 16 Aug 2007 15:01:41 GMT

before looping insert the code.

sort itab2 by f1 f2 descending f3.

Re: Read statment issue

Former Member — Thu, 16 Aug 2007 15:02:23 GMT

sorry

sort itab by f1 f2 descending f3.

Re: Read statment issue

Clemenss — Thu, 16 Aug 2007 15:04:39 GMT

Hi preeti,

sort itab.
loop at itab into wa1.
  at end of f2.
  append wa1 to itab2.
  endat.
endloop.

Regards,

Clemens

Re: Read statment issue

Former Member — Thu, 16 Aug 2007 15:07:51 GMT

Hi,

Sort the itab by f1, f3 and f2.

then use, AT END OF statement.

AT END OF F1-- move that record into another internal table .

Re: Read statment issue

Former Member — Thu, 16 Aug 2007 15:08:03 GMT

Hi Preeti,

Use SORT statement before LOOP...ENDLOOP.

<b>SORT ITAB BY F1 F2 DESCENDING F3.</b>

loop at itab2 into wa.

read table itab into wa1 with key f1 = wa-f1

f3 = wa-f3.

<b>IF SY-SUBRC = 0.

WRITE:/ WA1-F1 , WA1-F3.

ENDIF.</b>

endloop.

Thanks,

Vinay

Re: Read statment issue

Former Member — Thu, 16 Aug 2007 15:19:43 GMT

Thank you all