|
|
API IVL1
IVL1 - IVL Layer Level Table
Whse Journal OIVL SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TransSeq KEY UNIQUE | Transaction Sequence No. | Int | 11 | OIVL Whse Journal | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LayerID | Layer ID | Int | 11 | |||||
| CalcPrice | Calculated Price | Num | 20 | |||||
| Balance | Stock Balance | Num | 20 | |||||
| TransValue | Transaction Value | Num | 20 | |||||
| LayerInQty | Receipt Quantity | Num | 20 | |||||
| LayerOutQ | Issue Quantity | Num | 20 | |||||
| RevalTotal | Inventory Revaluation Total | Num | 20 |
SELECT statement
SELECT
IVL1.TransSeq AS 'Transaction Sequence No.',
IVL1.LayerID AS 'Layer ID',
IVL1.CalcPrice AS 'Calculated Price',
IVL1.Balance AS 'Stock Balance',
IVL1.TransValue AS 'Transaction Value',
IVL1.LayerInQty AS 'Receipt Quantity',
IVL1.LayerOutQ AS 'Issue Quantity',
IVL1.RevalTotal AS 'Inventory Revaluation Total'
FROM IVL1 AS IVL1
Related information
Whse Journal OIVL SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
