biuan SAP® BUSINESS ONE SDK
DTW Sales / Sales Quotation
API OPQW
OPQW - Purchase Quotation Generation: Parameter Sets Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
SetName KEY UNIQUESet NamenVarChar
20
SET_NAMEYes
SetDescSet DescriptionnVarChar
100
CreateDateCreation DateDate
8
ModifyDateLast Modified DateDate
8
UserSignUser SignatureInt
6OUSR
Users
CreatDraftCreate DraftsVarChar
Y) Yes
N) No
1
N
GroupByGroup ByVarChar
B) Business Partner
I) Item
1
B
ValidUntilValid Until DateDate
8
BPLIdBranchInt
11OBPL
Business Place
ReqDateRequired DateDate
8
BaseOnBase On TypeVarChar
1

Table relationship map

SELECT statement

SELECT OPQW.AbsEntry AS 'Internal Number', OPQW.SetName AS 'Set Name', OPQW.SetDesc AS 'Set Description', OPQW.CreateDate AS 'Creation Date', OPQW.ModifyDate AS 'Last Modified Date', OPQW.UserSign AS 'User Signature', OPQW.CreatDraft AS 'Create Drafts', OPQW.GroupBy AS 'Group By', OPQW.ValidUntil AS 'Valid Until Date', OPQW.BPLId AS 'Branch', OPQW.ReqDate AS 'Required Date', OPQW.BaseOn AS 'Base On Type' FROM OPQW AS OPQW

Related information


OPQW SQL Table

Business Place OBPL 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