biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Documents for Approval - Authorizers
API Approval Request Lines / Approval Request Line
WDD1 - Documents for Approval - Authorizers Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WddCode KEY UNIQUEInternal IDInt
11
PRIMARYYes
StepCodeStage KeyInt
11OWTM
Approval Templates
UserIDAuthorizer CodeInt
11OUSR
Users
StatusStatusVarChar
W) Pending
Y) Approved
N) Not Approved
1
W
RemarksRemarksnVarChar
100
UserSignUser SignatureInt
6OUSR
Users
CreateDateRequest DateDate
8
CreateTimeRequest TimeInt
6
UpdateDateDate of UpdateDate
8
UpdateTimeUpdate TimeInt
6

Table relationship map

SELECT statement

SELECT WDD1.WddCode AS 'Internal ID', WDD1.StepCode AS 'Stage Key', WDD1.UserID AS 'Authorizer Code', WDD1.Status AS 'Status', WDD1.Remarks AS 'Remarks', WDD1.UserSign AS 'User Signature', WDD1.CreateDate AS 'Request Date', WDD1.CreateTime AS 'Request Time', WDD1.UpdateDate AS 'Date of Update', WDD1.UpdateTime AS 'Update Time' FROM WDD1 AS WDD1

Related information


Approval Request Line ApprovalRequestLine Object· Table: WDD1
ApprovalRequestLine is a child object of the ApprovalRequest object. Since one approval request may have more than one authorizer, each line represents the details of the approval request to the authorizer. Source table: WDD1.
   Parent: Approval Request Lines ApprovalRequestLines Collection
Approval Templates OWTM SQL Table

Users OUSR 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