|
|
API AUOM
AUOM - UoM Master Data Table
Users OUSR SQL Table
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 | UoM Code | nVarChar | 20 | |||||
| UomName | UoM Name | nVarChar | 100 | |||||
| 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 |
SELECT statement
SELECT
AUOM.UomEntry AS 'UoM Abs. Entry',
AUOM.UomCode AS 'UoM Code',
AUOM.UomName AS 'UoM Name',
AUOM.Locked AS 'Locked',
AUOM.DataSource AS 'Data Source',
AUOM.UserSign AS 'User Signature',
AUOM.LogInstanc AS 'Log Instance',
AUOM.UserSign2 AS 'Updating User',
AUOM.UpdateDate AS 'Date of Update',
AUOM.CreateDate AS 'Creation Date',
AUOM.Length1 AS 'Length 1',
AUOM.Len1Unit AS 'Unit of Length 1',
AUOM.length2 AS 'Length 2',
AUOM.Len2Unit AS 'Unit of Length 2',
AUOM.Width1 AS 'Width 1',
AUOM.Wdth1Unit AS 'Unit of Width 1',
AUOM.Width2 AS 'Width 2',
AUOM.Wdth2Unit AS 'Unit of Width 2',
AUOM.Height1 AS 'Height 1',
AUOM.Hght1Unit AS 'Unit of Height 1',
AUOM.Height2 AS 'Height 2',
AUOM.Hght2Unit AS 'Unit of Height 2',
AUOM.Volume AS 'Volume',
AUOM.VolUnit AS 'Volume UoM',
AUOM.Weight1 AS 'Weight 1',
AUOM.WghtUnit AS 'Weight UoM',
AUOM.Weight2 AS 'Weight 2',
AUOM.Wght2Unit AS 'Unit of Weight 2',
AUOM.IntSymbol AS 'International Symbol'
FROM AUOM AS AUOM
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
