Skip to Content
0
Former Member
Jul 21, 2008 at 09:06 AM

How to join internal table?

10864 Views

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.