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..