Help require in Internal table condition

[Former Member]

Hi Experts,

i have Internal table(itab) while debuging i am getting fellowing type of records.

KSCHL KBETR WAERS

ZZ10 | 200.00 |EUR

ZPNL | 117.00 |EUR

ZPRA | 115.00 |EUR

ZZ10 | 300.00 |EUR

ZZ10 | 200.00 |EUR

ZZ10 | 350.00 |EUR.

i want to compare the ZZ10 values, I need the lowest value, how to compare?

in the above i need zz10 with the value of 200 only.

How to compare, and how to select the lowest value only.

Any one help this,

Point will be sure.

Mohana

[Sm1tje]

sort the table KSCHL KBETR and take for every new KSCHL take the first entry using

for example ON CHANGE OF, or AT NEW.

[Former Member]

Help require in Internal table condition

Posted: Apr 3, 2008 8:49 AM E-mail this message Reply

Hi Experts,

i have Internal table(itab) while debuging i am getting fellowing type of records.

KSCHL KBETR WAERS

ZZ10 | 200.00 |EUR

ZPNL | 117.00 |EUR

ZPRA | 115.00 |EUR

ZZ10 | 300.00 |EUR

ZZ10 | 200.00 |EUR

ZZ10 | 350.00 |EUR.

i want to compare the ZZ10 values, I need the lowest value, how to compare?

in the above i need zz10 with the value of 200 only.

How to compare, and how to select the lowest value only.

Any one help this,

Point will be sure.

Mohana

sort table by kscl kbetr.

loop at itab where kschl = 'ZZ10'.

AT FIRST.

" you have your lowest value

ENDAT.

endloop.

[Former Member]

sort ur itab and use select single * from itab where kschl = 'zz10'

U never close ur thread ?

[Former Member]

Better SORT internal T with kschl,kbetr..

else

use some Aritmetic fun:-MIN

[Former Member]

sort i_tab by kschl kbetr.

select single * from i_tab where kschl = 'ZZ10'.

reward if useful.

[Former Member]

declare another internal table jtab of same structre as itab.

for all KSCHL with same name as ZZ10. append the row with least value to jtab.

SORT itab BY KSCHL KBETR WAERS.

LOOP AT itab.

ON CHANGE OF KSCHL.

APPEND itab TO jtab.

CLEAR itab.

ENDON.

ENDLOOP.

All the other records that have KSCHL in common are sorted and the lowest value record is appended to the jtab int tab.

READ TABLE jtab with key KSCHL = 'ZZ10'.

if sy-subrc = 0.

(DO WHAT EVER U WANT WITH THE RECORD & VALUE YOU WANT)

endif.

Regards,

Srinivas