Skip to Content
-1

SQ01/SQVI - an issue with efficiency

Jan 17 at 08:33 AM

91

avatar image

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.

10 |10000 characters needed characters left characters exceeded

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

1
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Jelena Perfiljeva
Jan 19 at 09:27 PM
2

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.

Share
10 |10000 characters needed characters left characters exceeded
Siva Prasad Vasireddy Jan 17 at 08:37 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Jürgen L
Jan 17 at 09:03 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Rafal Domanski Jan 17 at 09:15 AM
-1

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.

Share
10 |10000 characters needed characters left characters exceeded