cancel
Showing results for 
Search instead for 
Did you mean: 

how to publish customized reports in NWBC which are created through SQVI?

0 Kudos

i want to publish custom reports in GRC nwbc. I know throgh LPD_CUST is possible.

But unable to complete it. can anyone have any documentation for this?

Thanks for the suggestions

madhusap - Any help?

Accepted Solutions (0)

Answers (2)

Answers (2)

madhusap
Active Contributor

Hi Shankar,

Query reports (SQVI) are client specific and cannot be transportable completely to other environments.

When you create a query report in SQVI, a report starting with AQ* will be auto generated. To view the program details you can execute the query and then go to System -> Status screen where you can see and copy the corresponding program details.

E.g. I have created a User to Composite and single roles report as shown below:

You can create a Tcode for this ABAP report and then assign the tcode to a role for giving access to the users.

However, only difference is you have to create the query in production and create a Tcode in development with the ABAP report name as the one created in production so that you can transport the tcode from DEV to PRD and it can work.

You also can add the Tcode to NWBC using LPD_CUST transaction. Please see below links on how you can achieve it.

https://help.sap.com/viewer/a7b390faab1140c087b8926571e942b7/7.51.4/en-US/b7999de9e8be4fa584f99a1082...

https://blogs.sap.com/2014/04/26/customizng-nwbc-for-new-menus-with-our-own-transactions-reports-and...

Regards,

Madhu

vijayakumarsuth
Advisor
Advisor

Hi Shankar,

I have not tried this option but, SQVI cannot be shared with other users after the report is generated. Let me see if it can be achieved from my side as well