ABAP Select data from SAP table ARCH_CHECK_STANDARD_RESULTS 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 ARCH_CHECK_STANDARD_RESULTS 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 ARCH_CHECK_STANDARD_RESULTS. 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 ARCH_CHECK_STANDARD_RESULTS 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_ARCH_CHECK_STANDARD_RESULTS TYPE STANDARD TABLE OF ARCH_CHECK_STANDARD_RESULTS,
      WA_ARCH_CHECK_STANDARD_RESULTS TYPE ARCH_CHECK_STANDARD_RESULTS,
      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: <ARCH_CHECK_STANDARD_RESULTS> TYPE ARCH_CHECK_STANDARD_RESULTS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ARCH_CHECK_STANDARD_RESULTS
*  INTO TABLE @DATA(IT_ARCH_CHECK_STANDARD_RESULTS2).
*--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_ARCH_CHECK_STANDARD_RESULTS INDEX 1 INTO DATA(WA_ARCH_CHECK_STANDARD_RESULTS2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<ARCH_CHECK_STANDARD_RESULTS>-ARCH_OBJECT = 1.
<ARCH_CHECK_STANDARD_RESULTS>-ARCH_OBJECT_SRCSYSTEM = 1.
<ARCH_CHECK_STANDARD_RESULTS>-ARCH_OBJECT_AUTHOR = 1.
<ARCH_CHECK_STANDARD_RESULTS>-ARCH_OBJECT_TOP = 1.
<ARCH_CHECK_STANDARD_RESULTS>-ARCH_OBJECT_NEW = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ARCH_CHECK_STANDARD_RESULTS-ARCH_OBJECT_LOCAL, sy-vline,
  WA_ARCH_CHECK_STANDARD_RESULTS-ARCH_OBJECT_XML, sy-vline,
  WA_ARCH_CHECK_STANDARD_RESULTS-STANDARD_FULFILLMENT, sy-vline,
  WA_ARCH_CHECK_STANDARD_RESULTS-STANDARD_VIOLATED, sy-vline,
  WA_ARCH_CHECK_STANDARD_RESULTS-PROGRAM_ERROR, sy-vline,
  WA_ARCH_CHECK_STANDARD_RESULTS-ILM_STANDARD_VIOLATED, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_ARCH_CHECK_STANDARD_RESULTS 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_ARCH_CHECK_STANDARD_RESULTS 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_ARCH_CHECK_STANDARD_RESULTS INTO WA_ARCH_CHECK_STANDARD_RESULTS.


*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_ARCH_CHECK_STANDARD_RESULTS_STR, 
ARCH_OBJECT TYPE STRING,
ARCH_OBJECT_SRCSYSTEM TYPE STRING,
ARCH_OBJECT_AUTHOR TYPE STRING,
ARCH_OBJECT_TOP TYPE STRING,
ARCH_OBJECT_NEW TYPE STRING,
ARCH_OBJECT_LOCAL TYPE STRING,
ARCH_OBJECT_XML TYPE STRING,
STANDARD_FULFILLMENT TYPE STRING,
STANDARD_VIOLATED TYPE STRING,
PROGRAM_ERROR TYPE STRING,
ILM_STANDARD_VIOLATED TYPE STRING,
ILM_OBJECT TYPE STRING,
CUS_OBJECT_DIRECTORY_ENTRY TYPE STRING,
CUS_INTERRUPTION_SUPPORTED TYPE STRING,
CUS_DEL_VARIANTS_PROPER_IN_CUS TYPE STRING,
CUS_DEL_VARIANTS_PROPER_EXIST TYPE STRING,
CUS_DEL_VARIANTS_PROPER_RBS_OK TYPE STRING,
CUS_REL_DELTA_FILE_SUPPORTED TYPE STRING,
CUS_INDEX_OLD_NOT_USED TYPE STRING,
CUS_READ_ACCESS_EXISTS TYPE STRING,
CUS_KW_DOCU_CONNECTION TYPE STRING,
CUS_KW_DOCU_EXISTS TYPE STRING,
CUS_HINTS_TEXTS_EMPTY TYPE STRING,
CUS_MAX_FILE_SIZE TYPE STRING,
CUS_COMMIT_COUNTER TYPE STRING,
PRE_EXISTS TYPE STRING,
PRE_DELIVERABLE TYPE STRING,
PRE_SELECTION_INCL_USED TYPE STRING,
PRE_SELECTION_INCL_DDIC_FLAGS TYPE STRING,
PRE_SELECTION_GROUP_FSC_EXIST TYPE STRING,
PRE_TEXT_SYMBOLS_MAX_LENGTH_OK TYPE STRING,
WRI_EXISTS TYPE STRING,
WRI_DELIVERABLE TYPE STRING,
WRI_AOFW_WITH_COMMENT_PARAM TYPE STRING,
WRI_SELECTION_INCL_USED TYPE STRING,
WRI_SELECTION_INCL_DDIC_FLAGS TYPE STRING,
WRI_SELECTION_GROUP_FSC_EXIST TYPE STRING,
WRI_TEXT_SYMBOLS_MAX_LENGTH_OK TYPE STRING,
WRI_SEL_SCREEN_PRINT_NOT_USED TYPE STRING,
DEL_EXISTS TYPE STRING,
DEL_DELIVERABLE TYPE STRING,
DEL_SELECTION_INCL_USED TYPE STRING,
DEL_SELECTION_INCL_DDIC_FLAGS TYPE STRING,
DEL_SEL_SCREEN_PRINT_NOT_USED TYPE STRING,
END_EXISTS TYPE STRING,
END_DELIVERABLE TYPE STRING,
END_SELECTION_INCL_USED TYPE STRING,
END_SELECTION_INCL_DDIC_FLAGS TYPE STRING,
REL_EXISTS TYPE STRING,
REL_DELIVERABLE TYPE STRING,
REL_SELECTION_INCL_USED TYPE STRING,
REL_SELECTION_INCL_DDIC_FLAGS TYPE STRING,
REL_TEXT_SYMBOLS_MAX_LENGTH_OK TYPE STRING,
REL_WRITE_HANDLE_REQUESTED TYPE STRING,
PRG_PROGRAMS_DOCU_EMPTY TYPE STRING,
PRG_SEL_SCR_MODE_EQ_AOF_MODE TYPE STRING,
PRG_PROTOCOL_USED TYPE STRING,
PRG_STATISTIC_USED TYPE STRING,
PRG_PROGRESS_IND_USED TYPE STRING,
PRG_OLD_STR_REGISTRATION_USE TYPE STRING,
ARCH_OBJECT_SOFTWARE_COMPONENT TYPE STRING,
ARCH_OBJECT_DESCR_DE TYPE STRING,
ARCH_OBJECT_DESCR_EN TYPE STRING,
APPLICATION_COMPONENT TYPE STRING,
APPLICATION_COMPONENT_TEXT_EN TYPE STRING,
APPLICATION_COMPONENT_TEXT_DE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_ARCH_CHECK_STANDARD_RESULTS_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_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_SRCSYSTEM sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_AUTHOR sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_TOP sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_NEW sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_LOCAL sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_XML sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-STANDARD_FULFILLMENT sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-STANDARD_VIOLATED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PROGRAM_ERROR sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ILM_STANDARD_VIOLATED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ILM_OBJECT sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_OBJECT_DIRECTORY_ENTRY sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_INTERRUPTION_SUPPORTED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_DEL_VARIANTS_PROPER_IN_CUS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_DEL_VARIANTS_PROPER_EXIST sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_DEL_VARIANTS_PROPER_RBS_OK sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_REL_DELTA_FILE_SUPPORTED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_INDEX_OLD_NOT_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_READ_ACCESS_EXISTS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_KW_DOCU_CONNECTION sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_KW_DOCU_EXISTS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_HINTS_TEXTS_EMPTY sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_MAX_FILE_SIZE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-CUS_COMMIT_COUNTER sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRE_EXISTS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRE_DELIVERABLE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRE_SELECTION_INCL_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRE_SELECTION_INCL_DDIC_FLAGS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRE_SELECTION_GROUP_FSC_EXIST sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRE_TEXT_SYMBOLS_MAX_LENGTH_OK sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-WRI_EXISTS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-WRI_DELIVERABLE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-WRI_AOFW_WITH_COMMENT_PARAM sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-WRI_SELECTION_INCL_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-WRI_SELECTION_INCL_DDIC_FLAGS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-WRI_SELECTION_GROUP_FSC_EXIST sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-WRI_TEXT_SYMBOLS_MAX_LENGTH_OK sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-WRI_SEL_SCREEN_PRINT_NOT_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-DEL_EXISTS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-DEL_DELIVERABLE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-DEL_SELECTION_INCL_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-DEL_SELECTION_INCL_DDIC_FLAGS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-DEL_SEL_SCREEN_PRINT_NOT_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-END_EXISTS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-END_DELIVERABLE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-END_SELECTION_INCL_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-END_SELECTION_INCL_DDIC_FLAGS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-REL_EXISTS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-REL_DELIVERABLE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-REL_SELECTION_INCL_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-REL_SELECTION_INCL_DDIC_FLAGS sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-REL_TEXT_SYMBOLS_MAX_LENGTH_OK sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-REL_WRITE_HANDLE_REQUESTED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRG_PROGRAMS_DOCU_EMPTY sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRG_SEL_SCR_MODE_EQ_AOF_MODE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRG_PROTOCOL_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRG_STATISTIC_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRG_PROGRESS_IND_USED sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-PRG_OLD_STR_REGISTRATION_USE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_SOFTWARE_COMPONENT sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_DESCR_DE sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-ARCH_OBJECT_DESCR_EN sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-APPLICATION_COMPONENT sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-APPLICATION_COMPONENT_TEXT_EN sy-vline 
WA_ARCH_CHECK_STANDARD_RESULTS_STR-APPLICATION_COMPONENT_TEXT_DE sy-vline      INTO ld_text SEPARATED BY SPACE.

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