SAP ABAP View DIAGST_STORE_V (Groups and Stores)

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

View Type	D	Database View
Database View	DIAGST_STORE_V
Short Description	Groups and Stores
Root table	DIAGST_STOREGR	Persistence Table for Class CL_DIAGST_STOREGROUP

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	DIAGST_STOREGR	DIAGST_STOREGR
2	DIAGST_STORE
3	DIAGST_UPLOAD

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DIAGST_STOREGR	STORE_GROUP_ID	JL	EQ				0	0
2	DIAGST_STORE	STORE_GROUP_ID	JR	EQ			AND	0	0
3	DIAGST_STORE	STORE_ID	JL	EQ				0	0
4	DIAGST_UPLOAD	STORE_ID	JR	EQ			AND	0	0
5	DIAGST_UPLOAD	UPLOAD_IS_LAST		EQ	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	STORE_GROUP_ID	DIAGST_STOREGR	STORE_GROUP_ID		☐	DIAGST_ID	☐	Unique-ID for a class instance of Store-API
2	STORE_ID	DIAGST_STORE	STORE_ID		☐	DIAGST_ID	☐	Unique-ID for a class instance of Store-API
3	LAST_UPLOAD_DATE	DIAGST_UPLOAD	UPLOAD_DATE		☐	DIAGST_UPLOAD_DATE	☐	Upload Date
4	LAST_UPLOAD_LOG	DIAGST_UPLOAD	LOG_TS		☐	DIAGST_LOG_TS	☐	Log Timestamp (long)
5	TPL_ID	DIAGST_STORE	TPL_ID		☐	DIAGST_STORE_TPL_ID	☐	Store Template ID
6	SOURCE	DIAGST_STOREGR	SOURCE		☐	DIAGST_STORE_GROUP_SOURCE	☐	Source of Store
7	CREATION_DATE	DIAGST_STOREGR	CREATION_DATE		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
8	LSCP_VK	DIAGST_STOREGR	LSCP_VK		☐	DIAGST_LSCP_VK	☐	CCDB: Landscape Virtual Key
9	LANDSCAPE_CLASS	DIAGST_STOREGR	LANDSCAPE_CLASS		☐	CLASSNAME	☐	Reference type
10	LANDSCAPE_ID	DIAGST_STOREGR	LANDSCAPE_ID		☐	DIAGLS_ID	☐	The Landscape ID.
11	COMP_ID	DIAGST_STOREGR	COMP_ID		☐	DIAGLS_SOFT_COMP_PPMS_ID	☐	The Ppms Id of the Software Component
12	SOFT_COMP_VER_ID	DIAGST_STOREGR	SOFT_COMP_VER_ID		☐	DIAGLS_ID	☐	The Landscape ID.
13	TECH_SYSTEM_ID	DIAGST_STOREGR	TECH_SYSTEM_ID		☐	DIAGLS_ID	☐	The Landscape ID.
14	HOST_ID	DIAGST_STOREGR	HOST_ID		☐	DIAGLS_ID	☐	The Landscape ID.
15	GROUP_NAME	DIAGST_STOREGR	GROUP_NAME		☐	DIAGST_STORE_GROUP_NAME	☐	Store Group Name
16	NAME	DIAGST_STORE	NAME		☐	DIAGST_STORE_NAME	☐	Store Name
17	MAINALIAS	DIAGST_STORE	MAINALIAS		☐	DIAGST_STORE_MAINALIAS	☐	Store Alias
18	SUBALIAS	DIAGST_STORE	SUBALIAS		☐	DIAGST_STORE_SUBALIAS	☐	Sub Alias
19	TYPE	DIAGST_STORE	TYPE		☐	DIAGST_STORE_TYPE	☐	Type of Store
20	CATEGORY	DIAGST_STORE	CATEGORY		☐	DIAGST_STORE_CATEGORY	☐	Category of Store
21	NAME_LONG	DIAGST_STORE	NAME_LONG		☐	DIAGST_STORE_NAME_LONG	☐	Store Name
22	PATH	DIAGST_STORE	PATH		☐	DIAGST_STORE_PATH	☐	Store Path
23	ABSOLUTE_PATH	DIAGST_STORE	ABSOLUTE_PATH		☐	DIAGST_BOOLEAN	☐	Boolean: 'X' = True, space = False
24	PATH_IS_LONG	DIAGST_STORE	PATH_IS_LONG		☐	DIAGST_BOOLEAN	☐	Boolean: 'X' = True, space = False
25	PATH_SHORT	DIAGST_STORE	PATH_SHORT		☐	DIAGST_STORE_PATH_SHORT	☐	Store Path Short
26	STORE_CR_DATE	DIAGST_STORE	STORE_CR_DATE		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
27	STORE_FROM_DATE	DIAGST_STORE	STORE_FROM_DATE		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
28	STORE_TO_DATE	DIAGST_STORE	STORE_TO_DATE		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
29	LAST_CHECK	DIAGST_STORE	LAST_CHECK		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
30	STATE	DIAGST_UPLOAD	STATE		☐	DIAGST_STORE_STATE	☐	Upload State
31	EFWK_WLI_ID	DIAGST_STORE	EFWK_WLI_ID		☐	E2E_EFWK_WLI_ID	☐	Data Element for Worklist Items
32	CHK_TIMESTAMPL	DIAGST_STORE	CHK_TIMESTAMPL		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
33	CHK_STORE_TPL_EX	DIAGST_STORE	CHK_STORE_TPL_EX		☐	CHAR1	☐	Single-Character Flag
34	CHK_STORE_TPL_RE	DIAGST_STORE	CHK_STORE_TPL_RE		☐	CHAR1	☐	Single-Character Flag
35	CHK_LSCP_OBJ_EX	DIAGST_STORE	CHK_LSCP_OBJ_EX		☐	CHAR1	☐	Single-Character Flag
36	CHK_LSCP_OBJ_RE	DIAGST_STORE	CHK_LSCP_OBJ_RE		☐	CHAR1	☐	Single-Character Flag
37	CHK_LSCP_TS_EX	DIAGST_STORE	CHK_LSCP_TS_EX		☐	CHAR1	☐	Single-Character Flag
38	CHK_LSCP_TS_RE	DIAGST_STORE	CHK_LSCP_TS_RE		☐	CHAR1	☐	Single-Character Flag
39	CHK_COMP_ID_EX	DIAGST_STORE	CHK_COMP_ID_EX		☐	CHAR1	☐	Single-Character Flag
40	CHK_COMP_ID_RE	DIAGST_STORE	CHK_COMP_ID_RE		☐	CHAR1	☐	Single-Character Flag
41	CHK_COMPV_ID_EX	DIAGST_STORE	CHK_COMPV_ID_EX		☐	CHAR1	☐	Single-Character Flag
42	CHK_COMPV_ID_RE	DIAGST_STORE	CHK_COMPV_ID_RE		☐	CHAR1	☐	Single-Character Flag
43	CHK_STORE_RE	DIAGST_STORE	CHK_STORE_RE		☐	CHAR1	☐	Single-Character Flag
44	CHK_OUTDATED	DIAGST_STORE	CHK_OUTDATED		☐	DIAGST_OUTDATED	☐	Store is outdated regarding its update
45	CHK_OUTDATED_DAY	DIAGST_STORE	CHK_OUTDATED_DAY		☐	DIAGST_NUM_OUTDATED_DAYS	☐	Number of days the store is outdated regarding its update
46	CHK_WAIT_FOR_UPD	DIAGST_STORE	CHK_WAIT_FOR_UPD		☐	CHAR1	☐	Single-Character Flag
47	CHK_WLI_VALID	DIAGST_STORE	CHK_WLI_VALID		☐	CHAR1	☐	Single-Character Flag
48	CHK_DELIV_BY_WLI	DIAGST_STORE	CHK_DELIV_BY_WLI		☐	CHAR1	☐	Single-Character Flag
49	CHK_MAIN_STATE	DIAGST_STORE	CHK_MAIN_STATE		☐	DIAGST_MAIN_STATE	☐	Store Main State
50	CHK_MAIN_STATE_T	DIAGST_STORE	CHK_MAIN_STATE_T		☐	DIAGST_MAIN_STATE_TYPE	☐	Main State Type ( 'R' , 'Y' , 'G', 'N')
51	CHK_EXCEPTION	DIAGST_STORE	CHK_EXCEPTION		☐	DIAGST_BOOLEAN	☐	Boolean: 'X' = True, space = False
52	CHK_NDEV_CHECK	DIAGST_STORE	CHK_NDEV_CHECK		☐	DIAGST_BOOLEAN	☐	Boolean: 'X' = True, space = False
53	NUM_READS	DIAGST_STORE	NUM_READS		☐	DIAGST_NUM_READS	☐	Number of reads via Read-API
54	STORE_SOURCE	DIAGST_STORE	STORE_SOURCE		☐	DIAGST_STORE_SOURCE	☐	Store Source used to find corresponding extractor
55	CUST_TTYPE	DIAGST_STORE	CUST_TTYPE		☐	DIAGST_CUST_TTYPE	☐	CCDB: Customizing TableType of Store
56	CUST_TTYPE_ID	DIAGST_STORE	CUST_TTYPE_ID		☐	DIAGST_CUST_TTYPE_ID	☐	CCDB: Customizing TableType ID
57	CHK_LSCP_OBJ_WD	DIAGST_STORE	CHK_LSCP_OBJ_WD		☐	CHAR1	☐	Single-Character Flag
58	STORE_ACTIVE	DIAGST_STORE	STORE_ACTIVE		☐	DIAGST_STORE_ACTIVE	☐	CCDB Store Activity Status

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	20111123
SAP Release Created in	400