|
|
DTW Administration / Setup / Inventory / Item Properties
API OITG / / Item Properties
OITG - Item Properties Table
Item Properties ItemProperties Object· Table: OITG
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItmsTypCod KEY UNIQUE | Number | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItmsGrpNam KEY UNIQUE | Property Name | nVarChar | 50 | GROUP_NAME | Yes | |||
| UserSign | User Signature | Int | 6 | OUSR 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
