Modify table

[Former Member]

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.

[Former Member]

Hey try this,

Modify <dbtab> from <workarea>.

You can fill the values in the work area.

Modify modifies the value when there is no change in the key field and when there is change in the key field the modify statement insert and there will be a new entry in th table.

Regards,

Midhun Abraham

Edited by: Midhun Abraham on Oct 9, 2008 6:30 PM

[Former Member]

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

[Former Member]

you can use MODIFY ...WHERE <CONDITION> TRANSPORTING <f1> <f2>..

just use f1 on Modify.

[Former Member]

wa_source-kunnr = 'XXXXXX'.

wa_source-pfnum = 'XXXXXXXXX'.

wa_source-oamount1 ='XXX'.

...

...

.....

wa_source-oamount5 ='XXX'.

Modify dbtable from wa_source.

If records are more go for itab.

To know more hit f1 on modify .