SAP ABAP Program SAPLSMSSCCMS (SAPLSMSSCCMS)
Basic Data
Program SAPLSMSSCCMS  
Program Type F Function group  
Attributes
Status    
Application S Basis  
Authorization Group  
Logical database D$S Processing without database  
Selection screen  
Editor lock Fixed point arithmetic  
Unicode checks active Start using variant  
Function Group
Include Function Module Short Description Mode
01   MSS_CCMS_CALL_SCREEN   MSS: Call Screen via Framework    
02   MSS_INFO_BUTTON_TEXT   Display text for info button    
       
Transaction Code
Transactions reference to this program
# Transaction Code Short Description
1 DB02_MSS Db02 for MS SQL Server 
2 EXPL_MSS Call the explain in a new window 
3 SQLSTMT_MSS Display SQL for abap in new window 
4 ST04_MSS St04 for MS SQL Server 
     
Screens
# Screen Short Description
1 0100  Index Operational Stats 
2 0110  Index Usage Stats 
3 0120  Recommended indexes 
4 0200  Top N Largest Tables 
5 0300  Display Top N Growing Tables 
6 0600  SQL Statements 
7 0700  Display Table Statistics from table size history 
8 0900  MSS: Navigation Frame 
9 1000  Display IO per file 
10 1100  Display SQL processes - sessions,connections and requests 
11 1200  Configuration Overview 
12 1201  SQL Server Instance 
13 1202  Server Configuration 
14 1203  Database Options 
15 1204  SQL Agent status 
16 1205  Server properties 
17 1300  Configuration Options 
18 1301  Current configuration tab 
19 1302  Configuration history tab 
20 1400  Database Options 
21 1401  Current database options tab 
22 1402  Database option history tab 
23 1500  DB02 Space Overview 
24 1501  DB02 - Overview 
25 1502  DB02 - Files 
26 1503  DB02 - Objects 
27 1600  Table detail 
28 1601  Table detail - Overview 
29 1602  Table detail - Indexes 
30 1603  Table detail - Runtime Statistics 
31 1604  Table detail - Fields 
32 1606  Table detail - Partitioning 
33 1607  Table detail - Execute DBCC checktable 
34 1608  Table detail - Expensive statements for a table 
35 1700  Table statistics view and update 
36 1701  Table statistics overview tab 
37 1702  Table statistics distribution tab 
38 1703  Update table statistics tab 
39 1705  Physical index statistics 
40 1800  View details 
41 1900  ST04 Performance Overview 
42 1901  ST04 - Overview 
43 1902  ST04 - Current Activity 
44 1903  ST04 - Alerts 
45 2000  Locks 
46 2001  Blocking locks - display lock holders and waiters 
47 2002  All locks 
48 2100  Display blocking lock history 
49 2200  Single table size history 
50 2300  LOG display ( errorlog or agent ) 
51 2400  MS SQL Server status 
52 2500  MSS Disp+work DLL display 
53 2600  Display of checkdb history files 
54 2700  Deadlock List 
55 2701  ABAP Deadlocks subscreen 
56 2702  XE Deadlocks subscreen 
57 2800  View GUID creation env. var setting 
58 2900  Memory Overview 
59 2901  Memory Overview tab 
60 2902  Memory Components 
61 2903  Memory Usage 
62 2904  NUMA Memory configuration 
63 3100  Wait Statistics 
64 3101  Categories tab 
65 3102  Individual wait categories 
66 3200  Entrance screen for collector data display 
67 3201  Subscreen for Snapshot -> I/O 
68 3202  Subscreen for Snapshot -> Memory 
69 3203  Subscreen for Snapshot -> Buffer 
70 3204  Subscreen for Snapshot ->Others 
71 3205  Subscreen of Snapshot Details 
72 3250  Subscreen of time series display 
73 3300  Database and file size histories 
74 3301  Database Size History - tab subscreen 
75 3302  File Size History - tab subscreen 
76 3400  Procedures and Triggers 
77 3500  Triggers for one table 
78 3600  Main QA Screen 
79 3601  Display SQL code 
80 3602  Display SQL explain as a tree control 
81 3603  Display SQL explain as Text 
82 3604  Display SQL output from execute command 
83 3605  POPUP: Select explain method 
84 3700  Main QA Screen 
85 3701  Display SQL code 
86 3702  Display SQL explain as a tree control 
87 3703  Display SQL explain as Text 
88 3704  Display SQL output from execute command 
89 3705  POPUP: Select explain method 
90 3800  Non-SAP Features 
91 3801  Replication 
92 3802  Changed Data Capture 
93 3803  Policy Based Management 
94 3804  SQL Resource Governor 
95 3805  Windows Resource Governor 
96 3806  Snapshot Databases 
97 3807  Assemblies 
98 3808  Linked Servers 
99 3809  Plan Guides 
100 3810  AlwaysOn 
101 3900  Select download packages 
102 4000  Display SQL statement workload history 
103 4100  Single table index analysis 
104 4200  Select previously saved download packages. 
105 4300  View performance package 
     
GUI Status
# GUI Status Short Description
1 0100  Index operational stats 
2 0200  Display Largest Tables 
3 0300  Display Growing Tables 
4 0400  SQL requests for SQL 2005 and later 
5 0700  Display table size history 
6 0900  Display IO file statistics 
7 1100  SQL Processes for SQL 2005 
8 1110  SQL Processes for SQL 2000 
9 1200  Configuration Overview 
10 1300  Configuration Options 
11 1400  Database Options 
12 1500  Space Overview 
13 1600  Single Table Analysis 
14 1700  Table Statistics 
15 1800  Analyze database view 
16 1900  ST04 Performance Overview 
17 2000  Blocking Locks 
18 2100  Blocking Lock History 
19 2200  Single table size history 
20 2300  MS SQL Server DB log overview 
21 2400  MS SQL Server DB setup status 
22 2500  Display Dlls 
23 2600  Display Checkdb History File 
24 2700  Deadlock list 
25 2800  SAP Configuration Settings 
26 2900  Memory Overview 
27 3100  Wait Statistics 
28 3200  Entrance screen for collector display 
29 3201  Entrance screen for collector display 
30 3202  Entrance screen for collector display 
31 3203  Entrance screen for collector display 
32 3203_RESET  Snapshot Detail, Reset Status 
33 3210  Entrance screen for collector display 
34 3250  Entrance screen for collector display 
35 3300  Database and file size history 
36 3400  Triggers and Stored Procedures 
37 3600  Query Analyzer, SQL Command Window, Explain 
38 3605  Select explain method 
39 3900  Download spreadsheets 
40 4000  SQL Statement History 
41 4100  Index Analysis 
42 4200  Saved Spreadsheet Packages 
43 4300  Performance Package Viewer 
     
GUI Title
# GUI Title Short Description
1 0100  Tables 
2 0110  Tables with high index operational statistics 
3 0120  Tables for which SQL Server recommends new indexes 
4 0130  Tables with high index usage 
5 0200  Top & largest tables 
6 0201  Top & largest partitioned tables 
7 0300  Top & growing tables in schema & per & 
8 0400  SQL Statements & 
9 0700  Table history & tables 
10 0710  Table history for schema &. & tables 
11 0900  IO per file 
12 1100  SQL Sessions 
13 1110  MS SQL Server Database Process Monitor 
14 1600  Single Table Analysis &.&.& 
15 1800  View &.&.& 
16 1900  SQL Server Performance Analysis: Overview 
17 2000  Database Lock Overview 
18 2100  Database Blocking Lock History 
19 2200  Size history for table &1.&2 
20 2300  Database error and agent log overview 
21 2400  SQL Server setup checks 
22 2500  DLLs in disp+work.exe 
23 2600  Checkdb Log History 
24 2700  Deadlocks 
25 2800  SAP Configuration Settings 
26 3100  Wait Statistics from sys.dm_os_wait_stats 
27 3201  DB Collector display: Snapshot 
28 3202  DB Collector display: Time Series 
29 3203  DB Collector display: Raw performance counters 
30 3210  DB Collector display: Time Series Graph 
31 3250  DB Collector display: Time Series 
32 3300  Database and file size history 
33 3400  Triggers in database & schema & 
34 3401  Stored procedures in database & schema & 
35 3500  Triggers for table & in database & schema & 
36 3600  SQL Statement & 
37 3605  Select explain method 
38 3900  Download 
39 4000  SQL Statement History 
40 4100  Single Table Index Analysis 
41 4200  Manage Download Packages 
42 4300  Performance Package Viewer 
43 CURRENT  &1 Current values on &2 &3 
44 RESET  &1 since reset (duration: &2) 
45 START  &1 since DB Start &2 
     
History
Last changed by/on SAP  20050204 
SAP Release Created in