|
|
DTW Administration / Approval Procedures / Approval Templates / Approval Templates
API Approval Templates / Approval Template
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | WtmCode KEY UNIQUE | Code | Int | 11 | OWTM Approval Templates | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Name | nVarChar | 20 | NAME | Yes | |||
| Remarks | Description | nVarChar | 100 | |||||
| Conds | Conditions | VarChar | Y) Yes N) No | 1 | N | |||
| Active | Active | VarChar | Y) Yes N) No | 1 | Y | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| PmptChg | Prompt Change | VarChar | Y) Yes N) No | 1 | Y |
Table relationship map
SELECT statement
SELECT
OWTM.WtmCode AS 'Code',
OWTM.Name AS 'Name',
OWTM.Remarks AS 'Description',
OWTM.Conds AS 'Conditions',
OWTM.Active AS 'Active',
OWTM.UserSign AS 'User Signature',
OWTM.PmptChg AS 'Prompt Change'
FROM OWTM AS OWTM
Related information
Approval Template ApprovalTemplate Object· Table: OWTM
ApprovalTemplate is a data structure related to the ApprovalTemplatesService.
Source table: OWTM.
Parent: Approval Templates ApprovalTemplates Collection· Table: OWTM Approval Template Params ApprovalTemplateParams Object· Table: OWTM
The ApprovalTemplateParams specifies the identification key combination (Code and Name) for which the ApprovalTemplatesService is related.
Source table: OWTM.
Parent: Approval Templates Params ApprovalTemplatesParams Collection· Table: OWTM Approval Templates Params ApprovalTemplatesParams Collection· Table: OWTM
ApprovalTemplatesParams is a Data Collection of ApprovalTemplateParams identification keys.
Source table: OWTM.
Parent: Approval Templates Service ApprovalTemplatesService Service· Table: OWTM Approval Templates ApprovalTemplates Collection· Table: OWTM
ApprovalTemplates is a Data Collection of ApprovalTemplate data structures.
Source table: OWTM.
Approval Templates Service ApprovalTemplatesService Service· Table: OWTM
ApprovalTemplatesService is a business object that manages the Approval of deviations from organization limitations.
This object enables to:
Add a new Approval Stage to approval process.
Get Approval Stage from approval process.
Get a list...
Approval Templates OWTM SQL Table
Users OUSR SQL Table
ApprovalTemplates
Object
ApprovalTemplate
Collection
Method
Property
Code
DTW DB
IsActive
DTW DB
Name
DTW DB
Remarks
DTW DB
UseTerms
DTW DB
Method
Property
Code
9.0 DB
Name
9.0 DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates