SAP ABAP Table SMSY_PHYS_HOST (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SMSY_PHYS_HOST	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	HOSTNAME	☑	SMSY_HOSTNAME	SMSY_HOSTNAME	CHAR	20	0	Server Name
2	KONZS	☑	KONZS	KONZS	CHAR	10	0	Group key
3	VERSION	☑	SMSY_VERSION	SMSY_VERSION	CHAR	10	0	Version
4	IPADRESS	☐	IPADRESS	LGASIPAD	CHAR	31	0	IP Address
5	NRCPU	☐	NRCPU		INT4	10	0	Number of CPUs
6	CPUID	☐	CPUID	CPUID	CHAR	50	0	CPU Type
7	CPUFREQ	☐	CPUFREQ		INT2	5	0	CPU Frequency
8	MEMORY	☐	SMSY_MAIN_MEM		INT4	10	0	Main Memory of a Server
9	OSTYPE	☐	SMSY_OPS	SMSY_OPS	CHAR	50	0	SolMan System Landscape: Operating System	SMSY_OP_SYS
10	OSVERSION	☐	SMSY_OPS_VERS	SMSY_OPS_VESR	CHAR	16	0	SolMan System Landscape: Operating System Version	SMSY_OP_SYS
11	HWNAME	☐	SMSY_HWNAME	SMSY_HWNAME	CHAR	50	0	Application Server Hardware	SMSY_HW_VENDOR
12	HWVENDOR	☐	HWVENDOR	HWVENDOR	CHAR	120	0	Hardware Manufacturer	SMSY_HW_VENDOR
13	SAPS_SAP	☐	SMSY_SAPS_MEASURED	SMSY_SAPS	CHAR	20	0	SAPS (Measured)
14	SAPS_VENDOR	☐	SMSY_SAPS	SMSY_SAPS	CHAR	20	0	SAPS (Manufacturer)
15	CPU_TYPE	☐	SMSY_CPU_TYPE	SMSY_CPU_TYPE	CHAR	20	0	CPU Type
16	ROUTE_TO_SM	☐	SMSY_RFCHOST_T	SMSY_RFCHOST	CHAR	100	0	Host to Central System Routing Information
17	ROUTE_FROM_SM	☐	SMSY_RFCHOST_F	SMSY_RFCHOST	CHAR	100	0	Central System to Server Routing Information
18	MEMORY_VIRTUAL	☐	SMSY_VIRT_MEM		INT4	10	0	Virtual Memory of a Server
19	PLANNED	☐	SMSY_FLG_PLANNED	SMSY_FLG_PLANNED	CHAR	1	0	Flag: Planned or Existing
20	SYDATUM	☐	SYDATUM	SYDATS	DATS	8	0	System Date
21	SYUZEIT	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
22	SYUNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
23	TRCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code
24	GENERATOR	☐	SMSY_FLAG	SMSY_FLAG	CHAR	10	0	System Landscape Capture Flag
25	AKT_VERSION	☐	SMSY_VERSION	SMSY_VERSION	CHAR	10	0	Version
26	ENTITY_KEY	☐	SMSY_ENTITY_GUID	CHAR32	CHAR	32	0	System Landscape Entity GUID
27	HOSTNAME_LARGE	☐	SMSY_HOSTNAME	SMSY_HOSTNAME	CHAR	20	0	Server Name
28	DESCR	☐	SMSY_ENTITY_DESCR	SMSY_ENTITY_DESCR	CHAR	80	0	Object Description
29	POOLNAME	☐	SMSY_ACPOOL	TEXT30	CHAR	30	0	Adaptive-Enabled Computer Pool

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMSY_PHYS_HOST	HWNAME	SMSY_HW_VENDOR	HWNAME
2	SMSY_PHYS_HOST	HWVENDOR	SMSY_HW_VENDOR	HWVENDOR
3	SMSY_PHYS_HOST	OSTYPE	SMSY_OP_SYS	OSTYPE		1	CN
4	SMSY_PHYS_HOST	OSVERSION	SMSY_OP_SYS	OSVERSION

History

Last changed by/on	SAP	20100705
SAP Release Created in