topic Re: maximum in Application Development and Automation Discussions

maximum

Former Member — Fri, 20 Feb 2009 06:02:41 GMT

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

Re: maximum

Former Member — Fri, 20 Feb 2009 06:04:03 GMT

sort internal table and read ...

sort itab by GL_Amount descending.

read table itab index 1.

Re: maximum

GauthamV — Fri, 20 Feb 2009 06:04:50 GMT


Sort itab by hkont ascending dmbtr descending.

delete adjacent duplicates from itab comparing hkont.

Re: maximum

Former Member — Fri, 20 Feb 2009 06:07:05 GMT

hi:

Sort itab by GL ascending Amount descending.

Regards

Shashi

Re: maximum

Former Member — Fri, 20 Feb 2009 06:07:07 GMT

Hi,

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

Regards

Md.MahaboobKhan

Re: maximum

Former Member — Fri, 20 Feb 2009 06:10:21 GMT

Hi,

USe COLLECT Statement

Re: maximum

Former Member — Fri, 20 Feb 2009 06:16:35 GMT

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

Re: maximum

Former Member — Fri, 20 Feb 2009 06:22:33 GMT

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.

Re: maximum

Former Member — Fri, 20 Feb 2009 07:08:57 GMT

Hi ,

sort itab by hkont dmbtr by ascending.

Regards