topic Re: Modify table in Application Development and Automation Discussions

Modify table

Former Member — Thu, 09 Oct 2008 16:27:17 GMT

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.

Re: Modify table

Former Member — Thu, 09 Oct 2008 16:29:44 GMT

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

Re: Modify table

Former Member — Thu, 09 Oct 2008 16:29:54 GMT

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

Re: Modify table

Former Member — Thu, 09 Oct 2008 16:31:17 GMT

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

just use f1 on Modify.

Re: Modify table

Former Member — Thu, 09 Oct 2008 16:34:08 GMT

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 .