Executing SQL queries in SAP-GUI e.g. select * from but000

[Former Member]

Hallo,

I am newbie in the SAP world. Is there a way to run select statements from SAP GUI? e.g. I want to know how many rows are returning from a join xyz.

select count() from tabA and tabB where tabA.id = tabB.id and tabA.Name is not null.*

Is it possible with SQVI (SQ01)?

Please help.

[Former Member]

Hi,

select count() from tabA and tabB where tabA.id = tabB.id and tabA.Name is not null.

You can either user Abap query (SQ01) or ABAP editor (SE38) to write respective piece of code and execute the same.

Regards,

Deepak Kori