topic update DB table in Application Development and Automation Discussions

update DB table

Former Member — Mon, 21 Sep 2009 20:24:06 GMT

HI ,

Can i update fields in DB that are key ?

for example .

if i have fields

and all the fields are keys and i want to do update it in the DB to

user 123 key

username Joy key

address Germany key

Can i do so since when i try to do UPDATE (mt_table_name) FROM <ls_object>.

i get sy-subrc = 4.

and in the DB table i have the record like

UPDATE (mt_table_name) FROM <ls_object>.

Regards

joy

former_member156446 — Mon, 21 Sep 2009 20:29:33 GMT

read the SAP help in Modify statement.

former_member191735 — Mon, 21 Sep 2009 20:33:37 GMT

You can update (if your company allowed you to do this). If there is already a record in the table with the same key, it gives you an error

if you use modify statement; The data will be modified if there is a record with the same key else the record will be inserted.

All in all, you cannot have 2 records with same key

Good luck