FOR ALL ENTRIES IN 语句真的会排除重复数据吗
ABAP OPEN SQL "FOR ALL ENTRIES IN " 语句从数据库取数时,会根据select 查询的字段排除重复项,(注意:不是根据内表字段排除重复项)。
比如:
" 取出会计凭证
DATA lt_bel LIKE STANDARD TABLE OF gs_bel.
"如果在SELECT 里指定了搜索字段,以下语句查询字段中没有BUZEI,即会计凭证项目字段,则查询结果会自动根据搜索字段排除重复项。
SELECT bkpf~bukrs bkpf~gjahr monat bkpf~belnr blart
INTO CORRESPONDING FIELDS OF TABLE lt_bel
FROM bkpf JOIN bseg
ON bkpf~bukrs = bseg~bukrs AND bkpf~gjahr = bseg~gjahr AND bkpf~belnr = bseg~belnr
FOR ALL ENTRIES IN pt_ser
WHERE bkpf~bukrs = pt_ser-bukrs
AND bkpf~gjahr = pt_ser-gjahr
AND monat = pt_ser-monat.
DATA pt_bel LIKE STANDARD TABLE OF gs_bel.
"如果 没有指定 字段,而是 * ,则查询结果不会排除重新项,因为查询的字段中包含BUKRS,BELNR,GJAHR,BUZEI,这4个字段在数据永远不会存在重复。
SELECT *
INTO CORRESPONDING FIELDS OF TABLE pt_bel
FROM bkpf JOIN bseg
ON bkpf~bukrs = bseg~bukrs AND bkpf~gjahr = bseg~gjahr AND bkpf~belnr = bseg~belnr
FOR ALL ENTRIES IN pt_ser
WHERE bkpf~bukrs = pt_ser-bukrs
AND bkpf~gjahr = pt_ser-gjahr
AND monat = pt_ser-monat.