topic ALV with 3 headers in Application Development and Automation Discussions

ALV with 3 headers

Former Member — Fri, 15 Nov 2013 07:06:34 GMT

Hi Friends,

My business requirement is to provide a list of Sales revenue report by 3 header field details as the image attached below. This is a dynamic table report output where each month of sales to be listed by Material weight item levels based on country keys. Please guide me which ALV function module or which way I can implement this requirement. This report output also to be exported as excel sheet manually by the user.

Thanks & Regards,

Saravanan

Re: ALV with 3 headers

rosenberg_eitan — Fri, 15 Nov 2013 07:54:14 GMT

Hi,

As far as I know (prove me wrong some one, Please !!!) there is none .

But I had similar request and finely I settled to generate html and

and pesenting it using excel 😞 .

You can use the span see here http://www.w3schools.com/tags/att_th_colspan.asp

Sample:

<html>

<head>

<title>Insert title here</title>

<style>

table {

border: 1px solid black;

border-collapse: collapse;

}

th {

border: 2px solid black;

padding: 5px;

text-decoration: underline;

color: blue;

text-align: center;

}

td {

border: 2px solid black;

padding: 5px;

text-align: center;

}

</style>

</head>

<body>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</body>

</html>

Result:

Regards.

Re: ALV with 3 headers

Former Member — Fri, 15 Nov 2013 11:48:56 GMT

We can get but not with merged cells

Re: ALV with 3 headers

former_member209120 — Sat, 16 Nov 2013 04:22:01 GMT

This message was moderated.

Re: ALV with 3 headers

Former Member — Sat, 16 Nov 2013 09:17:06 GMT

If columns under each month of sales (i.e) Material weight item levels based on

country keys is constant for every month.

Then you can use 'REUSE_ALV_LIST_DISPLAY' and in TOP_OF_PAGE event you can use conventional Write statement within the loop of no. of months to be print . this is just like hard coding title position

Note: try to adjust the position of printing vertical lines based on your cell width,

in other ALV methods you cannot merge the cells.

If columns under each month of sales varies then it is not possible to display in above method.

Re: ALV with 3 headers

Former Member — Sun, 17 Nov 2013 17:17:15 GMT

Hi,

Thanks to all.

I will try with your inputs and complete the report. If it matches to my expected requirement I will come back and close this thread with points again.

Regards.