text in the first column

[Former Member]

1st requirement:

Output of my report having two columns:

First column's display will be like below:

2nd cell of first column will display the text: 'Total'

4th cell of first column will display the text: 'City Office'

6th cell of first column will display the text: 'branches'

7th cell of first column will display the text: 'branch1'

8th cell of first column will display the text: 'branch2'

9th cell of first coumn will display the text: 'branch3'

10th cell of first column will display the text: 'branch4'

12th cell of first column will display the text: 'accounts'

14th cell of first column will display the text: 'Account A'

15th cell of first column will display the text: 'Account B'

16th cell of first column will display the text: 'Account C'

corresponding numeric cash values will be displayed rowwise in the second column.

(i.e. 2nd cell of second column will display total cash in numeric value.

4th cell of second column will display cash for city office in numeric value......etc.)

and so 1st row, 3rd row, 5th row, 11th, 13th rows of 1st and second both columns are blank.

how can i do this using my alv report?

kindly suggest.

[Former Member]

1st requirement:

Output of my report having two columns:

First column's display will be like below:

2nd cell of first column will display the text: 'Total'

4th cell of first column will display the text: 'City Office'

6th cell of first column will display the text: 'branches'

7th cell of first column will display the text: 'branch1'

8th cell of first column will display the text: 'branch2'

9th cell of first coumn will display the text: 'branch3'

10th cell of first column will display the text: 'branch4'

12th cell of first column will display the text: 'accounts'

14th cell of first column will display the text: 'Account A'

15th cell of first column will display the text: 'Account B'

16th cell of first column will display the text: 'Account C'

corresponding numeric cash values will be displayed rowwise in the second column.

(i.e. 2nd cell of second column will display total cash in numeric value.

4th cell of second column will display cash for city office in numeric value......etc.)

and so 1st row, 3rd row, 5th row, 11th, 13th rows of 1st and second both columns are blank.

how can i do this using my alv report?

kindly suggest.

[MarcinPciak]

Hi,

Pass below table to your alv:

data: begin of itab occurs 0,
         text(15) type c,
         val type p decimal 2,
       end of itab.

"1st row
append intial line to itab.
"2nd
itab-text = 'Total'.
itab-val = "your value here
append itab.
"3rd
append initial line to itab.
"4th
itab-text = 'City Office'.
itab-val = "your value here
append itab.

"and so on...

I hope it will help:)

Regards,

Marcin