Skip to Content

Error "illegal join conditions" in SAP infoset Query

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

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

    Hi Daniel,

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

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 17, 2017 at 06:04 PM

    Hi John,

    unfortunately EKES table is empty. We have SAP FMS.

    Any other idea?

    Add comment
    10|10000 characters needed 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

  • Apr 18, 2017 at 03:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 03, 2017 at 02:32 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded