SAP ABAP View SMSY_PGRP_SYS (System Products in Groups)
Hierarchy
ST (Software Component) SAP Solution Manager Tool
   SV-SMG-SYS (Application Component) Solution Manager System Landscape
     AI_S_CUSTOMIZING_LANDSCAPE (Package) System Landscape Maintenance for Customizing Tools
Basic Data
View Type D Database View 
Database View SMSY_PGRP_SYS  
Short Description System Products in Groups    
Root table SMSY_SYSTEM   Product Systems 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SMSY_SYSTEM SMSY_SYSTEM
2 SMSY_GROUPSYSTEM  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SMSY_SYSTEM SYSTEMNAME JL EQ 0 0
2 SMSY_GROUPSYSTEM SYSTEMNAME JR EQ AND 0 0
3 SMSY_SYSTEM KONZS JL EQ 0 0
4 SMSY_GROUPSYSTEM KONZS JR EQ AND 0 0
5 SMSY_SYSTEM VERSION EQ 'ACTIVE' AND 0 0
6 SMSY_GROUPSYSTEM VERSION EQ 'ACTIVE' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 SYSTEMNAME SMSY_SYSTEM SYSTEMNAME   SMSY_NAME Product System Name
2 LSYSTEMNAME SMSY_SYSTEM LSYSTEMNAME   SMSY_LNAME Long Product System Name
3 DESCR SMSY_SYSTEM DESCR   SMSY_SYSDESCR System Description
4 ARCHITECTURE SMSY_SYSTEM ARCHITECTURE   SMSY_ARCH Architecture
5 PLANNED SMSY_SYSTEM PLANNED   SMSY_FLG_PLANNED Flag: Planned or Existing
6 GROUPNAME SMSY_GROUPSYSTEM GROUPNAME   SMSY_GROUPNAME System Group Name
7 GROUP_TYPE SMSY_GROUPSYSTEM GROUP_TYPE   SMSY_GRPTYPE Group Type
8 MANDT SMSY_GROUPSYSTEM MANDT   SMSY_MANDT Client
9 ROLE SMSY_GROUPSYSTEM ROLE   SMSY_ROLE System Role
10 GROUP_PRODVERS SMSY_GROUPSYSTEM PRODUCT_VERSION   SMSYPRODVERS PPMS Product Version
11 SYSTEM_PRODVERS SMSY_SYSTEM PRODVERS   SMSYPRODVERS PPMS Product Version
12 ENTITY_KEY SMSY_SYSTEM ENTITY_KEY   SMSY_ENTITY_GUID System Landscape Entity GUID
13 KONZS SMSY_SYSTEM KONZS   KONZS Group key
                 
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  20100705 
SAP Release Created in 210