Skip to Content
0
Former Member
Sep 26, 2008 at 12:28 AM

how to write select within select in ABAP

13199 Views

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