biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / UoM Master Data / UoM Master Data
DTW Administration / Setup / Inventory / Units of Measure / UoM Master Data
API Unit Of Measurements Service / Unit Of Measurement
OUOM - UoM Master Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
UomEntry KEY UNIQUEUoM Abs. EntryInt
11
PRIMARYYes
UomCode KEY UNIQUEUoM CodenVarChar
20
CODEYes
UomName KEYUoM NamenVarChar
100
NAMENo
LockedLockedVarChar
Y) Yes
N) No
1
N
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
6
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
Length1Length 1Num
20
Len1UnitUnit of Length 1Int
6
length2Length 2Num
20
Len2UnitUnit of Length 2Int
6
Width1Width 1Num
20
Wdth1UnitUnit of Width 1Int
6
Width2Width 2Num
20
Wdth2UnitUnit of Width 2Int
6
Height1Height 1Num
20
Hght1UnitUnit of Height 1Int
6
Height2Height 2Num
20
Hght2UnitUnit of Height 2Int
6
VolumeVolumeNum
20
VolUnitVolume UoMInt
6
Weight1Weight 1Num
20
WghtUnitWeight UoMInt
6
Weight2Weight 2Num
20
Wght2UnitUnit of Weight 2Int
6
IntSymbolInternational SymbolnVarChar
20

Table relationship map

SELECT statement

SELECT OUOM.UomEntry AS 'UoM Abs. Entry', OUOM.UomCode AS 'UoM Code', OUOM.UomName AS 'UoM Name', OUOM.Locked AS 'Locked', OUOM.DataSource AS 'Data Source', OUOM.UserSign AS 'User Signature', OUOM.LogInstanc AS 'Log Instance', OUOM.UserSign2 AS 'Updating User', OUOM.UpdateDate AS 'Date of Update', OUOM.CreateDate AS 'Creation Date', OUOM.Length1 AS 'Length 1', OUOM.Len1Unit AS 'Unit of Length 1', OUOM.length2 AS 'Length 2', OUOM.Len2Unit AS 'Unit of Length 2', OUOM.Width1 AS 'Width 1', OUOM.Wdth1Unit AS 'Unit of Width 1', OUOM.Width2 AS 'Width 2', OUOM.Wdth2Unit AS 'Unit of Width 2', OUOM.Height1 AS 'Height 1', OUOM.Hght1Unit AS 'Unit of Height 1', OUOM.Height2 AS 'Height 2', OUOM.Hght2Unit AS 'Unit of Height 2', OUOM.Volume AS 'Volume', OUOM.VolUnit AS 'Volume UoM', OUOM.Weight1 AS 'Weight 1', OUOM.WghtUnit AS 'Weight UoM', OUOM.Weight2 AS 'Weight 2', OUOM.Wght2Unit AS 'Unit of Weight 2', OUOM.IntSymbol AS 'International Symbol' FROM OUOM AS OUOM

Related information


Unit Of Measurement UnitOfMeasurement Object· Table: OUOM
To manage inventory items by different UoMs (units of measurement) applicable to your business, you need to define the individual UoMs. These are the units in which the items will be purchased, sold, and stocked. You can later group associated...
   Parent: Unit Of Measurements Service UnitOfMeasurementsService Service· Table: OUOM

Unit Of Measurements Service UnitOfMeasurementsService Service· Table: OUOM
The UnitOfMeasurementsService service enables you to add, look up, update, and remove unit of measurements. Source table: OUOM.

OUOM SQL Table

Users OUSR SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates