Hi,
Use the below code:
select single ernam "User Name
from konh
into v_konh
where ernam = 'SAM'.
(The above code will fetch 'SAM' into variable v_konh)
Then:
select vbeln "Sales Orders
from vbak
into table i_vbak
where ernam = v_konh.
(This code will fetch all sales orders of SAM)
<b>Reward points if helpful.</b>
