topic Re: avoiding duplicates in internal table in Application Development and Automation Discussions

avoiding duplicates in internal table

Former Member — Fri, 19 Oct 2007 05:39:18 GMT

Hi Experts,

when Iam populating data into internal table how can i avoid duplicates.

For eg I want to capture all the sales order of all the items , if iam having the same sales order for all the items the internal table should be consisting of only one sales order .

Re: avoiding duplicates in internal table

former_member189059 — Fri, 19 Oct 2007 05:40:38 GMT

use select distinct while you select

else

sort the table and delete adjacent duplicates

Re: avoiding duplicates in internal table

Former Member — Fri, 19 Oct 2007 05:42:17 GMT

If you wanna extract distict value from data base table , then use

SELECT DISTINCT....

the DISTINCT addition can be used to exclude duplicate lines from the resulting list.

by this you can select only distict values and u can avoid duplicate values.

revert back if not clear.

reward points if helpful

Re: avoiding duplicates in internal table

Former Member — Fri, 19 Oct 2007 05:54:17 GMT

hi,

inorder to get only 1 sales order number for all the item number you need to use the statement :

Select DISTINCT inpopulating your internal table.

regards,

sohi

Re: avoiding duplicates in internal table

Former Member — Fri, 19 Oct 2007 05:57:46 GMT

Dont use select distinct, instead after populating internal table

sort itab

delete adjacent duplicates from itab comparing vbeln.

select distinct will increase load on your database

Re: avoiding duplicates in internal table

Former Member — Fri, 19 Oct 2007 06:00:55 GMT

Hi,

The better approach will be to use the following

SORT T_MARC BY MATNR.

DELETE ADJACENT DUPLICATES FROM T_MATNR COMPARING MATNR.

The DISTINCT addition to the SELECT statement allows you to remove duplicates from a set of results during a SELECT.

SELECT DISTINCT MATNR

FROM MARC

INTO TABLE T_MARC

WHERE DISMM = 'ND'.

Disadvantages:

• Requires sorting on database server and adversely affects overall system performance if no index can be used

• When using DISTINCT the database is always accessed directly by passing the SAP buffer

Alternative approach:

SELECT MATNR

FROM MARC

INTO TABLE T_MARC

WHERE DISMM = 'ND'.

SORT T_MARC BY MATNR.

DELETE ADJACENT DUPLICATES FROM T_MATNR COMPARING MATNR.

Recommendation:• Only use the DISTINCT addition if there are a large number of duplicates and the set of results will be significantly reduced if you remove duplicates.

• Use DISTINCT if the selected fields are part of DB index picked by WHERE clause of the SELECT.

Reward useful answers

Re: avoiding duplicates in internal table

Former Member — Fri, 19 Oct 2007 06:10:42 GMT

To avoid duplicate entries in the internal table you may try this approach

The DELETE ADJACENT DUPLICATES statement is especially useful if the internal table itab is sorted by fields (whether in ascending or descending order) which were compared during duplicate determination. In this case, the deletion of neighbouring duplicates is the same as the deletion of all duplicates.

If a comparison criterion is only known at runtime, it can be specified dynamically as the content of a field name by using COMPARING ... (name) ... . If name is blank at runtime, the comparison criterion is ignored. If name contains an invalid component name, a runtime error occurs.

Comparison criteria - statistically or dynamically specified - can be further restriced by specifying the offset and/or length.

Regards,

Neha.