Select with Join doesn't work

[Former Member]

Hi @ll,

can anybody say why I get the syntax error The column name "VKORG" has two meanings. ABAP/4 Open SQL statement.

Thanks

Kam

SELECT vtweg vmsta mtpos vkorg

FROM MVKE

INNER JOIN YMMARKET_CODE

ON mvke_{vkorg = ymmarket_code}vkorg

INTO CORRESPONDING FIELDS OF TABLE i_mvke

WHERE mvke~matnr = p_matnr.

[Former Member]

write as:

SELECT vtweg vmsta mtpos

MVKE~vkorg

FROM MVKE

INNER JOIN YMMARKET_CODE

ON mvke_{vkorg = ymmarket_code}vkorg

INTO CORRESPONDING FIELDS OF TABLE i_mvke

WHERE mvke~matnr = p_matnr.

[Former Member]

Thanks all of you for your help. Issue resolved.

[Former Member]

Because the column name vkorg has two meanings 😛

It must be either

SELECT vtweg vmsta mtpos mvke~vkorg
FROM MVKE
INNER JOIN YMMARKET_CODE
ON mvke~vkorg = ymmarket_code~vkorg
INTO CORRESPONDING FIELDS OF TABLE i_mvke
WHERE mvke~matnr = p_matnr.

or

SELECT vtweg vmsta mtpos ymmarket_code~vkorg
FROM MVKE
INNER JOIN YMMARKET_CODE
ON mvke~vkorg = ymmarket_code~vkorg
INTO CORRESPONDING FIELDS OF TABLE i_mvke
WHERE mvke~matnr = p_matnr.

[Former Member]

hi there...

the error is because in select, the system is unable to make out whose vkorg field u want to fetch as the field exists in both the tables.

Do like this....

select .... a~vkorg from table1 as a inner join table2 as b where......

this will make ur query work....

do reward and close the query or get bak if facing any more issues.

[Former Member]

try this way...

SELECT a_{vtweg a}vmsta a_{mtpos a}vkorg

INTO CORRESPONDING FIELDS OF TABLE i_mvke

FROM MVKE AS A

INNER JOIN YMMARKET_CODE AS B

ON b_{vkorg = a}vkorg

WHERE a~matnr = p_matnr.