Query

[Former Member]

Hi,

Can we use SQL seclect statements in ABAP QUERY.

While using multiple tables, Duplicate datas are generated in the output. How to avoid it.

Regards,

Ajju

[Former Member]

Hi,

After selecting in an internal table and u can delete the duplicate entries.

DELETE ADJACENT DUPLICATES FROM itab.

Thanks & Regards,

Judith.

[jayanthi_jayaraman]

Hi,

Use DISTINCT in the select statement.

I think you had posted the qn. twice.

[Former Member]

Hi Ajju, hi everyone,

YES you can. When defining a query you can add extra ABAP coding:

1. At tx SQ02, select your infoset and "change" it

2. At the menu, select Goto > Code > Data

3. At the right part of the screen, select the "event" you want to add the code to: data, start-of-selection, get, get late, ...

4. At the right part of the screen (just below the event you just selected), place here your ABAP code

...and that's it

Pls let us know if it helped. BR,

Alvaro