|
|
DTW Administration / Setup / Inventory / Unit of Measure Groups / UoM Group
API Unit Of Measurement Groups Service / Unit Of Measurement Group
OUGP - UoM Group Table
Unit Of Measurement Group UnitOfMeasurementGroup Object· Table: OUGP
Parent: Unit Of Measurement Groups Service UnitOfMeasurementGroupsService Service· Table: OUGP
Unit Of Measurement Groups Service UnitOfMeasurementGroupsService Service· Table: OUGP
OUGP SQL Table
UoM Master Data OUOM SQL Table
Users OUSR 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 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| UgpCode KEY UNIQUE | UoM Group Code | nVarChar | 20 | CODE | Yes | |||
| UgpName KEY | UoM Group Name | nVarChar | 100 | NAME | No | |||
| BaseUom | Base UoM Abs. Entry | Int | 11 | OUOM UoM Master Data | ||||
| 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 | 11 | 0 | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| UpdateDate | Date of Update | Date | 8 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OUGP.UgpEntry AS 'UoM Group Abs. Entry',
OUGP.UgpCode AS 'UoM Group Code',
OUGP.UgpName AS 'UoM Group Name',
OUGP.BaseUom AS 'Base UoM Abs. Entry',
OUGP.DataSource AS 'Data Source',
OUGP.UserSign AS 'User Signature',
OUGP.LogInstanc AS 'Log Instance',
OUGP.UserSign2 AS 'Updating User',
OUGP.UpdateDate AS 'Date of Update',
OUGP.CreateDate AS 'Creation Date',
OUGP.Locked AS 'Locked'
FROM OUGP AS OUGP
Related information
Unit Of Measurement Group UnitOfMeasurementGroup Object· Table: OUGP
A UoM (Unit of Measurement) group is a set of UoMs that you want to use for a certain type of product. Each UoM group has a base UoM. All the other UoMs belonging to this group are related to this base UoM by conversion rules.
You can assign a...
Parent: Unit Of Measurement Groups Service UnitOfMeasurementGroupsService Service· Table: OUGP Unit Of Measurement Groups Service UnitOfMeasurementGroupsService Service· Table: OUGP
The UnitOfMeasurementGroupsService service enables you to add, look up, update, and remove unit of measurement groups.
Source table: OUGP.
OUGP SQL Table
UoM Master Data OUOM SQL Table
Users OUSR SQL Table
UnitOfMeasurementGroupsService
Object
UnitOfMeasurementGroup
Collection
Method
Property
AbsEntry
DTW DB
BaseUoM
DTW DB
Code
DTW DB
Name
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
