Skip to Content
Author's profile photo Paulo Vitoriano

Improve CATS reporting for SAP PS with SQVI table join

Business Case:

In the time reporting process with CATS quite often the account assignment object is a PM Work Order.  It is a typical PS/PM integration scenario when PM work orders are assigned either to the WBS or to the NWA.  As result of that the CATS_DA report gives the output with Work Orders only.  Same time a common business requirement is to report hours by WBS, as well as provide management with statistics on CAPEX/OPEX breakdown (for example) that normally can be done only based on the WBS information.  Furthermore WBS-elements contain additional characteristics like Person Responsible, Responsible Cost Center, and JVA related fields.  All these additional fields can be important from reporting perspective.

Solution:

I will use SQVI transaction to create a query based on a simple Table join:

SQVI_104.PNG

Next I will link three tables as a minimum set of data: CATSDB, AUFK, and PRPS.

SQVI_105.PNG

I will need AUFK table to get the order link with WBS table, and PRPS to get WBS information.


Finally you can select the List fields and Selection fields for all the tables involved:


SQVI_500.png

Another common question is how to share the query with other business users.  Use transaction code SQ02.

Select from the menu Settings -> Settings and select the flag for Display system objects:

SQVI_501.png


Select from the menu Environment -> Query areas and select the radio button for Standard area:

SQVI_502.png

Next you can easily find your QV by the User Name:

SQVI_503.png

If you click on Role/User Group Assignment you can take a note of system generated User Group (it has a standard prefix SYSTQV followed by sequential number).  Next you can edit the User Group and assign additional users if needed.

Another (and probably better) alternative is to create a Z t-code for the SQVI generated program in SE93.

There are many more opportunities around SQVI to polish and improve it further, but this sample is hopefully enough to get you a quick start.

Thank you for your time and feedback!


Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sunil Yadav
      Sunil Yadav

      Hi Paulo,

      Good document 🙂

      this also achieved by SQ01, SQ02, & SQ03 transaction?

      thanks

      Sunil

      Author's profile photo Paulo Vitoriano
      Paulo Vitoriano
      Blog Post Author

      Hi Sunil,

      I must admit that have not used SQ01 - SQ03 before. It looks to be exactly the same functionality, just a different interface.

      Regards,

      Author's profile photo sanjeev chauhan
      sanjeev chauhan

      Main difference between SQVI and SQ01 is like functional consultant use SQVI and technical consultant use SQ01.

      but nice document to learn new comer.

      Regards,

      Author's profile photo Panagiotis Papaspyridakos
      Panagiotis Papaspyridakos

      Hi...

      i suspect that there might be some problem in case you need to share your report with other people since as far as i know...sqvi works only for the user that creates the query. If you want to share it you need to convert it to a query.

      Author's profile photo Former Member
      Former Member

      Good document

      Author's profile photo Paulo Vitoriano
      Paulo Vitoriano
      Blog Post Author

      Thank you!

      Author's profile photo Former Member
      Former Member

      Informative and has helped us in on of our CRs 🙂

      Author's profile photo Former Member
      Former Member

      Thanks, Good information & useful document