It goes without saying that when you are building queries and reports that you need a good reference to the database structure of application and of course SAP Business One is no different.



There are a couple of ways to determine the database structure of SAP Business One but as I was doing my regular trawling around the internet looking for handy resources to share I happened to stumble across this little gem.



SAP Tables - SAP Business One/ERP Table Definitions



This site allows you to select the B1 version and gives you a breakdown of the tables and fields.



A great resource to pin to your Bookmarks Bar in my opinion.



i hope you agree