select query----- inner join codition

[Former Member]

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 A_{EBELN = B}EBELN

AND A_{EBELP = B}EBELP

INTO CORRESPONDING FIELDS OF TABLE IT_ITEM

WHERE EBELN = I_EBELN.

please tell what could be the problem

regards,

krishna

[piyush_mathur]

Hi Krsihna,

refer below code:

WHERE A~EBELN = I_EBELN. or WHERE b~EBELN = I_EBELN..

Thanks

Piyush

Reward Points, if helpfull

[Former Member]

thanks a lot piyush

it got corrected.

[Former Member]

HI,

plz change the where condn as

WHERE a~EBELN = I_EBELN.

with Regards,

Neptune.M