topic Re: ALV grid in Application Development and Automation Discussions

ALV grid

Former Member — Mon, 04 Aug 2014 06:53:49 GMT

Is there any way to refresh ALV grid after executing native SQL, like this:

exec sql.

update tbl1 set some_fld=<some value>

endexec.

<refresh ALV grid>.

ALV grid is showing table tbl1.

thanks in advance

Re: ALV grid

former_member202818 — Mon, 04 Aug 2014 06:57:26 GMT

Hi,

CALL METHOD gr_alvgrid->refresh_table_display

* EXPORTING

* IS_STABLE =

* I_SOFT_REFRESH =

EXCEPTIONS

finished = 1

OTHERS = 2 .

IF sy-subrc <> 0.

*--Exception handling

ENDIF.

Parameter Meaning

IS_STABLE

If the row or column field of this structure is set, the position of the scroll bar for the rows or columns remains stable.

I_SOFT_REFRESH

This parameter is used only in exceptional cases. If you set this parameter, any totals created, any sort order defined and any filters set for the data displayed remain unchanged when the grid control is refreshed. This makes sense, for example, if you have not modified the data of the data table and want to refresh the grid control only with regard to layout or field catalog changes.

Regards

Sreekanth

Re: ALV grid

Former Member — Mon, 04 Aug 2014 07:18:08 GMT

Thanks you for your answer.

But unfortunately this does not work in my case. I have a main program where the data loads in ALV gris in Screen 0100 (see main.txt). Then, in USER_COMMAND_0100 input on TEST button of screen 0100 i have:

module USER_COMMAND_0100 input.

   case OK_CODE.
     when 'TEST'.
       exec sql.
         update "/DURS/OOOP_PORO"
         set     FLD1=22.
       endexec.

       CALL METHOD GRID->refresh_table_display
*       EXPORTING
*         IS_STABLE =
*         I_SOFT_REFRESH =
       EXCEPTIONS
         finished = 1
       OTHERS = 2 .

       IF sy-subrc <> 0.
*      --Exception handling
       ENDIF.

     when 'EXIT'.
       leave program.
   endcase.

endmodule.

I believe the problem is in native sql and SAP does not refresh data of table which is a part of data dictionary, but used in native sql. Is there any way to do it ?

regards

Miran

Re: ALV grid

Former Member — Mon, 04 Aug 2014 07:21:35 GMT

Aha, now I see - I must reload data to see the changes.

regards

Miran

Re: ALV grid

rosenberg_eitan — Mon, 04 Aug 2014 07:35:04 GMT

Hi,

The same thing also true for open SQL .

There is no automatic binding between the SQL results and the presentation .

Welcome to wonderful world of ABAP......

Regards.

Re: ALV grid

Former Member — Mon, 04 Aug 2014 07:37:51 GMT

Thank you for your answer.

Database without query performing in 21. century, eh

Re: ALV grid

rosenberg_eitan — Mon, 04 Aug 2014 07:45:55 GMT

Hi,

If you are interested in native sql then check this article:

Regards.

Re: ALV grid

Former Member — Mon, 04 Aug 2014 07:47:58 GMT

Thanks.