Restricting duplicate entries

[Former Member]

Hi

I have used an inner join to get data from two tables KNA1 and KNVP. In the result some entries are getting duplicated. How do i restrict it to get unique records???

[Former Member]

Hi

I have used an inner join to get data from two tables KNA1 and KNVP. In the result some entries are getting duplicated. How do i restrict it to get unique records???

[Former Member]

Hi,

after the data fetch , youcan execute the following command :

delete adjacent duplicates from ITAB comparing <some field>

regards,

[Former Member]

thanks sachin

i got it right now

[Former Member]

Hi Mayur,

After selecting the datas you can delete the Duplicate Values from your internal Table.

For Internal tables use,

DELETE ADJACENT DUPLICATES FROM itab.

If u want to delete the duplicate entries depending on one or 2 columns then u can use

DELETE ADJACENT DUPLICATES FROM itab COMPARING f1 f2.

Thanks.

Reward If Helpful.

[Former Member]

thanks viji

i got it right now

[Former Member]

Use the DISTINCT command in the query itself

[Former Member]

Hi,

Use DISTINCT option in your select query

like select distinct <field names ..............>.

Thanks

Sandeep

Reward if helpful

[Former Member]

Hi

If you Dont want any duplicate entries from the database table you can use SELECT DISTINGT clause in the query...Otherwise if you want to delete duplicate by giving condition to some specific fields after the selection you can use this command..

DELETE ADJASCENT DUPLICATE FROM ITAB COMPARING <FIELDS>

Hope this will help u..

Reward ALL The Helpfull Answers.......

[Former Member]

From Functional point of view, This join query should yield more than one records as A customer can be existing in more than one sales area(sales org, dist. channel, division).

What exactly is your requirement?

[Former Member]

Thanx the problem is solved...

[Former Member]

You have to follow the following steps..

Select A B C "(change it with the field you select)

Into ta_kna1_knvp

FROM KNA1

Inner Join KNVP

On...

where.... "(allways select based on primary key or index)

Sort ta_kna1_knvp by A B. "(Where A B is the key that differ your selection unique)

delete adjacent duplicates from ta_kna1_knvp comparing A B.

Allways use SORT and DELETE ADJACENT DUPLICATES after inner join.