[{ALLOW view All}]
[{ALLOW edit Authenticated}]

! ALV = Automatic List Viewer / SAP List Viewer (Control)

[NW 7.0|http://help.sap.com/saphelp_nw70/helpdata/en/bc/e5eb40c4f8712ae10000000a155106/frameset.htm] /
[NW 7.3|http://help.sap.com/saphelp_nw73/helpdata/de/4e/c1f117076868b8e10000000a42189e/content.htm?frameset=/de/59/e3eb40c4f8712ae10000000a155106/frameset.htm] |
[Word Wrap|http://scn.sap.com/docs/DOC-10351]

!Use your own screen status
If you did so and change the GUI STATUS later, the buffer gets not refreshed with a transport. To do so use report [BALVBUFDEL|http://www.stechno.net/sap-notes.html?view=sapnote&id=339258] !

! Consistency check for field list
# Located the gray table background (if your ALV fills up the full screen, then scroll to the bottom and use the small bar at the end)
# Hold down __shift__ key and __double click right__ on that background

! Excel View

If you click on the Excel button and get no data, do the following:

Office 2007:
# Enable Developer Toolbar under General Settings
# Developer Toolbar > Macro Security > Enable "Trust VBA Projects"

Office 2003:
# Menu > Extras > Makros > Sicherheit ... > Vertrauenswürdige Herausgeber
# Check "Zugriff auf Visual Basic-Projekt vertrauen"

!Output Format in Excel
# Best output in Excel is the format "__Excel (im Office 2007 XLSX Format)__". This saves the list to a file first, but it is fast and the data are not crumbled.
# If you once hit "Immer das gewählte Format anwenden" (Always use the chosen format), then you are not asked anymore. If you want to change the format inspite of that you can __right click__ anywhere __in the ALV data table__ and choose "Tabellenkalkulation..."
# You can change the output format with report [SALV_BS_ADMIN_MAINTAIN|http://blog.hr-manager.de/2013/08/alv-excel-vorgabe-downloadformat-excel.html]
# General hints changing the output format are in [note 1720373|http://service.sap.com/sap/support/notes/1720373]