Q

What is the run time difference of query vs. ABAP?

There can be a significant time difference between queries and ABAP reports. Why is this, and what are the benefits of these methods?

I created a query using a logical database BRM to extract financial data using tables BKPF and BSEG. I am running for period 1 with company code. The query ran an hour to extract data for period 1. I used same logical database BRM to create a simple ABAP report. But the ABAP program is taking one full day to get period 1 data.

What is the run time difference of query versus ABAP? I've used all performance tricks in the ABAP program.

ABAP queries generate ABAP code. Have a look at the program behind the query you have written, and you'll see the techniques in use.
This was first published in June 2005

Dig deeper on SAP ABAP

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close