Question

ABAP问题。 我想问下。为什么我用inner join 关联表的时候。为什么取出的数据会进行循环。

SELECT ekbe~ebeln
likp~vbeln
lips~werks
ekko~bukrs
makt~maktx
INTO CORRESPONDING FIELDS OF TABLE gi_ms
FROM ekko
INNER JOIN ekbe ON ekko~ebeln = ekbe~ebeln
INNER JOIN likp ON ekbe~belnr = likp~vbeln
INNER JOIN lips ON likp~vbeln = lips~vbeln
INNER JOIN makt ON lips~matnr = makt~matnr
WHERE ekko~reswk = p_reswk
AND ekko~bsart = 'UB'
AND ekbe~vgabe = '8'
AND ekbe~ebeln IN s_ebeln
AND lips~werks IN s_werks
AND likp~vbeln IN s_vbeln
AND likp~lfdat IN s_lfdat.

Answer 1

FROM ekko
INNER JOIN ekbe ON ekko~ebeln = ekbe~ebeln
EKBE和EKKO用EBELN连接的话，是一对多关系，所以会有重复记录出现。

Answer 2

楼上正解 而且看你select 的 字段 没有必要关联ekbe
ekbe~ebeln 换成 ekKO~ebeln
去掉 INNER JOIN ekbe ON ekko~ebeln = ekbe~ebeln
就ok了

Answer 3

1楼正解,表关系的问题,如果不想重复尝试用LEFT JOIN