KPI1 - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Others / Key Performance Indicator Field

API KPI Item Lines / KPI Item Line

KPI1 - Key Performance Indicator Field Table

SBO SQL database table details

Field	Description	Type	Size	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Number	Int	11	PRIMARY	Yes
KPIEntry	KPI Number	Int	11
Type	KPI Field Type	Int	11
FieldName	KPI Field Name	nVarChar	127
Method	Aggregation Method	nVarChar	127
DbType	Database Type	nVarChar	127
DefValue	Default Value	nVarChar	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_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

biuan SAP® BUSINESS ONE

Collection
KPI_ItemLines

Object
KPI_ItemLine

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

KPICode

KPIName

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