Query Report in SAP B1
Making the query report in sap b1:-
In this post, I will explain to you how to Making the query report in sap b1. Below are steps to Making the query report in sap b1.
Step1: this navigation- Open the query generator window in this navigation.
Tools->Query Manager->Query Generator.
step2: window or-Once query generator window opened we can press on execute button for directly go to the query window or can select tables and the fields from this window also for making the query.
Step3: When we will press on the Execute button then we will come to the query preview window where you can write a query and see the resultset below on the same window.
Step4: I have made a query with one parameter in the query preview as:
in this screenshot, I have expanded the space where we write the query.
Step5: Now we need to save after pressing the save button as:
Step6: When we will press on the save button query save window will open.In this window, we have to give the name of the query and need to define the category as:
Step7: I have saved the query with the Test name as above. it will add into the defined category as:
Step8:O once we have saved it we can open it after pressing on the Test in the General Menu and when we will press on the Test it will ask for the parameter as we have defined into the query.
Step9: When enter the warehouse code after selecting from the CFL and press Ok then it will open the SAP report with data as: