biuan SAP® BUSINESS ONE SDK
SQL Others / KPI Set Array 1
API KPS1
KPS1 - KPI Set Array 1 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
KpsCode KEY UNIQUEKPI Set CodenVarChar
15
NAMEYes
LineNumKPI Line NumberInt
11
KpiNameKPI NamenVarChar
100
KpiValue1KPI Value 1Num
20
KpiValue2KPI Value 2Num
20
KpiValue3KPI Value 3Num
20
KpiValue4KPI Value 4Num
20
KpiValue5KPI Value 5Num
20
KpiValue6KPI Value 6Num
20
KpiValue7KPI Value 7Num
20
KpiValue8KPI Value 8Num
20
KpiValue9KPI Value 9Num
20
KpiValue10KPI Value 10Num
20
KpiValue11KPI Value 11Num
20
KpiValue12KPI Value 12Num
20
KpiValue13KPI Value 13Num
20
KpiValue14KPI Value 14Num
20
KpiValue15KPI Value 15Num
20
KpiValue16KPI Value 16Num
20
KpiValue17KPI Value 17Num
20
KpiValue18KPI Value 18Num
20
KpiValue19KPI Value 19Num
20
KpiValue20KPI Value 20Num
20
KpiValue21KPI Value 21Num
20
KpiValue22KPI Value 22Num
20
KpiValue23KPI Value 23Num
20
KpiValue24KPI Value 24Num
20
KpiValue25KPI Value 25Num
20
KpiValue26KPI Value 26Num
20
KpiValue27KPI Value 27Num
20
KpiValue28KPI Value 28Num
20
KpiValue29KPI Value 29Num
20
KpiValue30KPI Value 30Num
20

SELECT statement

SELECT KPS1.KpsCode AS 'KPI Set Code', KPS1.LineNum AS 'KPI Line Number', KPS1.KpiName AS 'KPI Name', KPS1.KpiValue1 AS 'KPI Value 1', KPS1.KpiValue2 AS 'KPI Value 2', KPS1.KpiValue3 AS 'KPI Value 3', KPS1.KpiValue4 AS 'KPI Value 4', KPS1.KpiValue5 AS 'KPI Value 5', KPS1.KpiValue6 AS 'KPI Value 6', KPS1.KpiValue7 AS 'KPI Value 7', KPS1.KpiValue8 AS 'KPI Value 8', KPS1.KpiValue9 AS 'KPI Value 9', KPS1.KpiValue10 AS 'KPI Value 10', KPS1.KpiValue11 AS 'KPI Value 11', KPS1.KpiValue12 AS 'KPI Value 12', KPS1.KpiValue13 AS 'KPI Value 13', KPS1.KpiValue14 AS 'KPI Value 14', KPS1.KpiValue15 AS 'KPI Value 15', KPS1.KpiValue16 AS 'KPI Value 16', KPS1.KpiValue17 AS 'KPI Value 17', KPS1.KpiValue18 AS 'KPI Value 18', KPS1.KpiValue19 AS 'KPI Value 19', KPS1.KpiValue20 AS 'KPI Value 20', KPS1.KpiValue21 AS 'KPI Value 21', KPS1.KpiValue22 AS 'KPI Value 22', KPS1.KpiValue23 AS 'KPI Value 23', KPS1.KpiValue24 AS 'KPI Value 24', KPS1.KpiValue25 AS 'KPI Value 25', KPS1.KpiValue26 AS 'KPI Value 26', KPS1.KpiValue27 AS 'KPI Value 27', KPS1.KpiValue28 AS 'KPI Value 28', KPS1.KpiValue29 AS 'KPI Value 29', KPS1.KpiValue30 AS 'KPI Value 30' FROM KPS1 AS KPS1

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