|
|
API Document Packages / Document Package Items
INV7 - A/R Invoice - Delivery Packages Table
Document Package Items DocumentPackageItems Object· Table: INV7
Parent: Document Packages DocumentPackages Object
A/R Invoice OINV 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 | OINV A/R 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 | 13 | |||
| LogInstanc | Log Instance | Int | 11 | 0 |
Table relationship map
SELECT statement
SELECT
INV7.DocEntry AS 'Document Internal ID',
INV7.PackageNum AS 'Package Number',
INV7.PackageTyp AS 'Package Type',
INV7.Weight AS 'Weight',
INV7.WeightUnit AS 'UoM',
INV7.ObjType AS 'Object Type',
INV7.LogInstanc AS 'Log Instance'
FROM INV7 AS INV7
Related information
Document Package Items DocumentPackageItems Object· Table: INV7
A data structure holding the properties of items in a package.
Access this structure via DocumentPackages.Items.
Source table: DLN8.
Parent: Document Packages DocumentPackages ObjectA/R Invoice OINV SQL Table
Object Settings - History ADP1 SQL Table
Weight Units OWGT SQL Table
DocumentPackages
Object
DocumentPackageItems
Method
Property
MeasureUnit
DB
UoMEntry
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
