Job and Process Monitoring, Monthly Mean Value

DataStore object: 0SMJPMMD

This DataStore object is used in Job and Process Monitoring in SAP Solution Manager. This application monitors all the business-critical background jobs, such as ABAP jobs and BW process chains, centrally. One or more jobs, which, for example, satisfy a specified naming convention, are the monitored objects.

The DSO contains the monthly aggregated mean values for the monitored objects. The job JPM_DATA_AGGREGATION calculates the aggregates, the raw data comes from the following DSOs:

0SMJPMSDF contains the run-independent master data for the monitored objects.
0SMJPMSH1/0SMJPMSH2 contain the attributes, such as start or end time.
0SMJPMSM1/0SMJPMSM2 contain the measured metrics for the runs.

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	Date Granularity	0SMD_GRDA
Characteristic	Time Granularity	0SMD_GRTI
Characteristic	Hash collision index	0SMD_HCI
Characteristic	Metric Hash ID	0SMD_MEHI
Characteristic	Job Status	0SMD_STATUS
Characteristic	Step Number	0SMD_STEPNR
Characteristic	Hash Collision Index	0SM_JPMHCI
Characteristic	Monitoring Hash ID	0SM_JPMMOHI
Characteristic	Job or Process Variant	0SM_JPMVAR
Characteristic	Time	0TIME

Data Fields
Object Type	Name	Technical Name
Time characteristic	Calendar Year/Month	0CALMONTH
Time characteristic	Calendar Year/Week	0CALWEEK
Time characteristic	Calendar Year	0CALYEAR
Key figure	Threshold Value: Green -> Yellow	0CCM_G2Y
Characteristic	Time Zone	0CCM_PTMZ
Key figure	Threshold Value: Red -> Yellow	0CCM_R2Y
Key figure	Threshold Value: Yellow -> Green	0CCM_Y2G
Key figure	Threshold Value: Yellow -> Red	0CCM_Y2R
Data packet characteristic	BW Delta Process: Update Mode	0RECORDMODE
Characteristic	Expiration Date for Reorganization	0SMDVDAT
Characteristic	Client	0SMD_CLIENT
Key figure	Number of measured values	0SMD_COUN
Characteristic	Landscape System ID	0SMD_LSID
Characteristic	Unique System ID	0SMD_LUID
Key figure	Maximum of measured values	0SMD_MAX
Characteristic	Metric Name	0SMD_MENA
Characteristic	Metric Type	0SMD_METY
Key figure	Minimum of measured values	0SMD_MIN
Characteristic	Unit of a Metric	0SMD_MUNI
Key figure	Status Gray for Evaluated Metrics	0SMD_R_GRAY
Key figure	Status Green for Evaluated Metrics	0SMD_R_GREE
Key figure	Status Red for Evaluated Metrics	0SMD_R_RED
Key figure	Status Yellow for Evaluated Metrics	0SMD_R_YELL
Characteristic	Subcomponent Host Name	0SMD_SHOS
Characteristic	Subcomponent Instance Name	0SMD_SINA
Characteristic	Subcomponent Instance Type	0SMD_SITY
Key figure	Sum of measured values	0SMD_SUM
Characteristic	Time (hh)	0SMD_TIHH
Characteristic	Time (yyyyMMddhhmm)	0SMD_TIHM
Characteristic	Job or Process Name	0SM_JPMNAME
Characteristic	Job or Process Subtype	0SM_JPMSTYP
Characteristic	Job or Process Type	0SM_JPMTYP
Characteristic	Job Exec. User	0SM_JUSER
Characteristic	Monitoring Object ID	0SM_MONID
Characteristic	Monitoring Object Description	0SM_MONIDTX
Time characteristic	Weekday	0WEEKDAY1