|
|
API OAIM
OAIM - Archive Inventory Message Table
Currency Codes OCRN SQL Table
Items OITM SQL Table
Location OLCT SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ 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 | Document Number | Int | 11 | |||||
| TransType | Transaction Type | Int | 11 | -1 | ||||
| DocLineNum | Document Row Number | Int | 11 | |||||
| Quantity | Quantity in Document | Num | 20 | |||||
| EffectQty | Effective Inventory Quantity | Num | 20 | |||||
| LocType | Location Type | Int | 6 | |||||
| LocCode | Location Code | nVarChar | 8 | |||||
| TotalLC | Inventory Total LC | Num | 20 | |||||
| TotalFC | Inventory Total FC | Num | 20 | |||||
| BaseAbsEnt | Internal No. of Base Doc | 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 | |||
| Currency | Document 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 | |||||
| ItemCode | Item Code | nVarChar | 20 | OITM Items | ||||
| DocDate | Document Date | Date | 8 | |||||
| DocRate | Document Rate | Num | 20 | |||||
| JrnlMemo | Journal Remarks | nVarChar | 50 | |||||
| BaseLine | Base Row Number | Int | 11 | -1 | ||||
| CreateTime | Generation Time | Int | 6 | |||||
| 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 | Document Price | Num | 20 | |||||
| TreeType | BOM Type | VarChar | N) Not a BOM A) Assembly S) Sales I) BOM Component Item | 1 | N | |||
| ApplObj | Applied Object | Int | 11 | -1 | ||||
| AppObjAbs | Applied Object Internal ID | Int | 11 | -1 | ||||
| AppObjType | Applied Object Type | VarChar | 1 | |||||
| AppObjLine | Applied Object Row | Int | 11 | -1 | ||||
| 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 | ||||
| Price | Price | Num | 20 | |||||
| CIShbQty | Corr. Inv. Doc. Should Be Qty | Num | 20 | |||||
| SubLineNum | Subrow Number | Int | 11 | -1 | ||||
| PrjCode | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| UseDocPric | Use Document Price | VarChar | Y) Yes N) No | 1 | N | |||
| Location | Location | Int | 11 | OLCT Location | ||||
| BSubLineNo | Base Subrow Number | Int | 11 | -1 | ||||
| AppSubLine | Applied Subrow Number | Int | 11 | -1 | ||||
| DocAction | Document Action Type | Int | 11 |
Table relationship map
SELECT statement
SELECT
OAIM.MessageID AS 'Message ID',
OAIM.DocEntry AS 'Document Number',
OAIM.TransType AS 'Transaction Type',
OAIM.DocLineNum AS 'Document Row Number',
OAIM.Quantity AS 'Quantity in Document',
OAIM.EffectQty AS 'Effective Inventory Quantity',
OAIM.LocType AS 'Location Type',
OAIM.LocCode AS 'Location Code',
OAIM.TotalLC AS 'Inventory Total LC',
OAIM.TotalFC AS 'Inventory Total FC',
OAIM.BaseAbsEnt AS 'Internal No. of Base Doc',
OAIM.BaseType AS 'Base Transaction Type',
OAIM.Currency AS 'Document Currency',
OAIM.AccumType AS 'Accumulator Type',
OAIM.ActionType AS 'Action Type',
OAIM.ExpensesLC AS 'Expenses (LC)',
OAIM.ExpensesFC AS 'Expenses (FC)',
OAIM.ItemCode AS 'Item Code',
OAIM.DocDate AS 'Document Date',
OAIM.DocRate AS 'Document Rate',
OAIM.JrnlMemo AS 'Journal Remarks',
OAIM.BaseLine AS 'Base Row Number',
OAIM.CreateTime AS 'Generation Time',
OAIM.CreateDate AS 'Creation Date',
OAIM.OcrCode AS 'Distribution Rule',
OAIM.OcrCode2 AS 'Distribution Rule2',
OAIM.OcrCode3 AS 'Distribution Rule3',
OAIM.OcrCode4 AS 'Distribution Rule4',
OAIM.OcrCode5 AS 'Distribution Rule5',
OAIM.DocPrice AS 'Document Price',
OAIM.TreeType AS 'BOM Type',
OAIM.ApplObj AS 'Applied Object',
OAIM.AppObjAbs AS 'Applied Object Internal ID',
OAIM.AppObjType AS 'Applied Object Type',
OAIM.AppObjLine AS 'Applied Object Row',
OAIM.TransSeqRf AS 'Transaction Sequence Ref',
OAIM.LayerIDRef AS 'Layer ID Reference',
OAIM.VersionNum AS 'Version Number',
OAIM.PriceRate AS 'Price Rate',
OAIM.PriceCurr AS 'Price Currency',
OAIM.Price AS 'Price',
OAIM.CIShbQty AS 'Corr. Inv. Doc. Should Be Qty',
OAIM.SubLineNum AS 'Subrow Number',
OAIM.PrjCode AS 'Project Code',
OAIM.UseDocPric AS 'Use Document Price',
OAIM.Location AS 'Location',
OAIM.BSubLineNo AS 'Base Subrow Number',
OAIM.AppSubLine AS 'Applied Subrow Number',
OAIM.DocAction AS 'Document Action Type'
FROM OAIM AS OAIM
Related information
Currency Codes OCRN SQL Table
Items OITM SQL Table
Location OLCT SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
