topic Re: handling database tables in Application Development and Automation Discussions

handling database tables

Former Member — Tue, 03 Oct 2006 08:49:28 GMT

how can we do insert, update or delete in a database table using module pool i.e. push buttons on a screen

Former Member — Tue, 03 Oct 2006 08:51:51 GMT

Hi Tarka,

You can show the table data in table control, allow user to modify the data, and then update your ztable using the contents of your table control.

Regards,

Raj

Former Member — Tue, 03 Oct 2006 08:53:10 GMT

Hi tarka,

1. push button will trigger some fcode.

2. Inside the code, we have to write the logic

to update the table.

3. suppose your whole data is in ITAB.

4. then we can simply use

5. LOOP AT ITAB.

MODIFY ZDBTABLE FROM ITAB.

ENDLOOP.

5. This MODIFY statement will automatically

take care of insert/update

based upon the primary key found/not found

in the ztable.

regards,

amit m.

Former Member — Tue, 03 Oct 2006 08:53:48 GMT

Hi Tarka,

Assign FCODE `INSERT`, `DELETE` to the buttons in screen layout.

<b>In flow logic :</b>

PROCESS AFTER INPUT.

MODULE USER_COMMAND_100.

case okcode.

when `INSERT`.

insert into ztable values watab .

when `DELETE`.

DELETE FROM ZTABLE where matnr = watab-matnr.

endcase.

END MODULE.

Best regards,

Prashant