Combining queries.

Former Member — Thu, 18 Aug 2005 15:03:37 GMT

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.

Re: Combining queries.

Former Member — Thu, 18 Aug 2005 15:12:14 GMT

you can try this:

SELECT SINGLE CRHD~ARBPL

FROM AFKO

INNER JOIN V_QAPO ON V_QAPO_{AUFPL = AFKO}AUFPL

INNER JOIN CRHD ON CRHD_{OBJID = V_QAPO}ARBID

INTO XARBPL

WHERE AFKO~AUFNR = '007200000059'

AND V_QAPO~VORNR = '0020'.

WRITE: / XARBPL.

Hope it will be helpful

Thanks