|
|
API OIVQ
OIVQ - FIFO Queue Working Table Table
Items OITM SQL Table
Whse Journal OIVL SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TreeID KEY | Tree ID | Int | 11 | 0 | TreeOpenQt | No |
|---|---|---|---|---|---|---|---|---|
| ParentID | Parent ID | Int | 11 | -1 | ||||
| LocType | Location Type | Int | 6 | |||||
| LocCode | Location Code | nVarChar | 8 | |||||
| TransSeq KEY UNIQUE | Transaction Sequence No. | Int | 11 | OIVL Whse Journal | TRANS_SEQ | Yes | ||
| LayerID | Layer ID | Int | 11 | |||||
| OpenQty | Open Quantity | Num | 20 | |||||
| OpenValue | Open Value | Num | 20 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| AbsEntry KEY UNIQUE | Internal ID | Int | 11 | PRIMARY | Yes | |||
| StockActio | Stock Action Type | Int | 15) Delivery 16) Returns 13) A/R Invoice 14) A/R Credit Memo 132) Correction Invoice (-0) (- 20) Goods Receipt 21) Goods Return 18) A/P Invoice 19) A/P Credit Memo (-1) (- -2) Opening Balance 58) Inventory Update 59) Goods Receipt 60) Goods Issue 67) Inventory Transfer 68) Work Instructions (-2) (- -1) All Transactions 162) Inventory Revaluation 69) Landed Costs | 11 | -1 | |||
| RemMethod | Quantity Removal Method | VarChar | U) Unspecified I) Issue R) Revaluation | 1 | U |
Table relationship map
SELECT statement
SELECT
OIVQ.TreeID AS 'Tree ID',
OIVQ.ParentID AS 'Parent ID',
OIVQ.LocType AS 'Location Type',
OIVQ.LocCode AS 'Location Code',
OIVQ.TransSeq AS 'Transaction Sequence No.',
OIVQ.LayerID AS 'Layer ID',
OIVQ.OpenQty AS 'Open Quantity',
OIVQ.OpenValue AS 'Open Value',
OIVQ.ItemCode AS 'Item Code',
OIVQ.AbsEntry AS 'Internal ID',
OIVQ.StockActio AS 'Stock Action Type',
OIVQ.RemMethod AS 'Quantity Removal Method'
FROM OIVQ AS OIVQ
Related information
Items OITM SQL Table
Whse Journal OIVL SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
