SAP Reports / Programs

RSDD_MSSQL_CUBEANALYZE_BATCH SAP ABAP Report - RSDD_MSSQL_CUBEANALYZE_BATCH







RSDD_MSSQL_CUBEANALYZE_BATCH 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 RSDD_MSSQL_CUBEANALYZE_BATCH 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 RSDD_MSSQL_CUBEANALYZE_BATCH. "Basic submit
SUBMIT RSDD_MSSQL_CUBEANALYZE_BATCH AND RETURN. "Return to original report after report execution complete
SUBMIT RSDD_MSSQL_CUBEANALYZE_BATCH VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: RSDD_MSSQL_CUBEANALYZE_BATCH
Text Symbol: 122 = Disk Space Saved (%):
Text Symbol: 121 = Subsequent Table Size (MB):
Text Symbol: 120 = Previous Table Size (MB):
Text Symbol: 119 = Backgd. job sched.
Text Symbol: 118 = Bckgd
Text Symbol: 117 = Dialog
Text Symbol: 116 = Background job already running; action canceled
Text Symbol: 115 = Schedule
Text Symbol: 114 = Start immed.
Text Symbol: 113 = Schedule back. job?
Text Symbol: 112 = Error scheduling job
Text Symbol: 111 = Action canceled
Text Symbol: 110 = Partition limit successfully removed:
Text Symbol: 109 = Partition limit successfully created:
Text Symbol: 108 = Only set this mode for exceptions; not recommended by SAP
Text Symbol: 107 = Table does not contain decimal columns; no compression required
Text Symbol: 106 = Table successfully decompressed
Text Symbol: 105 = Decompress table
Text Symbol: 104 = Table is not compressed
Text Symbol: 103 = Compress table (type: variable decimal)
Text Symbol: 102 = Decimal compression not activated in this database
Text Symbol: 101 = Table successfully compressed
Text Symbol: 100 = Table already compressed (type: variable decimal)
Text Symbol: 091 = TooSmall
Text Symbol: 090 = Determine Cube Tables Without Statistics - Run 2
Text Symbol: 089 = Determine Cube Tables Without Statistics - Run 1
Text Symbol: 088 = Determine Superfluous PSA Partitions
Text Symbol: 087 = Determine Missing PSA Partitions
Text Symbol: 086 = Could not delete partition for table/request
Text Symbol: 085 = Partition limit does not exist:
Text Symbol: 084 = Partition limit already exists:
Text Symbol: 083 = Repair the table by repairing the primary key
Text Symbol: 082 = Determine number of decimal compressed tables
Text Symbol: 077 = Read largest fact tables
Text Symbol: 076 = Unique P index on primary key columns
Text Symbol: UNK = Unknown
Text Symbol: TIT = Start all checks





Text Symbol: SUC = Number of Successfully Processed Objects:
Text Symbol: SQL = SQL error; operation terminated
Text Symbol: SKP = Number of Previously Processed Objects:
Text Symbol: PRC = Number of Processed Objects:
Text Symbol: NOF = Not found
Text Symbol: ERR = Number of Incorrectly Processed Objects:
Text Symbol: ABR = Terminated
Text Symbol: 182 = Index decompressed
Text Symbol: 181 = Decompress all non-clustered indexes (type: row/page)
Text Symbol: 180 = Index compressed
Text Symbol: 179 = Compress all non-clustered indexes (type: row/page)
Text Symbol: 178 = Caution: Index compression is still in test phase (Note 991014)
Text Symbol: 177 = Table column already in index; will be removed
Text Symbol: 176 = Error in partitioning module; contact SAP support
Text Symbol: 175 = Table is partitioned; INCLUDE columns not allowed
Text Symbol: 174 = Index has INCLUDE columns; clustering not allowed
Text Symbol: 173 = INCLUDE columns not possible with clustered indexes and keys
Text Symbol: 172 = Use of Following Options
Text Symbol: 171 = Start of Index Declustering:
Text Symbol: 170 = Start of Index Clustering:
Text Symbol: 163 = Creation of Index Without INCLUDE Cols.
Text Symbol: 162 = Deletion of the Following Index in Database
Text Symbol: 161 = Recreation of Index with the Following INCLUDE Columns
Text Symbol: 160 = Creation of Missing Indexes:
Text Symbol: 145 = Statistics refreshed for table
Text Symbol: 144 = Table Size + Index Size Afterwards (MB):
Text Symbol: 143 = Table Size + Index Size Previously(MB):
Text Symbol: 142 = Compress Table (Type: Row)
Text Symbol: 141 = Table already compressed (type: row)
Text Symbol: 126 = Table does not exist in database
Text Symbol: 125 = Primary key (P flag) adjusted in DDIC
Text Symbol: 124 = Index P correct in database; need not be created
Text Symbol: 123 = Addtl. Disk Space (%):
Text Symbol: 039 = E Fact Table
Text Symbol: 038 = No
Text Symbol: 037 = Y
Text Symbol: 036 = Index created from within ABAP/4 Dictionary
Text Symbol: 035 = Writing P Index Columns in ABAP/4 Dictionary
Text Symbol: 034 = Indexes are consistent; no action requried





Text Symbol: 033 = Error creating index
Text Symbol: 032 = Clustered index was deleted (DROP)
Text Symbol: 031 = Error deleting (DROP) the clustered index
Text Symbol: 030 = Error: Table has a primary key. Terminate processing.
Text Symbol: 026 = No other index
Text Symbol: 025 = Does Not Exist
Text Symbol: 023 = Parts of the report are not yet released on the MS SQL Server 2005
Text Symbol: 022 = This report can only run on the MS SQL Server
Text Symbol: 021 = Not all indexes were created in the database
Text Symbol: 020 = Check if indexes are missing in the DB
Text Symbol: 019 = Table Has Clustered Index 010
Text Symbol: 018 = Following F fact tables have no clustered 010 index
Text Symbol: 017 = Error calling module MSS_GET_INDEXES
Text Symbol: 016 = Current Status of Table and Indexes
Text Symbol: 015 = Error occurred; check the output
Text Symbol: 014 = Processing successfully finished
Text Symbol: 013 = Index exists in ABAP/4 DDIC, but not in database
Text Symbol: 012 = Status of Table (of Indexes) After Processing
Text Symbol: 011 = Index created on database
Text Symbol: 010 = Creation of Remaining (Non-Clustered) Indexes
Text Symbol: 009 = Error calling module DD_CREATE_INDEX
Text Symbol: 008 = Creation of Clustered Index 010
Text Symbol: 007 = Error calling module DB_STORAGE_PUT
Text Symbol: 006 = Index Deleted (DROP)
Text Symbol: 005 = Error deleting (DROP) the index
Text Symbol: 004 = Delete (DROP) all non-clustered indexes
Text Symbol: 003 = Table already has a clustered index (<> index 010)
Text Symbol: 002 = Status of the Tables (of Indexes) Before Processing
Text Symbol: 001 = Table Processing
Text Symbol: 040 = F Fact Table
Text Symbol: 075 = Creation of partition for table/request failed:
Text Symbol: 074 = Index P successfully created on table
Text Symbol: 073 = Contact SAP support
Text Symbol: 072 = Error creating P index on table
Text Symbol: 071 = Write P index actively to ABAP DDIC
Text Symbol: 070 = Error in module RSDU_INFOCUBE_FACTTABLES
Text Symbol: 069 = Read partitioning information of all F fact tables:
Text Symbol: 068 = Report ended
Text Symbol: 067 = No partitioned tables found



Text Symbol: 066 = Following partitioned tables were found:
Text Symbol: 065 = Check if there are partitioned tables
Text Symbol: 064 = Partitioning is deactivated; activate it according to Note 869407
Text Symbol: 063 = Read P index information of all F fact tables:
Text Symbol: 062 = Error calling module DB_EXISTS_INDEX
Text Symbol: 061 = Read PK and P index information from E fact tables:
Text Symbol: 060 = Check inconsistency on primary index of F fact tables:
Text Symbol: 059 = Find other clustered index (<> 010) on F fact tables:
Text Symbol: 058 = Read system tables to find inconsistencies in the F fact table clustering:
Text Symbol: 057 = Execution Time (Sec):
Text Symbol: 056 = (To switch to bkgd process., see menu entry)
Text Symbol: 055 = Are you sure they should not be run in the background?
Text Symbol: 054 = You might be starting long-running commands in dialog
Text Symbol: 053 = Error deleting (DROP) index 0
Text Symbol: 052 = Info. about Analysis Functions
Text Symbol: 051 = Select at least one row
Text Symbol: 050 = Continue Anyway?
Text Symbol: 049 = They do not run on an MS SQL Server database
Text Symbol: 048 = (=inconsistent)
Text Symbol: 047 = Not Set
Text Symbol: 046 = Set
Text Symbol: 045 = Non-clustered index was created
Text Symbol: 044 = This index is not clustered
Text Symbol: 043 = Clustered index was created
Text Symbol: 042 = Another index is already clustered
Text Symbol: 041 = This index is already clustered


INCLUDES used within this REPORT RSDD_MSSQL_CUBEANALYZE_BATCH

INCLUDE RSDD_MSSQL_CUBEANALYZE_INCL.


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:

No SAP FUNCTION MODULES are executed within this report code!



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 RSDD_MSSQL_CUBEANALYZE_BATCH or its description.