CL_DMC_DB_ANALYZER - database analyzer class

CL_GUI_FRONTEND_SERVICES - Frontend Services   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

For the calculation of access plans, it is important to identify one field of the conversion object'sheader table that is sufficiently selective to serve as portioning field for the definition of the dataportions of the access plan. Usually, fields that identify organizational units (such as company codes,sales organizations, etc.) or a fiscal year are not selective; document numbers, by contrast, are moreselective. However, it is not in all cases possible to determine a selective key field of a table, without a deeper analysis if the table, and the data stored in this table in the sender system.

The methods of this class provide a means to perform such an analysis, and to determine the ideal selectionfield. This field must not also be sufficiently selective; it should also be in a top position of either the primary or of any of the secondary indexes of the table.

Methods:

1. GET_DISTINCT_VALUES : This method gets the distinct valued for each of the key fields in the root structure of the conversion object.

2. GET_RESULTS: This method returns an internal table containing the conv objs and their corresponding selection parameters.

3. CONSTRUCTOR: It initializes the runid attribute of the class and gets a reference to log handler.

4. ANALYZE: This method analyses the specified conversion objects and selects the the best selection paramerter.

5. GET_DISTINCT_VALUES: This method gets the distinct valued for each of the key fields in the root structure of the conversion object.

6. GET_FIELDS: This method gets the field information for the specified table name.

7. GET_INDEXES: This method gets the index information for the specified table name.

8. GET_NEXT_CONVOBJ: This method gets the reference to the next conversion obejct.

9. GET_ROOT_STRUCT: This method gets the root structure of the specified copnverison object.

10. UPDATE_ANALYSIS_STATUS: This method updates the analysis status of the conversion object in DMC_SEL_PARAMS.

11. UPDATE_SELPAR: This method updates the selection parameter of the conversion object in DMC_SEL_PARAMS.

12. GET_STATUS: This method reads database table DMC_SEL_PARAMS to get details like conversion object id, and status for the specified run id.

BAL_S_LOG - Application Log: Log header data   ABAP Short Reference  
This documentation is copyright by SAP AG.


Length: 2339 Date: 20120526 Time: 135454     triton ( 129 ms )