iStock-649229226.jpg

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