|
|
DTW Inventory / Inventory Transactions / Inventory Revaluation / Inventory Revaluation FIFO Rows
API Material Revaluation lines / FIFO Layers
MRV2 - Inventory Revaluation FIFO Rows Table
FIFO Layers FIFOLayers Object· Table: MRV2
Parent: Material Revaluation lines MaterialRevaluation_lines Object· Table: MRV1
Inventory Revaluation Information Array MRV1 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 | MRV1 Inventory Revaluation Information Array | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| BaseLine | Base Row Number | Int | 11 | |||||
| LineNum | Row Number | Int | 11 | |||||
| Quantity | Quantity | Num | 20 | |||||
| Price | Price | Num | 20 | |||||
| LineTotal | Row Total | Num | 20 | |||||
| RToStock | Reval. Amount Posted to Stock | Num | 20 | |||||
| RActPrice | Inventory Reval. Current Cost | Num | 20 | |||||
| INMTransNm | INM Transaction Number | Int | 11 | OINM | ||||
| INMInst | INM Instance | Int | 11 | OINM | ||||
| INMTransTy | INM Transaction Type | Int | 11 | OINM | -1 | |||
| INMCreatBy | INM Document Key Created | Int | 11 | OINM | ||||
| INMBaseRef | INM Base Reference | nVarChar | 11 | OINM | ||||
| INMDocDate | INM Posting Date | Date | 8 | OINM | ||||
| INMOpenQty | INM Open Quantity | Num | 20 | OINM | ||||
| ObjType | Object Type | nVarChar | 20 | 162 | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| IVLTransSe | IVL Transaction Sequence No. | Int | 11 | -1 | ||||
| IVLLayerID | IVL Layer ID | Int | 11 | -1 | ||||
| INMLineNum | INM Row Number in Document | Int | 11 | OINM | ||||
| INMSubLine | INM Subrow Number | Int | 11 | OINM | -1 |
SELECT statement
SELECT
MRV2.DocEntry AS 'Document Internal ID',
MRV2.BaseLine AS 'Base Row Number',
MRV2.LineNum AS 'Row Number',
MRV2.Quantity AS 'Quantity',
MRV2.Price AS 'Price',
MRV2.LineTotal AS 'Row Total',
MRV2.RToStock AS 'Reval. Amount Posted to Stock',
MRV2.RActPrice AS 'Inventory Reval. Current Cost',
MRV2.INMTransNm AS 'INM Transaction Number',
MRV2.INMInst AS 'INM Instance',
MRV2.INMTransTy AS 'INM Transaction Type',
MRV2.INMCreatBy AS 'INM Document Key Created',
MRV2.INMBaseRef AS 'INM Base Reference',
MRV2.INMDocDate AS 'INM Posting Date',
MRV2.INMOpenQty AS 'INM Open Quantity',
MRV2.ObjType AS 'Object Type',
MRV2.LogInstanc AS 'Log Instance',
MRV2.IVLTransSe AS 'IVL Transaction Sequence No.',
MRV2.IVLLayerID AS 'IVL Layer ID',
MRV2.INMLineNum AS 'INM Row Number in Document',
MRV2.INMSubLine AS 'INM Subrow Number'
FROM MRV2 AS MRV2
Related information
FIFO Layers FIFOLayers Object· Table: MRV2
Specifies the FIFO layers to be updated, and the new values for the quantity and price.
Source table: MRV2
Parent: Material Revaluation lines MaterialRevaluation_lines Object· Table: MRV1 Inventory Revaluation Information Array MRV1 SQL Table
MaterialRevaluation_lines
Object
FIFOLayers
Method
Property
LayerID
DTW DB
LineTotal
DTW DB
Price
DTW DB
Quantity
DTW DB
TransactionSequenceNum
DTW DB
Method
Property
AbsoluteEntry
8.8 DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
