Skip to Content

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

Modify table

Hi All,

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.

Thanks,

Veni.

Tags:
replied

Hi,

You can use use the UPDATE statement with the SET addition.

Ex..

UPDATE ztable 
              SET oamount1 = '1'
                     oamount5 = '1'
              WHERE kunnr = 'customer number'
              AND      pfnum = 'PF number'.

Thanks

Naren

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question