LOOP AT mdeqp.
LOOP AT mdcw.
SELECT equnr
FROM viser02
INTO viser02-equnr
WHERE sdaufnr = mdcw-zs_vbeln
AND posnr = mdcw-zs_posnr
AND equnr = mdeqp-equnr.
IF sy-subrc = 0.
mdcw-zs_equnr = viser02-equnr.
ENDIF.
MODIFY mdcw.
ENDSELECT.
ENDLOOP.
ENDLOOP.
i get error not defined viser02-equnr
i tried select single too and it's working.
thanks