Below is a listing of SQL which you can review for ideas or use in your SAP B1 System:
(Back to SAP B1 SQL Tips and Tricks Main Page - SAP B1 SQL Tips and Tricks )
SAP B1 SQL F-BP Tax Code Workstation . Monthly Special. This SQL allows a Customer to review and update their Federal Tax ID and Tax Exemption Certificates on the Business Partner Master Data window for an upcoming audit. The SQL creates a display of what I term a "workstation". Although the SQL is written only for four states in the USA, it can easily be changed to include others. SQL has a good example of using the SQL command of LIKE to find records endiing with certain characters.