|
|
API PQT9
PQT9 - Purchase Quotation - Drawn DPM Table
Purchase Quotation OPQT SQL Table
Object Settings - History ADP1 SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Internal Document ID | Int | 11 | OPQT Purchase Quotation | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| BaseAbs | Base Document Internal ID | Int | 11 | |||||
| BaseLine | Base Document Row | Int | 11 | |||||
| TargetBase | Target or Base Document | VarChar | B) Base T) Target | 1 | B | |||
| ObjType | Base Object Type | nVarChar | 20 | |||||
| DrawnSum | Net LC | Num | 20 | |||||
| DrawnSumFc | Net FC | Num | 20 | |||||
| DrawnSumSc | Net SC | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjCode | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 540000006 | |||
| ApplDrawn | Applied Net LC | Num | 20 | |||||
| ApplDrawnF | Applied Net FC | Num | 20 | |||||
| ApplDrawnS | Applied Net SC | Num | 20 | |||||
| BaseDocNum | Base Document Number | Int | 11 | |||||
| BsDocDate | Base Posting Date | Date | 8 | |||||
| BsDueDate | Base Due Date | Date | 8 | |||||
| BsCardName | Base BP Name | nVarChar | 100 | |||||
| BsComments | Base Remarks | nVarChar | 127 | |||||
| Posted | Base Document Posted | VarChar | Y) Yes N) No | 1 | Y | |||
| Vat | Tax LC | Num | 20 | |||||
| VatFc | Tax FC | Num | 20 | |||||
| VatSc | Tax SC | Num | 20 | |||||
| Gross | Gross LC | Num | 20 | |||||
| GrossFc | Gross FC | Num | 20 | |||||
| GrossSc | Gross SC | Num | 20 | |||||
| IsGross | Is Gross Line | VarChar | N) Net Line Y) Gross Line | 1 | N |
Table relationship map
SELECT statement
SELECT
PQT9.DocEntry AS 'Internal Document ID',
PQT9.LineNum AS 'Row Number',
PQT9.BaseAbs AS 'Base Document Internal ID',
PQT9.BaseLine AS 'Base Document Row',
PQT9.TargetBase AS 'Target or Base Document',
PQT9.ObjType AS 'Base Object Type',
PQT9.DrawnSum AS 'Net LC',
PQT9.DrawnSumFc AS 'Net FC',
PQT9.DrawnSumSc AS 'Net SC',
PQT9.LogInstanc AS 'Log Instance',
PQT9.ObjCode AS 'Object Type',
PQT9.ApplDrawn AS 'Applied Net LC',
PQT9.ApplDrawnF AS 'Applied Net FC',
PQT9.ApplDrawnS AS 'Applied Net SC',
PQT9.BaseDocNum AS 'Base Document Number',
PQT9.BsDocDate AS 'Base Posting Date',
PQT9.BsDueDate AS 'Base Due Date',
PQT9.BsCardName AS 'Base BP Name',
PQT9.BsComments AS 'Base Remarks',
PQT9.Posted AS 'Base Document Posted',
PQT9.Vat AS 'Tax LC',
PQT9.VatFc AS 'Tax FC',
PQT9.VatSc AS 'Tax SC',
PQT9.Gross AS 'Gross LC',
PQT9.GrossFc AS 'Gross FC',
PQT9.GrossSc AS 'Gross SC',
PQT9.IsGross AS 'Is Gross Line'
FROM PQT9 AS PQT9
Related information
Purchase Quotation OPQT SQL Table
Object Settings - History ADP1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
