SAP Reports / Programs
SDB1FMSS SAP ABAP Report - MSSQL System Catalog Accesses for Function Group SDB1
SDB1FMSS is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter SDB1FMSS into the relevant SAP transactions such as SE38 or SE80
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT SDB1FMSS. "Basic submit
SUBMIT SDB1FMSS AND RETURN. "Return to original report after report execution complete
SUBMIT SDB1FMSS VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: MSSQL System Catalog Accesses for Function Group SDB1
INCLUDES used within this REPORT SDB1FMSS
INCLUDE RADBTOU0.
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
MSS_GET_OBJECT_TYPE call function 'MSS_GET_OBJECT_TYPE' exporting object_name = msstabname importing object_type = otype exceptions db_error = 1 internal_error = 2 object_not_found = 3.
MSS_CHECK_DDL_ALLOWED call function 'MSS_CHECK_DDL_ALLOWED' exporting table_name = msstabname importing subrc = subrc exceptions db_error = 1 internal_error = 2.
MSS_GET_ALL_OBJECTS call function 'MSS_GET_ALL_OBJECTS' exporting object_type = 'U' tables all_objects = db_objects exceptions db_error = 1 internal_error = 2 no_objects_found = 3.
MSS_GET_LOCKED_TABLES call function 'MSS_GET_LOCKED_TABLES' tables locked_tables = locktabs exceptions db_error = 1 internal_error = 2 no_tables_found = 3.
MSS_GET_TABLE_COLUMNS call function 'MSS_GET_TABLE_COLUMNS' exporting table_name = msstabname names_only = 'X' tables table_cols = dbtab_cols exceptions db_error = 1 internal_error = 2 table_not_found = 3.
MSS_GET_TABLE_COLUMNS call function 'MSS_GET_TABLE_COLUMNS' exporting table_name = msstabname tables table_cols = dbtab_cols exceptions db_error = 1 internal_error = 2 table_not_found = 3.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = tabname indexname = '0' importing realname = primind.
MSS_GET_INDEX_COLUMNS call function 'MSS_GET_INDEX_COLUMNS' exporting index_name = mssindname table_name = msstabname tables index_cols = dbind_cols exceptions db_error = 1 internal_error = 2 index_not_found = 3.
MSS_GET_SQLTEXT call function 'MSS_GET_SQLTEXT' exporting object_name = dbtab_cols-default string = ' ' quotes = ' ' table = 'X' tables sqltable = l_t_sqltab exceptions db_error = 1 internal_error = 2 sqltext_not_found = 3.
DD_TABNAME_OF_INDEX call function 'DD_TABNAME_OF_INDEX' exporting dbindex = dbindex importing tabname = dbtab.
MSS_GET_SINGLE_TABLE_OF_INDEX call function 'MSS_GET_SINGLE_TABLE_OF_INDEX' exporting index_name = mssindname table_name = msstabname exceptions db_error = 1 internal_error = 2 index_not_found = 3 others = 4.
MSS_GET_INDEX_TYPE call function 'MSS_GET_INDEX_TYPE' exporting index_name = mssindname table_name = msstabname importing index_type = indtype exceptions db_error = 1 internal_error = 2 index_not_found = 3.
MSS_GET_INDEX_COLUMNS call function 'MSS_GET_INDEX_COLUMNS' exporting index_name = mssindname table_name = msstabname tables index_cols = dbind_cols exceptions db_error = 1 internal_error = 2 index_not_found = 3.
MSS_GET_TYPES_OF_INDEXES call function 'MSS_GET_TYPES_OF_INDEXES' exporting table_name = msstabname tables index_types = dbind_types exceptions db_error = 1 internal_error = 2 no_indexes_found = 3.
MSS_GET_COLUMNS_OF_INDEXES call function 'MSS_GET_COLUMNS_OF_INDEXES' exporting table_name = msstabname tables index_cols = dbind_cols exceptions db_error = 1 internal_error = 2 no_indexes_found = 3.
MSS_DEFINE_CS_INDEX CALL FUNCTION 'MSS_DEFINE_CS_INDEX' EXPORTING i_tabname = l_tabname i_indexid = 'CS' i_global_check = l_global_check IMPORTING e_clustered = l_cstype.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = l_tabname indexname = 'CS' importing realname = l_dbindex_real subrc = l_rc exceptions parameter_error = 1 others = 2.
DD_TABNAME_OF_INDEX call function 'DD_TABNAME_OF_INDEX' exporting dbindex = l_columnstore_db-dbindex importing index = l_columnstore_db-indexname tabname = l_columnstore_db-sqltab exceptions index_not_in_dd = 1 others = 2. "#EC FB_RC
call function 'DD_TBIX_GET' exporting get_state = 'A' indexname = l_columnstore_db-indexname tabl_name = l_columnstore_db-sqltab tables dd17v_tab_a = l_t_dd17v exceptions illegal_value = 1 others = 2. "#EC FB_RC
MSS_GET_INDEXES call function 'MSS_GET_INDEXES' tables all_indexes = dbinds exceptions db_error = 1 internal_error = 2 no_indexes_found = 3.
MSS_GET_INDEXES call function 'MSS_GET_INDEXES' exporting only_unique_inds = 'X' tables all_indexes = dbinds exceptions db_error = 1 internal_error = 2 no_indexes_found = 3.
MSS_GET_OBJECT_TYPE call function 'MSS_GET_OBJECT_TYPE' exporting object_name = mssviewname importing object_type = otype exceptions db_error = 1 internal_error = 2 object_not_found = 3.
MSS_GET_SQLTEXT call function 'MSS_GET_SQLTEXT' exporting object_name = mssviewname string = 'X' quotes = ' ' table = ' ' importing sqlstring = mssviewtext exceptions db_error = 1 internal_error = 2 sqltext_not_found = 3.
MSS_GET_ALL_OBJECTS call function 'MSS_GET_ALL_OBJECTS' exporting object_type = 'V' tables all_objects = db_objects exceptions db_error = 1 internal_error = 2 no_objects_found = 3.
MSS_GET_SQLTEXT call function 'MSS_GET_SQLTEXT' exporting object_name = msstrigname string = 'X' quotes = ' ' table = ' ' importing sqlstring = msstrigtext exceptions db_error = 1 internal_error = 2 sqltext_not_found = 3.
MSS_GET_TRIGGERS call function 'MSS_GET_TRIGGERS' exporting tabname = tabname * SCHEMA_NAME = * DB_NAME = importing row_count = row_count tables all_triggers = all_triggers exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 no_objects_found = 7 others = 8.
DD_GET_NAMETAB call function 'DD_GET_NAMETAB' exporting * STATUS = 'A' tabname = p_tabname importing x030l_wa = x030l_wa tables x031l_tab = x031l_tab exceptions not_found = 1 no_fields = 2 others = 3.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = p_tabname importing subrc = l_subrc.
MSS_GET_TRIGGERS call function 'MSS_GET_TRIGGERS' exporting tabname = tabname tables all_triggers = l_t_triggers exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 no_objects_found = 7 others = 8.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name SDB1FMSS or its description.