SAP ABAP View MES_DB_AGG2ALR_V (View on MES_DB_AGG2ALRT and MES_DB_AGGREGATE)

Hierarchy

☛ ST (Software Component) SAP Solution Manager Tool
   ⤷ SV-SMG-MON-ALR-CLC (Application Component) Alert Calculation Engine
     ⤷ AI_SOLMAN_ALRT_CALC_ME_STORE (Package) Metric and Event Store

Basic Data

View Type	D	Database View
Database View	MES_DB_AGG2ALR_V
Short Description	View on MES_DB_AGG2ALRT and MES_DB_AGGREGATE
Root table	MES_DB_AGG2ALRT	Table of relations between Alert Groups and Node Aggregates

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MES_DB_AGG2ALRT	MES_DB_AGG2ALRT
2	MES_DB_AGGREGATE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MES_DB_AGG2ALRT	CLIENT	JL	EQ				0	0
2	MES_DB_AGGREGATE	CLIENT	JR	EQ			AND	0	0
3	MES_DB_AGG2ALRT	CONTEXT_ID	JL	EQ				0	0
4	MES_DB_AGGREGATE	CONTEXT_ID	JR	EQ			AND	0	0
5	MES_DB_AGG2ALRT	TYPE_ID	JL	EQ				0	0
6	MES_DB_AGGREGATE	TYPE_ID	JR	EQ			AND	0	0
7	MES_DB_AGG2ALRT	HASH_METRIC_PATH	JL	EQ				0	0
8	MES_DB_AGGREGATE	HASH_METRIC_PATH	JR	EQ			AND	0	0
9	MES_DB_AGG2ALRT	START_TIMESTAMP	JL	EQ				0	0
10	MES_DB_AGGREGATE	START_TIMESTAMP	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	MES_DB_AGG2ALRT	CLIENT		☐	SYMANDT	☐	Client ID
2	ALERTGROUP_ID	MES_DB_AGG2ALRT	ALERTGROUP_ID		☐	E2EA_GUID	☐	Consumer Connector: guid
3	CONTEXT_ID	MES_DB_AGG2ALRT	CONTEXT_ID		☐	AC_GUID	☐	Alert configuration: guid
4	TYPE_ID	MES_DB_AGG2ALRT	TYPE_ID		☐	AC_GUID	☐	Alert configuration: guid
5	HASH_METRIC_PATH	MES_DB_AGG2ALRT	HASH_METRIC_PATH		☐	ACE_D_PATH_HASH	☐	E2E MAI: Metric Path Hash Value
6	START_TIMESTAMP	MES_DB_AGG2ALRT	START_TIMESTAMP		☐	ACE_D_TIME_FROM	☐	Start of calculation interval
7	END_TIMESTAMP	MES_DB_AGGREGATE	END_TIMESTAMP		☐	ACE_D_TIME_TO	☐	End of calculation interval
8	METRIC_PATH	MES_DB_AGGREGATE	METRIC_PATH		☐	AC_METRIC_PATH	☐	AC: dataelement to store the metric path
9	RATING_AGGREGATE	MES_DB_AGGREGATE	RATING_AGGREGATE		☐	ACE_D_TRAFFIC_LIGHT_NUMERIC	☐	Numeric values for traffic lights
10	VALUE_MIN	MES_DB_AGGREGATE	VALUE_MIN		☐	ACE_D_EVENT_VALUE_MIN	☐	Minimal value of the reported events in the period
11	VALUE_MAX	MES_DB_AGGREGATE	VALUE_MAX		☐	ACE_D_EVENT_VALUE_MAX	☐	Maximal value of the reported events in the period
12	VALUE_LAST	MES_DB_AGGREGATE	VALUE_LAST		☐	ACE_D_EVENT_VALUE	☐	Event value
13	LAST_TEXT	MES_DB_AGGREGATE	LAST_TEXT		☐		☐

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	20111123
SAP Release Created in	710