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: 

SQ01 Query with SELECT DISTINCT or UP TO nnn ROWS

Former Member
0 Kudos

Hello gurus

Is it possible to use the

SELECT DISTINCT

or

UP TO nn ROWS

in an SQ01 type of Join query?

I'm not talking about doing it in a normal ABAP program. I know that's possible. I mean just in an SQ02 => SQ01 infoset query.

Thanks

Ed Baker

1 ACCEPTED SOLUTION

naimesh_patel
Active Contributor
0 Kudos

Option for putting the Number fo dataset to be read comes when you run your query from Test button(Ctrl+F8) inside the query. Open your query in SQ01 and press the Test button. In this popup you can restricit the selected rows.

Regards,

Naimesh Patel

1 REPLY 1

naimesh_patel
Active Contributor
0 Kudos

Option for putting the Number fo dataset to be read comes when you run your query from Test button(Ctrl+F8) inside the query. Open your query in SQ01 and press the Test button. In this popup you can restricit the selected rows.

Regards,

Naimesh Patel