biuan SAP® BUSINESS ONE SDK
API OKPS
OKPS - KPI Set Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
KpsCode KEY UNIQUEKPI Set CodenVarChar
15
PRIMARYYes
KpsNameKPI Set NamenVarChar
100
KpsTypeKPI Set TypeVarChar
S) Single
Q) Quarterly
M) Monthly
P) Multiple
1
S
FieldsNumKPI Set Fields NumberInt
11
CreateDateCreate Date - HistoryDate
8
UserSignUpdating User - HistoryInt
6OUSR
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates