|
|
DTW Sales / Return
API OPRO
OPRO - Property Object Table
Mapping Elements OMAP SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Property ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| MapID KEY UNIQUE | Mapping ID | Int | 11 | OMAP Mapping Elements | CODE_NAME | Yes | ||
| Code | Input/Output Code | Int | 11 | |||||
| Type | Property Type | nVarChar | Strin) String XML) XML String) | 6 | Strin | |||
| Name | Property Name | nVarChar | 50 | |||||
| IsBlob | Is BLOB Type | VarChar | Y) N) | 1 | ||||
| TValue | Text Value | nVarChar | 127 | |||||
| BValue | BLOB Value | Text | 16 | |||||
| Encoding | Encoding | nVarChar | base64) | 20 |
SELECT statement
SELECT
OPRO.AbsEntry AS 'Property ID',
OPRO.MapID AS 'Mapping ID',
OPRO.Code AS 'Input/Output Code',
OPRO.Type AS 'Property Type',
OPRO.Name AS 'Property Name',
OPRO.IsBlob AS 'Is BLOB Type',
OPRO.TValue AS 'Text Value',
OPRO.BValue AS 'BLOB Value',
OPRO.Encoding AS 'Encoding'
FROM OPRO AS OPRO
Related information
Mapping Elements OMAP SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates