Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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:
Former Member
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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question