ABAP Select data from SAP table SYB_VIEW_HADR_RAT_DET 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 SYB_VIEW_HADR_RAT_DET 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 SYB_VIEW_HADR_RAT_DET. 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 SYB_VIEW_HADR_RAT_DET 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_SYB_VIEW_HADR_RAT_DET TYPE STANDARD TABLE OF SYB_VIEW_HADR_RAT_DET,
      WA_SYB_VIEW_HADR_RAT_DET TYPE SYB_VIEW_HADR_RAT_DET,
      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: <SYB_VIEW_HADR_RAT_DET> TYPE SYB_VIEW_HADR_RAT_DET.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SYB_VIEW_HADR_RAT_DET
*  INTO TABLE @DATA(IT_SYB_VIEW_HADR_RAT_DET2).
*--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_SYB_VIEW_HADR_RAT_DET INDEX 1 INTO DATA(WA_SYB_VIEW_HADR_RAT_DET2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SYB_VIEW_HADR_RAT_DET>-SCANNER_HISTORY = 1.
<SYB_VIEW_HADR_RAT_DET>-SCANNER_SUMMARY = 1.
<SYB_VIEW_HADR_RAT_DET>-INSTANCEID = 1.
<SYB_VIEW_HADR_RAT_DET>-DBID = 1.
<SYB_VIEW_HADR_RAT_DET>-DBNAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SYB_VIEW_HADR_RAT_DET-SCANNERSPID, sy-vline,
  WA_SYB_VIEW_HADR_RAT_DET-PATHNAME, sy-vline,
  WA_SYB_VIEW_HADR_RAT_DET-ENGINEBINDING, sy-vline,
  WA_SYB_VIEW_HADR_RAT_DET-LOGRECORDSSCANNED, sy-vline,
  WA_SYB_VIEW_HADR_RAT_DET-LOGRECORDSPROCESSED, sy-vline,
  WA_SYB_VIEW_HADR_RAT_DET-TRUNCPOINTREQUESTS, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SYB_VIEW_HADR_RAT_DET 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_SYB_VIEW_HADR_RAT_DET 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_SYB_VIEW_HADR_RAT_DET INTO WA_SYB_VIEW_HADR_RAT_DET.


*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_SYB_VIEW_HADR_RAT_DET_STR, 
SCANNER_HISTORY TYPE STRING,
SCANNER_SUMMARY TYPE STRING,
INSTANCEID TYPE STRING,
DBID TYPE STRING,
DBNAME TYPE STRING,
SCANNERSPID TYPE STRING,
PATHNAME TYPE STRING,
ENGINEBINDING TYPE STRING,
LOGRECORDSSCANNED TYPE STRING,
LOGRECORDSPROCESSED TYPE STRING,
TRUNCPOINTREQUESTS TYPE STRING,
TRUNCPOINTMOVES TYPE STRING,
STATUS TYPE STRING,
SLEEPSTATUS TYPE STRING,
STARTMARKER TYPE STRING,
ENDMARKER TYPE STRING,
CURRENTMARKER TYPE STRING,
OLDESTTRANSACTION TYPE STRING,
LOGSCANS TYPE STRING,
UPDATES TYPE STRING,
INSERTS TYPE STRING,
DELETES TYPE STRING,
STOREDPROCEDURES TYPE STRING,
SQLSTATEMENTS TYPE STRING,
DDL TYPE STRING,
WRITETXT TYPE STRING,
LOBCOLUMNS TYPE STRING,
CLRS TYPE STRING,
CHECKPOINTS TYPE STRING,
BEGINTRANSACTION TYPE STRING,
COMMITTRANSACTION TYPE STRING,
ABORTEDTRANSACTION TYPE STRING,
PREPAREDTRANSACTION TYPE STRING,
DELAYEDCOMMIT TYPE STRING,
MAINTUSERTRANSACTION TYPE STRING,
LOGEXTENTIONS TYPE STRING,
SCHEMAFWDLOOKUPS TYPE STRING,
SCHEMABCKWLOOKUPS TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
TIMESTAMP_FROM TYPE STRING,
TIMESTAMP_TO TYPE STRING,
TIME_PERIOD TYPE STRING,
ABORTCOMMAND TYPE STRING,
PARTIALROLLBACK TYPE STRING,
SAVETRANSACTION TYPE STRING,
CACHEDBEFOREIMAGEUSED TYPE STRING,
SENDER_HISTORY TYPE STRING,
SENDER_SUMMARY TYPE STRING,
INSTANCEID TYPE STRING,
DBID TYPE STRING,
DBNAME TYPE STRING,
SENDERSPID TYPE STRING,
SCANNERSPID TYPE STRING,
DATASERVER TYPE STRING,
REPLICATIONSERVER TYPE STRING,
USERNAME TYPE STRING,
STATUS TYPE STRING,
SLEEPSTATUS TYPE STRING,
PATHNAME TYPE STRING,
ENGINEBINDING TYPE STRING,
MESSAGEQUEUESIZE TYPE STRING,
MESSAGESINQUEUE TYPE STRING,
SCANNERYIELDS TYPE STRING,
SCANNERSLEEPS TYPE STRING,
MB_SENT TYPE STRING,
AVGBYTESPERCMD TYPE STRING,
LASTREPSERVERERROR TYPE STRING,
RETRIES TYPE STRING,
EMPTYQUEUE_SLEEPS TYPE STRING,
EMPTYQUEUE_SLEEPTIME TYPE STRING,
EMPTYQUEUE_MAXSLEEPTIME TYPE STRING,
QUEUEFLUSHES TYPE STRING,
MAXQUEUESIZE TYPE STRING,
CMDSPROCESSED TYPE STRING,
SNAPSHOT_TIMESTAMP TYPE STRING,
TIMESTAMP_FROM TYPE STRING,
TIMESTAMP_TO TYPE STRING,
TIME_PERIOD TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SYB_VIEW_HADR_RAT_DET_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_SYB_VIEW_HADR_RAT_DET_STR-SCANNER_HISTORY sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SCANNER_SUMMARY sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-INSTANCEID sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-DBID sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-DBNAME sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SCANNERSPID sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-PATHNAME sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-ENGINEBINDING sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-LOGRECORDSSCANNED sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-LOGRECORDSPROCESSED sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-TRUNCPOINTREQUESTS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-TRUNCPOINTMOVES sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-STATUS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SLEEPSTATUS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-STARTMARKER sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-ENDMARKER sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-CURRENTMARKER sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-OLDESTTRANSACTION sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-LOGSCANS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-UPDATES sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-INSERTS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-DELETES sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-STOREDPROCEDURES sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SQLSTATEMENTS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-DDL sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-WRITETXT sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-LOBCOLUMNS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-CLRS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-CHECKPOINTS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-BEGINTRANSACTION sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-COMMITTRANSACTION sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-ABORTEDTRANSACTION sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-PREPAREDTRANSACTION sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-DELAYEDCOMMIT sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-MAINTUSERTRANSACTION sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-LOGEXTENTIONS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SCHEMAFWDLOOKUPS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SCHEMABCKWLOOKUPS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SNAPSHOT_TIMESTAMP sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-TIMESTAMP_FROM sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-TIMESTAMP_TO sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-TIME_PERIOD sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-ABORTCOMMAND sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-PARTIALROLLBACK sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SAVETRANSACTION sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-CACHEDBEFOREIMAGEUSED sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SENDER_HISTORY sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SENDER_SUMMARY sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-INSTANCEID sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-DBID sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-DBNAME sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SENDERSPID sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SCANNERSPID sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-DATASERVER sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-REPLICATIONSERVER sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-USERNAME sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-STATUS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SLEEPSTATUS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-PATHNAME sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-ENGINEBINDING sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-MESSAGEQUEUESIZE sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-MESSAGESINQUEUE sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SCANNERYIELDS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SCANNERSLEEPS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-MB_SENT sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-AVGBYTESPERCMD sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-LASTREPSERVERERROR sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-RETRIES sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-EMPTYQUEUE_SLEEPS sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-EMPTYQUEUE_SLEEPTIME sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-EMPTYQUEUE_MAXSLEEPTIME sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-QUEUEFLUSHES sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-MAXQUEUESIZE sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-CMDSPROCESSED sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-SNAPSHOT_TIMESTAMP sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-TIMESTAMP_FROM sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-TIMESTAMP_TO sy-vline 
WA_SYB_VIEW_HADR_RAT_DET_STR-TIME_PERIOD sy-vline      INTO ld_text SEPARATED BY SPACE.

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