ABAP Select data from SAP table DMC_S_RTO_MD into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP DMC_S_RTO_MD table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to DMC_S_RTO_MD. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the DMC_S_RTO_MD table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_DMC_S_RTO_MD TYPE STANDARD TABLE OF DMC_S_RTO_MD,
      WA_DMC_S_RTO_MD TYPE DMC_S_RTO_MD,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: <DMC_S_RTO_MD> TYPE DMC_S_RTO_MD.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_DMC_S_RTO_MD.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM DMC_S_RTO_MD
  INTO TABLE IT_DMC_S_RTO_MD.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DMC_S_RTO_MD
*  INTO TABLE @DATA(IT_DMC_S_RTO_MD2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_DMC_S_RTO_MD INDEX 1 INTO DATA(WA_DMC_S_RTO_MD2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_DMC_S_RTO_MD ASSIGNING <DMC_S_RTO_MD>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<DMC_S_RTO_MD>-OBJECT_DATA = 1.
<DMC_S_RTO_MD>-CONVOBJ_GUID = 1.
<DMC_S_RTO_MD>-CONVOBJ_IDENT = 1.
<DMC_S_RTO_MD>-SUBPROJ_IDENT = 1.
<DMC_S_RTO_MD>-PROJECT_IDENT = 1.

ENDLOOP.

LOOP AT IT_DMC_S_RTO_MD INTO WA_DMC_S_RTO_MD.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DMC_S_RTO_MD-PROJECT_TYPE, sy-vline,
  WA_DMC_S_RTO_MD-CONFIG_GUID, sy-vline,
  WA_DMC_S_RTO_MD-MTID, sy-vline,
  WA_DMC_S_RTO_MD-ALIAS, sy-vline,
  WA_DMC_S_RTO_MD-SYSID, sy-vline,
  WA_DMC_S_RTO_MD-FMID, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_DMC_S_RTO_MD you want to display...

  WRITE:/ sy-uline.
* Aternatively use generic code to Write field values (and NAME) to screen report
  DO.
    ASSIGN COMPONENT sy-index OF STRUCTURE wa_DMC_S_RTO_MD TO <field>.
    IF sy-subrc <> 0. EXIT. ENDIF.
    WRITE:/ 'Field Value', <field>, sy-vline.
    gd_str = <field> .
    lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ).
    lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ).
    WRITE:/ 'Field Name', lv_fieldname.
  ENDDO.

  
*Redo loop but convert all fields from internal to out value  
LOOP AT IT_DMC_S_RTO_MD INTO WA_DMC_S_RTO_MD.


*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Convert all fields to display/output versions using conversion routines
  PERFORM convert_all_field_values CHANGING wa_EKKO.
	 
ENDLOOP.

  
*&---------------------------------------------------------------------*
*& Form convert_all_field_values
*&---------------------------------------------------------------------*
FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO.
DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_DMC_S_RTO_MD_STR, 
OBJECT_DATA TYPE STRING,
CONVOBJ_GUID TYPE STRING,
CONVOBJ_IDENT TYPE STRING,
SUBPROJ_IDENT TYPE STRING,
PROJECT_IDENT TYPE STRING,
PROJECT_TYPE TYPE STRING,
CONFIG_GUID TYPE STRING,
MTID TYPE STRING,
ALIAS TYPE STRING,
SYSID TYPE STRING,
FMID TYPE STRING,
READING_TYPE TYPE STRING,
ACPL_FAE_SEL TYPE STRING,
SELPAR TYPE STRING,
ROOT_STRUCT TYPE STRING,
IS_STRUCTURED_OBJECT TYPE STRING,
SOURCE TYPE STRING,
SOURCE_ID TYPE STRING,
OBJECT_TYPE TYPE STRING,
STRINGS_USED TYPE STRING,
DBCON_NAME TYPE STRING,
DBCON_DBMS TYPE STRING,
REPL_VIEW TYPE STRING,
CLUSTER_GENERIC TYPE STRING,
VIRTUAL_HEADER TYPE STRING,
CONFIG_APPLICATION TYPE STRING,
DATAAG_AVAILABLE TYPE STRING,
DATAAG_FIELDNAME TYPE STRING,
DATAAG_TEMPERATURE TYPE STRING,
DATAAG_TEMP_USED TYPE STRING,
CONSUMER_NR TYPE STRING,
LOGTAB_SEC_INDEX TYPE STRING,
ORIGTAB_PRIMARY_INDEX TYPE STRING,
PACKID TYPE STRING,
ROLLBACK_ACTIVE TYPE STRING,
TCR_ACTIVE TYPE STRING,
ODQ_ALIAS TYPE STRING,
SQLTAB TYPE STRING,
TABCLASS TYPE STRING,
UC_ACTIVE TYPE STRING,
ODQ_REQUEST_ID TYPE STRING,
MT_DEF TYPE STRING,
MT_ID TYPE STRING,
RCV_CODEPAGE TYPE STRING,
FULL_INCR TYPE STRING,
DATA_IN_LOGTAB TYPE STRING,
SCENARIO TYPE STRING,
DEACTIV_APPL_LOG TYPE STRING,
CLIENT_SPECIFIC TYPE STRING,
MULTI_LOGTAB_USE TYPE STRING,
SCENARIO_GUID TYPE STRING,
DEL_LOGTAB_REC TYPE STRING,
TABLE_DEF TYPE STRING,
MT_ID TYPE STRING,
TABNAME TYPE STRING,
SHADOWTAB_NAME TYPE STRING,
TABCLASS TYPE STRING,
SQLTAB TYPE STRING,
CONTFLAG TYPE STRING,
CLIDEP TYPE STRING,
PROCESS_OPTION TYPE STRING,
LOGTAB_IN_RCV TYPE STRING,
CLUSTER_PHYSICAL TYPE STRING,
CONSIDER_TREQ TYPE STRING,
STRUCTURES TYPE STRING,
FOREIGN_KEYS TYPE STRING,
FORKEY_STRUCTURES TYPE STRING,
RSTRUCTURES TYPE STRING,
RELATIONS TYPE STRING,
STRUCFIELDS TYPE STRING,
STRINGFIELDS TYPE STRING,
RFC_DATA TYPE STRING,
PERF_OPTIONS TYPE STRING,
CLUSTER_PHYSICAL TYPE STRING,
LOGTAB_IN_RCV TYPE STRING,
PARALL_JOBS TYPE STRING,
PARALL_FIELDNAME TYPE STRING,
SEQNUM TYPE STRING,
TABNAME_CLONE TYPE STRING,
MAX_IN_BLOCK TYPE STRING,
READING_TYPE TYPE STRING,
NUM_RECS_LOGTAB TYPE STRING,
NUM_ORA_HASH_PAR TYPE STRING,
SEQUN_CACHE_SIZE TYPE STRING,
SPC_LOGTAB_CLEAN TYPE STRING,
BLOCKSIZE TYPE STRING,
READ_SEQU_ORDER TYPE STRING,
ORACLE_RAC_OPT TYPE STRING,
NUM_CLUSTER_READ TYPE STRING,
PACKAGE_SIZE TYPE STRING,
FOR_ALL_ENTRIES TYPE STRING,
PARALLEL_HINT TYPE STRING,
REPL_SEL_COUNT TYPE STRING,
IS_HASH_PARALLELIZED TYPE STRING,
CLUSTER_CACHE_READ TYPE STRING,
KEYFIELD1 TYPE STRING,
KEYFIELD2 TYPE STRING,
KEYFIELD3 TYPE STRING,
PARAMETERS TYPE STRING,
CONNECTION_DETAILS TYPE STRING,
INCLUDES TYPE STRING,
MD_EXTRACT_PARAM TYPE STRING,
MD_EXTRACT_EXCEP TYPE STRING,
FM_DATA TYPE STRING,
ODQ_REQUEST_PROJECTIONS TYPE STRING,
ADD_STRUCTURES TYPE STRING,
ADD_FIELDS TYPE STRING,
UC_TABNAMES TYPE STRING,
TABLE_IDENTS TYPE STRING,
ADD_LOGTAB_FIELDS TYPE STRING,
SYSTEM_DATA TYPE STRING,
OLO_INCLUDES TYPE STRING,
RAP_DATA TYPE STRING,END OF T_EKKO_STR.
DATA: WA_DMC_S_RTO_MD_STR type T_EKKO_STR.

DATA: ld_text TYPE string.

LOOP AT IT_EKKO INTO WA_EKKO.
  MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR.
  CONCATENATE: sy-vline
WA_DMC_S_RTO_MD_STR-OBJECT_DATA sy-vline 
WA_DMC_S_RTO_MD_STR-CONVOBJ_GUID sy-vline 
WA_DMC_S_RTO_MD_STR-CONVOBJ_IDENT sy-vline 
WA_DMC_S_RTO_MD_STR-SUBPROJ_IDENT sy-vline 
WA_DMC_S_RTO_MD_STR-PROJECT_IDENT sy-vline 
WA_DMC_S_RTO_MD_STR-PROJECT_TYPE sy-vline 
WA_DMC_S_RTO_MD_STR-CONFIG_GUID sy-vline 
WA_DMC_S_RTO_MD_STR-MTID sy-vline 
WA_DMC_S_RTO_MD_STR-ALIAS sy-vline 
WA_DMC_S_RTO_MD_STR-SYSID sy-vline 
WA_DMC_S_RTO_MD_STR-FMID sy-vline 
WA_DMC_S_RTO_MD_STR-READING_TYPE sy-vline 
WA_DMC_S_RTO_MD_STR-ACPL_FAE_SEL sy-vline 
WA_DMC_S_RTO_MD_STR-SELPAR sy-vline 
WA_DMC_S_RTO_MD_STR-ROOT_STRUCT sy-vline 
WA_DMC_S_RTO_MD_STR-IS_STRUCTURED_OBJECT sy-vline 
WA_DMC_S_RTO_MD_STR-SOURCE sy-vline 
WA_DMC_S_RTO_MD_STR-SOURCE_ID sy-vline 
WA_DMC_S_RTO_MD_STR-OBJECT_TYPE sy-vline 
WA_DMC_S_RTO_MD_STR-STRINGS_USED sy-vline 
WA_DMC_S_RTO_MD_STR-DBCON_NAME sy-vline 
WA_DMC_S_RTO_MD_STR-DBCON_DBMS sy-vline 
WA_DMC_S_RTO_MD_STR-REPL_VIEW sy-vline 
WA_DMC_S_RTO_MD_STR-CLUSTER_GENERIC sy-vline 
WA_DMC_S_RTO_MD_STR-VIRTUAL_HEADER sy-vline 
WA_DMC_S_RTO_MD_STR-CONFIG_APPLICATION sy-vline 
WA_DMC_S_RTO_MD_STR-DATAAG_AVAILABLE sy-vline 
WA_DMC_S_RTO_MD_STR-DATAAG_FIELDNAME sy-vline 
WA_DMC_S_RTO_MD_STR-DATAAG_TEMPERATURE sy-vline 
WA_DMC_S_RTO_MD_STR-DATAAG_TEMP_USED sy-vline 
WA_DMC_S_RTO_MD_STR-CONSUMER_NR sy-vline 
WA_DMC_S_RTO_MD_STR-LOGTAB_SEC_INDEX sy-vline 
WA_DMC_S_RTO_MD_STR-ORIGTAB_PRIMARY_INDEX sy-vline 
WA_DMC_S_RTO_MD_STR-PACKID sy-vline 
WA_DMC_S_RTO_MD_STR-ROLLBACK_ACTIVE sy-vline 
WA_DMC_S_RTO_MD_STR-TCR_ACTIVE sy-vline 
WA_DMC_S_RTO_MD_STR-ODQ_ALIAS sy-vline 
WA_DMC_S_RTO_MD_STR-SQLTAB sy-vline 
WA_DMC_S_RTO_MD_STR-TABCLASS sy-vline 
WA_DMC_S_RTO_MD_STR-UC_ACTIVE sy-vline 
WA_DMC_S_RTO_MD_STR-ODQ_REQUEST_ID sy-vline 
WA_DMC_S_RTO_MD_STR-MT_DEF sy-vline 
WA_DMC_S_RTO_MD_STR-MT_ID sy-vline 
WA_DMC_S_RTO_MD_STR-RCV_CODEPAGE sy-vline 
WA_DMC_S_RTO_MD_STR-FULL_INCR sy-vline 
WA_DMC_S_RTO_MD_STR-DATA_IN_LOGTAB sy-vline 
WA_DMC_S_RTO_MD_STR-SCENARIO sy-vline 
WA_DMC_S_RTO_MD_STR-DEACTIV_APPL_LOG sy-vline 
WA_DMC_S_RTO_MD_STR-CLIENT_SPECIFIC sy-vline 
WA_DMC_S_RTO_MD_STR-MULTI_LOGTAB_USE sy-vline 
WA_DMC_S_RTO_MD_STR-SCENARIO_GUID sy-vline 
WA_DMC_S_RTO_MD_STR-DEL_LOGTAB_REC sy-vline 
WA_DMC_S_RTO_MD_STR-TABLE_DEF sy-vline 
WA_DMC_S_RTO_MD_STR-MT_ID sy-vline 
WA_DMC_S_RTO_MD_STR-TABNAME sy-vline 
WA_DMC_S_RTO_MD_STR-SHADOWTAB_NAME sy-vline 
WA_DMC_S_RTO_MD_STR-TABCLASS sy-vline 
WA_DMC_S_RTO_MD_STR-SQLTAB sy-vline 
WA_DMC_S_RTO_MD_STR-CONTFLAG sy-vline 
WA_DMC_S_RTO_MD_STR-CLIDEP sy-vline 
WA_DMC_S_RTO_MD_STR-PROCESS_OPTION sy-vline 
WA_DMC_S_RTO_MD_STR-LOGTAB_IN_RCV sy-vline 
WA_DMC_S_RTO_MD_STR-CLUSTER_PHYSICAL sy-vline 
WA_DMC_S_RTO_MD_STR-CONSIDER_TREQ sy-vline 
WA_DMC_S_RTO_MD_STR-STRUCTURES sy-vline 
WA_DMC_S_RTO_MD_STR-FOREIGN_KEYS sy-vline 
WA_DMC_S_RTO_MD_STR-FORKEY_STRUCTURES sy-vline 
WA_DMC_S_RTO_MD_STR-RSTRUCTURES sy-vline 
WA_DMC_S_RTO_MD_STR-RELATIONS sy-vline 
WA_DMC_S_RTO_MD_STR-STRUCFIELDS sy-vline 
WA_DMC_S_RTO_MD_STR-STRINGFIELDS sy-vline 
WA_DMC_S_RTO_MD_STR-RFC_DATA sy-vline 
WA_DMC_S_RTO_MD_STR-PERF_OPTIONS sy-vline 
WA_DMC_S_RTO_MD_STR-CLUSTER_PHYSICAL sy-vline 
WA_DMC_S_RTO_MD_STR-LOGTAB_IN_RCV sy-vline 
WA_DMC_S_RTO_MD_STR-PARALL_JOBS sy-vline 
WA_DMC_S_RTO_MD_STR-PARALL_FIELDNAME sy-vline 
WA_DMC_S_RTO_MD_STR-SEQNUM sy-vline 
WA_DMC_S_RTO_MD_STR-TABNAME_CLONE sy-vline 
WA_DMC_S_RTO_MD_STR-MAX_IN_BLOCK sy-vline 
WA_DMC_S_RTO_MD_STR-READING_TYPE sy-vline 
WA_DMC_S_RTO_MD_STR-NUM_RECS_LOGTAB sy-vline 
WA_DMC_S_RTO_MD_STR-NUM_ORA_HASH_PAR sy-vline 
WA_DMC_S_RTO_MD_STR-SEQUN_CACHE_SIZE sy-vline 
WA_DMC_S_RTO_MD_STR-SPC_LOGTAB_CLEAN sy-vline 
WA_DMC_S_RTO_MD_STR-BLOCKSIZE sy-vline 
WA_DMC_S_RTO_MD_STR-READ_SEQU_ORDER sy-vline 
WA_DMC_S_RTO_MD_STR-ORACLE_RAC_OPT sy-vline 
WA_DMC_S_RTO_MD_STR-NUM_CLUSTER_READ sy-vline 
WA_DMC_S_RTO_MD_STR-PACKAGE_SIZE sy-vline 
WA_DMC_S_RTO_MD_STR-FOR_ALL_ENTRIES sy-vline 
WA_DMC_S_RTO_MD_STR-PARALLEL_HINT sy-vline 
WA_DMC_S_RTO_MD_STR-REPL_SEL_COUNT sy-vline 
WA_DMC_S_RTO_MD_STR-IS_HASH_PARALLELIZED sy-vline 
WA_DMC_S_RTO_MD_STR-CLUSTER_CACHE_READ sy-vline 
WA_DMC_S_RTO_MD_STR-KEYFIELD1 sy-vline 
WA_DMC_S_RTO_MD_STR-KEYFIELD2 sy-vline 
WA_DMC_S_RTO_MD_STR-KEYFIELD3 sy-vline 
WA_DMC_S_RTO_MD_STR-PARAMETERS sy-vline 
WA_DMC_S_RTO_MD_STR-CONNECTION_DETAILS sy-vline 
WA_DMC_S_RTO_MD_STR-INCLUDES sy-vline 
WA_DMC_S_RTO_MD_STR-MD_EXTRACT_PARAM sy-vline 
WA_DMC_S_RTO_MD_STR-MD_EXTRACT_EXCEP sy-vline 
WA_DMC_S_RTO_MD_STR-FM_DATA sy-vline 
WA_DMC_S_RTO_MD_STR-ODQ_REQUEST_PROJECTIONS sy-vline 
WA_DMC_S_RTO_MD_STR-ADD_STRUCTURES sy-vline 
WA_DMC_S_RTO_MD_STR-ADD_FIELDS sy-vline 
WA_DMC_S_RTO_MD_STR-UC_TABNAMES sy-vline 
WA_DMC_S_RTO_MD_STR-TABLE_IDENTS sy-vline 
WA_DMC_S_RTO_MD_STR-ADD_LOGTAB_FIELDS sy-vline 
WA_DMC_S_RTO_MD_STR-SYSTEM_DATA sy-vline 
WA_DMC_S_RTO_MD_STR-OLO_INCLUDES sy-vline 
WA_DMC_S_RTO_MD_STR-RAP_DATA sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.