Sharing the SQVI Query with other Users
Part 2, which is perhaps not that well known, even by experienced SAP consultants, is how you can actually share you “personal” SQVI queries with your colleagues. As I work in a Team of 4 SAP CRM consultants currently, I often create a useful Query using SQVI, but as this is created as a “private” query, it ‘s by default not accessible by my other team members. As such we usually share them using this technique.
Now, for this purpose I quickly created a User Group (CRM_TEAM1) using tcode SQ03.
What I did was just enter a new “User Group name” in the field ‘user group’. In this case CRM_TEAM1, I next pressed the button CREATE.
In the following Pop-up , I entered a description for this User Group.
Then I pressed the button ‘Assign Users and InfoSets” where I added my Own UserID to the list. Here you would actually add your other team members too!
I now save these settings.
I now quickly launch the Transaction code SQ01 to show you I have actually access to this user Group.
When you launch SQ01, by default it will show the Queries contained in the global area. Here, in the menu I first choose:
Environment >> Query Areas (where I ‘ll choose “standard area – client specific” as this is where I will see my new created User group.
I now can see below that I have access to User Group CRM_TEAM1. But for now there are no queries visible yet.
In the menu (in transaction code SQ01) I now choose: Query >> Convert Quickview
In the following screen, I choose the relevant SQVI Query (that I – USER7SAP37) have created before, using the Input Help Button.
Obviously I select the query ZBP_ROLES -as I only have created just 1 query on this demo system, the list is pretty limited to choose from
In the above screen I entered the same name for the Query & Infoset.. this seems to work just fine for me.
Our wanted result appears now in the SQ01 list (for UserGroup CRM_TEAM1)
Now, my colleagues and I can just launch this query using the transaction code SQ01.
本文作者: GavinDong
版权属于: GavinDong博客
文章链接: https://gavindong.com/3944.html
如果使用过程中遇到问题,可 **点击此处** 交流沟通。
版权所有,转载时必须以链接形式注明作者和原始出处及本声明。