|
|
API AMR2
AMR2 - Inventory Revaluation FIFO Rows (Archive) Table
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 |
SELECT statement
SELECT
AMR2.DocEntry AS 'Document Internal ID',
AMR2.BaseLine AS 'Base Row Number',
AMR2.LineNum AS 'Row Number',
AMR2.Quantity AS 'Quantity',
AMR2.Price AS 'Price',
AMR2.LineTotal AS 'Row Total',
AMR2.RToStock AS 'Reval. Amount Posted to Stock',
AMR2.RActPrice AS 'Inventory Reval. Current Cost',
AMR2.INMTransNm AS 'INM Transaction Number',
AMR2.INMInst AS 'INM Instance',
AMR2.INMTransTy AS 'INM Transaction Type',
AMR2.INMCreatBy AS 'INM Document Key Created',
AMR2.INMBaseRef AS 'INM Base Reference',
AMR2.INMDocDate AS 'INM Posting Date',
AMR2.INMOpenQty AS 'INM Open Quantity',
AMR2.ObjType AS 'Object Type',
AMR2.LogInstanc AS 'Log Instance',
AMR2.IVLTransSe AS 'IVL Transaction Sequence No.',
AMR2.IVLLayerID AS 'IVL Layer ID',
AMR2.INMLineNum AS 'INM Row Number in Document',
AMR2.INMSubLine AS 'INM Subrow Number'
FROM AMR2 AS AMR2
Related information
Inventory Revaluation Information Array MRV1 SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
