SAP Knowledge Base Article - Preview

2490859 - SELECT FOR ALL ENTRIES: duplicate entries are removed from result set.

Symptom

The Open SQL command SELECT is used with FOR ALL ENTRIES, duplicate entries are removed in result set.

For example:

Table ZTESTSELECT contains following entries:

1.PNG

2.PNG

Duplicate entries are removed:

3.PNG


Read more...

Environment

ABAP System.

Product

SAP NetWeaver all versions ; SAP S/4HANA foundation 1709 on SAP NetWeaver Application Server for ABAP, version for SAP HANA ; SAP S/4HANA foundation 1809 on SAP NetWeaver Application Server for ABAP, version for SAP HANA

Keywords

SELECT, FOR ALL ENTRIES, duplicate entries, open SQL, removed , KBA , BC-ABA-LA , Syntax, Compiler, Runtime , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.