topic select query----- inner join codition in Application Development and Automation Discussions

select query----- inner join codition

Former Member — Mon, 21 Jan 2008 12:06:46 GMT

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 — Mon, 21 Jan 2008 12:12:07 GMT

Hi Krsihna,

refer below code:

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

Thanks

Piyush

Reward Points, if helpfull

Former Member — Mon, 21 Jan 2008 12:15:28 GMT

thanks a lot piyush

it got corrected.

Former Member — Mon, 21 Jan 2008 12:16:29 GMT

HI,

plz change the where condn as

WHERE a~EBELN = I_EBELN.

with Regards,

Neptune.M