|
|
DTW Administration / Setup / Inventory / Length and Width UoM
API OLGT / Length Measures
OLGT - Length Units Table
Length Measures LengthMeasures Object· Table: OLGT
OLGT SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | UnitCode KEY UNIQUE | Unit Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| UnitDisply KEY UNIQUE | Unit Display | nVarChar | 2 | DISPLAY | Yes | |||
| UnitName KEY UNIQUE | Unit Name | nVarChar | 20 | UNIT_NAME | Yes | |||
| VolDisply KEY | Unit Code for Quantity Display | nVarChar | 3 | VOLUME | No | |||
| SizeInMM | Unit Length in mm | Num | 20 | |||||
| Locked | Locked | VarChar | N) Changeable Y) Locked | 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 |
Table relationship map
SELECT statement
SELECT
OLGT.UnitCode AS 'Unit Code',
OLGT.UnitDisply AS 'Unit Display',
OLGT.UnitName AS 'Unit Name',
OLGT.VolDisply AS 'Unit Code for Quantity Display',
OLGT.SizeInMM AS 'Unit Length in mm',
OLGT.Locked AS 'Locked',
OLGT.DataSource AS 'Data Source',
OLGT.UserSign AS 'User Signature'
FROM OLGT AS OLGT
Related information
Length Measures LengthMeasures Object· Table: OLGT
The LengthMeasures object enables to define the length and width measure units that are used for item records.
Source table: OLGT.
OLGT SQL Table
Users OUSR SQL Table
LengthMeasures
Method
Property
UnitCode
DTW DB
UnitCodeforQuantityDisplay
DTW DB
UnitDisplay
DTW DB
UnitLengthinmm
DTW DB
UnitName
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
