|
|
API UIVL
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TransType | Transaction 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 |
|---|---|---|---|---|---|---|---|---|
| CreatedBy KEY | Document No. Created | Int | 11 | DOCENTRY | No | |||
| BASE_REF | Base Reference | nVarChar | 11 | |||||
| DocLineNum | Row Number in Document | Int | 11 | |||||
| DocDate KEY | Posting Date | Date | 8 | DOCDATE | No | |||
| CreateTime | Generation Time | Int | 6 | |||||
| ItemCode KEY | Item No. | nVarChar | 20 | UITM Items | ITEM | No | ||
| InQty | Receipt Quantity | Num | 20 | |||||
| OutQty | Issue Quantity | Num | 20 | |||||
| Price | Price | Num | 20 | |||||
| Currency KEY | Price Currency | nVarChar | 3 | CURRENCY | No | |||
| Rate | Currency Price | Num | 20 | |||||
| TrnsfrAct | Transfer Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PriceDifAc | Price Difference Account | nVarChar | 15 | OACT G/L Accounts | ||||
| VarianceAc | Variance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ReturnAct | Returning Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExcRateAct | Exchange Rate Differences Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ClearAct | Goods Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CostAct | COGS Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipAct | WIP Inventory Account | nVarChar | 15 | OACT G/L Accounts | ||||
| OpenStock | Open Sum Inventory Value | Num | 20 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| PriceDiff | Price Difference Value | Num | 20 | |||||
| TransSeq KEY UNIQUE | Transaction Sequence No. | Int | 11 | 0 | PRIMARY | Yes | ||
| InvntAct | Inventory Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SubLineNum | Subrow Number | Int | 11 | -1 | ||||
| AppObjLine | Applied Object Row | Int | 11 | -1 | ||||
| Expenses | Inventory Expenses | Num | 20 | |||||
| OpenExp | Open Expenses Value | Num | 20 | |||||
| Allocation | Allocation Amount | Num | 20 | |||||
| OpenAlloc | Open Allocation Value | Num | 20 | |||||
| ExpAlloc | Expenses Allocation Value | Num | 20 | |||||
| OExpAlloc | Open Expenses Allocation Value | Num | 20 | |||||
| OpenPDiff | Open Price Diff. Value | Num | 20 | |||||
| ExchDiff | Exchange Rate Difference Value | Num | 20 | |||||
| OpenEDiff | Open Exchange Rate Diff. Value | Num | 20 | |||||
| NegInvAdjs | Negative Inventory Adjustment Value | Num | 20 | |||||
| OpenNegInv | Open Negative Adjustment | Num | 20 | |||||
| NegStckAct | Neg. Inventory Adjustment Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| BTransVal | Base Transaction Value | Num | 20 | |||||
| VarVal | Variance Value | Num | 20 | |||||
| BExpVal | Base Freight Value | Num | 20 | |||||
| CogsVal | COGS Value | Num | 20 | |||||
| BNegAVal | Base Negative Adjustment Amt | Num | 20 | |||||
| IOffIncAcc | Inventory Offset Increase Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| IOffIncVal | Inv. Offset Increase Value | Num | 20 | |||||
| DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DOffDecVal | Inv. Offset Decrease Value | Num | 20 | |||||
| DecAcc | G/L Decrease Account | nVarChar | 15 | OACT G/L Accounts | ||||
| DecVal | G/L Decrease Value | Num | 20 | |||||
| WipVal | WIP Inventory Value | Num | 20 | |||||
| WipVarAcc | WIP Variance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipVarVal | WIP Variance Value | Num | 20 | |||||
| IncAct | G/L Increase Account | nVarChar | 15 | |||||
| IncVal | G/L Increase Value | Num | 20 | |||||
| ExpCAcc | Expense Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CostMethod | Costing Method | VarChar | A) Moving Average S) Standard F) FIFO N) None | 1 | N | |||
| MessageID KEY | Message ID | Int | 11 | UILM IVI Inventory Log Message | MESSAGEID | No | ||
| LocType | Location Type | Int | 11 | |||||
| LocCode | Warehouse Code | nVarChar | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Upgrade M) Import O) DI API A) Auto Summary D) Restore Wizard P) Partner Implementation Y) Year Transfer | 1 | N | |||
| PostStatus | Posting Status | VarChar | N) None P) Partial C) Complete | 1 | N | |||
| SumStock | Sum Inventory Value | Num | 20 | |||||
| OpenCogs | Open COGS Value | Num | 20 | |||||
| OpenQty | Open Quantity | Num | 20 | |||||
| TreeID KEY | Tree ID | Int | 11 | -1 | TREEID | No | ||
| ParentID | Parent ID | Int | 11 | -1 | ||||
| PAOffAcc | Purchase Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PAOffVal | Purchase Offset Value | Num | 20 | |||||
| OpenPAOff | Open Purchase Offset Value | Num | 20 | |||||
| PAAcc | Purchase Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PAVal | Purchase Account Value | Num | 20 | |||||
| OpenPA | Open Purchase Value | Num | 20 | |||||
| LinkArc | Linked To Archived Doc | VarChar | N) No Y) Yes | 1 | N | |||
| VersionNum | Version Number | nVarChar | 11 | |||||
| BSubLineNo | Base Subrow Number | Int | 11 | -1 | ||||
| WipDebCred | WIP Account: Debit/Credit Side | VarChar | 1 |
Table relationship map
SELECT statement
SELECT
UIVL.TransType AS 'Transaction Type',
UIVL.CreatedBy AS 'Document No. Created',
UIVL.BASE_REF AS 'Base Reference',
UIVL.DocLineNum AS 'Row Number in Document',
UIVL.DocDate AS 'Posting Date',
UIVL.CreateTime AS 'Generation Time',
UIVL.ItemCode AS 'Item No.',
UIVL.InQty AS 'Receipt Quantity',
UIVL.OutQty AS 'Issue Quantity',
UIVL.Price AS 'Price',
UIVL.Currency AS 'Price Currency',
UIVL.Rate AS 'Currency Price',
UIVL.TrnsfrAct AS 'Transfer Account',
UIVL.PriceDifAc AS 'Price Difference Account',
UIVL.VarianceAc AS 'Variance Account',
UIVL.ReturnAct AS 'Returning Account',
UIVL.ExcRateAct AS 'Exchange Rate Differences Acct',
UIVL.ClearAct AS 'Goods Clearing Account',
UIVL.CostAct AS 'COGS Account',
UIVL.WipAct AS 'WIP Inventory Account',
UIVL.OpenStock AS 'Open Sum Inventory Value',
UIVL.CreateDate AS 'Creation Date',
UIVL.PriceDiff AS 'Price Difference Value',
UIVL.TransSeq AS 'Transaction Sequence No.',
UIVL.InvntAct AS 'Inventory Account',
UIVL.SubLineNum AS 'Subrow Number',
UIVL.AppObjLine AS 'Applied Object Row',
UIVL.Expenses AS 'Inventory Expenses',
UIVL.OpenExp AS 'Open Expenses Value',
UIVL.Allocation AS 'Allocation Amount',
UIVL.OpenAlloc AS 'Open Allocation Value',
UIVL.ExpAlloc AS 'Expenses Allocation Value',
UIVL.OExpAlloc AS 'Open Expenses Allocation Value',
UIVL.OpenPDiff AS 'Open Price Diff. Value',
UIVL.ExchDiff AS 'Exchange Rate Difference Value',
UIVL.OpenEDiff AS 'Open Exchange Rate Diff. Value',
UIVL.NegInvAdjs AS 'Negative Inventory Adjustment Value',
UIVL.OpenNegInv AS 'Open Negative Adjustment',
UIVL.NegStckAct AS 'Neg. Inventory Adjustment Acct',
UIVL.BTransVal AS 'Base Transaction Value',
UIVL.VarVal AS 'Variance Value',
UIVL.BExpVal AS 'Base Freight Value',
UIVL.CogsVal AS 'COGS Value',
UIVL.BNegAVal AS 'Base Negative Adjustment Amt',
UIVL.IOffIncAcc AS 'Inventory Offset Increase Acct',
UIVL.IOffIncVal AS 'Inv. Offset Increase Value',
UIVL.DOffDecAcc AS 'Inventory Offset Decrease Acct',
UIVL.DOffDecVal AS 'Inv. Offset Decrease Value',
UIVL.DecAcc AS 'G/L Decrease Account',
UIVL.DecVal AS 'G/L Decrease Value',
UIVL.WipVal AS 'WIP Inventory Value',
UIVL.WipVarAcc AS 'WIP Variance Account',
UIVL.WipVarVal AS 'WIP Variance Value',
UIVL.IncAct AS 'G/L Increase Account',
UIVL.IncVal AS 'G/L Increase Value',
UIVL.ExpCAcc AS 'Expense Clearing Account',
UIVL.CostMethod AS 'Costing Method',
UIVL.MessageID AS 'Message ID',
UIVL.LocType AS 'Location Type',
UIVL.LocCode AS 'Warehouse Code',
UIVL.UserSign AS 'User Signature',
UIVL.DataSource AS 'Data Source',
UIVL.PostStatus AS 'Posting Status',
UIVL.SumStock AS 'Sum Inventory Value',
UIVL.OpenCogs AS 'Open COGS Value',
UIVL.OpenQty AS 'Open Quantity',
UIVL.TreeID AS 'Tree ID',
UIVL.ParentID AS 'Parent ID',
UIVL.PAOffAcc AS 'Purchase Offset Account',
UIVL.PAOffVal AS 'Purchase Offset Value',
UIVL.OpenPAOff AS 'Open Purchase Offset Value',
UIVL.PAAcc AS 'Purchase Account',
UIVL.PAVal AS 'Purchase Account Value',
UIVL.OpenPA AS 'Open Purchase Value',
UIVL.LinkArc AS 'Linked To Archived Doc',
UIVL.VersionNum AS 'Version Number',
UIVL.BSubLineNo AS 'Base Subrow Number',
UIVL.WipDebCred AS 'WIP Account: Debit/Credit Side'
FROM UIVL AS UIVL
Related information
UIVL SQL Table
G/L Accounts OACT SQL Table
Items UITM SQL Table
IVI Inventory Log Message UILM SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates