SQ01/SQVI - an issue with efficiency

[former_member569379]

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.

[siva_vasireddy2]

Hi,

what is the issue you are getting for creating the report in SE93,you can take the help of Technical people.

for SQVI report create a variant and in SE93 create a T.code for the report by selecting Transaction with variant.

[JL23]

A executable SQVI is in the background already a program just with lets call it ugly name.

But you can assign this directly as program in SE93 for execution

just go into you initial SQVI overview screen select your quickview and select from menu Quickview > further fuctions > display report name

and then copy this name and bring it to SE93 to create a transaction.

[former_member569379]

Unfortunately my company wants to avoid creating new z transaction for new reports, the company prefers to create reports in sq01 and assign them to proper user gruop.

[former_member365886]

Hi,

Offlate I had to work on few queries on our Production environment.

I did not notice the problem,which you mentioned.However,it is very strange to understand why the program logic behind SQVI would become less performance friendly when same requirement is implemented via SQ01.-->This also generates a program.

Is it because of any additional validation?

Then I have to check creating one in SQVI and same thing in SQ01.

Regards,

Avik

[Jelena]

You can convert SQVI into a proper SQ01 query. In SQVI, if you click "SAP Query" button it takes you to SQ01 and there is "Convert QuickView" option in the first menu. You just have to be in the client-dependent query area.