SAP ABAP View SMSY_CLIENTS (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_CLIENTS  
Short Description Products in Groups    
Root table SMSY_SYST_COMP   Installed Components 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SMSY_SYST_COMP SMSY_SYST_COMP
2 SMSY_SWCV_MI  
3 SMSY_SYSTEM  
4 SMSY_SW_COMP_VRS  
5 SMSY_SYST_CLIENT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SMSY_SYST_COMP COMPONENT JL EQ 0 0
2 SMSY_SW_COMP_VRS SW_COMPONENT JR EQ AND 0 0
3 SMSY_SYST_COMP SAPRELEASE JL EQ 0 0
4 SMSY_SW_COMP_VRS SW_RELEASE JR EQ AND 0 0
5 SMSY_SW_COMP_VRS COMPONENT_VRS JL EQ 0 0
6 SMSY_SWCV_MI COMPONENT_VRS JR EQ AND 0 0
7 SMSY_SYSTEM SYSTEMNAME JL EQ 0 0
8 SMSY_SYST_COMP SYSTEMNAME JR EQ AND 0 0
9 SMSY_SYST_CLIENT SYSTEMNAME JL EQ 0 0
10 SMSY_SYSTEM SYSTEMNAME JR EQ AND 0 0
11 SMSY_SYSTEM KONZS JL EQ 0 0
12 SMSY_SYST_COMP KONZS JR EQ AND 0 0
13 SMSY_SYST_CLIENT KONZS JL EQ 0 0
14 SMSY_SYSTEM KONZS JR EQ AND 0 0
15 SMSY_SYST_COMP VERSION EQ 'ACTIVE' AND 0 0
16 SMSY_SYSTEM VERSION EQ 'ACTIVE' AND 0 0
17 SMSY_SYST_CLIENT VERSION EQ 'ACTIVE' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 LOGSYS SMSY_SYST_CLIENT LOGSYS   LOGSYS Logical system
2 SYSTEMNAME SMSY_SYSTEM SYSTEMNAME   SMSY_NAME Product System Name
3 CLIENT SMSY_SYST_CLIENT MANDT   SMSY_MANDT Client
4 PRODUCT SMSY_SWCV_MI PRODUCT   SMSYPRODUCT PPMS Product
5 PRODUCTVERSION SMSY_SWCV_MI PRODUCTVERSION   SMSYPRODVERS PPMS Product Version
6 LEAD_COMP SMSY_SWCV_MI LEAD_COMP   SMSY_YESNO Flag, 'X' = Yes, ' ' = No
7 SW_COMPONENT SMSY_SW_COMP_VRS SW_COMPONENT   DLVUNIT Software Component
8 SAPRELEASE SMSY_SW_COMP_VRS SW_RELEASE   SAPRELEASE SAP Release
9 INSTANCE SMSY_SWCV_MI INSTANCE   SMSYINSTANCE Product Instance
10 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  20111123 
SAP Release Created in 220