SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | Microsoft SQL Server(BC-DB-MSS) SAP BC
RSMSSCRTABSCRIPT SAP ABAP Report - MS SQL Server Table definition and table statistics information
RSMSSCRTABSCRIPT 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 RSMSSCRTABSCRIPT 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 RSMSSCRTABSCRIPT. "Basic submit
SUBMIT RSMSSCRTABSCRIPT AND RETURN. "Return to original report after report execution complete
SUBMIT RSMSSCRTABSCRIPT VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: MS SQL Server Table definition and table statistics information
Text Symbol: 000 = Create SQL Script
Text Symbol: 001 = Input table name
Text Symbol: E00 = Nametab could not be mapped. Please try again.
Text Symbol: E01 = Cannot generate the script for table
INCLUDES used within this REPORT RSMSSCRTABSCRIPT
No INCLUDES are used within this REPORT code!
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:
DD_NAMETAB_TO_DDFIELDS call function 'DD_NAMETAB_TO_DDFIELDS' exporting keyfields = selected nullable = selected tabname = lv_crtable importing subrc = gv_subrc tables ddfields = lt_ddfields.
DB_CREATE_TABLE_S call function 'DB_CREATE_TABLE_S' exporting no_exec = selected tabname = lv_crtable tables ddfields = lt_ddfields statements = gt_ddl_stmts exceptions program_not_generated = 1 program_not_written = 2 tparam_source_not_determinated = 3 table_exists = 4 table_not_created = 5 others = 6.
DD_CREATE_INDEX_S call function 'DD_CREATE_INDEX_S' exporting * DBSYS = SY-DBSYS indexname = lt_index_tab-indexname no_exec = selected * PRID = 0 * PROGNAME = ' ' tabname = lv_crtable * IMPORTING * GENPROG = tables statements = lt_ddl_idx exceptions basetab_error = 1 db_error = 2 dd_error = 3 index_exists = 4 others = 5.
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 RSMSSCRTABSCRIPT or its description.
RSMSSCRTABSCRIPT - MS SQL Server Table definition and table statistics information RSMSSCRTABSCRIPT - MS SQL Server Table definition and table statistics information RSMSS100 - MSSQL: Simple textual explain functionality - for transaction SDBE RSMSS100 - MSSQL: Simple textual explain functionality - for transaction SDBE RSMSQSNP - Get database snapshot and store it in MSQSNP (called via RSCOLL00) RSMSQSNP - Get database snapshot and store it in MSQSNP (called via RSCOLL00)