ABAP DOUBT

[Former Member]

Hi friends,

when i update a record in database table using update query all records are updated . what's the reason anyone can tell me.

[Former Member]

Hi,

I think u didn't used Where Condition.

Regards,

Padmam.

[Former Member]

In update statement specify the condition using WHERE.With out this condition the update statement will update all records in u r table.

[Former Member]

hi varadarajan ,

can u paste the update statement here

thanks,

ravinder

[Former Member]

hi,

i think u used in a loop. for updating a single record use index as

update table tablename index sy-index [ current record gets updated].

if helpful reward some points.

with regards,

suresh babu aluri.

[Former Member]

Hi,

If you are using a loop to update the table, use the work area from which you are

updating the values. The work are must have the primary keys of the table.

Thanks.

Abhijit