biuan SAP® BUSINESS ONE SDK
SQL Others / Key Performance Indicator Parameter or Filter
API KPI3
KPI3 - Key Performance Indicator Parameter or Filter Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
KPIEntryKPI NumberInt
11
TypeTypenVarChar
20
FldNameField NamenVarChar
127
FldMethodField MethodnVarChar
127
OperatorOperatornVarChar
127
DbTypeDatabase TypenVarChar
127
SqlTypeSQL TypeInt
11
FromValueFrom ValuenVarChar
127
ToValueTo ValuenVarChar
127
DftValueDefault ValuenVarChar
127
ParamTypeParameter TypenVarChar
20
UdqPhUDQ Parameter's PlaceholdernVarChar
50
UdqOpUDQ Parameter's OperatornVarChar
20

SELECT statement

SELECT KPI3.AbsEntry AS 'Internal Number', KPI3.KPIEntry AS 'KPI Number', KPI3.Type AS 'Type', KPI3.FldName AS 'Field Name', KPI3.FldMethod AS 'Field Method', KPI3.Operator AS 'Operator', KPI3.DbType AS 'Database Type', KPI3.SqlType AS 'SQL Type', KPI3.FromValue AS 'From Value', KPI3.ToValue AS 'To Value', KPI3.DftValue AS 'Default Value', KPI3.ParamType AS 'Parameter Type', KPI3.UdqPh AS 'UDQ Parameter's Placeholder', KPI3.UdqOp AS 'UDQ Parameter's Operator' FROM KPI3 AS KPI3

Related information
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