Load from External Systems (Daily Data)

DataStore object: 0CCMEXDD

ABAP statistics data is initially written as single records. The single records are aggregated for long-term storage. This DataStore object contains aggregates with the workload that is created in a system due to actions from other systems. The content of this DSO is based on the analysis view Workload from External Systems of the workload monitor (transaction ST03).

The DSO is supplied with values by the Extractor Framework, with a maximum delay of an hour. The data in this DSO is stored as daily data, that is, for each metric stored in BI, exactly one average value is stored for each day. More information about the different aggregates and aggregation types: Aggregation.

The job CCMS_ASR_AGGR_DATA_UPDATE, which runs once an hour, writes the data to the InfoCubes 0CCMEXDD1 and 0CCMEXDD2.

Structure

Delta Update

Delta update is not supported for this DataStore object.

Data Modeling

Key Fields
Object Type	Name	Technical Name
Time characteristic	Calendar Day	0CALDAY
Characteristic	Generic Hash Key	0CCMAHASH
Characteristic	Task Type	0CCMTTYPE
Characteristic	Date Granularity	0SMD_GRDA
Characteristic	Time Granularity	0SMD_GRTI
Characteristic	Landscape Installation Number	0SMD_LINS
Characteristic	Landscape System ID	0SMD_LSID
Characteristic	Subcomponent Instance Name	0SMD_SINA
Characteristic	Time	0TIME

Data Fields
Object Type	Name	Technical Name
Time characteristic	Calendar Year/Month	0CALMONTH
Time characteristic	Calendar Year/Quarter	0CALQUARTER
Time characteristic	Calendar Year/Week	0CALWEEK
Time characteristic	Calendar Year	0CALYEAR
Key figure	BCOUNT	0CCMABCT
Key figure	CPICCNT	0CCMACCNT
Key figure	Number of Logical Database Changes	0CCMACHCN
Key figure	Number of Changed Records	0CCMACHRC
Key figure	Total Time for Logical Database Changes in Seconds	0CCMACHTI
Key figure	Number of Dialog Steps	0CCMACNT
Key figure	Total CPU Time in Milliseconds	0CCMACPTI
Key figure	DSQLCNT	0CCMADCN
Key figure	DCOUNT	0CCMADCT
Key figure	Number of Database Procedures	0CCMADPCN
Key figure	Execution Time of Database Procedures in Milliseconds	0CCMADPTI
Key figure	ECOUNT	0CCMAECT
Key figure	Time for Network Transfer of Request Data in Milliseconds	0CCMAGNTI
Key figure	Number of Roundtrips	0CCMAGUCN
Key figure	GUI Time in Milliseconds	0CCMAGUTI
Key figure	Number of Physical Database Accesses	0CCMAPHCL
Key figure	Number of Physical Database Read Accesses	0CCMAPHCN
Key figure	Number of Modified Database Records	0CCMAPHRC
Key figure	Processing Time in Milliseconds	0CCMAPRTI
Characteristic	Application Server	0CCMAPSRV
Key figure	QUECNT	0CCMAQCNT
Key figure	Wait Time in Milliseconds	0CCMAQETI
Key figure	Number of Records Read from the Buffer During Direct Read	0CCMARDBF
Key figure	Number of Direct Reads	0CCMARDCN
Key figure	Number of Records Read During Direct Read	0CCMARDRC
Key figure	Time for Logical Direct Read in Milliseconds	0CCMARDTI
Key figure	Response Time in Milliseconds	0CCMARETI
Key figure	Number of Records Read from Buffer During Sequential Read	0CCMARSBF
Key figure	Number of Sequential Reads	0CCMARSCN
Key figure	Number of Records Read During Sequential Read	0CCMARSRC
Key figure	Time for Logical Sequential Read in Milliseconds	0CCMARSTI
Key figure	Roll Wait Time in Milliseconds	0CCMARWTI
Key figure	SLI_CNT	0CCMASCNT
Key figure	SCOUNT	0CCMASCT
Characteristic	Time Range (Hour - Hour)	0CCMATIRA
Key figure	UCOUNT	0CCMAUCT
Characteristic	Initial Action	0CCMIACTI
Characteristic	Initial Action Type	0CCMIATYP
Characteristic	Instance Name	0CCMINSNM
Characteristic	Service	0CCMISRV
Characteristic	Initial System	0CCMISYS
Characteristic	Initial User	0CCMIUSR
Characteristic	System ID of Last Caller	0CCMPSID
Characteristic	Landscape Name	0CCM_LSN
Characteristic	Time Zone	0CCM_PTMZ
Characteristic	Hour Slot that Contains a Measured Value	0CCM_SHR
Characteristic	System Name	0CCM_SYS
Characteristic	Time Stamp	0CCM_TMSTMP
Data packet characteristic	BW Delta Process: Update Mode	0RECORDMODE
Characteristic	Expiration Date for Reorganization	0SMDVDAT
Characteristic	Admin System ID SolMan	0SMD_ASID
Characteristic	Admin WLI ID	0SMD_AWID
Characteristic	Landscape Component Name	0SMD_LCNA
Characteristic	Landscape Customer Number	0SMD_LCNR
Characteristic	Landscape Component CV PPMS ID	0SMD_LCVP
Characteristic	Landscape Maininstance MI PPMS ID	0SMD_LMIP
Characteristic	Landscape Maininstance Name	0SMD_LMNA
Characteristic	Landscape Maininstance P PPMS ID	0SMD_LMPP
Characteristic	Landscape Product Name	0SMD_LPNA
Characteristic	Landscape Product PV PPMS ID	0SMD_LPRP
Characteristic	Landscape Technical System Type	0SMD_LTST
Characteristic	Unique System ID	0SMD_LUID
Characteristic	Subcomponent Host Name	0SMD_SHOS
Characteristic	Subcomponent Instance Type	0SMD_SITY
Characteristic	Subcomponent Node Name	0SMD_SNNA
Characteristic	Subcomponent Node Type	0SMD_SNTY
Characteristic	Subcomponent Physical Host Name	0SMD_SPHH
Characteristic	Time (hh)	0SMD_TIHH
Characteristic	Time (yyyyMMddhhmm)	0SMD_TIHM