query in sap

[Former Member]

hi

is there any application

in which we can run query as we do in sql

like if i want to fetch records from two tables as

select a, b , c from tablea and table b

where something like that

can we directly execute any query in sap?

plz help me with step by step solution

[Former Member]

You could try transaction SQVI. I haven't used it a lot myself but is seems fairly straightforward and well documented.

Regards,

Nick

[Former Member]

Hi,

SQVI is quick viewer which can be used insted of SQ01, SQ02 & SQ03.

You can use the name of a Data Source, this can be a table, a logical database, a join or an InfoSet from SAP Query.

Regards

Vijay

[Former Member]

can somebody give me an example tutorial for the sap query??

[Former Member]

hi

go thru the following tutorial on ABAP Query

http://www.thespot4sap.com/Articles/SAP_ABAP_Queries_FunctionalAreas_WithoutLogicalDB.asp

<b>reward points for useful ans</b>

Regards

Aarti

[Former Member]

how can i insert konv table in sap query

it is giving error

plz explain???

konv is a cluster table not a transparent table