topic Re: what is wrong with this UPDATE code... in Application Development and Automation Discussions

what is wrong with this UPDATE code...

Former Member — Mon, 24 Sep 2007 09:30:23 GMT

what is wrong in this code..

it is updating all the records of the table

UPDATE t001b CLIENT SPECIFIED

SET : frpe1 = uv_pperiod,

frye1 = uv_pyear,

tope1 = uv_npperiod,

toye1 = uv_npyear

WHERE mandt = sy-mandt

AND rrcty = '0'

AND bukrs = uv_bukrs

AND mkoar = ls_add_spec-mkoar

AND vkont = ls_add_spec-vkont

AND bkont = ls_add_spec-bkont.

Title was edited by:

Alvaro Tejada Galindo

Re: what is wrong with this UPDATE code...

Former Member — Mon, 24 Sep 2007 09:33:31 GMT

Pl make sure the values in thw WHERE clause are NOT blank/initial.. else your sitaution will occur ie ALL UPDATE..

Arya

Re: what is wrong with this UPDATE code...

Former Member — Mon, 24 Sep 2007 09:36:41 GMT

Hi,

can you please check the values before executing the UPDATE satatment, please check the valuesin the where condition, only those values will be updated ..

Regards

Sudheer

Re: what is wrong with this UPDATE code...

Former Member — Mon, 24 Sep 2007 09:42:39 GMT

Hi,

pls check whether values are passed in ls_add_spec-mkoar, ls_add_spec-vkont, ls_add_spec-bkont and uv_bukrs

because if these are blank then all rows in table will be updated.

syntax is:

update table set fld1 = wa-fld1 where fld2 = wa-fld2.

Re: what is wrong with this UPDATE code...

hymavathi_oruganti — Mon, 24 Sep 2007 09:42:47 GMT

what error u r getting?