ABAP query performance

[Former Member]

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? <b><REMOVED BY MODERATOR></b>

Thanks

Ammy

Message was edited by:

Alvaro Tejada Galindo

[Former Member]

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

[Former Member]

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

<b><REMOVED BY MODERATOR></b>

Regards,

LIJO

Message was edited by:

Alvaro Tejada Galindo

[JozsefSzikszai]

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

ec

[sailaja_vadlamudi]

Hi

Abap query gives less perfoamance than the normal report .

The reasons are it generates code by itself with lot of <b>select and endselect</b>

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

Sail

[Former Member]

hi

good

go through this link

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

thanks

mrutyun^