What is this? Update for all is bad
Hi
I have written:
update z_table
SET: bukrs = 'AB' , po = '01'
where sapuser = 'MEE'.
And i look to the se16 for z_table and I see that all records
have bukrs = 'AB' but only one record have sapuser = 'MEE'.
Why this update all records not only one?
Tags:
Srinivas Adavi replied
Change it to
UPDATE z_table SET bukrs = 'AB' po = '0000000001' WHERE sapuser = 'MEE'.
Note that PO (if it is purchase order) is stored internally with leading zeros.