Optimization of DDF logical database

351 Views

Hi,

I'm working on a program that uses DDF logical database to list accounting documents. In order to do this, we use three get sentences to loop into KNB1, BSID and BKPF tables.

It's something like that:

GET bkpf.

gjahr is a range with several values

CHECK bkpf-gjahr IN gjahr.

checta is a range with several values

CHECK bkpf-blart IN checta. "1

GET bseg.

CHECK bseg-bschl EQ '01' OR bseg-bschl EQ '11' OR "2

bseg-bschl EQ '12' OR bseg-bschl EQ '02'.

GET gseg.

PERFORM list_document.

But my problem with this code is that it takes too much time to generate the report. Doing some performance analysis on execution, I've determined that the problem is with the access to tables of logical database (the "get" sentences).

So I need to improve report performance, but I don't know how can I do this, maybe if the get returns only the fields I need for execution instead of all table fields runtime would be better, but I'm not very sure if this is possible.

Another option could be changing GET sentences for SELECT, but looking into LDB code I see that as well as hard to change probably it will be useless.

So any information about LDB optimization, or how to improve this kind of reports would be very appreciated.

Thanks in advance

Best regards