|
|
API AUGP
AUGP - UoM Group 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 | UoM Group Code | nVarChar | 20 | |||||
| UgpName | UoM Group Name | nVarChar | 100 | |||||
| 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
AUGP.UgpEntry AS 'UoM Group Abs. Entry',
AUGP.UgpCode AS 'UoM Group Code',
AUGP.UgpName AS 'UoM Group Name',
AUGP.BaseUom AS 'Base UoM Abs. Entry',
AUGP.DataSource AS 'Data Source',
AUGP.UserSign AS 'User Signature',
AUGP.LogInstanc AS 'Log Instance',
AUGP.UserSign2 AS 'Updating User',
AUGP.UpdateDate AS 'Date of Update',
AUGP.CreateDate AS 'Creation Date',
AUGP.Locked AS 'Locked'
FROM AUGP AS AUGP
Related information
UoM Master Data OUOM SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates