J_1AINFT16

Warehouse report ( data of previous fiscal years ) | #transactional | Component: Localization
Column Name Description
MANDT FK Client
MATNR FK Material Number
BWKEY FK Valuation area
BWTAR FK Valuation Type
GJAHR Fiscal Year
Column Name Description
💲 Currency Key (T001.WAERS):
J_1AMPRICE Market price in local currency
Column Name Description
Column Name Description
J_1AMPDATE Date of market price
Column Name Description
J_1AMDOTYP Document type Show values
Column Name Description Domain name
BUKRS Company Code BUKRS
BELNR Document Number of an Accounting Document BELNR
EBELN Purchasing Document Number EBELN
EBELP Item Number of Purchasing Document EBELP
Master Data Relations Join Conditions
Valuation area
  • Valuation area
  • Client
  • J_1AINFT16.BWKEY == T001K.BWKEY
  • J_1AINFT16.MANDT == T001K.MANDT
Valuation Type
  • J_1AINFT16.MANDT == T149D.MANDT
  • J_1AINFT16.BWTAR == T149D.BWTAR
Client J_1AINFT16.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • J_1AINFT16.MATNR == MARA.MATNR
  • J_1AINFT16.MANDT == MARA.MANDT