Error "illegal join conditions" in SAP infoset Query

[former_member419727]

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?

[former_member419727]

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.

[former_member232581]

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

[former_member419727]

Hi John,

unfortunately EKES table is empty. We have SAP FMS.

Any other idea?

[former_member200754]

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

[former_member200754]

Hi Daniel,

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

Thanks,