SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | Microsoft SQL Server(BC-DB-MSS) SAP BC
SDB2FMSS SAP ABAP Report - FORMS for Database Access on MS SQL Server
SDB2FMSS 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 SDB2FMSS 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 SDB2FMSS. "Basic submit
SUBMIT SDB2FMSS AND RETURN. "Return to original report after report execution complete
SUBMIT SDB2FMSS VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: FORMS for Database Access on MS SQL Server
Text Symbol: 001 = Can Be Used
Text Symbol: 002 = Allowed Values
Text Symbol: 003 = Can Only Be Set/Changed by SAP
Text Symbol: 004 = Only Default Allowed
INCLUDES used within this REPORT SDB2FMSS
INCLUDE: RADBTMAC, RADBTMA1, RADBTOU0, RADBTOUM, RADBTSC0.
INCLUDE: RADBTMAC, RADBTMA1, RADBTOU0, RADBTOUM, RADBTSC0.
INCLUDE: RADBTMAC, RADBTMA1, RADBTOU0, RADBTOUM, RADBTSC0.
INCLUDE SDB2FCOM.
FORM NEXT_INDEX_INCLUDES USING INDX.
FORM GET_INDEX_ONLINE_POSSIBLE TABLES P_T_INCLUDE_COLUMS TYPE STANDARD TABLE
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:
DB_MAP_DDFIELDS call function 'DB_MAP_DDFIELDS' exporting dbsys = dbsys with_string = 'X' tables dbftypes = dbftype_glo ddfields = ddfields exceptions not_mappable = 1.
MSS_IS_COMP_ENABLED * call function 'MSS_IS_COMP_ENABLED' * IMPORTING * E_IS_ENABLED = l_comp_is_enabled * EXCEPTIONS * NOT_RUNNING_ON_MSSQL = 1 * DB_ERROR = 2 * INTERNAL_ERROR = 3 * DB_NOT_FOUND = 4 * NO_DB_ACCESS = 5 * SCHEMA_NOT_FOUND = 6 * OTHERS = 7 * .
DB_STORAGE_GET call function 'DB_STORAGE_GET' exporting dbsys = 'MSSQL' tabname = tabname source_hierarchy = src_hier tables storpar = storpars exceptions mapping_error = 1 db_error = 2 uncomplete_parameter = 3 others = 4.
DB_STORAGE_PUT call function 'DB_STORAGE_PUT' exporting dbsys = 'MSSQL' tabname = tabname useflag = 'X' tables storpar = storpars.
SCP_GET_CODEPAGE_KIND call function 'SCP_GET_CODEPAGE_KIND' importing cpkind = codepage.
MSS_GET_OBJECT_TYPE call function 'MSS_GET_OBJECT_TYPE' " PG121701 exporting object_name = 'mss_varbin_conversion' importing object_type = otype exceptions db_error = 1 internal_error = 2 object_not_found = 3.
MSS_GET_TABLE_STORPARS call function 'MSS_GET_TABLE_STORPARS' exporting table_name = msstabname importing table_storpars = dbtab_stor exceptions db_error = 1 internal_error = 2.
UPG_IS_SHADOW_SYSTEM CALL FUNCTION 'UPG_IS_SHADOW_SYSTEM' IMPORTING EV_SHADOW = l_shadow_and_tilde.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' EXPORTING * DBINDEX = TABNAME = tabname INDEXNAME = '0' IMPORTING * CONSTRAINT = * REALNAME = SUBRC = l_subrc * UNIQUE = EXCEPTIONS PARAMETER_ERROR = 1 OTHERS = 2.
MSS_PARTITION_STORAGE_GET call function 'MSS_PARTITION_STORAGE_GET' exporting part_tabname = tabname source_hierarchy = source_hierarchy * DBSYS = SY-DBSYS importing part_colname = part_colname left_right = left_right value_type = value_type value_length = value_length value_decimals = value_decimals part_type = part_type keyflag = keyflag tables part_values_out = partval_tab filegroups_out = partfg_tab part_names_out = partnm_tab storage_out = storpar_tmp exceptions wrong_database_platform = 1 wrong_parameter_input = 2 no_storage_parameter_available = 3 others = 4.
HELP_VALUES_GET_WITH_TABLE "call function 'HELP_VALUES_GET_WITH_TABLE' " exporting " titel = text-001 " importing " select_value = f4va-fieldval " tables " fields = fields " valuetab = file_gs " exceptions " field_not_in_ddic = 1 " more_then_one_selectfield = 2 " no_selectfield = 3 " others = 4.
MSS_GET_COLUMNS_OF_INDEXES call function 'MSS_GET_COLUMNS_OF_INDEXES' exporting table_name = msstabname also_mancre_stats = 'X' tables index_cols = dbind_cols exceptions db_error = 1 internal_error = 2 no_indexes_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_CREATE_CS_INDEX call function 'MSS_CREATE_CS_INDEX' exporting tabname = tabname indexid = indid is_clustered = clustered no_exec = 'X' maxdop = l_maxdop importing statements = l_t_stmt exceptions index_exists = 1 table_already_has_cs_index = 2 index_not_defined = 3 not_supported_cs_index = 4 not_supported_data_type = 5 index_not_created = 6 table_does_not_exist = 7 others = 8.
MSS_GET_INDEX_STORPARS call function 'MSS_GET_INDEX_STORPARS' exporting index_name = mssindname table_name = msstabname importing index_storpars = indstor exceptions db_error = 1 internal_error = 2 index_not_found = 3.
HELP_VALUES_GET_WITH_TABLE "call function 'HELP_VALUES_GET_WITH_TABLE' " exporting " titel = text-001 " importing " select_value = f4va-fieldval " tables " fields = fields " valuetab = file_gs " exceptions " field_not_in_ddic = 1 " more_then_one_selectfield = 2 " no_selectfield = 3 " others = 4.
HELP_VALUES_GET_WITH_TABLE "call function 'HELP_VALUES_GET_WITH_TABLE' " exporting " titel = text-002 " importing " select_value = f4va-fieldval " tables " fields = fields " valuetab = fillfacs " exceptions " field_not_in_ddic = 1 " more_then_one_selectfield = 2 " no_selectfield = 3 " others = 4.
F4IF_FIELD_VALUE_REQUEST "call function 'F4IF_FIELD_VALUE_REQUEST' " exporting " tabname = htable " fieldname = hfield " display = display_only " tables " return_tab = f4va " exceptions " others = 1.
call function 'F4IF_FIELD_VALUE_REQUEST' exporting tabname = htable fieldname = hfield display = display_only tables return_tab = f4va exceptions others = 1.
MSS_GET_INDEX_TYPE call function 'MSS_GET_INDEX_TYPE' exporting index_name = mssindname table_name = msstabname exceptions db_error = 1 internal_error = 2 index_not_found = 3.
MSS_GET_INDEX_TYPE call function 'MSS_GET_INDEX_TYPE' exporting index_name = mssindname table_name = msstabname exceptions db_error = 1 internal_error = 2 index_not_found = 3.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = '0' importing realname = pk_name subrc = subrc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = wa_pars-ddid importing realname = new_clus_index subrc = subrc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = wa_pars-ddid importing realname = dbindex subrc = subrc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = wa_pars-ddid importing realname = dbindex subrc = subrc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = new_clus_index_ddid importing realname = new_clus_index subrc = subrc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = wa_pars-ddid importing realname = dbindex subrc = subrc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = wa_pars-ddid importing realname = dbindex subrc = subrc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = wa_pars-ddid importing realname = dbindex subrc = subrc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting tabname = gtabname indexname = wa_pars-ddid importing realname = dbindex subrc = subrc.
DB_GET_RELEASE call function 'DB_GET_RELEASE' importing release = database_release.
DB_EXISTS_TABLE call function 'DB_EXISTS_TABLE' exporting tabname = table importing subrc = l_rc.
DB_EXISTS_INDEX call function 'DB_EXISTS_INDEX' exporting dbindex = dbindex tabname = table importing realname = l_realname_index subrc = l_rc.
DB_STORAGE_GET call function 'DB_STORAGE_GET' "#EC NOTEXT exporting dbsys = 'MSSQL' tabname = tabname source_hierarchy = src_hierarchy tables storpar = storpars exceptions mapping_error = 1 db_error = 2 uncomplete_parameter = 3 others = 4 .
DB_STORAGE_GET call function 'DB_STORAGE_GET' "#EC NOTEXT exporting dbsys = 'MSSQL' tabname = tabname source_hierarchy = src_hierarchy tables storpar = storpars exceptions mapping_error = 1 db_error = 2 uncomplete_parameter = 3 others = 4 .
DB_GET_RELEASE call function 'DB_GET_RELEASE' "#EC NOTEXT importing release = database_release.
DB_GET_RELEASE call function 'DB_GET_RELEASE' "#EC NOTEXT importing release = database_release.
DB_GET_RELEASE call function 'DB_GET_RELEASE' "#EC NOTEXT importing release = database_release.
MSS_DB_AND_SCHEMA call function 'MSS_DB_AND_SCHEMA' changing db_name = dname schema_name = sname exceptions not_running_on_mssql = 1 db_error = 2 internal_error = 3 db_not_found = 4 no_db_access = 5 schema_not_found = 6 others = 7.
UPG_GET_ACTIVE_COMP_UPGRADE call function 'UPG_GET_ACTIVE_COMP_UPGRADE' exporting iv_component = 'SAP_BASIS' iv_upgtype = '*' iv_buffered = ' ' exceptions no_upgrade_active = 1 others = 2.
DB_GET_RELEASE call function 'DB_GET_RELEASE' "#EC NOTEXT importing release = database_release.
DD_SHDUPG_GET_DBTABNAME call function 'DD_SHDUPG_GET_DBTABNAME' exporting ddic_tabname = tabname importing db_tabname = l_shdtable.
DD_TABNAME_OF_INDEX call function 'DD_TABNAME_OF_INDEX' exporting dbindex = p_dbindex importing index = indid exceptions index_not_in_dd = 1 others = 2.
DB_STORAGE_GET call function 'DB_STORAGE_GET' exporting tabname = p_tabname dbindex = p_dbindex source_hierarchy = l_src_hierarchy tables storpar = l_t_storpars exceptions others = 3.
DB_STORAGE_GET call function 'DB_STORAGE_GET' exporting tabname = p_tabname dbindex = p_dbindex source_hierarchy = l_src_hierarchy tables storpar = l_t_storpars exceptions others = 3.
DB_GET_RELEASE call function 'DB_GET_RELEASE' "#EC NOTEXT importing release = database_release.
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 SDB2FMSS or its description.