biuan SAP® BUSINESS ONE SDK
DTW Material Group
API Material Groups Service / Material Group
OMGP - Material Group Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEIDInt
11
PRIMARYYes
MatGrp KEY UNIQUEMaterial GroupnVarChar
3
CODEYes
DescripDescriptionnVarChar
70
LogInstancLog InstanceInt
11
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8

Table relationship map

SELECT statement

SELECT OMGP.AbsEntry AS 'ID', OMGP.MatGrp AS 'Material Group', OMGP.Descrip AS 'Description', OMGP.LogInstanc AS 'Log Instance', OMGP.UserSign2 AS 'Updating User', OMGP.UpdateDate AS 'Update Date' FROM OMGP AS OMGP

Related information


Material Group MaterialGroup Object· Table: OMGP
Represents a material group, which is used for the automatic tax code determination for materials. Source table: OMGP.
   Parent: Material Groups Service MaterialGroupsService Service· Table: OMGP

Material Groups Service MaterialGroupsService Service· Table: OMGP
The MaterialGroupsService service enables you to add, look up, update, and remove material groups. Source table: OMGP.

OMGP 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates