Hi Guys
I want to write a select statement in ABAP to select from 2 tables below is my code I want to write select within select statment in --->A and replace with ---> B
FORM sales_production_order USING p_vbeln TYPE vbeln_va
CHANGING p_aufnr TYPE aufnr
p_rtcod TYPE sysubrc.
CLEAR: p_rtcod,
p_aufnr.
A *******
SELECT aufnr FROM aufk INTO p_aufnr UP TO 1 ROWS
WHERE kdauf EQ p_vbeln .
B *******
SELECT kdauf from aufk into p_aufnr UP TO 1 ROWS
WHERE KDAUF IN ( SELECT VBELN FROM VBAP where vbeln EQ p_vbeln) .
ENDSELECT.
p_rtcod = sy-subrc.
ENDFORM. " sales
T