|
|
DTW Administration / Approval Procedures / Approval Templates / Confirmation Level
API Approval Stages / Approval Stage
OWST - Confirmation Level Table
Approval Stage ApprovalStage Object· Table: OWST
Parent: Approval Stages ApprovalStages Collection· Table: OWST
Approval Stage Params ApprovalStageParams Object· Table: OWST Parent: Approval Stages Params ApprovalStagesParams Collection· Table: OWST
Approval Stages Params ApprovalStagesParams Collection· Table: OWST Parent: Approval Stages Service ApprovalStagesService Service· Table: OWST
Approval Stages ApprovalStages Collection· Table: OWST
Approval Stages Service ApprovalStagesService Service· Table: OWST
Confirmation Level OWST SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WstCode KEY UNIQUE | Stage | Int | 11 | OWST Confirmation Level | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Name | nVarChar | 20 | NAME | Yes | |||
| Remarks | Description | nVarChar | 100 | |||||
| MaxReqr | No. of Authorizers | Int | 6 | 1 | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| MaxRejReqr | No. of Rejects | Int | 6 | 1 |
Table relationship map
SELECT statement
SELECT
OWST.WstCode AS 'Stage',
OWST.Name AS 'Name',
OWST.Remarks AS 'Description',
OWST.MaxReqr AS 'No. of Authorizers',
OWST.UserSign AS 'User Signature',
OWST.MaxRejReqr AS 'No. of Rejects'
FROM OWST AS OWST
Related information
Approval Stage ApprovalStage Object· Table: OWST
ApprovalStage is a Data structure related to the ApprovalStagesService.
Source table: OWST.
Parent: Approval Stages ApprovalStages Collection· Table: OWST Approval Stage Params ApprovalStageParams Object· Table: OWST
The ApprovalStageParams specifies the identification key combination (Code and Name) for which the ApprovalStagesService is related.
Source table: OWST.
Parent: Approval Stages Params ApprovalStagesParams Collection· Table: OWST Approval Stages Params ApprovalStagesParams Collection· Table: OWST
ApprovalStagesParams is a Data Collection of ApprovalStageParams identification keys.
Source table: OWST.
Parent: Approval Stages Service ApprovalStagesService Service· Table: OWST Approval Stages ApprovalStages Collection· Table: OWST
The ApprovalStages is a Data Collection of ApprovalStage data structure.
Source table: OWST.
Approval Stages Service ApprovalStagesService Service· Table: OWST
ApprovalStagesService is a business object that manages the Approval stages Process in SAP Business One environment.
This object enables user to:
Add new Approval Stage to approval Process.
Get Approval Stage from approval Process.
Get a...
Confirmation Level OWST SQL Table
Users OUSR SQL Table
ApprovalStages
Object
ApprovalStage
Collection
Method
Property
Code
DTW DB
Name
DTW DB
NoOfApproversRequired
DTW DB
Remarks
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates