cancel
Showing results for 
Search instead for 
Did you mean: 

sir i am new in sap b1 . plz suggest me about the store porcedure in sap b1.

90621007
Explorer
294

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.

Accepted Solutions (1)

Accepted Solutions (1)

Johan_H
Active Contributor

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

90621007
Explorer
0 Kudos

sir

can you give me query structure step by step so we can process esily

Johan_H
Active Contributor
  1. Write the query in the SAP Business One client
  2. Open MS SQL Server Management Studio
  3. Navigate to the Stored Procedures node and right-click on it. Go to New and then Stored Procedure:

  4. 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:

  5. Once you are done editing the template, press Execute

  6. In the SAP Business One client, you can now delete your query, and replace it with: EXEC sp_U_MyHiddenQuery

Regards,

Johan

90621007
Explorer

Thanking you sir all the best

Johan_H
Active Contributor
0 Kudos

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

90621007
Explorer
0 Kudos

sir your suggestion is good but no authorization means user can not see the query text its fine. but they also could not see the report its not right.

90621007
Explorer
0 Kudos

sir if you have any vedio clip about store procedure pls share me.

Johan_H
Active Contributor
0 Kudos

Hi,

You can just google "ms sql stored procedure" to find tutorials. Can you tell me what it is that you wish to learn?

Regards,

Johan

Answers (2)

Answers (2)

Abdul
Active Contributor
0 Kudos
narayanis
Active Contributor
0 Kudos

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.