Join conditions in data source - Configurable sub scenario

[Former Member]

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

[alessandr0 · Accepted solution]

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

[Former Member · Accepted solution]

Thanks for the reply,

Could you suggest how to rectify this error?

[alessandr0 · Accepted solution]

I don't know the tables and the fields, but it seems that EKKO-EBELN and EKPO-EBELN are similar. So did you try to have these connection as join condition?

Regards,

Alessandro

[Former Member]

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