biuan SAP® BUSINESS ONE SDK
DTW Docs. for Confirmation
API Approval Requests Service / Approval Request
OWDD - Docs. for Confirmation Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
WddCode KEY UNIQUEInternal NumberInt
11
PRIMARYYes
WtmCodeAuthorization TemplateInt
11OWTM
Approval Templates
OwnerIDProduction CodeInt
11OUSR
Users
DocEntryDocument CounterInt
11
ObjTypeObject TypenVarChar
23) Sales Quotation
17) Sales Order
15) Delivery
16) Return
203) A/R Down Payment
13) A/R Invoice
165) A/R Correction Invoice
166) A/R Correction Invoice Reversal
14) A/R Credit Memo
132) Correction Invoice
(-0) (-
1470000113) Purchase Request
540000006) Purchase Quotation
22) Purchase Order
20) Goods Receipt PO
21) Goods Returns
204) A/P Down Payment
18) A/P Invoice
163) A/P Correction Invoice
164) A/P Correction Invoice Reversal
19) A/P Credit Memo
(-1) (-
59) Goods Receipt
60) Goods Issue
1250000001) Inventory Transfer Request
67) Inventory Transfer
310000001) Inventory Opening Balance
(-2) (-
46) Outgoing Payment
(-3) (-
1470000065) Inventory Counting
10000071) Inventory Posting
112) Documents - Drafts
140) Payment Drafts
1470000109) Inventory Counting - Drafts
1470000136) Inventory Posting - Drafts
1470000131) Inventory Opening Balance - Drafts
20
DocDatePosting DateDate
8
CurrStepStage CodeInt
11OWST
Confirmation Level
StatusStatusVarChar
W) Pending
Y) Approved
N) Rejected
P) Generated
A) Generated by Authorizer
C) Canceled
1
W
RemarksRemarksnVarChar
100
UserSignUser SignatureInt
6OUSR
Users
CreateDateProduction DateDate
8
CreateTimeProduction TimeInt
6
IsDraftDraftVarChar
Y) Yes
N) No
1
Y
MaxReqrNo. of AuthorizersInt
6
MaxRejReqrNo. of RejectsInt
6

Table relationship map

SELECT statement

SELECT OWDD.WddCode AS 'Internal Number', OWDD.WtmCode AS 'Authorization Template', OWDD.OwnerID AS 'Production Code', OWDD.DocEntry AS 'Document Counter', OWDD.ObjType AS 'Object Type', OWDD.DocDate AS 'Posting Date', OWDD.CurrStep AS 'Stage Code', OWDD.Status AS 'Status', OWDD.Remarks AS 'Remarks', OWDD.UserSign AS 'User Signature', OWDD.CreateDate AS 'Production Date', OWDD.CreateTime AS 'Production Time', OWDD.IsDraft AS 'Draft', OWDD.MaxReqr AS 'No. of Authorizers', OWDD.MaxRejReqr AS 'No. of Rejects' FROM OWDD AS OWDD

Related information


Approval Request ApprovalRequest Object· Table: OWDD
Represents an approval request. Source table: OWDD.
   Parent: Approval Requests Service ApprovalRequestsService Service· Table: OWDD

Approval Request Params ApprovalRequestParams Object· Table: OWDD
Holds the key, remarks, and status of an approval request. This object is used to pass keys to and retrieve keys from ApprovalRequestsService methods. Source table: OWDD.
   Parent: Approval Requests Params ApprovalRequestsParams Collection

Approval Requests Service ApprovalRequestsService Service· Table: OWDD
ApprovalRequestsService is a business object that manages the approval requests process in the SAP Business One environment. This object enables users to do the following: Get an approval request from the approval process. Get a list of...

Confirmation Level OWST SQL Table

Users OUSR SQL Table

Approval Templates OWTM SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates