topic Re: ABAP query performance in Application Development and Automation Discussions

ABAP query performance

Former Member — Fri, 14 Sep 2007 08:57:26 GMT

Dear gurus,

I want to use ABAP query. However, i wonders about its performance.

Would anyone please show your opinion and experience using this tool?

Is it taking long time to run this tool? Will it effect the overall performace of the system if i use this tool? <REMOVED BY MODERATOR>

Thanks

Ammy

Message was edited by:

Alvaro Tejada Galindo

Re: ABAP query performance

Former Member — Fri, 14 Sep 2007 09:03:47 GMT

hi pavinee

r u saying abap standard query?

if it is yes

in the performence wise good if u works on standard tables

beacuse it works on standard sap memory

defenetly it will effects the performence of the system

beware using the standard query hw u r using ..................

otherwise if u want to create ur own query that is depends in u r coding

Re: ABAP query performance

Former Member — Fri, 14 Sep 2007 09:08:57 GMT

Hello,

plrase check the link

http://www.sap-img.com/abap/what-is-sap-queries.htm

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

http://www.ies.state.pa.us/hr/lib/hr/BJ0033_Travel_SQ00_Transfer_Travel_Expense_Reporting_.pdf

Executing Query

http://help.sap.com/erp2005_ehp_02/helpdata/en/d2/cb4056455611d189710000e8322d00/frameset.htm

Queries

http://help.sap.com/erp2005_ehp_02/helpdata/en/d2/cb476b455611d189710000e8322d00/frameset.htm

Sap Queries

http://help.sap.com/erp2005_ehp_02/helpdata/en/4f/71e252448011d189f00000e81ddfac/frameset.htm

Sap Query Components

http://help.sap.com/erp2005_ehp_02/helpdata/en/d2/cb3f2e455611d189710000e8322d00/frameset.htm

Sample Screen Shots

http://www.olemiss.edu/projects/sap/SQ01_10_03.pdf

Regards,

LIJO

Message was edited by:

Alvaro Tejada Galindo

Re: ABAP query performance

JozsefSzikszai — Fri, 14 Sep 2007 09:10:03 GMT

hi Pavinee,

the perormance of ABAP query is very bad by default, becuase it is using logical DB, which is a very general tool and not really useful for specific things. (For example it is retreiving always all the fields (could be several hundreds), when you need only a dozen)

try to avoid using Queries.

hope this helps

Re: ABAP query performance

sailaja_vadlamudi — Fri, 14 Sep 2007 09:10:52 GMT

Abap query gives less perfoamance than the normal report .

The reasons are it generates code by itself with lot of select and endselect

statements

The ohther hand there are lot of joins across the tables to fetch the data out of them ,this too reduces the performance.

In general functional consultants make use of them .

ABAP query is another tool for ABAP. It provides efficency for ABAP reports.

Transaction Code : SQ01

The advantage with ABAP QUERY is logic required for classic & interactive reports system design automatically 80%.

For ABAP QUERY handle these

SQ01 ; QUERY

SQ02 : INFOSET OR FUNCTIONAL AREA

SQ03: USER GROUP.

[Edit section] Report Writer

Key Concept :

Super users and end users can use Report Painter/Report Writer tools to write their own reports.

Giving them the ability to report on additional fields at their discretion shifts the report maintenance burden to them, saving SAP support groups time and effort normally spent creating and maintaining the reports.

Sail

Re: ABAP query performance

Former Member — Fri, 14 Sep 2007 09:30:16 GMT

good

go through this link

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

thanks

mrutyun^