SAP ABAP View /MRSS/V_RM_ALERT (DB View for MRS Alert data)
Hierarchy
MRSS_NW (Software Component) SAP Multiresource Scheduling for SAP Net
   PM-WOC-CP (Application Component) Capacity and Resource Planning
     /MRSS/RMS (Package) Resource Management Service Layer
Basic Data
View Type D Database View 
Database View /MRSS/V_RM_ALERT  
Short Description DB View for MRS Alert data    
Root table /MRSS/D_COMPO   Alert Components 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 /MRSS/D_COMPO /MRSS/D_COMPO
2 /MRSS/D_ALERTS  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 /MRSS/D_COMPO ALERT_GUID JL EQ 0 0
2 /MRSS/D_ALERTS ALERT_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT /MRSS/D_COMPO CLIENT   MANDT Client
2 ALERT_GUID /MRSS/D_COMPO ALERT_GUID   /MRSS/T_GUID GUID
3 GUID /MRSS/D_COMPO GUID   /MRSS/T_GUID GUID
4 OBJ_TYPE /MRSS/D_COMPO OBJ_TYPE   /MRSS/T_SGE_OBJECT_TYPE Object Type in Planning Board
5 MSGID /MRSS/D_ALERTS MSGID   SYMSGID Message Class
6 MSGNR /MRSS/D_ALERTS MSGNR   SYMSGNO Message Number
7 MSGTYPE /MRSS/D_ALERTS MSGTYPE   SYMSGTY Message Type
8 VALID_FROM /MRSS/D_ALERTS VALID_FROM   TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9 VALID_TO /MRSS/D_ALERTS VALID_TO   TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10 MSGVAR1 /MRSS/D_ALERTS MSGVAR1   SYMSGV Message Variable
11 MSGVAR1_IS_TSTMP /MRSS/D_ALERTS MSGVAR1_IS_TSTMP   XFELD Checkbox
12 MSGVAR2 /MRSS/D_ALERTS MSGVAR2   SYMSGV Message Variable
13 MSGVAR2_IS_TSTMP /MRSS/D_ALERTS MSGVAR2_IS_TSTMP   XFELD Checkbox
14 MSGVAR3 /MRSS/D_ALERTS MSGVAR3   SYMSGV Message Variable
15 MSGVAR3_IS_TSTMP /MRSS/D_ALERTS MSGVAR3_IS_TSTMP   XFELD Checkbox
16 MSGVAR4 /MRSS/D_ALERTS MSGVAR4   SYMSGV Message Variable
17 MSGVAR4_IS_TSTMP /MRSS/D_ALERTS MSGVAR4_IS_TSTMP   XFELD Checkbox
18 CONFIRMD /MRSS/D_ALERTS CONFIRMD   /MRSS/T_ALERT_CONFRIMD Confirmation
19 ALERT_TYPE /MRSS/D_ALERTS ALERT_TYPE   /MRSS/T_ALERTTYPE Alert Type
20 DEL_FLG /MRSS/D_ALERTS DEL_FLG   /MRSS/T_BOOLEAN Boolean Variable
                 
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  20141109 
SAP Release Created in 610