topic Re: modifying DB table in Application Development and Automation Discussions

modifying DB table

former_member671224 — Tue, 28 Aug 2007 00:11:58 GMT

Hi,

Im populating the internal table from DB table. and deleting one record from that internal table. and also im changing one record in that internal table. so the same should be updated to DB table also.<b>ie.,</b> deleted record should be deleted in DB table and also modified record should be modified in DB table.

How i can do this?

Regards,

Amal

Re: modifying DB table

former_member192429 — Tue, 28 Aug 2007 00:27:39 GMT

How are you displaying internal table from DB table or modifying the internal table? Are you using any Table control in screens?

-Kriss

Re: modifying DB table

Former Member — Tue, 28 Aug 2007 00:44:52 GMT

Hi here is what the code should look like...


data : tab1 type standard table,
         tab2 type standard table.

select * from DBTAB into table tab1.

tab2[] = tab1[].

*** change table one!

loop at tab2 into wa_tab2.

read table tab1 with key....
if sy-subrc ne 0. " record was deleted from tab2
delete DBTAB where KEY
endif.
endloop.

Re: modifying DB table

kishorepallapothula — Tue, 28 Aug 2007 01:15:47 GMT

hI stephen,

use modify <db tab name> while looping the valies from itab.

reward if useful.

kishore