|
|
API UIVE
UIVE - FIFO Based Sales Return 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 | TreeID | No |
|---|---|---|---|---|---|---|---|---|
| ParentID | Parent ID | Int | 11 | -1 | ||||
| AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes | |||
| LocType | Location Type | Int | 6 | |||||
| LocCode | Location Code | nVarChar | 8 | |||||
| TransSeq KEY | Transaction Sequence No. | Int | 11 | UIVL Whse Journal | TRANS_SEQ | No | ||
| LayerID | Layer ID | Int | 11 | |||||
| LayerInQty | Layer In Quantity | Num | 20 | |||||
| LayerOutQ | Layer Out Quantity | Num | 20 | |||||
| LayerVal | Layer Value | Num | 20 | |||||
| ItemCode | Item Code | nVarChar | 20 | UITM Items | ||||
| EntryTreeI | Entry Tree ID | Int | 11 | |||||
| LayerCogs | Layer - Cost of Goods Sold | Num | 20 |
Table relationship map
SELECT statement
SELECT
UIVE.TreeID AS 'Tree ID',
UIVE.ParentID AS 'Parent ID',
UIVE.AbsEntry AS 'Internal Number',
UIVE.LocType AS 'Location Type',
UIVE.LocCode AS 'Location Code',
UIVE.TransSeq AS 'Transaction Sequence No.',
UIVE.LayerID AS 'Layer ID',
UIVE.LayerInQty AS 'Layer In Quantity',
UIVE.LayerOutQ AS 'Layer Out Quantity',
UIVE.LayerVal AS 'Layer Value',
UIVE.ItemCode AS 'Item Code',
UIVE.EntryTreeI AS 'Entry Tree ID',
UIVE.LayerCogs AS 'Layer - Cost of Goods Sold'
FROM UIVE AS UIVE
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
