Delete distinct records from an internal table.

[Vishal__2546]

HI,

I want to delete distinct records from an internal table.

I am giving images for your reference.

These are the records in the table. I want to delete order number 4 from this table because it is only distinct records present in this table.

Thanks,

Vishal.

[Sandra_Rossi]

Question asked again and again. Use your Web search engine: Delete distinct records from an internal table site:sap.com

[raymond_giuseppi]

You can identify your so-named "distinct" (single) records with a simple SELECT statement such as SELECT with aggregation and having clause. So why won't you try to use a single DELETE statement with a subquery.

Read online documentation such as DELETE dbtab / WHERE sql_cond - subquery_clauses  / SELECT, GROUP BY  and HAVING