Make a Query in SAP business One
Cara membuat Query Di SAP business One
Cara Membuat Query di Query Generator SAP Business One
1. Understand how to create and conceptualize database structures, if you don't understand this, maybe this link http://www.w3schools.com/sql/default.asp can help you, or other links2. Knowing the Table Name and Field in SAP
- Display System Information in advance (View - System information Or Shortcut CTRL + SHIFT + I)
- Open one of the documents that you will display in the query, for example I want to create a query to display the Sales Order
- Place the Cursor Position on the Field that will be displayed, then information about the Field and the name of the table will be displayed as shown below. Position is below the left
- After you know the Table Name and Field, the next step is to create the query. How to Tools - Query - Query Generator
- Then Forms Like This Will Be Displayed
- You Simply Fill in a Table Name In a field like the picture above Ex (OITM) then Tab, then a list will appear showing all the fields in the table
- Double Click the Field that will be displayed in the Query
Column Select - displays all fields that will be displayed in the Query
Column From - Table Name
Column Where - To fill in the Parameters / do Filters, you can click the Condition button below. see the next step
Sort By Field - Data displayed will be sorted by the Field selected
Group By - column If the data you want to display will be grouped.
Then click Execute, then the Form parameter that is registered will be displayed
How to display the Save Query
1.Select Tools - Queries - User Queries or on the toolbar click the image as below
How to Edit a Save Query
1. Open the Query to edit, click the Pencil image
4. Click Save Button to save the edited query