biuan SAP® BUSINESS ONE SDK
SQL Others / Key Performance Indicator Package / Key Performance Indicator Package
DTW Key Performance Indicator Package
API KP Is Service / KPI
OKPI - Key Performance Indicator Package Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
CodeKPI CodenVarChar
127
NameKPI NamenVarChar
127
DescDescriptionnVarChar
127
ValueTypeValue TypenVarChar
127
ValueQidValue Query NumberInt
11
ViewNameValue View NamenVarChar
127
ViewCtgView CatalognVarChar
127
ViewSynView SynonymnVarChar
127
TrendTypeTrend TypenVarChar
127
TrendQidTrend Query NumberInt
11
GoalValueGoal ValueNum
20
GoalQidGoal Query NumbernVarChar
11
GoalDescGoal DescriptionnVarChar
127
CalcFrmlCalculation FormulanVarChar
127
VisibleVisible For Front EndVarChar
1
Y
SBetterSmaller Value is BetterVarChar
1
Y
AuthorCreatornVarChar
32
VersionVersionnVarChar
13
CreateDateCreate DateDate
8
CreateTimeCreate TimeInt
6
IsSystemIs SystemVarChar
1
N
MeasUnitMeasuring UnitnVarChar
50
0

SELECT statement

SELECT OKPI.AbsEntry AS 'Internal Number', OKPI.Code AS 'KPI Code', OKPI.Name AS 'KPI Name', OKPI.Desc AS 'Description', OKPI.ValueType AS 'Value Type', OKPI.ValueQid AS 'Value Query Number', OKPI.ViewName AS 'Value View Name', OKPI.ViewCtg AS 'View Catalog', OKPI.ViewSyn AS 'View Synonym', OKPI.TrendType AS 'Trend Type', OKPI.TrendQid AS 'Trend Query Number', OKPI.GoalValue AS 'Goal Value', OKPI.GoalQid AS 'Goal Query Number', OKPI.GoalDesc AS 'Goal Description', OKPI.CalcFrml AS 'Calculation Formula', OKPI.Visible AS 'Visible For Front End', OKPI.SBetter AS 'Smaller Value is Better', OKPI.Author AS 'Creator', OKPI.Version AS 'Version', OKPI.CreateDate AS 'Create Date', OKPI.CreateTime AS 'Create Time', OKPI.IsSystem AS 'Is System', OKPI.MeasUnit AS 'Measuring Unit' FROM OKPI AS OKPI

Related information


KPI KPI Object· Table: OKPI
A KPI set is a parameter set that you can define or modify parameters for dashboards. Source table: OKPI.
   Parent: KP Is Service KPIsService Service· Table: OKPI

KP Is Service KPIsService Service· Table: OKPI
The KPIsService service enables you to add, look up, update, and remove dashboard parameters. Source table: OKPI.
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates