biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Master Data / Package in Items
API Item Unit Of Measurements / Item Uo M Packages
ITM4 - Package in Items Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
UomTypeUoM TypeVarChar
P) Purchasing
S) Sales
1
P
UomEntry KEYUoM EntryInt
11OUOM
UoM Master Data
UOM_ENTRYNo
PkgCode KEYPackage CodeInt
11OPKG
Package Types
PKG_CODENo
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
QtyPerPackQuantity per Packaging UoMNum
20

Table relationship map

SELECT statement

SELECT ITM4.ItemCode AS 'Item No.', ITM4.UomType AS 'UoM Type', ITM4.UomEntry AS 'UoM Entry', ITM4.PkgCode AS 'Package Code', ITM4.Height1 AS 'Height 1', ITM4.Hght1Unit AS 'Height 1 UoM', ITM4.Height2 AS 'Height 2', ITM4.Hght2Unit AS 'Height 2 UoM', ITM4.Width1 AS 'Width 1', ITM4.Wdth1Unit AS 'Width 1 UoM', ITM4.Width2 AS 'Width 2', ITM4.Wdth2Unit AS 'Width 2 UoM', ITM4.Length1 AS 'Length 1', ITM4.Len1Unit AS 'Length 1 UoM', ITM4.Length2 AS 'Length 2', ITM4.Len2Unit AS 'Length 2 UoM', ITM4.Volume AS 'Volume', ITM4.VolUnit AS 'Volume UoM', ITM4.Weight1 AS 'Weight 1', ITM4.Wght1Unit AS 'Weight 1 UoM', ITM4.Weight2 AS 'Weight 2', ITM4.Wght2Unit AS 'Weight 2 UoM', ITM4.QtyPerPack AS 'Quantity per Packaging UoM' FROM ITM4 AS ITM4

Related information


Item Uo M Packages ItemUoMPackages Object· Table: ITM4
The item UoM package. Source table: ITM4.
   Parent: Item Unit Of Measurements ItemUnitOfMeasurements Object· Table: ITM12
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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates