Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to find the field name of variable system information on SAP B1

Hi All,

I recently wanted to create a simple SQL query to list all ITEM MASTER DATE where the weight is blank. This is so i can get a list of all items with the weight information missing from the system to investigate.

It turns out the weight field within the SALES DATA tab is a system variable. When i pull the OITM table up within the query generator i can not identify where this variable name come up without guessing which can give me the wrong information.

Can someone point me into the direction on how to assisocate variable to a field name within SAP B1. This is also another problem if i wanted to display variable within Crystal report layout.



The simplest thing to try in a test data base. Select * from OITM and watch.

The weight in the sales tab is stored in the SWeight1 field.

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question