SAP ABAP View DIAGST_STAT_V1 (CCDB: Statistics of last upload)

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_STAT_V1
Short Description	CCDB: Statistics of last upload
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
4	DIAGST_UPL_STAT

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_UPL_STAT	STORE_ID	JL	EQ				0	0
6	DIAGST_UPLOAD	STORE_ID	JR	EQ			AND	0	0
7	DIAGST_UPL_STAT	UPLOAD_DATE	JL	EQ				0	0
8	DIAGST_UPLOAD	UPLOAD_DATE	JR	EQ			AND	0	0
9	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	TPL_ID	DIAGST_STORE	TPL_ID		☐	DIAGST_STORE_TPL_ID	☐	Store Template ID
5	SOURCE	DIAGST_STOREGR	SOURCE		☐	DIAGST_STORE_GROUP_SOURCE	☐	Source of Store
6	CREATION_DATE	DIAGST_STOREGR	CREATION_DATE		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
7	LANDSCAPE_CLASS	DIAGST_STOREGR	LANDSCAPE_CLASS		☐	CLASSNAME	☐	Reference type
8	LANDSCAPE_ID	DIAGST_STOREGR	LANDSCAPE_ID		☐	DIAGLS_ID	☐	The Landscape ID.
9	COMP_ID	DIAGST_STOREGR	COMP_ID		☐	DIAGLS_SOFT_COMP_PPMS_ID	☐	The Ppms Id of the Software Component
10	SOFT_COMP_VER_ID	DIAGST_STOREGR	SOFT_COMP_VER_ID		☐	DIAGLS_ID	☐	The Landscape ID.
11	LSCP_VK	DIAGST_STOREGR	LSCP_VK		☐	DIAGST_LSCP_VK	☐	CCDB: Landscape Virtual Key
12	TECH_SYSTEM_ID	DIAGST_STOREGR	TECH_SYSTEM_ID		☐	DIAGLS_ID	☐	The Landscape ID.
13	GROUP_NAME	DIAGST_STOREGR	GROUP_NAME		☐	DIAGST_STORE_GROUP_NAME	☐	Store Group Name
14	NAME	DIAGST_STORE	NAME		☐	DIAGST_STORE_NAME	☐	Store Name
15	MAINALIAS	DIAGST_STORE	MAINALIAS		☐	DIAGST_STORE_MAINALIAS	☐	Store Alias
16	SUBALIAS	DIAGST_STORE	SUBALIAS		☐	DIAGST_STORE_SUBALIAS	☐	Sub Alias
17	TYPE	DIAGST_STORE	TYPE		☐	DIAGST_STORE_TYPE	☐	Type of Store
18	CATEGORY	DIAGST_STORE	CATEGORY		☐	DIAGST_STORE_CATEGORY	☐	Category of Store
19	NAME_LONG	DIAGST_STORE	NAME_LONG		☐	DIAGST_STORE_NAME_LONG	☐	Store Name
20	PATH	DIAGST_STORE	PATH		☐	DIAGST_STORE_PATH	☐	Store Path
21	STORE_CR_DATE	DIAGST_STORE	STORE_CR_DATE		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
22	STORE_FROM_DATE	DIAGST_STORE	STORE_FROM_DATE		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
23	STORE_TO_DATE	DIAGST_STORE	STORE_TO_DATE		☐	DIAGST_DATE	☐	DDIC type used in Store-API as general date format
24	STATE	DIAGST_UPLOAD	STATE		☐	DIAGST_STORE_STATE	☐	Upload State
25	STATE_TEXT	DIAGST_UPLOAD	STATE_TEXT		☐	DIAGST_STORE_STATE_TEXT	☐	Store State Text
26	EFWK_WLI_ID	DIAGST_STORE	EFWK_WLI_ID		☐	E2E_EFWK_WLI_ID	☐	Data Element for Worklist Items
27	CHK_TIMESTAMPL	DIAGST_STORE	CHK_TIMESTAMPL		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
28	CHK_STORE_RE	DIAGST_STORE	CHK_STORE_RE		☐	CHAR1	☐	Single-Character Flag
29	CHK_OUTDATED	DIAGST_STORE	CHK_OUTDATED		☐	DIAGST_OUTDATED	☐	Store is outdated regarding its update
30	CHK_OUTDATED_DAY	DIAGST_STORE	CHK_OUTDATED_DAY		☐	DIAGST_NUM_OUTDATED_DAYS	☐	Number of days the store is outdated regarding its update
31	CHK_MAIN_STATE	DIAGST_STORE	CHK_MAIN_STATE		☐	DIAGST_MAIN_STATE	☐	Store Main State
32	CHK_MAIN_STATE_T	DIAGST_STORE	CHK_MAIN_STATE_T		☐	DIAGST_MAIN_STATE_TYPE	☐	Main State Type ( 'R' , 'Y' , 'G', 'N')
33	IS_SNAPSHOT	DIAGST_UPL_STAT	IS_SNAPSHOT		☐	DIAGST_BOOLEAN	☐	Boolean: 'X' = True, space = False
34	SENT_ELEMENTS	DIAGST_UPL_STAT	SENT_ELEMENTS		☐	INT4	☐	Natural number
35	NUM_INITIALS	DIAGST_UPL_STAT	NUM_INITIALS		☐	DIAGST_NUM_INITIALS	☐	Number of inital elements
36	NUM_CHANGES	DIAGST_UPL_STAT	NUM_CHANGES		☐	DIAGST_NUM_CHANGES	☐	Number of changes
37	RT_LD	DIAGST_UPL_STAT	RT_LD		☐	DIAGST_UPLOAD_RT_LD	☐	Total Data Loader Runtime
38	RT_LD_RFC	DIAGST_UPL_STAT	RT_LD_RFC		☐	DIAGST_UPLOAD_RT_LD_RFC	☐	Netto Data Loader Runtime
39	RT_UP	DIAGST_UPL_STAT	RT_UP		☐	DIAGST_UPLOAD_RT_UP	☐	Total runtime of handle_store_data (upload-api)
40	RT_UP_REFSTORE	DIAGST_UPL_STAT	RT_UP_REFSTORE		☐	DIAGST_UPLOAD_RT_UP_RESTORE	☐	Runtime of ref. store creation within upload-api
41	RT_UP_COMPARE	DIAGST_UPL_STAT	RT_UP_COMPARE		☐	DIAGST_UPLOAD_RT_UP_COMPARE	☐	Runtime of the compare within upload-api
42	RT_UP_PS	DIAGST_UPL_STAT	RT_UP_PS		☐	DIAGST_UPLOAD_RT_PERSIST	☐	Total runtime of store persists within upload-api
43	RT_UP_PS_DBSAVE	DIAGST_UPL_STAT	RT_UP_PS_DBSAVE		☐	DIAGST_UPLOAD_RT_DBSAVE	☐	Runtime of DB Save within Store persists
44	RT_UP_PS_CONCHK	DIAGST_UPL_STAT	RT_UP_PS_CONCHK		☐	DIAGST_UPLOAD_RT_CONCHK	☐	Consistency Check within store persist
45	RT_UP_PS_OTHERS	DIAGST_UPL_STAT	RT_UP_PS_OTHERS		☐	DIAGST_UPLOAD_RT_PS_OTHERS	☐	Runtime of other functions within store persist
46	RT_UP_OTHERS	DIAGST_UPL_STAT	RT_UP_OTHERS		☐	DIAGST_UPLOAD_RT_UP_OTHERS	☐	Runtime of other coding within upload-api
47	RT_EX	DIAGST_UPL_STAT	RT_EX		☐	DIAGST_UPLOAD_RT_EX	☐	Extraction Runtime per Store

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