SAP AMPL Table of Approved Manufacturer Parts Table
Overview
AMPL is a standard SAP S/4HANA table that stores Table of Approved Manufacturer Parts data. There are total 13 fields in the AMPL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AMPL belongs to Purchasing (MM-PUR) module and is located in the package Purchasing (ME).
In addition, following links provide an overview of foreign key relationships, if any, that link AMPL to other SAP tables and standard CDS views available based on AMPL table in S/4HANA 2020.
Techincal Settings of AMPL
Below are technical details of the table AMPL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AMPL Fields
The following table gives you an overview of the fields available in AMPL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BMATN | Number of firm's own (internal) inventory-managed material | MPMAT | MARA | CHAR | 40 |
| AMPNR | Number of AMPL record | AMPNR | NUMC | 5 | |
| EMATN | Material number corresponding to manufacturer part number | EMATN | MARA | CHAR | 40 |
| MFRNR | Manufacturer number | MFRNR | LFA1 | CHAR | 10 |
| WERKS | Plant | WERKS_MASK | T001W | CHAR | 4 |
| DATUV | Date as of which the MPN material may be procured | AMPAB | DATS | 8 | |
| DATUB | Date until which the MPN material may be procured | AMPBI | DATS | 8 | |
| REVLV | Revision Level | REVLV | CHAR | 2 | |
| AMPSP | Blocked manufacturer/part combinations | AMPSP | TAMPSP | CHAR | 4 |
| REOAM | Deletion indicator: AMPL record | REOAM | CHAR | 1 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AMPL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AMPL | AMPSP | 1: CN | TAMPSP |
| AMPL | BMATN | 1: CN | MARA |
| AMPL | EMATN | 1: CN | MARA |
| AMPL | MANDT | 1: CN | T000 |
| AMPL | MFRNR | 1: CN | LFA1 |
| AMPL | WERKS | : | T001W |