|
|
API AMR1
AMR1 - Inventory Revaluation - History - Rows Table
Inventory Revaluation OMRV SQL Table
Items OITM SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | DocEntry KEY UNIQUE | Document Internal ID | Int | 11 | OMRV Inventory Revaluation | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineNum | Row Number | Int | 11 | |||||
| ItemCode KEY | Item Code | nVarChar | 20 | OITM Items | ITEM | No | ||
| Dscription | Item/Service Description | nVarChar | 100 | |||||
| Quantity | Quantity | Num | 20 | |||||
| Price | Price | Num | 20 | |||||
| LineTotal | Row Total | Num | 20 | |||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| RIncmAcct | Inv. Reval. Increment Account | nVarChar | 15 | |||||
| RDcrmAcct | Inv. Reval. Decrement Account | nVarChar | 15 | |||||
| RToStock | Reval. Amount Posted to Stock | Num | 20 | |||||
| RActPrice | Inv. Reval. Actual Price | Num | 20 | |||||
| ROnHand | In Stock at Reval. | Num | 20 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | 162 | ||||
| EvalSystem | Cost Accounting Method | VarChar | A) Moving Average S) Standard F) FIFO | 1 | OITM Items | |||
| OcrCode | Distribution Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| UnitMsr | Unit of Measure | nVarChar | 100 | |||||
| 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 | ||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes |
Table relationship map
SELECT statement
SELECT
AMR1.DocEntry AS 'Document Internal ID',
AMR1.LineNum AS 'Row Number',
AMR1.ItemCode AS 'Item Code',
AMR1.Dscription AS 'Item/Service Description',
AMR1.Quantity AS 'Quantity',
AMR1.Price AS 'Price',
AMR1.LineTotal AS 'Row Total',
AMR1.WhsCode AS 'Warehouse Code',
AMR1.RIncmAcct AS 'Inv. Reval. Increment Account',
AMR1.RDcrmAcct AS 'Inv. Reval. Decrement Account',
AMR1.RToStock AS 'Reval. Amount Posted to Stock',
AMR1.RActPrice AS 'Inv. Reval. Actual Price',
AMR1.ROnHand AS 'In Stock at Reval.',
AMR1.LogInstanc AS 'Log Instance',
AMR1.ObjType AS 'Object Type',
AMR1.EvalSystem AS 'Cost Accounting Method',
AMR1.OcrCode AS 'Distribution Rule',
AMR1.UnitMsr AS 'Unit of Measure',
AMR1.OcrCode2 AS 'Distribution Rule2',
AMR1.OcrCode3 AS 'Distribution Rule3',
AMR1.OcrCode4 AS 'Distribution Rule4',
AMR1.OcrCode5 AS 'Distribution Rule5',
AMR1.Project AS 'Project Code'
FROM AMR1 AS AMR1
Related information
Inventory Revaluation OMRV SQL Table
Items OITM SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
