Skip to Content
avatar image
Former Member

Join conditions in data source - Configurable sub scenario

Hello Experts,

In configurable sub scenario, when I try to join 2 tables (EKKO and EKPO), I am getting a warning message saying that "Redundant Join Conditions proposed; manual maintenance required" and the data source is not fetching any data.

Could anyone suggest what could be the reason


Regards,

Ramakrishna Chaitanya

pastedImage_1.png (27.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 10, 2014 at 06:26 AM

    Hi Ramakrishna,

    is it correct that you join the field EKKO-EBELN to EKPO-ANFNR, EKPO-EBEL and EKPO-KONNR? From my point of view that's causing the issue as it's a redundant join condition for the same field.

    Regards,

    Alessandro

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 12, 2014 at 02:26 PM

    Hello Ramakrishna,

    Alessandro is right. EKKO-EBELN and EKPO-EBELN is the redundant condition. Just remove manually this row from the join condition and the warning message dissapears.

    Best Regards,

    Fernando

    Add comment
    10|10000 characters needed characters exceeded