Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Updating Database Table Using Module POOL.

biswajit_das6
Participant
0 Kudos

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

4 REPLIES 4

former_member1245113
Active Contributor
0 Kudos

Hi

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
0 Kudos

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
0 Kudos

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..

or

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

0 Kudos

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