SAP ABAP View SMSY_SYST_ATTR (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_SYST_ATTR  
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  
3 SMSY_ATTRIB_VAL  
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_ATTRIB_VAL ENTITY_KEY JL EQ 0 0
4 SMSY_SYSTEM ENTITY_KEY 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_ATTRIB_VAL KONZS JR EQ AND 0 0
9 SMSY_SYSTEM VERSION EQ 'ACTIVE' AND 0 0
10 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 GROUPNAME SMSY_GROUPSYSTEM GROUPNAME   SMSY_GROUPNAME System Group Name
3 GROUP_TYPE SMSY_GROUPSYSTEM GROUP_TYPE   SMSY_GRPTYPE Group Type
4 ROLE SMSY_GROUPSYSTEM ROLE   SMSY_ROLE System Role
5 ENTITY_KEY SMSY_SYSTEM ENTITY_KEY   SMSY_ENTITY_GUID System Landscape Entity GUID
6 ATTRIBKEY SMSY_ATTRIB_VAL ATTRIBKEY   SMSY_ATTRIBKEY Attribute Key
7 VALUE SMSY_ATTRIB_VAL VALUE   SMSY_ATTRIBVALUE Value of an Attribute in the System Landscape
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 400