|
|
DTW Sales / Sales Order
API PQW1
PQW1 - Purchase Quotation Generation: Line Items Table
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | OPQW Purchase Quotation Generation: Parameter Sets | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| ItemCode | Item No. | nVarChar | 20 | OITM Items | ||||
| Dscription | Item/Service Description | nVarChar | 100 | |||||
| PQTReqDate | Pur Quotation: Required Date | Date | 8 | |||||
| PQTReqQty | Pur Quotation: Required Qty | Num | 20 | |||||
| BuyUnitMsr | Purchasing UoM | nVarChar | 100 | |||||
| FreeTxt | Free Text | nVarChar | 100 | |||||
| PQTGrpNum | Pur. Quotation Group Number | Int | 11 | |||||
| PQTGrpSer | Pur. Quotation Group Series | Int | 6 | |||||
| PQTGrpHW | Pur. Quotation Group Manual | VarChar | Y) Yes N) No | 1 | N | |||
| ValidUntil | Valid Until Date | Date | 8 | |||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| PQTSeries | Purchase Quotation Series | Int | 6 | NNM1 Documents Numbering - Series | ||||
| PRAbsEntry | Purchase Request Number | Int | 11 | OPRQ Purchase Request | ||||
| ReqName | Requester Name | nVarChar | 127 | |||||
| PRLineNum | Purchase Request Row Number | Int | 11 | |||||
| PRLineStat | Purchase Request Row Status | VarChar | 1 | |||||
| DistriRule | Distribution Rule | nVarChar | 8 | |||||
| Project | Project Code | nVarChar | 20 | |||||
| VendMfrNum | Vendor Mfr Catalog No. | nVarChar | 17 | |||||
| ShipType | Shipping Type | Int | 6 | |||||
| ItmPerUnit | No. of Items per Purchase Unit | Num | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
