AMPL SAP table for – Table of Approved Manufacturer Parts

Here we would like to draw your attention to AMPL table in SAP. As we know it is being mainly used with the SAP MM-PUR (Purchasing in MM) component which is coming under MM module (Material Management). AMPL is a SAP standard transparent table used for storing Table of Approved Manufacturer Parts related data in SAP. It comes under the package ME.

SAP AMPL table

Table AMPL technical data

TableAMPL
Data storingTable of Approved Manufacturer Parts
ModuleMM
ComponentMM-PUR
SAP PackageME
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP AMPL Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in AMPL table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • AMPSP
    Its data type is C (Character String) with field length 4
  • REOAM
    Its data type is C (Character String) with field length 1
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CI_AMPL
  • BMATN
    Its a key field. Its data type is C (Character String) with field length 18
  • AMPNR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • EMATN
    Its data type is C (Character String) with field length 18
  • MFRNR
    Its data type is C (Character String) with field length 10
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • DATUV : Valid-From Date
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DATUB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • REVLV : Revision Level
    Its data type is C (Character String) with field length 2