on 09-05-2022 11:27 AM
hi
i am sankar new in sap b1 , suppose i create one query report and save it query manager in sap b1. i want that all the query structure are invisible to other's. by using of store procedure. plz guide me proper.
thank you.
Hi sankar,
You can use the MS SQL Server Management Studio, to create the stored procedure in the company database. It is best to start the name of the stored procedure with sp_U_, for example sp_U_MyHiddenQuery.
Next save your query into the stored procedure.
Finally create the following new query in the SAP Business One client:
EXEC dbo.sp_U_MyHiddenQuery
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Navigate to the Stored Procedures node and right-click on it. Go to New and then Stored Procedure:
The SSMS will generate a template for you. All you need to do is fill in some information. For step 4 copy the query from the SAP Business One client:
Once you are done editing the template, press Execute
In the SAP Business One client, you can now delete your query, and replace it with: EXEC sp_U_MyHiddenQuery
Regards,
Johan
Thanking you sir all the best
You are welcome, and I forgot to say that if all you want is that users cannot see the query text, you can also hide this from them through Authorizations (Administration > System Initialization > Authorizations > General Authorizations > [select relevant user in the left panel, then in the right panel] > Reports > Query Generator > [set to No Authorization, and then] > [set relevant Query groups to Read only or Full authorization])
Regards,
Johan
Please go thought the below link
https://sysconz.com/common-controls-stored-procedures-for-sbo-transaction-notifications-in-sap-b1/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Stored procedure and query reports under query manager are two separate topics. You can code the logic at database level and just call the stored procedure from user queries so that your query logic remains hidden subject to access to database..
Second, if you want to control the accessibility to the report then you assign a query group to the report and give authorization to only those users who are supposed to see them and no authorization to others for that group.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.