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