Skip to Content
0
Former Member
Aug 18, 2005 at 03:03 PM

Combining queries.

12 Views

Hi,

Is there a code when we can combine the following three queries in one and imprrove performance

DATA: XAUFPL LIKE AFKO-AUFPL,

XARBPL LIKE CRHD-ARBPL,

XARBID LIKE V_QAPO-ARBID.

SELECT SINGLE AUFPL FROM AFKO INTO XAUFPL WHERE AUFNR = '007200000059'.

SELECT SINGLE ARBID FROM V_QAPO INTO XARBID WHERE AUFPL = XAUFPL AND VORNR = '0020'.

SELECT SINGLE ARBPL FROM CRHD INTO XARBPL WHERE OBJID = XARBID.

WRITE: / XARBPL.