|
|
API PQT7
PQT7 - Delivery Packages - Purchase Quotation Table
Purchase Quotation OPQT SQL Table
Object Settings - History ADP1 SQL Table
Weight Units OWGT 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 |
|---|---|---|---|---|---|---|---|---|
| PackageNum | Package Number | Int | 11 | |||||
| PackageTyp | Package Type | nVarChar | 30 | |||||
| Weight | Weight | Num | 20 | |||||
| WeightUnit | UoM | Int | 6 | OWGT Weight Units | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 540000006 | |||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
PQT7.DocEntry AS 'Internal Document ID',
PQT7.PackageNum AS 'Package Number',
PQT7.PackageTyp AS 'Package Type',
PQT7.Weight AS 'Weight',
PQT7.WeightUnit AS 'UoM',
PQT7.ObjType AS 'Object Type',
PQT7.LogInstanc AS 'Log Instance'
FROM PQT7 AS PQT7
Related information
Purchase Quotation OPQT SQL Table
Object Settings - History ADP1 SQL Table
Weight Units OWGT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
