For SAP B1 developers, its sometimes difficult to determine which table to select from, specially with so many tables and columns on the DB. It does not help much that the table names can be pretty cryptic as well.
Here are some places to get information:
1. SAP SDK documentation
This is probably the most straightforward. When we install the SAP B1 SDK, it comes with a CHM file the the database documentation. Finding what you want can be difficult, but the easiest way is to use the Search and use keywords.
2. From SAP B1 Client
There SAP B1 Client can give a lot of information. Here are 2 ways that comes into mind right away:
1. Using the System Information (View -> System Information or Ctrl+Shift+I). When this is selected, you can see the table and column used when you mouse over a field in any of the forms in SAP B1 if that particular field is bound to the table.
2. Using the Query Generator function in SAP B1 (Tools -> Queries -> Query Generator).
3. Using the SQL Profiler
Sometimes, its just so damn hard to get what tables are affected by an operation. In this case, just turn on the SQL Profiler, do the operation you need done on the SAP B1 Client and look at the sql commands on the SQL Profiler output.