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
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
| 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 |
