| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DTW Sales / Sales Order API PQW1 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PQW1 - Purchase Quotation Generation: Line Items Table SBO SQL database table details
Table relationship mapSELECT statementSELECT
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 informationPurchase 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. Contact This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates |