SAP Reports / Programs

comments icon Comments

DMC_ANALYZE_TABLE_COLUMNS SAP ABAP Report - MWB: Analysis of Table Column (Distinct Values and Their Occurrences)







DMC_ANALYZE_TABLE_COLUMNS is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This function is used to analyze the values in a table column in a remote system...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 DMC_ANALYZE_TABLE_COLUMNS 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 DMC_ANALYZE_TABLE_COLUMNS. "Basic submit
SUBMIT DMC_ANALYZE_TABLE_COLUMNS AND RETURN. "Return to original report after report execution complete
SUBMIT DMC_ANALYZE_TABLE_COLUMNS 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: P_DEST = D RFC Destination
Selection Text: P_TAB = D Table Name
Title: MWB: Analysis of Table Column (Distinct Values and Their Occurrences)
Text Symbol: 001 = No valid field was chosen:
Text Symbol: 002 = Data type is not allowed:
Text Symbol: 003 = Batch start is not allowed
Text Symbol: 004 = RFC login terminated. Reason:
Text Symbol: 005 = No valid table type:
Text Symbol: 006 = Analysis
Text Symbol: 007 = Number of Entries
Text Symbol: T00 = RFC Connection Data
Text Symbol: T01 = Table


INCLUDES used within this REPORT DMC_ANALYZE_TABLE_COLUMNS

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:

RFC_SYSTEM_INFO
  CALL FUNCTION 'RFC_SYSTEM_INFO'
    DESTINATION p_dest
    IMPORTING
      rfcsi_export          = rfcsi
      rfc_login_complete    = login_complete
      dialog_user_type      = is_dialog_user
    EXCEPTIONS
      communication_failure = 1  MESSAGE msg_text
      system_failure        = 2  MESSAGE msg_text.

RFC_LOGON_INFO
    CALL FUNCTION 'RFC_LOGON_INFO'
      DESTINATION p_dest
      IMPORTING
        rfc_login_complete    = login_complete
        dialog_user_type      = is_dialog_user
      EXCEPTIONS
        communication_failure = 1  MESSAGE msg_text
        system_failure        = 2  MESSAGE msg_text.

LVC_FIELDCATALOG_MERGE
  CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'
    EXPORTING
      i_structure_name = 'DD03P'
    CHANGING
      ct_fieldcat      = lt_fcat.

LVC_FIELDCATALOG_MERGE
  CALL FUNCTION 'LVC_FIELDCATALOG_MERGE'
    EXPORTING
      i_structure_name = 'DMCTABANA'
    CHANGING
      ct_fieldcat      = lt_fcat.

SAPGUI_PROGRESS_INDICATOR
  CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'
    EXPORTING
      text = l_textline.

DMC_ANALYZE_TABLE_COLUMNS
  CALL FUNCTION 'DMC_ANALYZE_TABLE_COLUMNS'
    DESTINATION p_dest
    EXPORTING
      im_tabname        = p_tab
      im_fieldname      = wa_field-fieldname
    IMPORTING
      ex_max_value      = g_max_value
      ex_max_count      = g_max_count
      ex_tablen         = g_tablen
    TABLES
      ex_analysis       = gt_analysis
    EXCEPTIONS
      invalid_tabname   = 1
      invalid_fieldname = 2
      invalid_tabclass  = 3
      OTHERS            = 4.


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


   
 

DMC_ANALYZE_TABLE_COLUMNS - MWB: Analysis of Table Column (Distinct Values and Their Occurrences)
DMC_ANALYZE_TABLE_COLUMNS - MWB: Analysis of Table Column (Distinct Values and Their Occurrences)
DMC_ANALYZE_INTRANSP_FIELDS - MWB: Remote Analysis of Usage of Non-Transparent Fields
DMC_ANALYZE_INTRANSP_FIELDS - MWB: Remote Analysis of Usage of Non-Transparent Fields
DMC_ANALYZE_DB_USER_COMMANDI04 - Include DMC_ANALYZE_DB_USER_COMMANDI04
DMC_ANALYZE_DB_USER_COMMANDI02 - Include DMC_ANALYZE_DB_USER_COMMANDI02