biuan SAP® BUSINESS ONE SDK
DTW Sales / Sales Order
API PQW1
PQW1 - Purchase Quotation Generation: Line Items Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11OPQW
Purchase Quotation Generation: Parameter Sets
PRIMARYYes
LineNumRow NumberInt
11
ItemCodeItem No.nVarChar
20OITM
Items
DscriptionItem/Service DescriptionnVarChar
100
PQTReqDatePur Quotation: Required DateDate
8
PQTReqQtyPur Quotation: Required QtyNum
20
BuyUnitMsrPurchasing UoMnVarChar
100
FreeTxtFree TextnVarChar
100
PQTGrpNumPur. Quotation Group NumberInt
11
PQTGrpSerPur. Quotation Group SeriesInt
6
PQTGrpHWPur. Quotation Group ManualVarChar
Y) Yes
N) No
1
N
ValidUntilValid Until DateDate
8
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
PQTSeriesPurchase Quotation SeriesInt
6NNM1
Documents Numbering - Series
PRAbsEntryPurchase Request NumberInt
11OPRQ
Purchase Request
ReqNameRequester NamenVarChar
127
PRLineNumPurchase Request Row NumberInt
11
PRLineStatPurchase Request Row StatusVarChar
1
DistriRuleDistribution RulenVarChar
8
ProjectProject CodenVarChar
20
VendMfrNumVendor Mfr Catalog No.nVarChar
17
ShipTypeShipping TypeInt
6
ItmPerUnitNo. of Items per Purchase UnitNum
20

Table relationship map

SELECT statement

SELECT PQW1.AbsEntry AS 'Internal Number', PQW1.LineNum AS 'Row Number', PQW1.ItemCode AS 'Item No.', PQW1.Dscription AS 'Item/Service Description', PQW1.PQTReqDate AS 'Pur Quotation: Required Date', PQW1.PQTReqQty AS 'Pur Quotation: Required Qty', PQW1.BuyUnitMsr AS 'Purchasing UoM', PQW1.FreeTxt AS 'Free Text', PQW1.PQTGrpNum AS 'Pur. Quotation Group Number', PQW1.PQTGrpSer AS 'Pur. Quotation Group Series', PQW1.PQTGrpHW AS 'Pur. Quotation Group Manual', PQW1.ValidUntil AS 'Valid Until Date', PQW1.WhsCode AS 'Warehouse Code', PQW1.PQTSeries AS 'Purchase Quotation Series', PQW1.PRAbsEntry AS 'Purchase Request Number', PQW1.ReqName AS 'Requester Name', PQW1.PRLineNum AS 'Purchase Request Row Number', PQW1.PRLineStat AS 'Purchase Request Row Status', PQW1.DistriRule AS 'Distribution Rule', PQW1.Project AS 'Project Code', PQW1.VendMfrNum AS 'Vendor Mfr Catalog No.', PQW1.ShipType AS 'Shipping Type', PQW1.ItmPerUnit AS 'No. of Items per Purchase Unit' FROM PQW1 AS PQW1

Related information


Purchase Quotation Generation: Parameter Sets OPQW SQL Table

Items OITM SQL Table

Documents Numbering - Series NNM1 SQL Table

Purchase Request OPRQ SQL Table

Warehouses OWHS 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