01-21-2008 12:06 PM
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
01-21-2008 12:12 PM
Hi Krsihna,
refer below code:
WHERE A~EBELN = I_EBELN. or WHERE b~EBELN = I_EBELN..
Thanks
Piyush
Reward Points, if helpfull
01-21-2008 12:12 PM
Hi Krsihna,
refer below code:
WHERE A~EBELN = I_EBELN. or WHERE b~EBELN = I_EBELN..
Thanks
Piyush
Reward Points, if helpfull
01-21-2008 12:15 PM
01-21-2008 12:16 PM
HI,
plz change the where condn as
WHERE a~EBELN = I_EBELN.
with Regards,
Neptune.M