Skip to Content
0
Former Member
Nov 22, 2008 at 01:37 PM

queries on ALV Sub totalling

40 Views

Hi all,

I have a requirement to change few fields in existing ALV.

1) i have data like this in ALV.

GROUP G/L ACCOUNT LC USD

100 10 5 5

100 11 6 4

100 12 3 3

100 11 3 2

200 10 5 5

200 11 6 4

200 12 3 3

200 11 3 2

now for particular GROUP (ex: 100) i need the sub totals of LC(5633=17) and USD(5432=14)

it should be shown before the GROUP 200 begins.

now the output should come as:

GROUP G/L ACCOUNT LC USD

100 10 5 5

11 6 4

12 3 3

11 3 2

TOTAL 17 14

200 10 5 5

11 6 4

12 3 3

11 3 2

TOTAL 17 14

Is there any way to do this..please help

thanks,

prasanth