ALV Problem

[Former Member]

Hi,

Good Evening guys,

I need a alv report one which is going to disply Items and then diplay the subtotal wih out useing control break events.

Normally we can get the subtotal after Items disply through using the AT END OF. But i need to get it with out using controll break events.

Regards

R.Reddy.

[Former Member]

In the layout variable there's a field, I think it's called do_sum that let's you point the fields that you want to sum. You just need to set it to X in the appropiate fields.

[Former Member]

Hi,

thank you for reply. Actually if ive 9 agencies ... i need to get every agency items displys and then subtotal

like:

agency

-

---

a 10

a 10

tot 20

b 10

b 10

tot 20

how can we do through alv feild cataglog.plz advice me

regards

rreddy

[peter_ruiz2]

Hi Reddy,

When creating the field_catalog for you report, assing X as a value for do_sum on each field that you require to have a sub-total value.

Then, on your Layout, assign space as value for the field NO_TOTLINE.

Regards,

Peter

[Clemenss]

Hi Reddy,

the ALV display does it for you.

Check the documentaion about [Calculating and Deleting Subtotals|http://help.sap.com/erp2005_ehp_02/helpdata/en/ee/b99d37e188a049e10000009b38f8cf/content.htm]

Save it as default layout, you may transport the layout.

Regards,

Clemens

[Former Member]

Hi,

user It_sort for subtotaling and pass to ALV FM.

Edited by: Rasheed salman on Feb 11, 2010 6:50 AM

[Former Member]

Hi,

Refer to this link:

[http://wiki.sdn.sap.com/wiki/display/Snippets/DisplaysubtotaltextinALV+grid]

This gives a similar output as required by you.

Hoping this helps,

Thanks & Regards,

Komal

[Former Member]

done