biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Unit of Measure Groups / UoM Group
API Unit Of Measurement Groups Service / Unit Of Measurement Group
OUGP - UoM Group Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
UgpEntry KEY UNIQUEUoM Group Abs. EntryInt
11
PRIMARYYes
UgpCode KEY UNIQUEUoM Group CodenVarChar
20
CODEYes
UgpName KEYUoM Group NamenVarChar
100
NAMENo
BaseUomBase UoM Abs. EntryInt
11OUOM
UoM Master Data
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
CreateDateCreation DateDate
8
LockedLockedVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates