How to share an SQVI query in SAP?

I assume you already have an understanding about how you can create an SQVI Query..

For those people that have not used this powerful tool before, I “ll demonstrate this with an example. In chapter 2 I will next demonstrate how you can actually share your personal made SQVI query with your colleagues!

Creating a new Query via Transaction Code SQVI

In the SAPGUI, launch the QuickViewer using the transaction code SQVI.

This will show the following screen:

SQVI Quickviewer

First enter a useful name, and next press the “CREATE” button.

As an example, I will quickly create a query, called ZBP_ROLES which  I use a lot in the context of SAP CRM Business Partner Role checks, using a Join between the tables BUT000 and BUT100.

This query will allow me to quickly identify following things:

* which BP roles have been maintained for a certain business partners

* which Business partners are maintained with e.g. the role BUP003 (Employee).

Table Join as Datasource in SQVI

In the title, I just entered a relevant explanation for myself…and in the field Data Source, I choose  “Table Join” as will want to create my query based on the two tables.

Insert Tables to be joined

I next push the button “Insert Table” in order to add my first table (BUT000). This table contains general master data for a Business Partner.

Add Table BUT000

Now you see that my first table has been added.

SAP CRM Table BUT000

I now repeat this step, and also add table BUT100 (this table contains the maintained Business Partner Roles per business partner).

Table join between BUT000 and BUT100

The Join condition in this case is automatically set by the field PARTNER which for this join is correct. You”ll notice this will not always be the case when adding tables … therefore I usually test this process and especially the join conditions out before I create my query..just by looking at the CRM Datamodel or just testing out the GUIDS and see which match if I use them across tables.

Now that my tables have been added, I push the “green back-button” and I “ll see the next screen, where I can choose my input and output fields.

To keep it very simple, I choose following fields as Input/output:

  • BUT000-PARTNER (not visible in below screenshot as the table is collapsed- but  I marked this field as “list field & selection field”.
  • BUT100-RLTYPE (see below screenshot)

Selection of input & Output fields

Now I pres the Save Button ..and next press the “green Back-button”.

The only thing that always seemed mysterious is that even although I pushed the save-button already, I still get a pop-up asking me whether I would like to save this query or not…I always press “YES”  such a case…

Now you see that in my list my first SQVI Query has been created, which I now can launch using the “Execute-button”.

Query is available

I’ll quickly also demonstrate the use of this particular query:

suppose I would quickly like to found out how many “Employees” have been created in my demo system, and I actually would like to have a list with all relevant Business Partner Numbers. In such a case, all I have to do is fill out the selection field “BP Role” with the value BUP0003 (you can use the input help, if you are not sure about the technical name of the BP role) and press the execute button.

execute SQVI Query

The output is now being generated by the system. If I would like to, I can easily export the results into MS-Excel or a flatfile..

Output of SQVI Query

So far the query building basic tutorial..