SAP Reports / Programs | Cross-Application Components | General Application Functions | Business Application Support(CA-GTF-BS) SAP CA

comments icon Comments

CNV_10020_UPDATE_STATS SAP ABAP Report - Refresh optimizer statistic for the object tables







CNV_10020_UPDATE_STATS is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The optimizer statistics are refreshed for the object tables CNV_10020_LOR_x, CNV_10020_ROR_x and CNV_10020_CLUSTER...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter CNV_10020_UPDATE_STATS 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

CNV_10020_UPD_STATS - Refresh of optimizer statistics


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


Text pool values


Selection Text: SO_TABLE = Table
Selection Text: P_SIGNI = Precision
Title: Refresh optimizer statistic for the object tables
Text Symbol: UPD = Refresh optimizer statistic for &1
Text Symbol: RFS = Optimizer statistic for &1 was refreshed
Text Symbol: PAR = Parameters
Text Symbol: CHO = Restriction


INCLUDES used within this REPORT CNV_10020_UPDATE_STATS

INCLUDE CNV_10020_CONSTANTS.
INCLUDE CNV_10020_GLOBAL_FORMS.


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:

SELECT_OPTIONS_RESTRICT
  CALL FUNCTION 'SELECT_OPTIONS_RESTRICT'
       EXPORTING
            RESTRICTION = RESTRICT.

UPDATE_STATS
  CALL FUNCTION 'UPDATE_STATS'
       EXPORTING
            TABLE_NAME = LD_TABLE
            SIGNI      = P_SIGNI
       EXCEPTIONS
            NOT_FOUND  = 1
            ERROR      = 2
            OTHERS     = 3.


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


   
 

CNV_10020_UPDATE_STATS - Refresh optimizer statistic for the object tables
CNV_10020_UPDATE_STATS - Refresh optimizer statistic for the object tables
CNV_10020_TRANSPORT_OBJECT_TOP - Creation of a transport request with specific org objects - data decl.
CNV_10020_TRANSPORT_OBJECT_F01 - Creation of a transport request with specific org objects - form rout.
CNV_10020_TRANSPORT_OBJECT - Creation of a transport request with specific org objects
CNV_10020_TRANSPORT_OBJECT - Creation of a transport request with specific org objects