biuan SAP® BUSINESS ONE SDK
API KPI Item Lines / KPI Item Line
KPI1 - Key Performance Indicator Field Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
KPIEntryKPI NumberInt
11
TypeKPI Field TypeInt
11
FieldNameKPI Field NamenVarChar
127
MethodAggregation MethodnVarChar
127
DbTypeDatabase TypenVarChar
127
DefValueDefault ValuenVarChar
127

SELECT statement

SELECT KPI1.AbsEntry AS 'Internal Number', KPI1.KPIEntry AS 'KPI Number', KPI1.Type AS 'KPI Field Type', KPI1.FieldName AS 'KPI Field Name', KPI1.Method AS 'Aggregation Method', KPI1.DbType AS 'Database Type', KPI1.DefValue AS 'Default Value' FROM KPI1 AS KPI1

Related information


KPI Item Line KPI_ItemLine Object· Table: KPI1
KPI_ItemLine is a child object of the KPI object and represents the line entries of a parameter set. Source table: KPI1.
   Parent: KPI Item Lines KPI_ItemLines Collection


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