Skip to Content

SOS – my ALV report is not working

ALV dumps

Often, the ALV screen of your report is shown correctly, but using any of the ALV functions will cause a dump, mostly with the message GETWA_NOT_ASSIGNED. In most cases this is caused by an error in the fieldcatalog or in the  sortfields. Fieldnames in both structures must be in upper case and there must be a corresponding component in the output table. An easy way to find out those misconfigured structures is the ALV consistency check.

ALV Grid

You can invoke the ALV consistency check by holding down the SHIFT key and double click with the right mouse button (maybe its the middle button, depends on your mouse/mouse configuration) in an empty area of the ALV Grid, see the pink area in the screenshot below:

Hotspot area for ALV consistency check

After the ALV consistency check is started, you can easily check the layout options, the field catalog, the sort fields and so on. And not even errors are shown up, you should fix the warnings, too. Warnings will be sown shown up if you omit the quantity or currency for example.

ALV consistency check with showing the field catalog

Checking the ALV Grid should always be done after development like checking your sourcecode with the Code Inspector.

The consistency check can be done without the mouse in addition. Switch to the list view by going to  List->Print preview and enter &SOS in the command field.

ALV List

In an ALV list the mouse action does not work, you have to enter &SOS in the command field like described above.

You must be Logged on to comment or reply to a post.
  • Hello Rainer,

    SOS is Cool.

    But Consistency Check fails we try to perform it for the empty ALV output.
    From my actual ALV, I did Shift+2 Right clicks and it opened the Consistency Check. On bottom part of the consistency check ALV (which is empty right now – I haven’t selected any thing to display yet) and try to get the Consistency check for bottom ALV grid and got the GETWA_NOT_ASSIGNED. :). The resaon for this dump is the empty ALV.

    Naimesh Patel

    • I tried that, i’m getting an ALV consistency check with a warning “Output table contains no entries”

      But doing a consistency check on the consistency check reveals two errors 🙂

      Field TABCOL has a wrong value h in FCAT-INTTYPE
      Field TABCOL has a wrong value TTYP in FCAT-DATATYPE

  • same as Guillaume, thank you Rainer! That works well.
    I tested the problem mentioned by Naimesh with an empty internal table, I couldn’t get the dump in grid and list programs (derived from SAP demo programs), so I guess there are other conditions to get this dump.
    • Just another remark, if one gets the dump before the ALV screen is displayed, one may use parameter I_CONSISTENCY_CHECK = ‘X’ in method SET_TABLE_FOR_FIRST_DISPLAY, or call ALV_CONSISTENCY_CHECK function module… or check manually 🙁
    • To be honest i dont know if its working for all methods on how to create an ALV, but it works for all of my ALVs (regardless of FM or class based). But for sure i didnt used all available methods…