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

API OWPK

SBO SQL database table details

Field	Description	Type	Constraints	Size	Default	Primary_Key	Unique
AbsEntry ^KEY ^UNIQUE	Internal Key	Int		11		PRIMARY	Yes
PackagCode ^KEY ^UNIQUE	Package Code	nVarChar		32		CODE	Yes
PackagName	Package Name	nVarChar		100
Note	Package Description	Text		16
Content	Package Content	Text		16
Author	Creator	nVarChar		32
Version	Version	nVarChar		13
CreateDate	Create Date	Date		8
CreateTime	Create Time	Int		6
IsSystem	Is System	VarChar	N) No Y) Yes	1	N
PackagType	Package Type	VarChar	D) Dashboard M) Mobile P) Pervasive	1	D
ISIMDB	IS IMDB	VarChar	N) No Y) Yes	1	N
StraType	Strategy Type	nVarChar		127	none
StraPara	Strategy Parameters	nVarChar		127
SourceType	Query Source Type	nVarChar		20	normal
ViewName	View's Name	nVarChar		127
ViewCtg	View's Catalog	nVarChar		127
ViewSyn	View's Synonym	nVarChar		127
Viewid	Query Number	Int		11

SELECT statement

SELECT
   OWPK.AbsEntry AS 'Internal Key', 
   OWPK.PackagCode AS 'Package Code', 
   OWPK.PackagName AS 'Package Name', 
   OWPK.Note AS 'Package Description', 
   OWPK.Content AS 'Package Content', 
   OWPK.Author AS 'Creator', 
   OWPK.Version AS 'Version', 
   OWPK.CreateDate AS 'Create Date', 
   OWPK.CreateTime AS 'Create Time', 
   OWPK.IsSystem AS 'Is System', 
   OWPK.PackagType AS 'Package Type', 
   OWPK.ISIMDB AS 'IS IMDB', 
   OWPK.StraType AS 'Strategy Type', 
   OWPK.StraPara AS 'Strategy Parameters', 
   OWPK.SourceType AS 'Query Source Type', 
   OWPK.ViewName AS 'View's Name', 
   OWPK.ViewCtg AS 'View's Catalog', 
   OWPK.ViewSyn AS 'View's Synonym', 
   OWPK.Viewid AS 'Query Number'
FROM OWPK AS OWPK

Related information

OWPK SQL Table

biuan SAP® BUSINESS ONE

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