select single matnr
werks
into marc
from marc
where matnr = 'ETEST1'
and werks = '0001'.
Output comes as 1
whereas table contains values as shown, what could be the issue.
