topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Wed, 04 May 2005 05:09:50 GMT

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 — Wed, 04 May 2005 05:18:44 GMT

Hi,

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

DELETE ADJACENT DUPLICATES FROM itab.

Thanks & Regards,

Judith.

jayanthi_jayaraman — Wed, 04 May 2005 05:57:42 GMT

Hi,

Use DISTINCT in the select statement.

I think you had posted the qn. twice.

Former Member — Wed, 04 May 2005 06:38:54 GMT

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