biuan SAP® BUSINESS ONE SDK
API WPK1
WPK1 - Dashboard Packages' Parameter or Filter Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DsbrdEntryDashboard EntryInt
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 WPK1.AbsEntry AS 'Internal Number', WPK1.DsbrdEntry AS 'Dashboard Entry', WPK1.Type AS 'Type', WPK1.FldName AS 'Field Name', WPK1.FldMethod AS 'Field Method', WPK1.Operator AS 'Operator', WPK1.DbType AS 'Database Type', WPK1.SqlType AS 'SQL Type', WPK1.FromValue AS 'From Value', WPK1.ToValue AS 'To Value', WPK1.DftValue AS 'Default Value', WPK1.ParamType AS 'Parameter Type', WPK1.UdqPh AS 'UDQ Parameter's Placeholder', WPK1.UdqOp AS 'UDQ Parameter's Operator' FROM WPK1 AS WPK1

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