SAP ABAP View SMSY_PHYS_HOST (Physical Host)

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_PHYS_HOST
Short Description	Physical Host
Root table	SMSY_LOG_HOST	Hardware Instance

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SMSY_LOG_HOST	SMSY_LOG_HOST
2	SMSY_HOST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SMSY_LOG_HOST	PHYS_HOSTNAME	JL	EQ				0	0
2	SMSY_HOST	HOSTNAME	JR	EQ			AND	0	0
3	SMSY_LOG_HOST	VERSION	JL	EQ				0	0
4	SMSY_HOST	VERSION	JR	EQ			AND	0	0
5	SMSY_LOG_HOST	KONZS	JL	EQ				0	0
6	SMSY_HOST	KONZS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	HOSTNAME	SMSY_LOG_HOST	HOSTNAME		☐	SMSY_HOSTNAME	☐	Server Name
2	KONZS	SMSY_HOST	KONZS		☐	KONZS	☐	Group key
3	VERSION	SMSY_HOST	VERSION		☐	SMSY_VERSION	☐	Version
4	IPADRESS	SMSY_HOST	IPADRESS		☐	IPADRESS	☐	IP Address
5	NRCPU	SMSY_HOST	NRCPU		☐	NRCPU	☐	Number of CPUs
6	CPUID	SMSY_HOST	CPUID		☐	CPUID	☐	CPU Type
7	CPUFREQ	SMSY_HOST	CPUFREQ		☐	CPUFREQ	☐	CPU Frequency
8	MEMORY	SMSY_HOST	MEMORY		☐	SMSY_MAIN_MEM	☐	Main Memory of a Server
9	OSTYPE	SMSY_HOST	OSTYPE		☐	SMSY_OPS	☐	SolMan System Landscape: Operating System
10	OSVERSION	SMSY_HOST	OSVERSION		☐	SMSY_OPS_VERS	☐	SolMan System Landscape: Operating System Version
11	HWNAME	SMSY_HOST	HWNAME		☐	SMSY_HWNAME	☐	Application Server Hardware
12	HWVENDOR	SMSY_HOST	HWVENDOR		☐	HWVENDOR	☐	Hardware Manufacturer
13	SAPS_SAP	SMSY_HOST	SAPS_SAP		☐	SMSY_SAPS_MEASURED	☐	SAPS (Measured)
14	SAPS_VENDOR	SMSY_HOST	SAPS_VENDOR		☐	SMSY_SAPS	☐	SAPS (Manufacturer)
15	CPU_TYPE	SMSY_HOST	CPU_TYPE		☐	SMSY_CPU_TYPE	☐	CPU Type
16	ROUTE_TO_SM	SMSY_HOST	ROUTE_TO_SM		☐	SMSY_RFCHOST_T	☐	Host to Central System Routing Information
17	ROUTE_FROM_SM	SMSY_HOST	ROUTE_FROM_SM		☐	SMSY_RFCHOST_F	☐	Central System to Server Routing Information
18	MEMORY_VIRTUAL	SMSY_HOST	MEMORY_VIRTUAL		☐	SMSY_VIRT_MEM	☐	Virtual Memory of a Server
19	PLANNED	SMSY_HOST	PLANNED		☐	SMSY_FLG_PLANNED	☐	Flag: Planned or Existing
20	SYDATUM	SMSY_HOST	SYDATUM		☐	SYDATUM	☐	System Date
21	SYUZEIT	SMSY_HOST	SYUZEIT		☐	SYUZEIT	☐	System Time
22	SYUNAME	SMSY_HOST	SYUNAME		☐	SYUNAME	☐	User Name
23	TRCODE	SMSY_HOST	TRCODE		☐	TCODE	☐	Transaction Code
24	GENERATOR	SMSY_HOST	GENERATOR		☐	SMSY_FLAG	☐	System Landscape Capture Flag
25	AKT_VERSION	SMSY_HOST	AKT_VERSION		☐	SMSY_VERSION	☐	Version
26	ENTITY_KEY	SMSY_HOST	ENTITY_KEY		☐	SMSY_ENTITY_GUID	☐	System Landscape Entity GUID
27	HOSTNAME_LARGE	SMSY_HOST	HOSTNAME_LARGE		☐	SMSY_HOSTNAME	☐	Server Name
28	DESCR	SMSY_HOST	DESCR		☐	SMSY_ENTITY_DESCR	☐	Object Description
29	POOLNAME	SMSY_HOST	POOLNAME		☐	SMSY_ACPOOL	☐	Adaptive-Enabled Computer Pool

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