AMPL

Table of Approved Manufacturer Parts | #masterdata | Component: Purchasing
Column Name Description
MANDT FK Client
BMATN FK Number of firm's own (internal) inventory-managed material
AMPNR Number of AMPL record
Column Name Description
Column Name Description
Column Name Description
DATUV Date as of which the MPN material may be procured
DATUB Date until which the MPN material may be procured
ERDAT Date on which the record was created
Column Name Description
REOAM Deletion indicator: AMPL record Show values
Column Name Description Domain name
REVLV Revision Level REVLV
ERNAM Name of Person Responsible for Creating the Object USNAM
Master Data Relations Join Conditions
Blocked manufacturer/part combinations
  • Blocked manufacturer/part combinations
  • Client
Number of firm's own (internal) inventory-managed material
  • Number of firm's own (internal) inventory-managed material
  • Client
  • AMPL.BMATN == MARA.MATNR
  • AMPL.MANDT == MARA.MANDT
Material number corresponding to manufacturer part number
  • Material number corresponding to manufacturer part number
  • Client
  • AMPL.EMATN == MARA.MATNR
  • AMPL.MANDT == MARA.MANDT
Client AMPL.MANDT == T000.MANDT
Manufacturer number
  • AMPL.MANDT == LFA1.MANDT
  • AMPL.MFRNR == LFA1.LIFNR
Plant
  • AMPL.MANDT == T001W.MANDT
  • AMPL.WERKS == T001W.WERKS