I have around 20 fields in a custom table. Kunnr and pfnum are the primary keys. I need to modify few fields oamount1 to oamount5 for the table based on the primary key values. Remaining fields values should not be changed.
Please help me.
You can use use the UPDATE statement with the SET addition.
UPDATE ztable SET oamount1 = '1' oamount5 = '1' WHERE kunnr = 'customer number' AND pfnum = 'PF number'.