Skip to end of metadata
Go to start of metadata

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.

  • No labels