topic Re: Optimization with logical database in Application Development and Automation Discussions

Optimization with logical database

Former Member — Thu, 17 Nov 2011 10:54:06 GMT

Hi all.

I have to optimize a report, and it is using BRM logical database to get data from BKPF and BSEG. Could you say to me if it is the faster way or if it would be better to use a SELECT?

Thanks a lot.

Marta.

Re: Optimization with logical database

yuri_ziryukin — Thu, 17 Nov 2011 12:39:54 GMT

Hello Marta,

my experience with logical databases is mostly negative.

Old standard coding nobody wants to touch. All selects are normally single and nested. So if you need many entries they will be read most probably one by one with quite some overhead.

Regards,

Yuri

Re: Optimization with logical database

surajarafath — Fri, 18 Nov 2011 02:57:13 GMT

Can you give the fields in the output ..??

Re: Optimization with logical database

MarcinPciak — Fri, 18 Nov 2011 09:26:43 GMT

Couple reasons why to use LDBs:

- they provide standard and uniform way of data selection (you don't need to know the relationship b/w tables)

- they provide standard selection screen

- they provide authorization check

- you can control them with nested GET statements (i.e. you decide at what time which data are extracted)

- you can restrict data selection based on field [GET ... fields|http://help.sap.com/abapdocu_70/en/ABAPGET_SHORTREF.htm]

Once I met with statement that good ABAPers don't use direct SELECT statement, at least they shouldn't have to. There are so many standard FMs which cover most of SAP db queries.

Regards

Marcin

Re: Optimization with logical database

Former Member — Fri, 18 Nov 2011 09:29:56 GMT

It's a balances report. It show average balance by bussines code and account.

Re: Optimization with logical database

SuhaSaha — Fri, 18 Nov 2011 09:45:39 GMT

Hello Marcin,

Once I met with statement that good ABAPers don't use direct SELECT statement, at least they shouldn't have to.

What?? This might be true for HR ABAP, where LDBs are used in abundance

There are so many standard FMs which cover most of SAP db queries.

Most of these std. FMs are generally "not released" & are not performance friendly either.The "released" BAPIs (BAPIGET) don't cater to all your requirements.

I seldom use FMs to fetch the data. I find it easy to implement relevant authority objects & build an optimised SQL construct as per my requirement

Let me know your comments.

BR,

Suhas

Re: Optimization with logical database

MarcinPciak — Fri, 18 Nov 2011 09:47:03 GMT

Yes I didn't mention it was in HR-ABAP context

Regards

Marcin