/ATL/SMR1

Inventory value in "hard" currency | #masterdata | Component: Logistics Israel
Column Name Description
MANDT FK Client
MATNR FK Material Number
GJAHR Fiscal Year
MONAT Fiscal period
BWKEY FK Valuation area
BWTAR FK Valuation Type
Column Name Description
💲 Currency Key (T001.WAERS):
VALUE Inventory value in the "hard" currency
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
STOCK Total Valuated Stock
Column Name Description
LAST_ISSUE last issue date of the material
LAST_RECIE last reciept date of the material
Column Name Description
Column Name Description Domain name
PRICE MAP in Cost of Live index units FLOPO
NEXT_PRICE Material price for the following period FLOPO
PRICE3 moving average price in local currency FLTP
PEINH Price unit PACK3
Master Data Relations Join Conditions
Valuation area
  • Valuation area
  • Client
  • /ATL/SMR1.BWKEY == T001K.BWKEY
  • /ATL/SMR1.MANDT == T001K.MANDT
Valuation Type
  • /ATL/SMR1.MANDT == T149D.MANDT
  • /ATL/SMR1.BWTAR == T149D.BWTAR
Client /ATL/SMR1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • /ATL/SMR1.MATNR == MARA.MATNR
  • /ATL/SMR1.MANDT == MARA.MANDT