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
This Content Component encountered an error

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