SAP ABAP View ESV_COMP (EHS: Search for Components with Various Search Criteria)

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

View Type	D	Database View
Database View	ESV_COMP
Short Description	EHS: Search for Components with Various Search Criteria
Root table	ESTVP	EHS: Value Assignment Item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ESTVP	ESTVP
2	ESTVA
3	ESTVH

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ESTVP	MANDT	JL	EQ				0	0
2	ESTVA	MANDT	JR	EQ			AND	0	0
3	ESTVP	RECNTVA	JL	EQ				0	0
4	ESTVA	RECN	JR	EQ			AND	0	0
5	ESTVA	MANDT	JL	EQ				0	0
6	ESTVH	MANDT	JR	EQ			AND	0	0
7	ESTVA	RECNTVH	JL	EQ				0	0
8	ESTVH	RECN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDTVP	ESTVP	MANDT		☐	MANDT	☐	Client
2	RECNVP	ESTVP	RECN		☐	ESERECN	☐	Sequential Number of Data Record
3	ACTNVP	ESTVP	ACTN		☐	ESEACTN	☐	Sequential Number of the Change State
4	VALFRVP	ESTVP	VALFR		☐	ESEVALFR	☐	Valid-From Date
5	VALTOVP	ESTVP	VALTO		☐	ESEVALTO	☐	Valid-To Date
6	AENNRVP	ESTVP	AENNR		☐	ESEAENNR	☐	Change Number
7	DELFLGVP	ESTVP	DELFLG		☐	ESEDELFLG	☐	Deletion Indicator
8	RECNTVA	ESTVP	RECNTVA		☐	ESERECNTVA	☐	Reference to RECN for Tables ESTVA, ESTRH and ESTRI
9	COMPCAT	ESTVP	COMPCAT		☐	ESECOMPCAT	☐	Component Type
10	RECNCMP	ESTVP	RECNCMP		☐	ESERECNCMP	☐	Reference to Specification Header of a Component
11	PRECL	ESTVP	PRECL		☐	ESEPRECL	☐	Operator for Lower Limit
12	COMPLOW	ESTVP	COMPLOW		☐	ESECOMPLOW	☐	Lower Limit of a Component Proportion
13	PRECU	ESTVP	PRECU		☐	ESEPRECU	☐	Operator for Upper Limit
14	COMPUPP	ESTVP	COMPUPP		☐	ESECOMPUPP	☐	Upper limit of a component proportion
15	COMPAVG	ESTVP	COMPAVG		☐	ESECOMPAVG	☐	Target Value or Actual Value of a Component
16	COMPEXP	ESTVP	COMPEXP		☐	ESECOMPEXP	☐	Unit for Quantity Specification
17	COMPEXCVAL	ESTVP	COMPEXCVAL		☐	ESECOMPEXCVAL	☐	Exception Value of a Component
18	MANDT	ESTVH	MANDT		☐	MANDT	☐	Client
19	RECN	ESTVH	RECN		☐	ESERECN	☐	Sequential Number of Data Record
20	ACTN	ESTVH	ACTN		☐	ESEACTN	☐	Sequential Number of the Change State
21	VALFR	ESTVH	VALFR		☐	ESEVALFR	☐	Valid-From Date
22	VALTO	ESTVH	VALTO		☐	ESEVALTO	☐	Valid-To Date
23	AENNR	ESTVH	AENNR		☐	ESEAENNR	☐	Change Number
24	DELFLG	ESTVH	DELFLG		☐	ESEDELFLG	☐	Deletion Indicator
25	RECNROOT	ESTVH	RECNROOT		☐	ESERECN	☐	Sequential Number of Data Record
26	ESTCAT	ESTVH	ESTCAT		☐	ESEESTCAT	☐	Value Assignment Type
27	MANDTVA	ESTVA	MANDT		☐	MANDT	☐	Client
28	RECNVA	ESTVA	RECN		☐	ESERECN	☐	Sequential Number of Data Record
29	ACTNVA	ESTVA	ACTN		☐	ESEACTN	☐	Sequential Number of the Change State
30	VALFRVA	ESTVA	VALFR		☐	ESEVALFR	☐	Valid-From Date
31	VALTOVA	ESTVA	VALTO		☐	ESEVALTO	☐	Valid-To Date
32	AENNRVA	ESTVA	AENNR		☐	ESEAENNR	☐	Change Number
33	DELFLGVA	ESTVA	DELFLG		☐	ESEDELFLG	☐	Deletion Indicator
34	RECNTVH	ESTVA	RECNTVH		☐	ESERECNTVH	☐	Reference to Value Assignment Header
35	ORD	ESTVA	ORD		☐	ESEORD	☐	Sort Sequence
36	COMPREL	ESTVA	COMPREL		☐	ESECOMPREL	☐	Reference Quantity for Component Specification

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20110901
SAP Release Created in