Shortdump @ alv grid program

[Former Member]

Hi,

we have a problem with our alv grid program.

Here is the coding:

*Varibalendeklaration
DATA:   wa_buero TYPE zd06_buero.
DATA:   it_buero LIKE TABLE OF wa_buero.

*Selectierung und Sortierung
SELECT agencynum COUNT( * ) AS zcount
       INTO CORRESPONDING FIELDS OF TABLE it_buero
       FROM sbook
       GROUP BY agencynum
       ORDER BY zcount DESCENDING.


*Den Dynpro aufrufen
CALL SCREEN 103.


*&---------------------------------------------------------------------*
*&      Module  STATUS_0103  OUTPUT
*&---------------------------------------------------------------------*
*       text
*----------------------------------------------------------------------*
MODULE status_0103 OUTPUT.

*Aufrufen des von Hendrik erstellten Funktionsbaustein zum Aufruf des
*Alv Grids

  CALL FUNCTION 'ZD06_06_ALV'
    EXPORTING
      container_name_in   = 'CONTAINER_1'
      i_structure_name_in = 'ZD06_BUERO'
    CHANGING
      it_outtab_in        = it_buero.
  .
ENDMODULE.                 " STATUS_103  OUTPUT

We have just create an new DDIC Structure with the points we need.

Our referent can't solve the problem and know I need your help.

Thanks.

Best Regards,

Marcus

[former_member69765]

what exactly are you trying to do...

I believe this is a Report program and you are doing the ALV grid by Object Oriented principles.

If yes .. then this is not the way to do...

And can you plz tell what is this FM - ZD06_06_ALV for ????

Also could you please give the exact reason of the Dump... you have not mentioned the reason of dump.

I believe it is due to the null reference ...

Plz revert back with these anwers... this will help in solving the issue.

[Former Member]

Hi,

thank you for answering.

The programm take a travelagencynumber from dbtab sbook. There also is a counter who sort and count the agencynumbers. The programm should tell us, how many books are done with this agency. e.g.: Travelagency 98565 1358 books

ZD06_06_ALV is a function for alv grid. The code for this function is:

*"----------------------------------------------------------------------
*"*"Lokale Schnittstelle:
*"  IMPORTING
*"     REFERENCE(CONTAINER_NAME_IN) TYPE  CHAR30
*"     REFERENCE(I_STRUCTURE_NAME_IN)
*"  CHANGING
*"     REFERENCE(IT_OUTTAB_IN)
*"----------------------------------------------------------------------

  DATA: container_r TYPE REF TO cl_gui_custom_container,
        grid_r      TYPE REF TO cl_gui_alv_grid.

  CREATE OBJECT container_r
   EXPORTING container_name = container_name_in.
  CREATE OBJECT grid_r
  EXPORTING i_parent = container_r.
  CALL METHOD grid_r->set_table_for_first_display
    EXPORTING
      i_structure_name = i_structure_name_in
    CHANGING
      it_outtab        = it_outtab_in.

ENDFUNCTION.

The dump reason is

Runtime error: DBIF_RSQL_INVALID_RSQL

We set a breakpoint at the select statement and there is the problem. exactly there is the dump.

Best Regards.

Marcu

[Former Member]

Hi,

Let me know the structure of the table 'zd06_buero' ,might be here is the problem of defining this table strucuter..

Regards,

Satya.

[Former Member]

Hi,

my friend Hendrik create a new structure and know its ok.

I think there was a little problem.

Thank you for you help. The sdn is a very good and useful platform.

Thank you.

Best Regards,

Marcus

[Former Member]

Hi Markus,

Change ur declarations like this

DATA:   wa_buero TYPE zd06_buero.
DATA:   it_buero type standard TABLE OF zd06_buero.

wa_buero is not a table , so when u use it_buero in the select statement because it is not a table