Skip to Content
0

Error "illegal join conditions" in SAP infoset Query

Apr 17, 2017 at 02:02 PM

319

avatar image

Hi,

I am trying to join the table EKPO and LIPS using the fields in green in the example below, but I have the error “Illegal Join condition”.

The reason that I have to this is because I can have the same item (GTIN) multiple times (in red color).

The system error is because:

EKPO. EBELP (Item number) = 5 digits

LIPS. VGPOS (item number) = 6 char

I saw a few threads about this topic but there is not an example and a clear explanation how to do it.

Is there a way to resolve this issue?

ekpo-lips.png (362.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Apr 17, 2017 at 03:54 PM
0

Hi Daniel,

Try to join more table EKES: EKPO - EKES - LIPS

Thanks,

Share
10 |10000 characters needed characters left characters exceeded
Daniel F. Apr 17, 2017 at 06:04 PM
0

Hi John,

unfortunately EKES table is empty. We have SAP FMS.

Any other idea?

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Daniel,

You can create program then will easy to query data from EKPO and LIPS, it is flexible and easy to maintain in the future also.

Thanks,

John

0
Vibhor Kulshrestha Apr 18, 2017 at 03:33 PM
0

Hi Daniel

I can't think of any business reason for creating that Join. You already have all the required details available in LIPS table. Why do you need join then?

Again you are working on item level table therefore you are bound to get duplicate data if it is repeated in more than single line.

If you can explain what your actual requirement is (why you need these infoset/Join) there might be other possible way to meet those.

Thanks

Vibhor

Share
10 |10000 characters needed characters left characters exceeded
Daniel F. May 03, 2017 at 02:32 PM
0

Hi Vibhor,

Sorry for the delay, but here there are always emergencies.

In order to answer your questions, let me first say that the request of the business is track the PO with the delivery.

Now I need LIPS table essentially for the field SGT_SCAT (Stock segment) because they told me that it could be different with that one on the PO (EKPO.SGT_SCAT). Also another info that I have only in LIPS is a new field called Bonded warehouse added in this table. These are the two business reasons.

However I believe there is other people that would like to understand how it is possible to resolve this error in the infoset. A clear solution could help other people with similar problem with other tables.

Thank you.

Share
10 |10000 characters needed characters left characters exceeded