Skip to Content
0
Former Member
Jan 21, 2008 at 12:06 PM

select query----- inner join codition

15 Views

i have used below query to get fields from ekpo and eket tables.

i am getting error as the column name 'ebeln' has two meanings.

SELECT A~EBELN

A~EBELP

A~TXZ01

A~MENGE

A~MEINS

A~NETPR

A~NETWR

B~EINDT

FROM EKPO AS A INNER JOIN EKET AS B

ON AEBELN = BEBELN

AND AEBELP = BEBELP

INTO CORRESPONDING FIELDS OF TABLE IT_ITEM

WHERE EBELN = I_EBELN.

please tell what could be the problem

regards,

krishna