Skip to Content
0
Dec 05, 2009 at 01:28 PM

Query on internal table

16 Views

Hi All,

Please resolve the following quiery:

The internal table itab1 is as follows;

A B C

1 X 12

2 X 11

3 X 9

4 Y 1

5 Y 3

6 Y 5

7 Z 22

8 Z 4

9 Z 7

10 Z 8

The totals of all values corresponding to x,y and z are sotred as follows in itab2:

A B c

X 32

Y 9

Z 41

Now the above two tables has to be combined and display the output in below format:

That is the total correspnding to X should come first before the X vaues are started.

That is the total correspnding to Y should come first before the Y vaues are started.

That is the total correspnding to Z should come first before the Z vaues are started.

The final output ih itab3 is as follows:

A B C

X 32

1 X 12

2 X 11

3 X 9

Y 9

4 Y 1

5 Y 3

6 Y 5

Z 41

7 Z 22

8 Z 4

9 Z 7

10 Z 8

Please do the needful at the earliest.

Regards,

A.Srinivas