Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

abap query

Former Member
0 Kudos

i am doing an abap query in which some duplicate records are being picked from the makt table.

i want to delete these duplicate records but can you tell me how to delete duplicate records in an query(sq02)

2 REPLIES 2

valter_oliveira
Active Contributor
0 Kudos

Hello.

In MAKT, remember that the primary key is composed by matnr and spras. Don't use only matnr to fetch data from makt (choose the language for the material description).

Regards.

Valter Oliveira.

Former Member
0 Kudos

Hi,

when ur joining to the other table from MAKT table, taken the correct combination to fetch the data other, join is important to fetching the data. Please give more conditions for refine ur selection.

Give points if it helps you..

Thanks,

Suresh