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.

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