SAP table AMPL (Table of Approved Manufacturer Parts)

SAP table AMPL has 3 primary key fields being MANDT,BMATN,AMPNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BMATN Number of firm's own (internal) inventory-managed material CHAR 40 0 MARA MPMAT
AMPNR Number of AMPL record NUMC 5 0 AMPNR
EMATN Material number corresponding to manufacturer part number CHAR 40 0 MARA EMATN
MFRNR Manufacturer number CHAR 10 0 LFA1 MFRNR
WERKS Plant CHAR 4 0 T001W WERKS_MASK
DATUV Date as of which the MPN material may be procured DATS 8 0 AMPAB
DATUB Date until which the MPN material may be procured DATS 8 0 AMPBI
REVLV Revision Level CHAR 2 0 REVLV
AMPSP Blocked manufacturer/part combinations CHAR 4 0 TAMPSP AMPSP
REOAM Deletion indicator: AMPL record CHAR 1 0 REOAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM

AMPL foreign key relationships

Table Field Check Table Check Field
0 AMPL AMPSP TAMPSP Manufacturer/Part Combinations: Blocking Reasons MANDT
0 AMPL AMPSP TAMPSP Manufacturer/Part Combinations: Blocking Reasons AMPSP
1 AMPL BMATN MARA General Material Data MATNR
0 AMPL EMATN MARA General Material Data MANDT
0 AMPL EMATN MARA General Material Data MATNR
1 AMPL MANDT T000 Clients MANDT
0 AMPL MFRNR LFA1 Supplier Master (General Section) MANDT
0 AMPL MFRNR LFA1 Supplier Master (General Section) LIFNR
1 AMPL WERKS T001W Plants/Branches MANDT
1 AMPL WERKS T001W Plants/Branches WERKS