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:
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
CHECK bseg-bschl EQ '01' OR bseg-bschl EQ '11' OR "2
bseg-bschl EQ '12' OR bseg-bschl EQ '02'.
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