SAP ABAP Table SDIAGST_STORE_ADMIN (Structure of a Store for Admin)

Hierarchy

☛ ST (Software Component) SAP Solution Manager Tool
   ⤷ SV-SMG-DIA (Application Component) Solution Manager Diagnostics
     ⤷ AI_DIAGNOSTICS_STORE_API (Package) Read / Write Stores from/in the database.

Basic Data

Table Category	INTTAB	Structure
Structure	SDIAGST_STORE_ADMIN	Table Relationship Diagram
Short Description	Structure of a Store for Admin

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	LSCP_VK	☐	DIAGST_LSCP_VK		INT4	10	0	CCDB: Landscape Virtual Key
2	LANDSCAPE_CLASS	☐	CLASSNAME	CLASSNAME	CHAR	30	0	Reference type
3	LANDSCAPE_ID	☐	DIAGLS_ID	D_DIAGLS_ID	CHAR	128	0	The Landscape ID.
4	COMPV_ID	☐	DIAGLS_SOFT_COMP_VERS_PPMS_ID		CHAR	20	0	The Ppms Id of the Software Component Version
5	COMP_ID	☐	DIAGLS_SOFT_COMP_PPMS_ID		CHAR	20	0	The Ppms Id of the Software Component
6	GROUP_SOURCE	☐	DIAGST_STORE_GROUP_SOURCE		CHAR	4	0	Source of Store
7	GROUP_NAME	☐	DIAGST_STORE_GROUP_NAME	DIAGST_C60SM	CHAR	60	0	Store Group Name
8	STORE_CATEGORY	☐	DIAGST_STORE_CATEGORY		CHAR	10	0	Category of Store
9	STORE_TYPE	☐	DIAGST_STORE_TYPE		CHAR	15	0	Type of Store
10	STORE_FULLPATH	☐	DIAGST_STORE_PATH	DIAGST_STORE_PATH	STRG	0	0	Store Path
11	STORE_NAME	☐	DIAGST_STORE_NAME_LONG	DIAGST_STORE_NAME_LONG	STRG	0	0	Store Name
12	LONG_SID	☐	DIAGLS_TECH_SYST_LONG_SID		CHAR	8	0	The Technical System Long Sid
13	TECH_SYSTEM_TYPE	☐	DIAGLS_TECHNICAL_SYSTEM_TYPE		CHAR	16	0	The Technical System Type (Abap Server, J2ee Server)
14	SID	☐	DIAGLS_TECHNICAL_SYSTEM_SID		CHAR	3	0	The Technical System Sid
15	INSTALL_NUMBER	☐	DIAGLS_TECH_SYST_INSTALL_NBR		CHAR	10	0	The Technical System Install Number
16	TECH_SYSTEM_ID	☐	DIAGLS_ID	D_DIAGLS_ID	CHAR	128	0	The Landscape ID.
17	HOST_ID	☐	DIAGLS_ID	D_DIAGLS_ID	CHAR	128	0	The Landscape ID.
18	HOST_FULL	☐	DIAGLS_HOST_FULL_NAME		CHAR	256	0	Name of the host plus the domain
19	HOST	☐	DIAGLS_HOST_NAME		CHAR	256	0	The short Host name.
20	STORE_GROUP_ID	☐	DIAGST_STORE_GROUP_ID	SYSUUID_C	CHAR	32	0	Store Group ID
21	STORE_ID	☐	DIAGST_STORE_ID	SYSUUID_C	CHAR	32	0	Store ID
22	STORE_TPL_ID	☐	DIAGST_STORE_TPL_ID		CHAR	40	0	Store Template ID
23	STORE_WLI_ID	☐	E2E_EFWK_WLI_ID	SYSUUID_C	CHAR	32	0	Data Element for Worklist Items
24	STORE_LAST_UPLOAD	☐	DIAGST_UPLOAD_DATE	TZNTSTMPS	DEC	15	0	Upload Date
25	STORE_LAST_UPLOAD_LOG	☐	DIAGST_LOG_TS	TZNTSTMPL	DEC	21	7	Log Timestamp (long)
26	STORE_CREATED	☐	DIAGST_STORE_CREATION_DATE	TZNTSTMPS	DEC	15	0	Store Creation Date
27	STORE_FROM	☐	DIAGST_STORE_FROM_DATE	TZNTSTMPS	DEC	15	0	Store Content: From Date
28	STORE_TO	☐	DIAGST_STORE_TO_DATE	TZNTSTMPS	DEC	15	0	Store Content: To Date
29	STORE_STATE	☐	DIAGST_STORE_STATE		CHAR	20	0	Upload State
30	STORE_STATE_TEXT	☐	DIAGST_STORE_STATE_TEXT		STRG	0	0	Store State Text
31	CHK_TIMESTAMPL	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
32	STORE_OUTDATED_DAY	☐	DIAGST_NUM_OUTDATED_DAYS		INT4	10	0	Number of days the store is outdated regarding its update
33	STORE_MAIN_STATE	☐	DIAGST_MAIN_STATE		CHAR	10	0	Store Main State
34	STORE_MAIN_STATE_TYPE	☐	DIAGST_MAIN_STATE_TYPE		CHAR	1	0	Main State Type ( 'R' , 'Y' , 'G', 'N')
35	COMP_NAME	☐	DIAGLS_SOFT_COMP_NAME		CHAR	30	0	The name of te Software Component
36	COMPV_NAME	☐	DIAGLS_SOFT_COMP_VERS_NAME		CHAR	30	0	The Name of the Software Component Version
37	GROUP_CREATED	☐	DIAGST_DATE	TZNTSTMPS	DEC	15	0	DDIC type used in Store-API as general date format
38	STORE_FULLALIAS	☐	DIAGST_STORE_FULLALIAS	DIAGST_FULLALIAS	CHAR	57	0	Concatenate MainAlias+': '+SubAlias
39	STORE_MAINALIAS	☐	DIAGST_STORE_MAINALIAS	DIAGST_MAINALIAS	CHAR	30	0	Store Alias
40	STORE_SUBALIAS	☐	DIAGST_STORE_SUBALIAS	DIAGST_SUBALIAS	CHAR	25	0	Sub Alias
41	MESSAGE	☐			STRG	0	0
42	SENT_ELEMENTS	☐			INT4	10	0
43	RT_LD	☐	DIAGST_UPLOAD_RT_LD	DIAGST_RUNTIME_DEC	DEC	12	3	Total Data Loader Runtime
44	RT_EX	☐	DIAGST_UPLOAD_RT_EX	DIAGST_RUNTIME_DEC	DEC	12	3	Extraction Runtime per Store
45	NUM_READS	☐			INT4	10	0
46	STORE_SOURCE	☐	DIAGST_STORE_SOURCE		CHAR	15	0	Store Source used to find corresponding extractor
47	EXTR_WLI_ID	☐	E2E_EFWK_WLI_ID	SYSUUID_C	CHAR	32	0	Data Element for Worklist Items
48	STORE_CUST_TTYPE	☐	DIAGST_CUST_TTYPE	TTYPENAME	CHAR	30	0	CCDB: Customizing TableType of Store	*
49	STORE_CUST_TTYPE_ID	☐	DIAGST_CUST_TTYPE_ID		NUMC	3	0	CCDB: Customizing TableType ID
50	STORE_ACTIVE	☐	DIAGST_STORE_ACTIVE	DIAGST_STORE_ACTIVE	CHAR	1	0	CCDB Store Activity Status

History

Last changed by/on	SAP	20111123
SAP Release Created in	400