how can we update data base table in an report program

[Former Member]

can any one explain in detail how can we update data base table in an report program

[andreas_mann3]

hi,

pls look here:

http://help.sap.com/saphelp_47x200/helpdata/en/41/7af4b6a79e11d1950f0000e82de14a/frameset.htm

A.

[Former Member]

Hi,

it's very simple,

suppose take a dbtable <b>'SBOOK'</b>

if you want to update <b>CONNID</b> value with some other value where <b>CARRID = 'abc'</b> suppose.

then

tables: sbook.

<b>update sbook set connid = 45 where carrid = 'abc'.</b>

the existing value of connid chages

please assign points if it helps you

Regards,

Sowjanya

[Former Member]

Raja,

you can insert, modify and delete DB records usign work area as following stmets..

INSERT INTO zppa_idr_payscal VALUES wa_payscal.

MODIFY zppa_idr_curr FROM wa_curr.

DELETE TABLE t_jobs FROM wa_jobs.

-Anu

[Former Member]

Hi

U can use update or modify statement to update database tables.