|
|
API OKPS
OKPS - KPI Set Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | KpsCode KEY UNIQUE | KPI Set Code | nVarChar | 15 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| KpsName | KPI Set Name | nVarChar | 100 | |||||
| KpsType | KPI Set Type | VarChar | S) Single Q) Quarterly M) Monthly P) Multiple | 1 | S | |||
| FieldsNum | KPI Set Fields Number | Int | 11 | |||||
| CreateDate | Create Date - History | Date | 8 | |||||
| UserSign | Updating User - History | Int | 6 | OUSR Users |
SELECT statement
SELECT
OKPS.KpsCode AS 'KPI Set Code',
OKPS.KpsName AS 'KPI Set Name',
OKPS.KpsType AS 'KPI Set Type',
OKPS.FieldsNum AS 'KPI Set Fields Number',
OKPS.CreateDate AS 'Create Date - History',
OKPS.UserSign AS 'Updating User - History'
FROM OKPS AS OKPS
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
