what is wrong with this UPDATE code...

[Former Member]

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

[Former Member]

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

Arya

[Former Member]

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

[Former Member]

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.

[hymavathi_oruganti]

what error u r getting?