Definitions

For those who would like to try their hand at doing some queries for formatted searches, alerts, or reports, but do not know what the common table names are, here is a short list. Check back and I will update the list from time to time.

Master Files:

OITM = Item Master
OCRD = Customer, Vendor, and Lead Master
CRD1 = Customer Master Address
OCRG = Customer Master Group Code

Curious what the SAP means? The German and English versions come directly from the SAP website.

German

A user just asked me this question, and many people have asked in the past.

The answer is:

• From the drop-down menus at the top of the screen, go to: Tools -> Queries -> Query Manager
• Click on the Query Manager icon located on the icon bar at the top of the screen.

 The most common question we seem to get is how to learn more about the SAP Business One if you have no previous experience with the software and with any of the companies using or selling it. Unfortunately, there are very few resources outside of the official SAP training world. If you work for someone who is either using or selling SAP Business One, you can obtain a SAP “S” number.

 Follow the steps described below to create a new set of posting periods for a year. This process is normally a part of preparing for the beginning of a new year at or near the end of the year.