topic Re: Updating Database Table Using Module POOL. in Application Development and Automation Discussions

Updating Database Table Using Module POOL.

biswajit_das6 — Wed, 10 Dec 2008 09:57:02 GMT

Hi ,

I want to update a database table using module pool.

In screen the value will be given to be updated in database after pressing SAVE button.

Please suggest me how to do that.

here I'm using table control.

Thanks & Regards,

Biswajit

Former Member — Wed, 10 Dec 2008 09:59:34 GMT

First you transfer the data from screen(table control) to the program where your itab is declared

then

case ok_code.

when 'SAVE'.

MODIFY DBTAB from table itab.

endcase.

Best Regards

Ramchander Rao.K

Former Member — Wed, 10 Dec 2008 10:24:06 GMT

Hi,

WHEN 'SAVE'.

Using SELECT query to fetch all the fields and move it to a itab.

IF SY-SUBRC EQ 0.

MODIFY DBTABLE FROM TABLE ITAB.

Note: Internal table should be of the same structure as Database table.

Former Member — Wed, 10 Dec 2008 10:27:24 GMT

if it isstandard table (like vbak is to be updated) then do bdc program for that and attach that bdc program below the save button..

if it is ztable then simply use modify statement......

biswajit_das6 — Wed, 10 Dec 2008 13:16:38 GMT

It is a table control table. Values coming here can be changed and if the change on value made then it needs to be updated in DATABASE