|
|
API WTQ8
WTQ8 - Inventory Transfer Request - Items in Package Table
Inventory Transfer Request OWTQ 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 | Internal Document ID | Int | 11 | OWTQ Inventory Transfer Request | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PackageNum | Package Number | Int | 11 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| Quantity | Quantity | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 1250000001 | |||
| 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
WTQ8.DocEntry AS 'Internal Document ID',
WTQ8.PackageNum AS 'Package Number',
WTQ8.ItemCode AS 'Item Code',
WTQ8.Quantity AS 'Quantity',
WTQ8.LogInstanc AS 'Log Instance',
WTQ8.ObjType AS 'Object Type',
WTQ8.UomEntry AS 'UoM Entry',
WTQ8.unitMsr AS 'Unit',
WTQ8.NumPerMsr AS 'UoM Value'
FROM WTQ8 AS WTQ8
Related information
Inventory Transfer Request OWTQ SQL Table
Items OITM SQL Table
Object Settings - History ADP1 SQL Table
UoM Master Data OUOM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
