|
|
API ODAB
ODAB - Dashboard Table
ODAB SQL Table
Dashboard Packages OWPK SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Key | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PackEntry KEY UNIQUE | Package Entry | Int | 11 | OWPK Dashboard Packages | CODE | Yes | ||
| DashbdCode | Dashboard Code | nVarChar | 32 | |||||
| DashbdName | Dashboard Name | nVarChar | 100 | |||||
| DashbdPath | Dashboard Path | nVarChar | 127 | |||||
| Note | Dashboard Description | Text | 16 | |||||
| Status | Dashboard Status | VarChar | I) Inactive A) Active | 1 | A | |||
| JobFlag | Use Schedule Job Flag | VarChar | Y) Yes N) No | 1 | N | |||
| JobType | Schedule Job Type | VarChar | R) Real Time P) Periodic | 1 | R | |||
| JobSetting | Schedule Job Time Setting | nVarChar | 100 | |||||
| RenewDate | Latest Renew Date | Date | 8 | |||||
| RenewTime | Latest Renew Time | Int | 6 | |||||
| ProcName | Procedure Name | nVarChar | 100 | |||||
| JobName | Schedule Job Name | nVarChar | 100 |
Table relationship map
SELECT statement
SELECT
ODAB.AbsEntry AS 'Internal Key',
ODAB.PackEntry AS 'Package Entry',
ODAB.DashbdCode AS 'Dashboard Code',
ODAB.DashbdName AS 'Dashboard Name',
ODAB.DashbdPath AS 'Dashboard Path',
ODAB.Note AS 'Dashboard Description',
ODAB.Status AS 'Dashboard Status',
ODAB.JobFlag AS 'Use Schedule Job Flag',
ODAB.JobType AS 'Schedule Job Type',
ODAB.JobSetting AS 'Schedule Job Time Setting',
ODAB.RenewDate AS 'Latest Renew Date',
ODAB.RenewTime AS 'Latest Renew Time',
ODAB.ProcName AS 'Procedure Name',
ODAB.JobName AS 'Schedule Job Name'
FROM ODAB AS ODAB
Related information
ODAB SQL Table
Dashboard Packages OWPK SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
