SAP Table AMPL
Table of Approved Manufacturer Parts
AMPL (Table of Approved Manufacturer Parts) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link AMPL to other SAP tables.
AMPL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| BMATN | Number of firm's own (internal) inventory-managed material | MPMAT | MARA | CHAR | 18 | 0 | ||||||
| AMPNR | Number of AMPL record | AMPNR | NUMC | 5 | 0 | |||||||
| EMATN | Material Number Corresponding to Manufacturer Part Number | EMATN | MARA | CHAR | 18 | 0 | ||||||
| MFRNR | Number of a Manufacturer | MFRNR | LFA1 | CHAR | 10 | 0 | ||||||
| WERKS | Plant | WERKS_MASK | T001W | CHAR | 4 | 0 | ||||||
| DATUV | Date as of which the MPN materail may be procured | AMPAB | DATS | 8 | 0 | |||||||
| DATUB | Date until which the MPN material may be procured | AMPBI | DATS | 8 | 0 | |||||||
| REVLV | Revision Level | REVLV | CHAR | 2 | 0 | |||||||
| AMPSP | Blocked manufacturer/part combinations | AMPSP | TAMPSP | CHAR | 4 | 0 | ||||||
| REOAM | Deletion indicator: AMPL record | REOAM | CHAR | 1 | 0 |
Possible values
|
||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||
AMPL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| AMPL | AMPSP | AMPL | AMPSP | TAMPSP | Manufacturer/Part Combinations: Blocking Reasons | AMPSP |
| AMPL | AMPSP | AMPL | MANDT | TAMPSP | Manufacturer/Part Combinations: Blocking Reasons | MANDT |
| AMPL | BMATN | AMPL | MANDT | MARA | General Material Data | MANDT |
| AMPL | BMATN | AMPL | BMATN | MARA | General Material Data | MATNR |
| AMPL | EMATN | AMPL | MANDT | MARA | General Material Data | MANDT |
| AMPL | EMATN | AMPL | EMATN | MARA | General Material Data | MATNR |
| AMPL | MANDT | AMPL | MANDT | T000 | Clients | MANDT |
| AMPL | MFRNR | AMPL | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| AMPL | MFRNR | AMPL | MFRNR | LFA1 | Vendor Master (General Section) | LIFNR |
| AMPL | WERKS | AMPL | MANDT | T001W | Plants/Branches | MANDT |
| AMPL | WERKS | AMPL | WERKS | T001W | Plants/Branches | WERKS |
