biuan SAP® BUSINESS ONE SDK
DTW Inventory / Inventory Transactions / Inventory Revaluation / Inventory Revaluation FIFO Rows
API Material Revaluation lines / FIFO Layers
MRV2 - Inventory Revaluation FIFO Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11MRV1
Inventory Revaluation Information Array
PRIMARYYes
BaseLineBase Row NumberInt
11
LineNumRow NumberInt
11
QuantityQuantityNum
20
PricePriceNum
20
LineTotalRow TotalNum
20
RToStockReval. Amount Posted to StockNum
20
RActPriceInventory Reval. Current CostNum
20
INMTransNmINM Transaction NumberInt
11OINM
INMInstINM InstanceInt
11OINM
INMTransTyINM Transaction TypeInt
11OINM
-1
INMCreatByINM Document Key CreatedInt
11OINM
INMBaseRefINM Base ReferencenVarChar
11OINM
INMDocDateINM Posting DateDate
8OINM
INMOpenQtyINM Open QuantityNum
20OINM
ObjTypeObject TypenVarChar
20
162
LogInstancLog InstanceInt
11
0
IVLTransSeIVL Transaction Sequence No.Int
11
-1
IVLLayerIDIVL Layer IDInt
11
-1
INMLineNumINM Row Number in DocumentInt
11OINM
INMSubLineINM Subrow NumberInt
11OINM
-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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates