biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Items / UoM in Item
DTW Inventory / Item Master Data / UoM in Item
API Items / Item Unit Of Measurements
ITM12 - UoM in Item Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items		PRIMARYYes
UomTypeUoM TypeVarChar
P) Purchasing
S) Sales
I) Inventory
1
P
UomEntry KEYUoM EntryInt
11OUOM
UoM Master Data		UOM_ENTRYNo
BcdEntDftDefault Bar Code EntryInt
11OBCD
Bar Code Master Data
PkgCodeDftDefault Package CodeInt
11OPKG
Package Types
Height1Height 1Num
20
Hght1UnitHeight 1 UoMInt
6
Height2Height 2Num
20
Hght2UnitHeight 2 UoMInt
6
Width1Width 1Num
20
Wdth1UnitWidth 1 UoMInt
6
Width2Width 2Num
20
Wdth2UnitWidth 2 UoMInt
6
Length1Length 1Num
20
Len1UnitLength 1 UoMInt
6
Length2Length 2Num
20
Len2UnitLength 2 UoMInt
6
VolumeVolumeNum
20
VolUnitVolume UoMInt
6
Weight1Weight 1Num
20
Wght1UnitWeight 1 UoMInt
6
Weight2Weight 2Num
20
Wght2UnitWeight 2 UoMInt
6

Table relationship map

SELECT statement

SELECT ITM12.ItemCode AS 'Item No.', ITM12.UomType AS 'UoM Type', ITM12.UomEntry AS 'UoM Entry', ITM12.BcdEntDft AS 'Default Bar Code Entry', ITM12.PkgCodeDft AS 'Default Package Code', ITM12.Height1 AS 'Height 1', ITM12.Hght1Unit AS 'Height 1 UoM', ITM12.Height2 AS 'Height 2', ITM12.Hght2Unit AS 'Height 2 UoM', ITM12.Width1 AS 'Width 1', ITM12.Wdth1Unit AS 'Width 1 UoM', ITM12.Width2 AS 'Width 2', ITM12.Wdth2Unit AS 'Width 2 UoM', ITM12.Length1 AS 'Length 1', ITM12.Len1Unit AS 'Length 1 UoM', ITM12.Length2 AS 'Length 2', ITM12.Len2Unit AS 'Length 2 UoM', ITM12.Volume AS 'Volume', ITM12.VolUnit AS 'Volume UoM', ITM12.Weight1 AS 'Weight 1', ITM12.Wght1Unit AS 'Weight 1 UoM', ITM12.Weight2 AS 'Weight 2', ITM12.Wght2Unit AS 'Weight 2 UoM' FROM ITM12 AS ITM12

Related information


Item Unit Of Measurements ItemUnitOfMeasurements Object· Table: ITM12
Unit of measurement for the item. Source table: ITM12.
   Parent: Items Items Object· Table: OITM
Bar Code Master Data OBCD SQL Table

Items OITM SQL Table

Package Types OPKG SQL Table

UoM Master Data OUOM 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