cancel
Showing results for 
Search instead for 
Did you mean: 

Text for Total and Subtotal rows in ALV

Former Member
0 Kudos

Hello All

I wanted to show Text for Totals and Subtotals in ALV. I couldn't find any solution in old posts. Please help me in this

I have columns A B C the column C is having numeric field remaining fields are text fields. I am getting Totals and Subtotals by aggrtype_total and create_sort_rule(group_aggregation = abap_true), I applied sort_rule on both A and B fields for subtotals

 
A	B	C
Apples	Red	2
	Red	3
Apples	Red	5
Apples	Green	6
Apples	Green	6
Apples		11
Oranges	Grade1	6
	Grade1	6
Oranges	Grade2	8
	Grade2	3
	Grade2	11
Oranges		17
		28


I need in below format 

Apples	Red	2
	Red	3
Red Total		5
	Green	6
Green Total		6
Apples Total		11
Oranges	Grade1	6
Grade1 Total		6
Oranges	Grade2	8
	Grade2	3
Grade2 Total		11
Oranges Total		17
Total Fruits		28
 

My requirement is to provide only one text in the total row like u201CTotal Applesu201D and in the last row i need to provide text as "Grand Total" and grouping for column A

Please suggest me the possible way to achieve this.

Thanks,

Venkat.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Venkat,

I hope you would have solved this issue.

My requirement is also the same.

kindly help to solve.

In my alv list 6 columns are available.

1) Region

2)Section

3)Group

4)G/L account no

5) Amount

6)Currency key

I want to show

Total

Region Total

Inside region Total

Each section Total

Inside Each section total have

Each group total

Inside Each group total have

G/L account Total

Inside G/L account Total have

Different Currency key

In the total for sub groups and final total with out any text or Description getting only single or double or triple ( dots ) ..

Is it possible to populate / change with useful text or decription for those rows.

I am not getting Currency type after the total/sub totals.

how to fix this in ALV list after using aggregate for the ALV.

Thanks in advance.

Dav