topic Re: ABAP Queries in Application Development and Automation Discussions

ABAP Queries

Former Member — Wed, 28 Feb 2007 10:49:18 GMT

Hi,

I need to write some coding and run the abap query. I need to know where the output table has to be placed so that i can get the desired result.

Can any body help me with the steps to be followed in creating Abap query with coding.

Re: ABAP Queries

sreeramkumar_madisetty — Wed, 28 Feb 2007 10:51:53 GMT

Use the transaction :SQ01.

Regards,

kumar

Re: ABAP Queries

Former Member — Wed, 28 Feb 2007 10:53:39 GMT

Hi,

SQ01,SQ02,SQ03..

These r the transactions forsap query.

Regards,

Kishore.

Re: ABAP Queries

Former Member — Wed, 28 Feb 2007 10:55:11 GMT

Hi Siju,

If you need to create an ABAP Query, u can use transaction SQ01. But,before creating the query u need to find the appropriate infoset for that query. Bcoz infoset is the thing where we define the tables to be used and put joins on them. For Infoset Goto Environment-> Infosets in the SQ01 transaction.

Define the tables to be used, put the join and conditions on them. Then create a query using that infoset.

Hope this helps.

Please award points if helpful.

Thanks,

Himanshu.

Re: ABAP Queries

Former Member — Wed, 28 Feb 2007 10:59:51 GMT

Follow this link :

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

Hope this helps u.

Re: ABAP Queries

Former Member — Wed, 28 Feb 2007 11:34:15 GMT

Use the transaction SQ01 to creata a query.

Also u can try at SQVI for quick view on two or more tables.

Regards,

Ponraj.s.