|
|
API PCH7
PCH7 - Delivery Packages - A/P Invoice Table
A/P Invoice OPCH 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 | Document Internal ID | Int | 11 | OPCH A/P Invoice | 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 | 18 | |||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
PCH7.DocEntry AS 'Document Internal ID',
PCH7.PackageNum AS 'Package Number',
PCH7.PackageTyp AS 'Package Type',
PCH7.Weight AS 'Weight',
PCH7.WeightUnit AS 'UoM',
PCH7.ObjType AS 'Object Type',
PCH7.LogInstanc AS 'Log Instance'
FROM PCH7 AS PCH7
Related information
A/P Invoice OPCH 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