Show Header and Footer in ALV Grid [english]

In this video I show how to add and show a header and footer in an ALV Grid. For the ALV Grid I use the class CL_SALV_TABLE.
To create the header and the footer I use the class CL_SALV_FORM_LAYOUT_GRID.
Header and Footer can contain important information in addition to the data itself which can be helpful especially for a printout.
Different text objects are used for this purpose.
* Headline/Title
* Action Text
* Groupbox
* Label and Text
#header #footer #alvgrid
▬▬ My Hardware ▬▬▬▬▬▬▬▬▬▬▬▬▬
Microphone: amzn.to/3zj2UIz
Headphone: amzn.to/3GUBRFg
*The links are affiliate links. There are no additional costs.
▬▬ My Software (free) ▬▬▬▬▬▬▬▬▬▬▬
Video Recorder: bit.ly/678fgh6
Video Editor: bit.ly/38Rj9lb
▬▬ Further Links ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Become my subscriber: bit.ly/CustAnd...
All videos in English: bit.ly/CustAnd...

[@vamsinaidu7581]

In this video, everything is on the left side of the header if we want to use both left & right then how can we achieve that?

[@kashifaliakbarali4686]

You deserve more subscribers ❤️ love from PAKISTAN 🇵🇰

[@CustAndCode]

Thank you for your feedback! I appreciate that 🤗🤗🤗

[@rhythmofsoulletsdance]

How can I add some space in same row if we want to print more than one text?

[@CustAndCode]

Unfortunately I do not exactly understand your requirement... 🤔

[@user-ud7bp8xx9u]

Merci

[@CustAndCode]

Thank you! 😀🤗

[@PaliBhangoo]

The header and footer doesn't seem to work when displaying multiple ALV using splitter in Salv

[@CustAndCode]

Ok, I have to check this. I have never used header an footer when I need more then one ALV. In my opinion it then quickly becomes confusing. 🤗😀

[@syedsalman3898]

Hi, can we add dynamic header line or action text based on some gui action in same alv.
for ex. Number of record :20
after some action
Number of processed record :15

[@CustAndCode]

If you know when things are changed you can do this. Will be difficult when you e.g. filter some records. 🤔

[@syedsalman3898]

​@CustAndCode I added the same header properties on function event still its not reflecting.

[@nisargmehta796]

Hello bro, fantastic video again.. have a question regarding the traditional ALV, I have some color information in it (a few cells are colored based on business logic).. but when I export it to excel, it loses all the colors.. do you have a solution to this?

[@CustAndCode]

Thank you! 🤗 I think the color information is unfortunately lost. But I'm not sure whether ABAP2XLSX would offer a solution. 🤔

[@nisargmehta796]

@@CustAndCode Yes, thinking bout using ABAP2XLSX, but since my organization is pretty old school in its thinking, it does not allow access to Github URLs, so cant install it🤣. Would the OLE2 be fine for this?

[@CustAndCode]

@@nisargmehta796 I know what you mean with "old school" 🙈 Unfortunately, I have too little experience with Excel exports so far. But if you find a solution, I would be happy if you share it here. 🤗

[@nisargmehta796]

@@CustAndCode Yeah, will share whatever I end up doing here..thanks 🤘

[@kitsanafreeman6812]

please show how to show first date and last date in header, how to print this alv

[@CustAndCode]

Ok, I have to try it 😀

[@CustAndCode]

Ok, for the max and min. Write this into a variable e.g. with SELECT max from... and show it in the header like I show my strings here. Instead of the string you put the variable with the max and min value of your table. 🤗