|
|
DTW Inventory / Inventory Transactions / Inventory Revaluation / Inventory Revaluation Information Array
API Material Revaluation / Material Revaluation lines
MRV1 - Inventory Revaluation Information Array Table
Material Revaluation lines MaterialRevaluation_lines Object· Table: MRV1
Parent: Material Revaluation MaterialRevaluation Object· Table: OMRV
MRV1 SQL 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 Time of Revaluation | 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 B) Serial/Batch | 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
MRV1.DocEntry AS 'Document Internal ID',
MRV1.LineNum AS 'Row Number',
MRV1.ItemCode AS 'Item Code',
MRV1.Dscription AS 'Item/Service Description',
MRV1.Quantity AS 'Quantity',
MRV1.Price AS 'Price',
MRV1.LineTotal AS 'Row Total',
MRV1.WhsCode AS 'Warehouse Code',
MRV1.RIncmAcct AS 'Inv. Reval. Increment Account',
MRV1.RDcrmAcct AS 'Inv. Reval. Decrement Account',
MRV1.RToStock AS 'Reval. Amount Posted to Stock',
MRV1.RActPrice AS 'Inv. Reval. Actual Price',
MRV1.ROnHand AS 'In Stock at Time of Revaluation',
MRV1.LogInstanc AS 'Log Instance',
MRV1.ObjType AS 'Object Type',
MRV1.EvalSystem AS 'Cost Accounting Method',
MRV1.OcrCode AS 'Distribution Rule',
MRV1.UnitMsr AS 'Unit of Measure',
MRV1.OcrCode2 AS 'Distribution Rule2',
MRV1.OcrCode3 AS 'Distribution Rule3',
MRV1.OcrCode4 AS 'Distribution Rule4',
MRV1.OcrCode5 AS 'Distribution Rule5',
MRV1.Project AS 'Project Code'
FROM MRV1 AS MRV1
Related information
Material Revaluation lines MaterialRevaluation_lines Object· Table: MRV1
MaterialRevaluation_Lines is a child object of the MaterialRevaluation object representing the line entries of each transaction.
Source table: MRV1.
Parent: Material Revaluation MaterialRevaluation Object· Table: OMRV MRV1 SQL Table
Inventory Revaluation OMRV SQL Table
Items OITM SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Warehouses OWHS SQL Table
MaterialRevaluation
Object
MaterialRevaluation_lines
Method
Object
FIFOLayers MRV2
Property
ActualPrice
DB
DebitCredit
DTW DB
DocEntry
DB
ItemCode
DTW DB
LineNum
DTW DB
OnHand
DB
Price
DTW DB
Quantity
DTW DB
RevaluationDecrementAccount
DTW DB
RevaluationIncrementAccount
DTW DB
WarehouseCode
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
