Skip to Content
0
Former Member
Jan 18, 2008 at 11:58 AM

Fetching data from 3 tables

190 Views

Hi All,

I trying to fetch values from 3 tables and pass the values into an internal table.

Code

SELECT KNA1KTOKD KNA1KUNNR KNB1BUKRS KNVVVKORG KNVVVTWEG KNVVSPART KNVV~LOEVM

INTO

(ITAB-KTOKD,ITAB-KUNNR,ITAB-BUKRS, ITAB-VKORG,ITAB-VTWEG,ITAB-SPART, ITAB-LOEVM)

FROM ( ( KNA1

INNER JOIN KNB1

ON KNA1KUNNR = KNB1KUNNR)

KNA1

INNER JOIN KNVV

ON KNA1KUNNR = KNVVKUNNR ) .

I am getting an error message.

"The Format of the Field Specificatio "KNB1~KUNNR" is not supported.

What is the problem here?

Regards

Aby