ABAP Select data from SAP table DB6_DBH_COLLECTOR into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP DB6_DBH_COLLECTOR 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 DB6_DBH_COLLECTOR. 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 DB6_DBH_COLLECTOR 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_DB6_DBH_COLLECTOR TYPE STANDARD TABLE OF DB6_DBH_COLLECTOR,
      WA_DB6_DBH_COLLECTOR TYPE DB6_DBH_COLLECTOR,
      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: <DB6_DBH_COLLECTOR> TYPE DB6_DBH_COLLECTOR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DB6_DBH_COLLECTOR
*  INTO TABLE @DATA(IT_DB6_DBH_COLLECTOR2).
*--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_DB6_DBH_COLLECTOR INDEX 1 INTO DATA(WA_DB6_DBH_COLLECTOR2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_DB6_DBH_COLLECTOR ASSIGNING <DB6_DBH_COLLECTOR>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<DB6_DBH_COLLECTOR>-COLLECTOR = 1.
<DB6_DBH_COLLECTOR>-SNAPSHOT = 1.
<DB6_DBH_COLLECTOR>-COLNAME = 1.
<DB6_DBH_COLLECTOR>-COLRENAME = 1.
<DB6_DBH_COLLECTOR>-COLTYPE = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DB6_DBH_COLLECTOR-COLLENGTH, sy-vline,
WA_DB6_DBH_COLLECTOR-COLKEY, sy-vline,
WA_DB6_DBH_COLLECTOR-DBREL, sy-vline,
WA_DB6_DBH_COLLECTOR-DBMAX, sy-vline,
WA_DB6_DBH_COLLECTOR-DELTA, sy-vline,
WA_DB6_DBH_COLLECTOR-FORCE_DELTA, sy-vline.
ENDLOOP. *Add any further fields from structure WA_DB6_DBH_COLLECTOR 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_DB6_DBH_COLLECTOR 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_DB6_DBH_COLLECTOR INTO WA_DB6_DBH_COLLECTOR. *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_DB6_DBH_COLLECTOR_STR,
COLLECTOR TYPE STRING,
SNAPSHOT TYPE STRING,
COLNAME TYPE STRING,
COLRENAME TYPE STRING,
COLTYPE TYPE STRING,
COLLENGTH TYPE STRING,
COLKEY TYPE STRING,
DBREL TYPE STRING,
DBMAX TYPE STRING,
DELTA TYPE STRING,
FORCE_DELTA TYPE STRING,
CONV_UDF TYPE STRING,
CONV_UDF_PARAM TYPE STRING,
COLLECT TYPE STRING,
JOINS TYPE STRING,
BI TYPE STRING,
BI2 TYPE STRING,
BI_CONV_UDF TYPE STRING,
CALCULATION TYPE STRING,
DDIC_STRUCTURE TYPE STRING,
DDIC_FIELD TYPE STRING,
LABEL TYPE STRING,
TOOLTIP TYPE STRING,
UNIT TYPE STRING,
PRIM_AGGR TYPE STRING,
EXCPT_AGGR TYPE STRING,
METRIC_TYPE TYPE STRING,END OF T_EKKO_STR. DATA: WA_DB6_DBH_COLLECTOR_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_DB6_DBH_COLLECTOR_STR-COLLECTOR sy-vline
WA_DB6_DBH_COLLECTOR_STR-SNAPSHOT sy-vline
WA_DB6_DBH_COLLECTOR_STR-COLNAME sy-vline
WA_DB6_DBH_COLLECTOR_STR-COLRENAME sy-vline
WA_DB6_DBH_COLLECTOR_STR-COLTYPE sy-vline
WA_DB6_DBH_COLLECTOR_STR-COLLENGTH sy-vline
WA_DB6_DBH_COLLECTOR_STR-COLKEY sy-vline
WA_DB6_DBH_COLLECTOR_STR-DBREL sy-vline
WA_DB6_DBH_COLLECTOR_STR-DBMAX sy-vline
WA_DB6_DBH_COLLECTOR_STR-DELTA sy-vline
WA_DB6_DBH_COLLECTOR_STR-FORCE_DELTA sy-vline
WA_DB6_DBH_COLLECTOR_STR-CONV_UDF sy-vline
WA_DB6_DBH_COLLECTOR_STR-CONV_UDF_PARAM sy-vline
WA_DB6_DBH_COLLECTOR_STR-COLLECT sy-vline
WA_DB6_DBH_COLLECTOR_STR-JOINS sy-vline
WA_DB6_DBH_COLLECTOR_STR-BI sy-vline
WA_DB6_DBH_COLLECTOR_STR-BI2 sy-vline
WA_DB6_DBH_COLLECTOR_STR-BI_CONV_UDF sy-vline
WA_DB6_DBH_COLLECTOR_STR-CALCULATION sy-vline
WA_DB6_DBH_COLLECTOR_STR-DDIC_STRUCTURE sy-vline
WA_DB6_DBH_COLLECTOR_STR-DDIC_FIELD sy-vline
WA_DB6_DBH_COLLECTOR_STR-LABEL sy-vline
WA_DB6_DBH_COLLECTOR_STR-TOOLTIP sy-vline
WA_DB6_DBH_COLLECTOR_STR-UNIT sy-vline
WA_DB6_DBH_COLLECTOR_STR-PRIM_AGGR sy-vline
WA_DB6_DBH_COLLECTOR_STR-EXCPT_AGGR sy-vline
WA_DB6_DBH_COLLECTOR_STR-METRIC_TYPE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.