Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

maximum

Former Member
0 Likes
995

hi,

In my report 5 GL accounts are there i have to find maximum of GL account.

for Example:

GL Amount

510000 10000

510000 20000

520000 5000

520000 8000

can you help me.

Regards ,

Karthikeyan.K

1 ACCEPTED SOLUTION
Read only

GauthamV
Active Contributor
0 Likes
976

Sort itab by hkont ascending dmbtr descending.

delete adjacent duplicates from itab comparing hkont.
8 REPLIES 8
Read only

Former Member
0 Likes
976

sort internal table and read ...

sort itab by GL_Amount descending.

read table itab index 1.

Read only

GauthamV
Active Contributor
0 Likes
977

Sort itab by hkont ascending dmbtr descending.

delete adjacent duplicates from itab comparing hkont.
Read only

Former Member
0 Likes
976

hi:

Sort itab by GL ascending Amount descending.

Regards

Shashi

Read only

Former Member
0 Likes
976

Hi,

Display report after click on sort. Now srol down last record is your requirement.

Regards

Md.MahaboobKhan

Read only

Former Member
0 Likes
976

Hi,

USe COLLECT Statement

Read only

Former Member
0 Likes
976

Hi ,

You can sort your internal table with your GL Amount field in descending order ,

i.e,

sort itab by gl amount field descending.

read table itab index 1.

By you can fetch the maximum value of gl amount field from itab internal table.

Hope it helps

Regrds

Mansi

Read only

Former Member
0 Likes
976

Hi,

You can do as below :



sort itab by hkont dmbtr by ascending.

delete adjacent duplicates from itab comparing hkont dmbtr.

write : 

Thanks,

Sriram Ponna.

Read only

Former Member
0 Likes
976

Hi ,

sort itab by hkont dmbtr by ascending.

Regards