Skip to Content
0
Former Member
Sep 28, 2005 at 11:57 PM

Select query failing here ?

154 Views

Hi,

Following is the flow chart of my data selction:

AUFNR

AUFPL (from TABLE AFKO using AUFNR)

ARBID (from Table V_QAPO using AUFPL)

ARBPL (from Table CRHD using ARBID )

REPORT ZTEST1.

TABLES: AFKO, V_QAPO, CRHD.

DATA: BEGIN OF INTERNAL OCCURS 100,

XARBPL LIKE CRHD-ARBPL,

XAUFPL LIKE AFKO-AUFPL,

XVORNR LIKE V_QAPO-VORNR,

XARBID LIKE V_QAPO-ARBID,

END OF INTERNAL.

SELECT CRHDARBPL AFKOAUFPL V_QAPOVORNR V_QAPOARBID

from AFKO

INNER JOIN V_QAPO ON V_QAPOAUFPL = AFKOAUFPL

INNER JOIN CRHD ON CRHDOBJID = V_QAPOARBID

into corresponding fields of table INTERNAL

WHERE AFKO~AUFNR = '007200000059'.

Can someone tell why my select query is failing ?

I am not getting any data in internal table..