problem with update

[Former Member]

Hi,

I have problem with update, why this simple part of program doesn't work?

UPDATE zvratka_prijemky

SET spz = 'test'

WHERE mblnr_101 = '5000084938'

AND zeile_101 = '0001'.

write SY-SUBRC.

sy-subrc returns 4.

thanks.

[Former Member]

Hello,

Are u passing values to all the key feields of the Z table . Check this.

UPDATE zvratka_prijemky
SET spz = 'test'
WHERE mblnr_101 = '5000084938' 
AND zeile_101 = '0001'. 
commit work and wait.  " Check here

Vasanth

[Former Member]

Hi

sy-subrc returns 0 but the value still doesn't appear in table.

[Former Member]

Hello,

Always use MODFY statement.

Do like this.

data: wa like zvratka_prijemky.

select single * from zvratka_prijemky into wa where mblnr_101 = '5000084938' 
AND zeile_101 = '0001'.
if sy-subrc = 0.
wa-spz = 'test'.
modify zvratka_prijemky  from wa.
endif.

Hope this solve ur issue.

Vasanth

[Former Member]

Thaks so much, it solves my problem.