|
|
DTW Administration / Setup / Inventory / Unit of Measure Groups
API Uo M Group Definition Collection / Uo M Group Definition
UGP1 - UoM Group Detail Table
Uo M Group Definition UoMGroupDefinition Object· Table: UGP1
Parent: Uo M Group Definition Collection UoMGroupDefinitionCollection Collection
UoM Group OUGP SQL Table
UoM Master Data OUOM SQL Table
Weight Units OWGT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | UgpEntry KEY UNIQUE | UoM Group Abs. Entry | Int | 11 | OUGP UoM Group | GROUP | Yes |
|---|---|---|---|---|---|---|---|---|
| UomEntry | UoM Abs. Entry | Int | 11 | OUOM UoM Master Data | ||||
| AltQty | Alternative Quantity | Num | 20 | |||||
| BaseQty | Base Quantity | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| LineNum | Row Number | Int | 11 | |||||
| WghtFactor | Weight Factor | Int | 6 | OWGT Weight Units | 0 | |||
| UdfFactor | UDF Factor | Int | 11 | -1 |
Table relationship map
SELECT statement
SELECT
UGP1.UgpEntry AS 'UoM Group Abs. Entry',
UGP1.UomEntry AS 'UoM Abs. Entry',
UGP1.AltQty AS 'Alternative Quantity',
UGP1.BaseQty AS 'Base Quantity',
UGP1.LogInstanc AS 'Log Instance',
UGP1.LineNum AS 'Row Number',
UGP1.WghtFactor AS 'Weight Factor',
UGP1.UdfFactor AS 'UDF Factor'
FROM UGP1 AS UGP1
Related information
Uo M Group Definition UoMGroupDefinition Object· Table: UGP1
Defines the unit of measurement group.
Source table: UGP1.
Parent: Uo M Group Definition Collection UoMGroupDefinitionCollection CollectionUoM Group OUGP SQL Table
UoM Master Data OUOM SQL Table
Weight Units OWGT SQL Table
UoMGroupDefinitionCollection
Object
UoMGroupDefinition
Method
Property
BaseQuantity
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
