Hi! I tried to add a new table to my data model (EORD) linked to EINE vía WERKS, MATNR, SYS_ID, MANDT, EKORG, ESOKZ, LIFNR.
If I check this unique key in EINE ( Using: select WERKS,MATNR,SYS_ID,MANDT,EKORG,ESOKZ,LIFNR, count(*) AS Amount FROM ALL_NPM_EINE group by WERKS,MATNR,SYS_ID,MANDT,EKORG,ESOKZ,LIFNR order by Amount DESC ) and there is only one case per combination. So in a 1:N relationship it should work or? (EINE 1 → N EORD)
Error Message: Case insensitive duplicated joins detected between tables: [EORD] and [EINE].