SAP ABAP Table AMPL (Table of Approved Manufacturer Parts)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AMPL	Table Relationship Diagram
Short Description	Table of Approved Manufacturer Parts

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BMATN	☑	MPMAT	MATNR	CHAR	18	0	Number of firm's own (internal) inventory-managed material	MARA
3	AMPNR	☑	AMPNR	NUM5	NUMC	5	0	Number of AMPL record
4	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
5	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
6	WERKS	☐	WERKS_MASK	WERKS	CHAR	4	0	Plant	T001W
7	DATUV	☐	AMPAB	DATUM	DATS	8	0	Date as of which the MPN materail may be procured
8	DATUB	☐	AMPBI	DATUM	DATS	8	0	Date until which the MPN material may be procured
9	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
10	AMPSP	☐	AMPSP	AMPSP	CHAR	4	0	Blocked manufacturer/part combinations	TAMPSP
11	REOAM	☐	REOAM	XFELD	CHAR	1	0	Deletion indicator: AMPL record
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
14	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AMPL	AMPSP	TAMPSP	AMPSP	REF	1	CN
2	AMPL	BMATN	MARA	MATNR	KEY	1	CN
3	AMPL	EMATN	MARA	MATNR	REF	1	CN
4	AMPL	MANDT	T000	MANDT	KEY	1	CN
5	AMPL	MFRNR	LFA1	LIFNR	REF	1	CN
6	AMPL	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20020219
SAP Release Created in