SAP R/3 форум ABAP консультантов

[admin]

Author: J.Jayanthi

Description:
This document describes how to make the column as editable get the edited values in internal table save the edited values in database and refreshing the grid for display in ALV using OOPS method.

This document considers a scenario that after output is displayed, user edits the Material description and then he will select the edited rows. Once he presses save, that edited values will be updated in database.

Applies to
SAP R/3 Enterprise Version

Procedure
Step 1: Make the column as Editable by modifying the fieldcatalog table.

* Making the column as ediable
LOOP AT i_fieldcat ASSIGNING <fs_fieldcat>.
CASE <fs_fieldcat>-fieldname.
WHEN 'MAKTX'.
* Making a column as Editable
<fs_fieldcat>-edit = 'X'.
ENDCASE.
ENDLOOP.

Step 2: In PBO, code should be written to register the edit.

call method o_grid->register_edit_event
exporting
i_event_id = cl_gui_alv_grid=>mc_evt_modified.

Step 3: In PAI, write the code to capture the selected rows in internal table and then save it to database(once SAVE button is clicked).
MODULE user_command_9000 INPUT.
DATA lv_ucomm TYPE sy-ucomm.
lv_ucomm = sy-ucomm.
CASE lv_ucomm.
.....
WHEN 'SAVE'.
perform save_database.
CALL METHOD O_GRID->REFRESH_TABLE_DISPLAY.
ENDCASE.
ENDMODULE. " USER_COMMAND_9000 INPUT

FORM save_database .
* Getting the selected rows index
CALL METHOD O_GRID->GET_SELECTED_ROWS
IMPORTING
ET_INDEX_ROWS = i_selected_rows.
* Through the index capturing the values of selected rows
loop at i_selected_rows into w_selected_rows.
read table itab into wa index w_selected_rows-index.
if sy-subrc eq 0.
move-corresponding wa to w_modified.
append w_modified to i_modified.
endif.
endloop.
modify zzzmaterial from table i_modified.
endform. " save_database

Complete Code

Screen 9000, GUI Status ZSTATUS and GUI Title ZTITLE should be created and in Flow logic of the screen, PBO and PAI should be uncommented.