ALV

[Former Member]

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

[Former Member]

HI anand,

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

Best of luck,

Bhumika.

[former_member386202]

Hi,

User can use standard functionality for that.

Regards,

Prashant

[Former Member]

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.

[Former Member]

Hi Anand,

Check the program inthis link.

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

Regards,

Syf