Replace Select/Delete Adjacent duplicate in ABAP for HANA

[Former Member]

Hi All,

We are migrating to HANA and need to change ABAP code as per ABAP for HANA guidelines. Please assist in transforming following query.

SELECT <fld1> <fld2> <fld3>... FROM <TABLE> INTO TABLE LT_TAB.

SORT LT_TAB ASCENDING <fld1> <fld2>.

DELETE ADJACENT DUPLICATE FROM LT_TAB.

We need to transform it into single query to eliminate warning message we are getting.

Please assist.

Thanks & Regards,

Rajesh

[charlycris]

Hi Rajesh

You can use SELECT DISTINCT statement, whenever no have key field complete.

CCCE.