SAP ABAP View SMSY_PGRP_SAPSYS (SAP 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_SAPSYS  
Short Description SAP System Products in Groups    
Root table SMSY_SYSTEM_SAP   Product Systems 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SMSY_SYSTEM_SAP SMSY_SYSTEM_SAP
2 SMSY_GROUPSYSTEM  
3 SMSY_SYSTEM  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SMSY_SYSTEM_SAP SYSTEMNAME JL EQ 0 0
2 SMSY_GROUPSYSTEM SYSTEMNAME JR EQ AND 0 0
3 SMSY_SYSTEM_SAP SYSTEMNAME JL EQ 0 0
4 SMSY_SYSTEM SYSTEMNAME JR EQ AND 0 0
5 SMSY_SYSTEM KONZS JL EQ 0 0
6 SMSY_GROUPSYSTEM KONZS JR EQ AND 0 0
7 SMSY_SYSTEM KONZS JL EQ 0 0
8 SMSY_SYSTEM_SAP KONZS JR EQ AND 0 0
9 SMSY_SYSTEM_SAP VERSION EQ 'ACTIVE' AND 0 0
10 SMSY_GROUPSYSTEM VERSION EQ 'ACTIVE' AND 0 0
11 SMSY_SYSTEM VERSION EQ 'ACTIVE' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 SYSTEMNAME SMSY_SYSTEM_SAP SYSTEMNAME   SMSY_NAME Product System Name
2 INST_NUMBER SMSY_SYSTEM_SAP INST_NUMBER   SMSY_INST_NR Installation Number
3 GROUPNAME SMSY_GROUPSYSTEM GROUPNAME   SMSY_GROUPNAME System Group Name
4 GROUP_TYPE SMSY_GROUPSYSTEM GROUP_TYPE   SMSY_GRPTYPE Group Type
5 MANDT SMSY_GROUPSYSTEM MANDT   SMSY_MANDT Client
6 ROLE SMSY_GROUPSYSTEM ROLE   SMSY_ROLE System Role
7 LSYSTEMNAME SMSY_SYSTEM LSYSTEMNAME   SMSY_LNAME Long Product System Name
8 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