i don't know how to join 2 or more internal table
SELECT
c~bukrs
c~waers
v~dmbtr
i~dmbtr
FROM
(i_curr as c
LEFT OUTER JOIN i_vendor_p as v
ON cbukrs = vbukrs AND
cwaers = vwaers)
LEFT OUTER JOIN i_intrcpny_vendor_p as i
ON cbukrs = ibukrs AND
cwaers = iwaers
INTO TABLE i_data.
that query return error
" Fields "I_CURR AS C JOIN I_VENDOR_P AS V ON CBUKRS = VBUKRS AND CWAERS = VWAERS" is unknown. It is neither in one of the specified table nor defined by a "DATA" statement"
i have search this problem, and i get syntax PROVIDE ENDPROVIDE to solve this problem. but i can implement to this query.
Please expert, let me know how to jin this internal table with PROVIDE.