|
|
DTW Business Partners / Business Partner Master Data
API SDEX
SDEX - Dynamic Extensions Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | FormId KEY UNIQUE | Form ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItemId | Item ID | Int | 11 | 0 | ||||
| ColumnId | Column ID | Int | 11 | 0 | ||||
| BefAppl | Application Before | Text | 16 | |||||
| AftAppl | Application After | Text | 16 | |||||
| BefScript | Is Script Before | VarChar | Y) Yes N) No | 1 | Y | |||
| AftScript | Is Script After | VarChar | Y) Yes N) No | 1 | Y | |||
| UserSign | User Signature | Int | 6 | OUSR Users | -1 |
SELECT statement
SELECT
SDEX.FormId AS 'Form ID',
SDEX.ItemId AS 'Item ID',
SDEX.ColumnId AS 'Column ID',
SDEX.BefAppl AS 'Application Before',
SDEX.AftAppl AS 'Application After',
SDEX.BefScript AS 'Is Script Before',
SDEX.AftScript AS 'Is Script After',
SDEX.UserSign AS 'User Signature'
FROM SDEX AS SDEX
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
