Skip to Content
Jan 17, 2018 at 08:33 AM

SQ01/SQVI - an issue with efficiency

1213 Views Last edit Jan 17, 2018 at 08:48 AM 2 rev

Hello all,

I have created report in SQVI - left join between BSEG and BKPF to get GL account line items with some data from the header, like document type and dates. The report is running very fast, but I need to share this report with end users, unfortunatelly I can't do it by SE93 to generate z tcode for this report. I needed to recreate this report in SQ01 with using infoset: /SAPQUERY/FIGL40. And I did it... the problem is that there is big difference with efficiency of these reports. In sqvi it works very fast, but in sq01, it is working very slow. Thank you in advance for help.