|
|
DTW Inventory / Item Master Data / Package in Items
API Item Unit Of Measurements / Item Uo M Packages
ITM4 - Package in Items Table
Item Uo M Packages ItemUoMPackages Object· 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY UNIQUE | Item No. | nVarChar | 20 | OITM Items | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| UomType | UoM Type | VarChar | P) Purchasing S) Sales | 1 | P | |||
| UomEntry KEY | UoM Entry | Int | 11 | OUOM UoM Master Data | UOM_ENTRY | No | ||
| PkgCode KEY | Package Code | Int | 11 | OPKG Package Types | PKG_CODE | No | ||
| Height1 | Height 1 | Num | 20 | |||||
| Hght1Unit | Height 1 UoM | Int | 6 | |||||
| Height2 | Height 2 | Num | 20 | |||||
| Hght2Unit | Height 2 UoM | Int | 6 | |||||
| Width1 | Width 1 | Num | 20 | |||||
| Wdth1Unit | Width 1 UoM | Int | 6 | |||||
| Width2 | Width 2 | Num | 20 | |||||
| Wdth2Unit | Width 2 UoM | Int | 6 | |||||
| Length1 | Length 1 | Num | 20 | |||||
| Len1Unit | Length 1 UoM | Int | 6 | |||||
| Length2 | Length 2 | Num | 20 | |||||
| Len2Unit | Length 2 UoM | Int | 6 | |||||
| Volume | Volume | Num | 20 | |||||
| VolUnit | Volume UoM | Int | 6 | |||||
| Weight1 | Weight 1 | Num | 20 | |||||
| Wght1Unit | Weight 1 UoM | Int | 6 | |||||
| Weight2 | Weight 2 | Num | 20 | |||||
| Wght2Unit | Weight 2 UoM | Int | 6 | |||||
| QtyPerPack | Quantity per Packaging UoM | Num | 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
ItemUnitOfMeasurements
Object
ItemUoMPackages
Enumeration
Method
Property
Height1
DB
Height1Unit
DB
Height2
DB
Height2Unit
DB
Length1
DB
Length1Unit
DB
Length2
DB
Length2Unit
DB
UoMEntry
DB
Volume
DB
VolumeUnit
DB
Weight1
DB
Weight1Unit
DB
Weight2
DB
Weight2Unit
DB
Width1
DB
Width1Unit
DB
Width2
DB
Width2Unit
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
