SAP ABAP Table ESTVP (EHS: Value Assignment Item)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-SAF (Application Component) Product Safety
     ⤷ CBUI (Package) Company Environment Information System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ESTVP	Table Relationship Diagram
Short Description	EHS: Value Assignment Item

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
9	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record	*
18	RECNTVA	☐	ESERECNTVA	ESDRECN	NUMC	20	0	Reference to RECN for Tables ESTVA, ESTRH and ESTRI
19	COMPCAT	☐	ESECOMPCAT	ESDCOMPCAT	CHAR	10	0	Component Type	TCG76
20	RECNCMP	☐	ESERECNCMP	ESDRECN	NUMC	20	0	Reference to Specification Header of a Component
21	PRECL	☐	ESEPRECL	ESDPREC	CHAR	5	0	Operator for Lower Limit
22	COMPLOW	☐	ESECOMPLOW	ESDDEC6_4	DEC	10	4	Lower Limit of a Component Proportion
23	PRECU	☐	ESEPRECU	ESDPRECU	CHAR	5	0	Operator for Upper Limit
24	COMPUPP	☐	ESECOMPUPP	ESDDEC6_4	DEC	10	4	Upper limit of a component proportion
25	COMPAVG	☐	ESECOMPAVG	ESDDEC6_4	DEC	10	4	Target Value or Actual Value of a Component
26	COMPEXP	☐	ESECOMPEXP	MEINS	UNIT	3	0	Unit for Quantity Specification	T006
27	ORD	☐	ESEORD	NUMC4	NUMC	4	0	Sort Sequence
28	COMPLOWDEC	☐	ESECOMPNUMDEC	INT4	INT4	10	0	Decimal Places for the Concentration of a Component
29	COMPUPPDEC	☐	ESECOMPNUMDEC	INT4	INT4	10	0	Decimal Places for the Concentration of a Component
30	COMPAVGDEC	☐	ESECOMPNUMDEC	INT4	INT4	10	0	Decimal Places for the Concentration of a Component
31	COMPEXCVAL	☐	ESECOMPEXCVAL	ESDCOMPEXCVAL	CHAR	2	0	Exception Value of a Component	TCG78
32	UPD_CMP	☐	ESEUPD_CMP	DATUM	DATS	8	0	Date of Last Change to Component
33	.INCLU--AP	☐				0	0	CP: Append Struktur ESTVP
34	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
35	ALPGR	☐	CS_ALPGR	CHAR2	CHAR	2	0	Alternative Item: Group
36	PREF_ALT	☐	/TDAG/CPE_PREF_ALT	ESDBOOLE	CHAR	1	0	Preferred Alternative
37	REC_PROC_ID_COMP	☐	/TDAG/CPE_RECPROCESSID		CHAR	20	0	Recycling Process ID
38	DISASSEMBLY_COMP	☐	/TDAG/CPE_FLG_DISASSEMBLY	ESDBOOLE	CHAR	1	0	Disassembly
39	NOT_REL_FOR_REG	☐	/TDAG/CPE_FLG_NOT_REL_FOR_REG		CHAR	1	0	Not Relevant for Registration
40	NOT_REL_FOR_CHCK	☐	/TDAG/CPE_FLG_NOT_REL_FOR_CHCK	ESDBOOLE	CHAR	1	0	Not Relevant for Check

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ESTVP	AENNR	AENR	AENNR	REF	1	CN
2	ESTVP	COMPCAT	TCG76	COMPCAT	REF	1	CN
3	ESTVP	COMPEXCVAL	TCG78	COMPEXCVAL
4	ESTVP	COMPEXP	T006	MSEHI	REF	1	CN
5	ESTVP	MANDT	T000	MANDT
6	ESTVP	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20141109
SAP Release Created in