biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Item Properties
API OITG / / Item Properties
OITG - Item Properties Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItmsTypCod KEY UNIQUENumberInt
6
PRIMARYYes
ItmsGrpNam KEY UNIQUEProperty NamenVarChar
50
GROUP_NAMEYes
UserSignUser SignatureInt
6OUSR
Users

SELECT statement

SELECT OITG.ItmsTypCod AS 'Number', OITG.ItmsGrpNam AS 'Property Name', OITG.UserSign AS 'User Signature' FROM OITG AS OITG

Related information


Item Properties ItemProperties Object· Table: OITG
The ItemProperties object enables to update the property names that can be used for sorting or grouping items in reports. Source table: OITG

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