|
|
API Document Packages / Document Package Items
DLN8 - Items in Package - Delivery Table
Document Package Items DocumentPackageItems Object· Table: DLN8
Parent: Document Packages DocumentPackages Object
Delivery ODLN SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
UoM Master Data OUOM 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 | ODLN Delivery | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PackageNum | Package Number | Int | 11 | |||||
| ItemCode | Item Number | nVarChar | 20 | OITM Items | ||||
| Quantity | Quantity | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 15 | |||
| UomEntry | UoM Entry | Int | 11 | OUOM UoM Master Data | 0 | |||
| unitMsr | Unit | nVarChar | 100 | |||||
| NumPerMsr | UoM Value | Num | 20 | 0 |
Table relationship map
SELECT statement
SELECT
DLN8.DocEntry AS 'Document Internal ID',
DLN8.PackageNum AS 'Package Number',
DLN8.ItemCode AS 'Item Number',
DLN8.Quantity AS 'Quantity',
DLN8.LogInstanc AS 'Log Instance',
DLN8.ObjType AS 'Object Type',
DLN8.UomEntry AS 'UoM Entry',
DLN8.unitMsr AS 'Unit',
DLN8.NumPerMsr AS 'UoM Value'
FROM DLN8 AS DLN8
Related information
Document Package Items DocumentPackageItems Object· Table: DLN8
A data structure holding the properties of items in a package.
Access this structure via DocumentPackages.Items.
Source table: DLN8.
Parent: Document Packages DocumentPackages ObjectDelivery ODLN SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
UoM Master Data OUOM 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
