Archive for Formatted Search

The Anatomy of a SQL Statement – SQL Statement Breakdown (Part 2)

In the previous discussion I introduced a simple SQL query that selected all of the customer numbers and names from the SAP Customer/Vendor/Lead Master file. The query actually selects all three types (customers, vendors, and leads) because SBO uses one table/file to store this information. How you will know which type you are looking at [...]

The Anatomy of a SQL Statement – The Basics (Part 1)

The Basics Writing your own query for SAP (or any system) can be very satisfying and cost effective, if you are a user of SBO. Once you understand the basics, you will be able to direct your computer to give you exactly what information you are looking for from the system. Most systems have some [...]

SAP Business One Need the Current Date to Use Within Your Query?

Get the current system date using the GetDate() value within your query… Examples: SELECT GetDate() Returns the current date Use the date for comparisons: SELECT * FROM OINV WHERE DocDate <= GETDATE() Thanks to Ed Monk of SBONotes.com

SAP Business One How to Specify an On-Screen Field in a Formatted Search SQL Statement

When referencing an on-screen field in an SQL statement, specific syntax is required and unfortunately the only way that the syntax can be validated is by testing the formatted search. The error messages that result are not very helpful either. Use the instructions in this document to build these references to on-screen fields. Turn on [...]

« Previous Page