SAP ABAP Table SCCDBAD_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_CCDB (Package) CCDB based ABAP Webdynpro Applications

Basic Data

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