biuan SAP® BUSINESS ONE SDK
API SWPD
SWPD - SWPD Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ProcDefID KEY UNIQUEWF process definition IDInt
11
PRIMARYYes
DeploymtIDDeployment IDInt
11SWDP
SWDP
ResourceIDResource IDInt
11SWRS
SWRS
KeyWF process definition keynVarChar
127
NameWF process definition namenVarChar
127
DescWF process definitionText
16
CategoryWF category urinVarChar
50
VersionWF process definition versionnVarChar
13
ProcTypeProcess definition typenVarChar
20
StatusStatus during importVarChar
M) Importing
P) Imported
F) Import failed
I) Inactive
A) Active
E) Activate failed
D) Deleted
1
M
StartTypeStart TypeVarChar
M) Manual Start
T) Timer Start
C) Conditional Start
1
M

Table relationship map

SELECT statement

SELECT SWPD.ProcDefID AS 'WF process definition ID', SWPD.DeploymtID AS 'Deployment ID', SWPD.ResourceID AS 'Resource ID', SWPD.Key AS 'WF process definition key', SWPD.Name AS 'WF process definition name', SWPD.Desc AS 'WF process definition', SWPD.Category AS 'WF category uri', SWPD.Version AS 'WF process definition version', SWPD.ProcType AS 'Process definition type', SWPD.Status AS 'Status during import', SWPD.StartType AS 'Start Type' FROM SWPD AS SWPD

Related information


SWDP SWDP SQL Table

SWRS SWRS SQL Table



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