SAP Reports / Programs | Basis Components | Database Interface, Database Platforms | CCMS / Database Monitors for Oracle(BC-DB-ORA-CCM) SAP BC
SAPMDB20 SAP ABAP dialog Program - Create and Delete Statistics
SAPMDB20 is a standard Module pool for a dialog screen ABAP Program 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 SAPMDB20 into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
DB20ORA - Update DB Statistics: Oracle
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 SAPMDB20. "Basic submit
SUBMIT SAPMDB20 AND RETURN. "Return to original report after report execution complete
SUBMIT SAPMDB20 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: Create and Delete Statistics
Text Symbol: 029 = Caution: Statistics Are Locked
Text Symbol: 028 = BITMAP index used for new statistics - changes could be incorrect
Text Symbol: 027 = Statistics do not exist (for example, pool or cluster table, data from DBSTATTORA, IGNORE flag)
Text Symbol: 026 = Statistics do not exist (for example, pool or cluster table, IGNORE flag set)
Text Symbol: 025 = Check Structure Of:
Text Symbol: 024 = Start operation?
Text Symbol: 023 = Check the results using transaction DB14.
Text Symbol: 022 = This operation can run for a long time.
Text Symbol: 021 = Delete Statistics For:
Text Symbol: 020 = Create Statistics For:
Text Symbol: 019 = Statistics do not exist (such as pool or cluster table, data from DBSTATTORA)
Text Symbol: 018 = Statistics do not exist (such as pool or cluster table)
Text Symbol: 017 = Harmful statistics (such as pool or cluster table, IGNORE flag set)
Text Symbol: 016 = Harmful statistics (such as pool or cluster table); delete statistics
Text Symbol: 015 = Statistics missing (Data from DBSTATTORA, IGNORE flag set)
Text Symbol: 014 = Statistics missing (data from DBSTATTORA); create statistics
Text Symbol: 013 = Statistics missing (IGNORE Flag set)
Text Symbol: 012 = Statistics missing; create statistics
Text Symbol: 011 = Statistics are obsolete (Changes| >= 50%, IGNORE flag set)
Text Symbol: 010 = Statistics are obsolete (|Changes| >= 50%); Create new statistics
Text Symbol: 009 = Statistics are current (|Changes| < 50%, IGNORE flag set)
Text Symbol: 008 = Statistics are current (|Changes| < 50%)
Text Symbol: 005 = Update Statistics for Application Tables for Application Monitor
Text Symbol: 004 = Update Statistics for Tables for Application Monitor
Text Symbol: 003 = Update Statistics for Tables from DBSTATC
Text Symbol: 002 = Create Missing Statistics
Text Symbol: 001 = Update Statistics for All Indexes
INCLUDES used within this REPORT SAPMDB20
INCLUDE MDB20TOP.
INCLUDE MDB20O01.
INCLUDE MDB20I01.
INCLUDE MDB20F01.
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 SAPMDB20 or its description.
SAPMDB20 - Create and Delete Statistics SAPMDB20 - Create and Delete Statistics SAPMCUSC - CUSC Country version configuration, internal use only SAPMCUSC - CUSC Country version configuration, internal use only SAPMCURR - documentation and ABAP source code SAPMCURR - documentation and ABAP source code