|
|
API SWPD
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ProcDefID KEY UNIQUE | WF process definition ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DeploymtID | Deployment ID | Int | 11 | SWDP SWDP | ||||
| ResourceID | Resource ID | Int | 11 | SWRS SWRS | ||||
| Key | WF process definition key | nVarChar | 127 | |||||
| Name | WF process definition name | nVarChar | 127 | |||||
| Desc | WF process definition | Text | 16 | |||||
| Category | WF category uri | nVarChar | 50 | |||||
| Version | WF process definition version | nVarChar | 13 | |||||
| ProcType | Process definition type | nVarChar | 20 | |||||
| Status | Status during import | VarChar | M) Importing P) Imported F) Import failed I) Inactive A) Active E) Activate failed D) Deleted | 1 | M | |||
| StartType | Start Type | VarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates