topic Re: single Update stmt.. for 2 fields in Application Development and Automation Discussions

single Update stmt.. for 2 fields

Former Member — Thu, 09 Aug 2007 06:57:40 GMT

Hi everyone,

I have to update 2 fields in my table zsd47_loc_master. I have used 2 update stmts.. for each field. Is it possible to update the table using single stmt.. ?

UPDATE zsd47_loc_master SET capacity = capacity - 1

WHERE location = wk_location

AND status = 'A'.

UPDATE zsd47_loc_master SET status = 'P' WHERE location = wk_location

AND status = 'A'.

thanks in advance,

regards,

Stanley.

Re: single Update stmt.. for 2 fields

Former Member — Thu, 09 Aug 2007 07:01:11 GMT

HI,

You can use a single statment ..

UPDATE zsd47_loc_master

SET capacity = capacity - 1

status = 'P'

WHERE location = wk_location

AND status = 'A'.

Regards

Sudheer

Re: single Update stmt.. for 2 fields

Former Member — Thu, 09 Aug 2007 07:01:39 GMT

Hi Jose,

Yes, You can do this with the help : in ABAP and don't forget to put comma after setting a value to the field.

UPDATE zsd47_loc_master

<b>SET: capacity = capacity - 1,

status = 'P'</b>

WHERE location = wk_location

AND status = 'A'.

Check this link which has example

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/update.htm

<b>Friendly Note:</b> You have many open threads and Plz close the threads if they are answered/solved and reward points to the people who are helping you.

Thanks,

Vinay

Re: single Update stmt.. for 2 fields

Former Member — Thu, 09 Aug 2007 07:03:54 GMT

Use a single update statement.


UPDATE zsd47_loc_master SET: capacity = capacity - 1
status = 'P'
WHERE location = wk_location
AND status = 'A'.

Please mark points if the solution was useful.

Regards,

Manoj

Re: single Update stmt.. for 2 fields

RaymondGiuseppi — Thu, 09 Aug 2007 07:14:08 GMT

Try the following syntax

  UPDATE zsd47_loc_master
    SET: capacity = capacity - 1,
         status = 'P'
    WHERE location = wk_location
      AND status = 'A'.

Regards