|
|
API SIVQ
SIVQ - FIFO Queue Working Table Table
Items SITM SQL Table
Whse Journal SIVL 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 | SIVL 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 | SITM 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
SIVQ.TreeID AS 'Tree ID',
SIVQ.ParentID AS 'Parent ID',
SIVQ.LocType AS 'Location Type',
SIVQ.LocCode AS 'Location Code',
SIVQ.TransSeq AS 'Transaction Sequence No.',
SIVQ.LayerID AS 'Layer ID',
SIVQ.OpenQty AS 'Open Quantity',
SIVQ.OpenValue AS 'Open Value',
SIVQ.ItemCode AS 'Item Code',
SIVQ.AbsEntry AS 'Internal ID',
SIVQ.StockActio AS 'Stock Action Type',
SIVQ.RemMethod AS 'Quantity Removal Method'
FROM SIVQ AS SIVQ
Related information
Items SITM SQL Table
Whse Journal SIVL SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
