What is this? Update for all is bad

This question is answered

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?

Correct Answer

October 18, 2007 at 16:40 PM

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.

0 Likes 0 View this answer in context