|
|
DTW Banking / Bank Statements and External Reconciliations / Bank Pages
API ODOW
ODOW - Data Ownership - Objects Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Object KEY UNIQUE | The Object Number | nVarChar | 20 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| SubObject | Array Offset | Int | 6 | 0 | ||||
| OwnerField | Column Number of Owner | Int | 6 | |||||
| Active | Indication: Does it Work | VarChar | Y) Yes N) No | 1 | Y | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UpdateUser | Updating User | Int | 6 | OUSR Users | ||||
| CreateDate | Creation Date | Date | 8 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Upgrade M) Import O) DI API A) Auto Summary D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| AC | Cache Access Counter | Int | 11 | 0 |
SELECT statement
SELECT
ODOW.Object AS 'The Object Number',
ODOW.SubObject AS 'Array Offset',
ODOW.OwnerField AS 'Column Number of Owner',
ODOW.Active AS 'Indication: Does it Work',
ODOW.UserSign AS 'User Signature',
ODOW.UpdateUser AS 'Updating User',
ODOW.CreateDate AS 'Creation Date',
ODOW.UpdateDate AS 'Date of Update',
ODOW.DataSource AS 'Data Source',
ODOW.AC AS 'Cache Access Counter'
FROM ODOW AS ODOW
Related information
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
