Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Inner Join

Hi people,

I have a requirement where i have to fetch data from 2 table EKKO and EKPO for which the common field is EBELN. I want to use inner join for these tables. So, I have given EBELN field in the join condition. I also need to give a condition in the WHERE clause saying EBELN in EBELN value in the selection-screen parameter. Since we have 2 conditions given for the same field i.e., EBELN, it gives an error. How would I overcome this problem having in mind that both the conditions must be satisfied.

Tags:
Former Member
Former Member replied

In the where condition you did not mention which ebeln should be considered. that is from which table it should take and compare.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question