SAP ABAP Table VAMPL (Structure for AMPL)

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	INTTAB	Structure
Structure	VAMPL	Table Relationship Diagram
Short Description	Structure for AMPL

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

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

History

Last changed by/on	SAP	20020219
SAP Release Created in