|
|
API OSRQ
OSRQ - Serial No. Quantities Table
OSRQ SQL Table
Items OITM SQL Table
Serial Numbers Master Data OSRN SQL Table
Tracking Note OTCN SQL Table
Tracking Note - Line Data TCN1 SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY UNIQUE | Item Code | nVarChar | 20 | OITM Items | SYSTEM_KEY | Yes |
|---|---|---|---|---|---|---|---|---|
| SysNumber | System Number | Int | 11 | OSRN Serial Numbers Master Data | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| Quantity | Quantity | Num | 20 | |||||
| CommitQty | Committed Quantity | Num | 20 | |||||
| CountQty | Counted Quantity | Num | 20 | |||||
| AbsEntry KEY UNIQUE | abs entry | Int | 11 | PRIMARY | Yes | |||
| MdAbsEntry KEY | MD Abs Entry | Int | 11 | OSRN Serial Numbers Master Data | MDABS_KEY | No | ||
| TrackingNt | CCD Tracking Note | Int | 11 | OTCN Tracking Note | ||||
| TrackiNtLn | CCD Tracking Note Line | Int | 11 | TCN1 Tracking Note - Line Data | ||||
| CCDQuant | CCD Quantity | Num | 20 |
Table relationship map
SELECT statement
SELECT
OSRQ.ItemCode AS 'Item Code',
OSRQ.SysNumber AS 'System Number',
OSRQ.WhsCode AS 'Warehouse Code',
OSRQ.Quantity AS 'Quantity',
OSRQ.CommitQty AS 'Committed Quantity',
OSRQ.CountQty AS 'Counted Quantity',
OSRQ.AbsEntry AS 'abs entry',
OSRQ.MdAbsEntry AS 'MD Abs Entry',
OSRQ.TrackingNt AS 'CCD Tracking Note',
OSRQ.TrackiNtLn AS 'CCD Tracking Note Line',
OSRQ.CCDQuant AS 'CCD Quantity'
FROM OSRQ AS OSRQ
Related information
OSRQ SQL Table
Items OITM SQL Table
Serial Numbers Master Data OSRN SQL Table
Tracking Note OTCN SQL Table
Tracking Note - Line Data TCN1 SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
