biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Items / Material Type
DTW Inventory / Item Master Data / Material Type
API Items / Material Type
OMTP - Material Type Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUENumeratorInt
11
PRIMARYYes
MatTypeMaterial TypenVarChar
50
DescripDescriptionnVarChar
100

SELECT statement

SELECT OMTP.AbsEntry AS 'Numerator', OMTP.MatType AS 'Material Type', OMTP.Descrip AS 'Description' FROM OMTP AS OMTP

Related information


Material Type MaterialType Property· Table: OMTP
Sets or returns a valid value of BoMaterialTypes that determines current material state from Raw Material to Finished Goods. Field name: MatType.
· Table: OITM    Parent: Items Items Object· Table: OITM
OMTP 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