Regards update

[Former Member]

Hi

im working to update table on the DB and for instance i check the value from <ls_obt>

when the specific DB records is exactly the same and after the update is done i get sy-subrc = 0 and sy-dbcnt = 1. but the records is the same way the update process is done?

this is the regular behavior ?

there is a way to do update just if the recodes is different?

UPDATE (lt_table) FROM <ls_obt> .

Br

Nina

[Former Member]

HI,

UPDATE statment update's the database table from the work area if the record exists with the same Primary key as of in workarea.

Else if doesnot exist then inserts the record into the DB Table.

Check the F1 help for more info on UPDATE statement.