|
|
API UILM
UILM - IVI Inventory Log Message Table
UILM SQL Table
Business Partner OCRD SQL Table
Distribution Rule OOCR SQL Table
Currency Codes OCRN SQL Table
Items OITM SQL Table
Location OLCT SQL Table
Project Codes OPRJ SQL Table
Sales Employee OSLP SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | MessageID KEY UNIQUE | Message ID | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| DocEntry | Doc Number | Int | 11 | |||||
| TransType KEY | Transaction Type | Int | 11 | -1 | DocLine | No | ||
| DocLineNum | Doc Row Number | Int | 11 | |||||
| Quantity | Quantity in Doc | Num | 20 | |||||
| EffectQty | Stock Effective Qty | Num | 20 | |||||
| LocType | Location Type | Int | 6 | |||||
| LocCode | Location Code | nVarChar | 8 | |||||
| TotalLC | Inventory Total LC | Num | 20 | |||||
| TotalFC | Inventory Total FC | Num | 20 | |||||
| TotalSC | Inventory Total SC | Num | 20 | |||||
| BaseAbsEnt | Internal ID of Base Document | Int | 11 | |||||
| BaseType | Base Transaction Type | Int | -1) 0 13) A/R Invoice 15) Delivery 16) Returns 17) Sales Order 18) A/P Invoice 20) Goods Receipt PO 21) Goods Return 22) Purchase Order 23) Sales Quotation 59) Goods Receipt 67) Inventory Transfer 69) Landed Costs 163) A/P Correction Invoice 164) A/P Correction Invoice Reversal 165) A/R Correction Invoice 166) A/R Correction Invoice Reversal 202) Production Order 203) A/R Down Payment 204) A/P Down Payment | 11 | -1 | |||
| BaseCurr | Base Currency | nVarChar | 3 | |||||
| Currency | Doc Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| AccumType | Accumulator Type | Int | 0 1) ACCUM_ON_HAND 2) ACCUM_COMMITTED 3) ACCUM_ON_ORDER 4) ACCUM_CONSIGNATION 5) ACCUM_COUNTED | 11 | 0 | |||
| ActionType | Action Type | Int | 0 1) TRANSACTION_IN 2) TRANSACTION_OUT 3) TRANSACTION_SET 4) TRANSACTION_COMPLETE 5) EMPTY_TRANSACTION 6) TRANSACTION_REVALUATION 7) TRANSACTION_REVALUATION_INCREASE 8) TRANSACTION_REVALUATION_DECREASE 9) TRANSACTION_CLOSE_IN 10) TRANSACTION_CLOSE_OUT 11) TRANSACTION_NEGATIVE_REVALUATION 12) TRANSACTION_NULLIFY 13) TRANSACTION_RESERVE_CI_IN 14) TRANSACTION_RESERVE_CI_OUT 15) TRANSACTION_RESERVE_CI_REVAL_INC 16) TRANSACTION_RESERVE_CI_REVAL_DEC 17) TRANSACTION_REVAL_PRICE_CHANGE_INCREASE 18) TRANSACTION_REVAL_PRICE_CHANGE_DECREASE | 11 | 5 | |||
| ExpensesLC | Expenses (LC) | Num | 20 | |||||
| ExpensesFC | Expenses (FC) | Num | 20 | |||||
| ExpensesSC | Expenses (SC) | Num | 20 | |||||
| DocDueDate | Doc. Due Date | Date | 8 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| BPCardCode KEY | Business Partner Code | nVarChar | 15 | OCRD Business Partner | CARD | No | ||
| DocDate | Doc Date | Date | 8 | |||||
| DocRate | Doc. Rate | Num | 20 | |||||
| Comment | Comment | nVarChar | 127 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| Ref1 | Reference 1 | nVarChar | 11 | |||||
| Ref2 | Reference 2 | nVarChar | 11 | |||||
| BaseLine | Base Row Number | Int | 11 | -1 | ||||
| SnBType | Serials and Batches Type | Int | 0 1) Serial Number Management | 11 | -1 | |||
| CreateTime | Generation Time | Int | 6 | |||||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| CreateDate | Creation Date | Date | 8 | |||||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Distribution Rule2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Distribution Rule3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Distribution Rule4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Distribution Rule5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| DocPrice | Doc Price | Num | 20 | |||||
| CardName | BP Name | nVarChar | 100 | |||||
| Dscription | Item Description | nVarChar | 100 | |||||
| TreeType | BOM Type | VarChar | N) Not a BOM A) Assembly S) Sales I) BOM Component Item P) Production T) Template | 1 | N | |||
| ApplObj KEY | Applied Object | Int | 11 | -1 | APPOBJ | No | ||
| AppObjAbs | Applied Object Internal ID | Int | 11 | -1 | ||||
| AppObjType | Applied Object Type | VarChar | 1 | |||||
| AppObjLine | Applied Object Row | Int | 11 | -1 | ||||
| BASE_REF | Base Reference | nVarChar | 11 | |||||
| TransSeqRf | Transaction Sequence Ref | Int | 11 | -1 | ||||
| LayerIDRef | Layer ID Reference | Int | 11 | -1 | ||||
| VersionNum | Version Number | nVarChar | 11 | |||||
| PriceRate | Price Rate | Num | 20 | |||||
| PriceCurr | Price Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| DocTotal | Document Total | Num | 20 | |||||
| Price | Price | Num | 20 | |||||
| CIShbQty | Corr. Inv. Doc. Should Be Qty | Num | 20 | |||||
| SubLineNum | Sub Line Number | Int | 11 | -1 | ||||
| PrjCode | Project code | nVarChar | 20 | OPRJ Project Codes | ||||
| SlpCode | Sales Employee | Int | 11 | OSLP Sales Employee | -1 | |||
| TaxDate | Document Date | Date | 8 | |||||
| UseDocPric | Use Document Price | VarChar | Y) Yes N) No | 1 | N | |||
| VendorNum | Vendor Catalog No. | nVarChar | 17 | |||||
| SerialNum | Serial Number | nVarChar | 17 | |||||
| BlockNum | Block Number | nVarChar | 100 | |||||
| ImportLog | Import Log | nVarChar | 20 | |||||
| Location | Location | Int | 11 | OLCT Location | ||||
| DocPrcRate | Document Price Rate | Num | 20 | |||||
| DocPrcCurr | Document Price Currency | nVarChar | 3 | OCRN Currency Codes | ||||
| CgsOcrCod | COGS Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| CgsOcrCod2 | COGS Distribution Rule 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| CgsOcrCod3 | COGS Distribution Rule 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| CgsOcrCod4 | COGS Distribution Rule 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| CgsOcrCod5 | COGS Distribution Rule 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| BSubLineNo | Base Subrow Number | Int | 11 | -1 | ||||
| AppSubLine | Applied Subrow Number | Int | 11 | -1 | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| SysRate | System Rate | Num | 20 | |||||
| ExFromRpt | Exclude from Report | VarChar | Y) Yes N) No | 1 | N | |||
| Ref3 | Reference 3 | nVarChar | 11 | |||||
| EnSetCost | Enable Set Item Cost in Return | VarChar | Y) Yes N) No | 1 | N | |||
| RetCost | Return Cost in A/R Return | Num | 20 | |||||
| DocAction | Document Action Type | Int | 11 | |||||
| UseShpdGd | Use Shipped Goods Account | VarChar | N) No Y) Yes | 1 | N | |||
| AddTotalLC | Additional Total LC | Num | 20 | |||||
| AddExpLC | Additional Expenses LC | Num | 20 | |||||
| IsNegLnQty | Negative Line Quantity | VarChar | 1 | N |
Table relationship map
SELECT statement
SELECT
UILM.MessageID AS 'Message ID',
UILM.DocEntry AS 'Doc Number',
UILM.TransType AS 'Transaction Type',
UILM.DocLineNum AS 'Doc Row Number',
UILM.Quantity AS 'Quantity in Doc',
UILM.EffectQty AS 'Stock Effective Qty',
UILM.LocType AS 'Location Type',
UILM.LocCode AS 'Location Code',
UILM.TotalLC AS 'Inventory Total LC',
UILM.TotalFC AS 'Inventory Total FC',
UILM.TotalSC AS 'Inventory Total SC',
UILM.BaseAbsEnt AS 'Internal ID of Base Document',
UILM.BaseType AS 'Base Transaction Type',
UILM.BaseCurr AS 'Base Currency',
UILM.Currency AS 'Doc Currency',
UILM.AccumType AS 'Accumulator Type',
UILM.ActionType AS 'Action Type',
UILM.ExpensesLC AS 'Expenses (LC)',
UILM.ExpensesFC AS 'Expenses (FC)',
UILM.ExpensesSC AS 'Expenses (SC)',
UILM.DocDueDate AS 'Doc. Due Date',
UILM.ItemCode AS 'Item Code',
UILM.BPCardCode AS 'Business Partner Code',
UILM.DocDate AS 'Doc Date',
UILM.DocRate AS 'Doc. Rate',
UILM.Comment AS 'Comment',
UILM.JrnlMemo AS 'Journal Remarks',
UILM.Ref1 AS 'Reference 1',
UILM.Ref2 AS 'Reference 2',
UILM.BaseLine AS 'Base Row Number',
UILM.SnBType AS 'Serials and Batches Type',
UILM.CreateTime AS 'Generation Time',
UILM.DataSource AS 'Data Source',
UILM.CreateDate AS 'Creation Date',
UILM.OcrCode AS 'Distribution Rule',
UILM.OcrCode2 AS 'Distribution Rule2',
UILM.OcrCode3 AS 'Distribution Rule3',
UILM.OcrCode4 AS 'Distribution Rule4',
UILM.OcrCode5 AS 'Distribution Rule5',
UILM.DocPrice AS 'Doc Price',
UILM.CardName AS 'BP Name',
UILM.Dscription AS 'Item Description',
UILM.TreeType AS 'BOM Type',
UILM.ApplObj AS 'Applied Object',
UILM.AppObjAbs AS 'Applied Object Internal ID',
UILM.AppObjType AS 'Applied Object Type',
UILM.AppObjLine AS 'Applied Object Row',
UILM.BASE_REF AS 'Base Reference',
UILM.TransSeqRf AS 'Transaction Sequence Ref',
UILM.LayerIDRef AS 'Layer ID Reference',
UILM.VersionNum AS 'Version Number',
UILM.PriceRate AS 'Price Rate',
UILM.PriceCurr AS 'Price Currency',
UILM.DocTotal AS 'Document Total',
UILM.Price AS 'Price',
UILM.CIShbQty AS 'Corr. Inv. Doc. Should Be Qty',
UILM.SubLineNum AS 'Sub Line Number',
UILM.PrjCode AS 'Project code',
UILM.SlpCode AS 'Sales Employee',
UILM.TaxDate AS 'Document Date',
UILM.UseDocPric AS 'Use Document Price',
UILM.VendorNum AS 'Vendor Catalog No.',
UILM.SerialNum AS 'Serial Number',
UILM.BlockNum AS 'Block Number',
UILM.ImportLog AS 'Import Log',
UILM.Location AS 'Location',
UILM.DocPrcRate AS 'Document Price Rate',
UILM.DocPrcCurr AS 'Document Price Currency',
UILM.CgsOcrCod AS 'COGS Distribution Rule',
UILM.CgsOcrCod2 AS 'COGS Distribution Rule 2',
UILM.CgsOcrCod3 AS 'COGS Distribution Rule 3',
UILM.CgsOcrCod4 AS 'COGS Distribution Rule 4',
UILM.CgsOcrCod5 AS 'COGS Distribution Rule 5',
UILM.BSubLineNo AS 'Base Subrow Number',
UILM.AppSubLine AS 'Applied Subrow Number',
UILM.UserSign AS 'User Signature',
UILM.SysRate AS 'System Rate',
UILM.ExFromRpt AS 'Exclude from Report',
UILM.Ref3 AS 'Reference 3',
UILM.EnSetCost AS 'Enable Set Item Cost in Return',
UILM.RetCost AS 'Return Cost in A/R Return',
UILM.DocAction AS 'Document Action Type',
UILM.UseShpdGd AS 'Use Shipped Goods Account',
UILM.AddTotalLC AS 'Additional Total LC',
UILM.AddExpLC AS 'Additional Expenses LC',
UILM.IsNegLnQty AS 'Negative Line Quantity'
FROM UILM AS UILM
Related information
UILM SQL Table
Business Partner OCRD SQL Table
Distribution Rule OOCR SQL Table
Currency Codes OCRN SQL Table
Items OITM SQL Table
Location OLCT SQL Table
Project Codes OPRJ SQL Table
Sales Employee OSLP 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
