SAP Reports / Programs | Cross-Application Components | European Monetary Union: Euro(CA-EUR) SAP CA

DMC_GET_TABLES_REMOTE SAP ABAP Report - MWB: Remote Determination of Relevant Tables







DMC_GET_TABLES_REMOTE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Determination of a set of database tables via RFC in a remote system based on defined criteria...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_GET_TABLES_REMOTE 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_GET_TABLES_REMOTE. "Basic submit
SUBMIT DMC_GET_TABLES_REMOTE AND RETURN. "Return to original report after report execution complete
SUBMIT DMC_GET_TABLES_REMOTE 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: S_TAB = D Table Name
Selection Text: S_DONT = Exclude (migrate never)
Selection Text: S_DEVCL = D Package
Selection Text: S_DEFTAB = Default (migrate always)
Selection Text: P_OWN = Own Selection
Selection Text: P_FILL = Only filled tables?
Selection Text: P_DEST = D RFC Destination
Selection Text: P_CUST = Only Customizing (SCEG)
Selection Text: P_CNTCLU = Also CLUSTER Tables (Runtime!)
Selection Text: P_CLIIND = Only Client-INdependent Tables
Selection Text: P_CLIDEP = Only Client-Dependent Tables
Selection Text: P_CLIALL = All Tables
Selection Text: P_CF_W = Delivery Class W
Selection Text: P_CF_S = Delivery Class S
Selection Text: P_CF_L = Delivery Class L
Selection Text: P_CF_G = Delivery Class G
Selection Text: P_CF_E = Delivery Class E
Selection Text: P_CF_C = Delivery Class C
Selection Text: P_CF_A = Delivery Class A
Selection Text: P_APPL = Only Application Data (ALW)
Selection Text: P_ALLTAB = All Tables
Title: MWB: Remote Determination of Relevant Tables
Text Symbol: T07 = RFC Connection Data
Text Symbol: T06 = Special Tables (Excluded ones and Defaults)
Text Symbol: T05 = Selection: By Existence of Entries
Text Symbol: T04 = Output Behavior
Text Symbol: T03 = Own Selection of Delivery Classes
Text Symbol: T02 = Selection: Delivery Class of Table
Text Symbol: T01 = Selection: Client Dependency
Text Symbol: T00 = Restrictions
Text Symbol: S12 = ... cache INDX
Text Symbol: S11 = ... directly to MT table in case of mass data processing
Text Symbol: S10 = ... local download (in dialog)
Text Symbol: S07 = Delivery Class G
Text Symbol: S06 = Delivery Class E
Text Symbol: S05 = Delivery Class C
Text Symbol: S04 = Delivery Class S
Text Symbol: S03 = Delivery Class W





Text Symbol: S02 = Delivery Class L
Text Symbol: S01 = Delivery Class A
Text Symbol: 101 = Selection of Output File
Text Symbol: 001 = No RFC destination specified - table determination is done in the local system
001 Table Name TabClass C A Pool/Cluster Entries Package/DevClass


INCLUDES used within this REPORT DMC_GET_TABLES_REMOTE

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:

SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = 'Get remote dictionary information'. "#EC NOTEXT

RFC_READ_TABLE CALL FUNCTION 'RFC_READ_TABLE' DESTINATION p_dest EXPORTING query_table = 'DD02L' delimiter = co_delimiter TABLES options = gt_options fields = gt_fields data = gt_data EXCEPTIONS table_not_available = 1 table_without_data = 2 option_not_valid = 3 field_not_valid = 4 not_authorized = 5 data_buffer_exceeded = 6 communication_failure = 7 MESSAGE msg_text system_failure = 8 MESSAGE msg_text OTHERS = 9.

SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING text = 'Get remote object catalog information'. "#EC NOTEXT

RFC_READ_TABLE CALL FUNCTION 'RFC_READ_TABLE' DESTINATION p_dest EXPORTING query_table = 'TADIR' delimiter = co_delimiter TABLES options = gt_options fields = gt_fields data = gt_data2 EXCEPTIONS table_not_available = 1 table_without_data = 2 option_not_valid = 3 field_not_valid = 4 not_authorized = 5 data_buffer_exceeded = 6 communication_failure = 7 MESSAGE msg_text system_failure = 8 MESSAGE msg_text OTHERS = 9.

SAPGUI_PROGRESS_INDICATOR CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' EXPORTING percentage = l_proz text = l_text.

DMC_COUNT_TABLE_ENTRIES CALL FUNCTION 'DMC_COUNT_TABLE_ENTRIES' DESTINATION p_dest EXPORTING im_tabname = wa_tab-tabname im_exact_count = space IMPORTING ex_count = l_count EXCEPTIONS communication_failure = 1 MESSAGE msg_text system_failure = 2 MESSAGE msg_text.



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