ABAP Select data from SAP table DB6DBSNAP 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 DB6DBSNAP 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 DB6DBSNAP. 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 DB6DBSNAP 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_DB6DBSNAP TYPE STANDARD TABLE OF DB6DBSNAP,
      WA_DB6DBSNAP TYPE DB6DBSNAP,
      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: <DB6DBSNAP> TYPE DB6DBSNAP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DB6DBSNAP
*  INTO TABLE @DATA(IT_DB6DBSNAP2).
*--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_DB6DBSNAP INDEX 1 INTO DATA(WA_DB6DBSNAP2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<DB6DBSNAP>-DBPATH = 1.
<DB6DBSNAP>-DBALIAS = 1.
<DB6DBSNAP>-DBNAME = 1.
<DB6DBSNAP>-LOCKSHELD = 1.
<DB6DBSNAP>-LOCKWAITS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DB6DBSNAP-WAITTIME, sy-vline,
  WA_DB6DBSNAP-LISTINUSE, sy-vline,
  WA_DB6DBSNAP-DEADLOCKS, sy-vline,
  WA_DB6DBSNAP-LOCKESC, sy-vline,
  WA_DB6DBSNAP-XLOCKESC, sy-vline,
  WA_DB6DBSNAP-LOCKSWAITG, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_DB6DBSNAP 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_DB6DBSNAP 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_DB6DBSNAP INTO WA_DB6DBSNAP.


*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_DB6DBSNAP_STR, 
DBPATH TYPE STRING,
DBALIAS TYPE STRING,
DBNAME TYPE STRING,
LOCKSHELD TYPE STRING,
LOCKWAITS TYPE STRING,
WAITTIME TYPE STRING,
LISTINUSE TYPE STRING,
DEADLOCKS TYPE STRING,
LOCKESC TYPE STRING,
XLOCKESC TYPE STRING,
LOCKSWAITG TYPE STRING,
HEAP TYPE STRING,
SORTS TYPE STRING,
SORTTIME TYPE STRING,
OVERFLOWS TYPE STRING,
ACTIVESORT TYPE STRING,
LREADS TYPE STRING,
PREADS TYPE STRING,
WRITES TYPE STRING,
ILREADS TYPE STRING,
IPREADS TYPE STRING,
IWRITES TYPE STRING,
READTIME TYPE STRING,
WRITETIME TYPE STRING,
CLOSEDFILE TYPE STRING,
COMMITS TYPE STRING,
ROLLBACKS TYPE STRING,
DYNAMICSQL TYPE STRING,
STATICSQL TYPE STRING,
FAILEDSQL TYPE STRING,
SELSQL TYPE STRING,
DDLSQL TYPE STRING,
UIDSQL TYPE STRING,
INTREBINDS TYPE STRING,
INTROWSDEL TYPE STRING,
INTROWSUPD TYPE STRING,
INTROWSINS TYPE STRING,
INTCOMMIT TYPE STRING,
INTROLL TYPE STRING,
INTDROLL TYPE STRING,
ROWSDEL TYPE STRING,
ROWSINS TYPE STRING,
ROWSUPD TYPE STRING,
ROWSSEL TYPE STRING,
BINDPRECOM TYPE STRING,
DBCONNTIME TYPE STRING,
LASTRESET TYPE STRING,
LASTBACKUP TYPE STRING,
TOTALCONS TYPE STRING,
APPLCONS TYPE STRING,
APPLINDB2 TYPE STRING,
DBSTATUS TYPE STRING,
LOCKTMOUT TYPE STRING,
CONNTOP TYPE STRING,
DBHEAPTOP TYPE STRING,
PADREADS TYPE STRING,
PADWRITES TYPE STRING,
PAIWRITES TYPE STRING,
PARTIME TYPE STRING,
PAWTIME TYPE STRING,
PADRREQS TYPE STRING,
PLSNAGPCLN TYPE STRING,
PDPGSCLN TYPE STRING,
PDPGTCLN TYPE STRING,
DIRREADS TYPE STRING,
DIRWRITES TYPE STRING,
DIRRREQS TYPE STRING,
DIRWREQS TYPE STRING,
DIRRTIME TYPE STRING,
DIRWTIME TYPE STRING,
LOGREADS TYPE STRING,
LOGWRITS TYPE STRING,
PKGCLOOKUP TYPE STRING,
PKGCINSERT TYPE STRING,
CATCLOOKUP TYPE STRING,
CATCINSERT TYPE STRING,
CATCOFLOWS TYPE STRING,
CATCHEAPF TYPE STRING,
PAIREADS TYPE STRING,
SECLOGUTOP TYPE STRING,
TOTLOGUTOP TYPE STRING,
SECLOGALLO TYPE STRING,
PDAT2ESTOR TYPE STRING,
PIDX2ESTOR TYPE STRING,
DATESTOR2P TYPE STRING,
IDXESTOR2P TYPE STRING,
PREWAITTM TYPE STRING,
CATNODE TYPE STRING,
TOTSECCONS TYPE STRING,
NUMASSOCAG TYPE STRING,
AGENTSTOP TYPE STRING,
CAGENTSTOP TYPE STRING,
SERVER_OS TYPE STRING,
CATNODENAM TYPE STRING,
APPSECLOOK TYPE STRING,
APPSECINS TYPE STRING,
BUFFPAGE TYPE STRING,
LOCKLIST TYPE STRING,
SORTHEAP TYPE STRING,
CATCACHESZ TYPE STRING,
PCKCACHESZ TYPE STRING,
NUMIOCLNS TYPE STRING,
NUMIOSRVS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_DB6DBSNAP_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_DB6DBSNAP_STR-DBPATH sy-vline 
WA_DB6DBSNAP_STR-DBALIAS sy-vline 
WA_DB6DBSNAP_STR-DBNAME sy-vline 
WA_DB6DBSNAP_STR-LOCKSHELD sy-vline 
WA_DB6DBSNAP_STR-LOCKWAITS sy-vline 
WA_DB6DBSNAP_STR-WAITTIME sy-vline 
WA_DB6DBSNAP_STR-LISTINUSE sy-vline 
WA_DB6DBSNAP_STR-DEADLOCKS sy-vline 
WA_DB6DBSNAP_STR-LOCKESC sy-vline 
WA_DB6DBSNAP_STR-XLOCKESC sy-vline 
WA_DB6DBSNAP_STR-LOCKSWAITG sy-vline 
WA_DB6DBSNAP_STR-HEAP sy-vline 
WA_DB6DBSNAP_STR-SORTS sy-vline 
WA_DB6DBSNAP_STR-SORTTIME sy-vline 
WA_DB6DBSNAP_STR-OVERFLOWS sy-vline 
WA_DB6DBSNAP_STR-ACTIVESORT sy-vline 
WA_DB6DBSNAP_STR-LREADS sy-vline 
WA_DB6DBSNAP_STR-PREADS sy-vline 
WA_DB6DBSNAP_STR-WRITES sy-vline 
WA_DB6DBSNAP_STR-ILREADS sy-vline 
WA_DB6DBSNAP_STR-IPREADS sy-vline 
WA_DB6DBSNAP_STR-IWRITES sy-vline 
WA_DB6DBSNAP_STR-READTIME sy-vline 
WA_DB6DBSNAP_STR-WRITETIME sy-vline 
WA_DB6DBSNAP_STR-CLOSEDFILE sy-vline 
WA_DB6DBSNAP_STR-COMMITS sy-vline 
WA_DB6DBSNAP_STR-ROLLBACKS sy-vline 
WA_DB6DBSNAP_STR-DYNAMICSQL sy-vline 
WA_DB6DBSNAP_STR-STATICSQL sy-vline 
WA_DB6DBSNAP_STR-FAILEDSQL sy-vline 
WA_DB6DBSNAP_STR-SELSQL sy-vline 
WA_DB6DBSNAP_STR-DDLSQL sy-vline 
WA_DB6DBSNAP_STR-UIDSQL sy-vline 
WA_DB6DBSNAP_STR-INTREBINDS sy-vline 
WA_DB6DBSNAP_STR-INTROWSDEL sy-vline 
WA_DB6DBSNAP_STR-INTROWSUPD sy-vline 
WA_DB6DBSNAP_STR-INTROWSINS sy-vline 
WA_DB6DBSNAP_STR-INTCOMMIT sy-vline 
WA_DB6DBSNAP_STR-INTROLL sy-vline 
WA_DB6DBSNAP_STR-INTDROLL sy-vline 
WA_DB6DBSNAP_STR-ROWSDEL sy-vline 
WA_DB6DBSNAP_STR-ROWSINS sy-vline 
WA_DB6DBSNAP_STR-ROWSUPD sy-vline 
WA_DB6DBSNAP_STR-ROWSSEL sy-vline 
WA_DB6DBSNAP_STR-BINDPRECOM sy-vline 
WA_DB6DBSNAP_STR-DBCONNTIME sy-vline 
WA_DB6DBSNAP_STR-LASTRESET sy-vline 
WA_DB6DBSNAP_STR-LASTBACKUP sy-vline 
WA_DB6DBSNAP_STR-TOTALCONS sy-vline 
WA_DB6DBSNAP_STR-APPLCONS sy-vline 
WA_DB6DBSNAP_STR-APPLINDB2 sy-vline 
WA_DB6DBSNAP_STR-DBSTATUS sy-vline 
WA_DB6DBSNAP_STR-LOCKTMOUT sy-vline 
WA_DB6DBSNAP_STR-CONNTOP sy-vline 
WA_DB6DBSNAP_STR-DBHEAPTOP sy-vline 
WA_DB6DBSNAP_STR-PADREADS sy-vline 
WA_DB6DBSNAP_STR-PADWRITES sy-vline 
WA_DB6DBSNAP_STR-PAIWRITES sy-vline 
WA_DB6DBSNAP_STR-PARTIME sy-vline 
WA_DB6DBSNAP_STR-PAWTIME sy-vline 
WA_DB6DBSNAP_STR-PADRREQS sy-vline 
WA_DB6DBSNAP_STR-PLSNAGPCLN sy-vline 
WA_DB6DBSNAP_STR-PDPGSCLN sy-vline 
WA_DB6DBSNAP_STR-PDPGTCLN sy-vline 
WA_DB6DBSNAP_STR-DIRREADS sy-vline 
WA_DB6DBSNAP_STR-DIRWRITES sy-vline 
WA_DB6DBSNAP_STR-DIRRREQS sy-vline 
WA_DB6DBSNAP_STR-DIRWREQS sy-vline 
WA_DB6DBSNAP_STR-DIRRTIME sy-vline 
WA_DB6DBSNAP_STR-DIRWTIME sy-vline 
WA_DB6DBSNAP_STR-LOGREADS sy-vline 
WA_DB6DBSNAP_STR-LOGWRITS sy-vline 
WA_DB6DBSNAP_STR-PKGCLOOKUP sy-vline 
WA_DB6DBSNAP_STR-PKGCINSERT sy-vline 
WA_DB6DBSNAP_STR-CATCLOOKUP sy-vline 
WA_DB6DBSNAP_STR-CATCINSERT sy-vline 
WA_DB6DBSNAP_STR-CATCOFLOWS sy-vline 
WA_DB6DBSNAP_STR-CATCHEAPF sy-vline 
WA_DB6DBSNAP_STR-PAIREADS sy-vline 
WA_DB6DBSNAP_STR-SECLOGUTOP sy-vline 
WA_DB6DBSNAP_STR-TOTLOGUTOP sy-vline 
WA_DB6DBSNAP_STR-SECLOGALLO sy-vline 
WA_DB6DBSNAP_STR-PDAT2ESTOR sy-vline 
WA_DB6DBSNAP_STR-PIDX2ESTOR sy-vline 
WA_DB6DBSNAP_STR-DATESTOR2P sy-vline 
WA_DB6DBSNAP_STR-IDXESTOR2P sy-vline 
WA_DB6DBSNAP_STR-PREWAITTM sy-vline 
WA_DB6DBSNAP_STR-CATNODE sy-vline 
WA_DB6DBSNAP_STR-TOTSECCONS sy-vline 
WA_DB6DBSNAP_STR-NUMASSOCAG sy-vline 
WA_DB6DBSNAP_STR-AGENTSTOP sy-vline 
WA_DB6DBSNAP_STR-CAGENTSTOP sy-vline 
WA_DB6DBSNAP_STR-SERVER_OS sy-vline 
WA_DB6DBSNAP_STR-CATNODENAM sy-vline 
WA_DB6DBSNAP_STR-APPSECLOOK sy-vline 
WA_DB6DBSNAP_STR-APPSECINS sy-vline 
WA_DB6DBSNAP_STR-BUFFPAGE sy-vline 
WA_DB6DBSNAP_STR-LOCKLIST sy-vline 
WA_DB6DBSNAP_STR-SORTHEAP sy-vline 
WA_DB6DBSNAP_STR-CATCACHESZ sy-vline 
WA_DB6DBSNAP_STR-PCKCACHESZ sy-vline 
WA_DB6DBSNAP_STR-NUMIOCLNS sy-vline 
WA_DB6DBSNAP_STR-NUMIOSRVS sy-vline      INTO ld_text SEPARATED BY SPACE.

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