|
|
DTW Administration / Setup / Inventory / Units of Measure / UoM Master Data
API Unit Of Measurements Service / Unit Of Measurement
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | UomEntry KEY UNIQUE | UoM Abs. Entry | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| UomCode KEY UNIQUE | UoM Code | nVarChar | 20 | CODE | Yes | |||
| UomName KEY | UoM Name | nVarChar | 100 | NAME | No | |||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 6 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Length1 | Length 1 | Num | 20 | |||||
| Len1Unit | Unit of Length 1 | Int | 6 | |||||
| length2 | Length 2 | Num | 20 | |||||
| Len2Unit | Unit of Length 2 | Int | 6 | |||||
| Width1 | Width 1 | Num | 20 | |||||
| Wdth1Unit | Unit of Width 1 | Int | 6 | |||||
| Width2 | Width 2 | Num | 20 | |||||
| Wdth2Unit | Unit of Width 2 | Int | 6 | |||||
| Height1 | Height 1 | Num | 20 | |||||
| Hght1Unit | Unit of Height 1 | Int | 6 | |||||
| Height2 | Height 2 | Num | 20 | |||||
| Hght2Unit | Unit of Height 2 | Int | 6 | |||||
| Volume | Volume | Num | 20 | |||||
| VolUnit | Volume UoM | Int | 6 | |||||
| Weight1 | Weight 1 | Num | 20 | |||||
| WghtUnit | Weight UoM | Int | 6 | |||||
| Weight2 | Weight 2 | Num | 20 | |||||
| Wght2Unit | Unit of Weight 2 | Int | 6 | |||||
| IntSymbol | International Symbol | nVarChar | 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
UnitOfMeasurementsService
Object
UnitOfMeasurement
Method
Property
AbsEntry
DTW DB
Code
DTW DB
Height1
DTW DB
Height1Unit
DTW DB
Height2
DTW DB
Height2Unit
DTW DB
InternationalSymbol
DTW DB
Length1
DTW DB
Length1Unit
DTW DB
Length2
DTW DB
Length2Unit
DTW DB
Name
DTW DB
Volume
DTW DB
VolumeUnit
DTW DB
Weight1
DTW DB
Weight1Unit
DTW DB
Weight2
DTW DB
Weight2Unit
DTW DB
Width1
DTW DB
Width1Unit
DTW DB
Width2
DTW DB
Width2Unit
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates