topic Re: ALV in Application Development and Automation Discussions

ALV

Former Member — Wed, 20 Aug 2008 08:57:11 GMT

Hi,

I have ALV Report with a default "subtotal" based on the plant field in the report.

Now I want the "subtotal" to be on "profit center" when user sorts the report based on the "profit center" using standard sort button povided by ALV report (interactively). Is this possible using standard functinality ? If not how do I go about the same?

Thanks

Re: ALV

Former Member — Wed, 20 Aug 2008 08:58:52 GMT

HI anand,

This can be accomplished by using standard functionality..You need go for anything else.

Best of luck,

Bhumika.

Re: ALV

former_member386202 — Wed, 20 Aug 2008 09:03:04 GMT

Hi,

User can use standard functionality for that.

Regards,

Prashant

Re: ALV

Former Member — Wed, 20 Aug 2008 09:07:50 GMT

is this possible using standard functinality ? If not how do I go about the same?

yes it is possible. Default subtotal can be done with the help of sort table . if you want to do it after the display you can do it manually , Using SUM button on Qty/currency/number fields and Sort and Subtotal can be done in the display.

if you want it to be shown by Default then you have to use

sort table option.

sort-fieldname = 'WERKS'.
sort-up = 'X'.
sort-subtot = 'X'.
append sort to it_sort.

pass this it_sort to ALV function parameter IT_SORT.

and also you need use DO_SUM = 'X' for the Column which you want totals and subtotals.

Re: ALV

Former Member — Wed, 20 Aug 2008 09:12:04 GMT

Hi Anand,

Check the program inthis link.

http://saptechnical.com/Tutorials/ALV/Subtotals/Define.htm

Regards,

Syf