ABAP Select data from SAP table CCRCS_CHK_RESULT 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 CCRCS_CHK_RESULT 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 CCRCS_CHK_RESULT. 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 CCRCS_CHK_RESULT 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_CCRCS_CHK_RESULT TYPE STANDARD TABLE OF CCRCS_CHK_RESULT,
      WA_CCRCS_CHK_RESULT TYPE CCRCS_CHK_RESULT,
      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: <CCRCS_CHK_RESULT> TYPE CCRCS_CHK_RESULT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CCRCS_CHK_RESULT
*  INTO TABLE @DATA(IT_CCRCS_CHK_RESULT2).
*--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_CCRCS_CHK_RESULT INDEX 1 INTO DATA(WA_CCRCS_CHK_RESULT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CCRCS_CHK_RESULT>-REG = 1.
<CCRCS_CHK_RESULT>-TYEAR = 1.
<CCRCS_CHK_RESULT>-PLANT = 1.
<CCRCS_CHK_RESULT>-MATNR = 1.
<CCRCS_CHK_RESULT>-SUBID = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CCRCS_CHK_RESULT-TRACK_SUBST, sy-vline,
  WA_CCRCS_CHK_RESULT-CRDAT, sy-vline,
  WA_CCRCS_CHK_RESULT-PERIOD, sy-vline,
  WA_CCRCS_CHK_RESULT-OBJECT, sy-vline,
  WA_CCRCS_CHK_RESULT-ATTRIB, sy-vline,
  WA_CCRCS_CHK_RESULT-VALUE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CCRCS_CHK_RESULT 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_CCRCS_CHK_RESULT 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_CCRCS_CHK_RESULT INTO WA_CCRCS_CHK_RESULT.


*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.

*Conversion exit MATN1, internal->external for field MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SPEC1, internal->external for field SUBID
CALL FUNCTION 'CONVERSION_EXIT_SPEC1_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-SUBID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-SUBID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SPEC1, internal->external for field TRACK_SUBST
CALL FUNCTION 'CONVERSION_EXIT_SPEC1_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-TRACK_SUBST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-TRACK_SUBST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field COMPUOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-COMPUOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-COMPUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field UOM_LIMIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-UOM_LIMIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-UOM_LIMIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field VBELN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-VBELN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-VBELN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field EBELN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-EBELN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-EBELN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AUFNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-AUFNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-AUFNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field BANFN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-BANFN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-BANFN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field RECN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CCRCS_CHK_RESULT-RECN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCRCS_CHK_RESULT-RECN.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

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

TYPES: BEGIN OF T_CCRCS_CHK_RESULT_STR, 
REG TYPE STRING,
TYEAR TYPE STRING,
PLANT TYPE STRING,
MATNR TYPE STRING,
SUBID TYPE STRING,
TRACK_SUBST TYPE STRING,
CRDAT TYPE STRING,
PERIOD TYPE STRING,
OBJECT TYPE STRING,
ATTRIB TYPE STRING,
VALUE TYPE STRING,
AMOUNT TYPE STRING,
UOM TYPE STRING,
COMPAVG TYPE STRING,
COMPUOM TYPE STRING,
BUKRS TYPE STRING,
CHARG TYPE STRING,
POS TYPE STRING,
DOCCAT TYPE STRING,
REL_LIMIT TYPE STRING,
MSGTYPE TYPE STRING,
REG_LEVEL TYPE STRING,
FLG_DISP TYPE STRING,
FLG_MAIL TYPE STRING,
FLG_BLOCK TYPE STRING,
AMOUNT_LIMIT TYPE STRING,
UOM_LIMIT TYPE STRING,
LIMITB TYPE STRING,
LIMITB_L TYPE STRING,
FLG_RESET TYPE STRING,
FLG_UNLOCK TYPE STRING,
FLG_EXP TYPE STRING,
FLG_IMP TYPE STRING,
CNTRY_O TYPE STRING,
CNTRY_R TYPE STRING,
ETENR TYPE STRING,
SCEN TYPE STRING,
DOCTYPE TYPE STRING,
FLG_PLAN TYPE STRING,
FLG_HIST TYPE STRING,
FLG_ERROR TYPE STRING,
TABNAME TYPE STRING,
VBELN TYPE STRING,
POSNR_VA TYPE STRING,
EBELN TYPE STRING,
EBELP TYPE STRING,
AUFNR TYPE STRING,
CO_POSNR TYPE STRING,
BANFN TYPE STRING,
BNFPO TYPE STRING,
SUBSEC TYPE STRING,
FLG_SUBID_FAIL TYPE STRING,
REG_STATUS TYPE STRING,
FLG_STATUS_BUKRS_DEP TYPE STRING,
FLG_SLIMIT_BUKRS_DEP TYPE STRING,
FLG_SLIMIT_EXIST TYPE STRING,
AMOUNT_SUM TYPE STRING,
REG_DATE TYPE STRING,
REG_FREQUENT TYPE STRING,
EINDT TYPE STRING,
VDATU TYPE STRING,
DATE TYPE STRING,
OR_INT TYPE STRING,
OR_EXT TYPE STRING,
OR_ADDR_CAT TYPE STRING,
RECN TYPE STRING,
FLG_POLYIND TYPE STRING,
REG_DATEE TYPE STRING,
REG_TYPE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CCRCS_CHK_RESULT_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_CCRCS_CHK_RESULT_STR-REG sy-vline 
WA_CCRCS_CHK_RESULT_STR-TYEAR sy-vline 
WA_CCRCS_CHK_RESULT_STR-PLANT sy-vline 
WA_CCRCS_CHK_RESULT_STR-MATNR sy-vline 
WA_CCRCS_CHK_RESULT_STR-SUBID sy-vline 
WA_CCRCS_CHK_RESULT_STR-TRACK_SUBST sy-vline 
WA_CCRCS_CHK_RESULT_STR-CRDAT sy-vline 
WA_CCRCS_CHK_RESULT_STR-PERIOD sy-vline 
WA_CCRCS_CHK_RESULT_STR-OBJECT sy-vline 
WA_CCRCS_CHK_RESULT_STR-ATTRIB sy-vline 
WA_CCRCS_CHK_RESULT_STR-VALUE sy-vline 
WA_CCRCS_CHK_RESULT_STR-AMOUNT sy-vline 
WA_CCRCS_CHK_RESULT_STR-UOM sy-vline 
WA_CCRCS_CHK_RESULT_STR-COMPAVG sy-vline 
WA_CCRCS_CHK_RESULT_STR-COMPUOM sy-vline 
WA_CCRCS_CHK_RESULT_STR-BUKRS sy-vline 
WA_CCRCS_CHK_RESULT_STR-CHARG sy-vline 
WA_CCRCS_CHK_RESULT_STR-POS sy-vline 
WA_CCRCS_CHK_RESULT_STR-DOCCAT sy-vline 
WA_CCRCS_CHK_RESULT_STR-REL_LIMIT sy-vline 
WA_CCRCS_CHK_RESULT_STR-MSGTYPE sy-vline 
WA_CCRCS_CHK_RESULT_STR-REG_LEVEL sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_DISP sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_MAIL sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_BLOCK sy-vline 
WA_CCRCS_CHK_RESULT_STR-AMOUNT_LIMIT sy-vline 
WA_CCRCS_CHK_RESULT_STR-UOM_LIMIT sy-vline 
WA_CCRCS_CHK_RESULT_STR-LIMITB sy-vline 
WA_CCRCS_CHK_RESULT_STR-LIMITB_L sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_RESET sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_UNLOCK sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_EXP sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_IMP sy-vline 
WA_CCRCS_CHK_RESULT_STR-CNTRY_O sy-vline 
WA_CCRCS_CHK_RESULT_STR-CNTRY_R sy-vline 
WA_CCRCS_CHK_RESULT_STR-ETENR sy-vline 
WA_CCRCS_CHK_RESULT_STR-SCEN sy-vline 
WA_CCRCS_CHK_RESULT_STR-DOCTYPE sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_PLAN sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_HIST sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_ERROR sy-vline 
WA_CCRCS_CHK_RESULT_STR-TABNAME sy-vline 
WA_CCRCS_CHK_RESULT_STR-VBELN sy-vline 
WA_CCRCS_CHK_RESULT_STR-POSNR_VA sy-vline 
WA_CCRCS_CHK_RESULT_STR-EBELN sy-vline 
WA_CCRCS_CHK_RESULT_STR-EBELP sy-vline 
WA_CCRCS_CHK_RESULT_STR-AUFNR sy-vline 
WA_CCRCS_CHK_RESULT_STR-CO_POSNR sy-vline 
WA_CCRCS_CHK_RESULT_STR-BANFN sy-vline 
WA_CCRCS_CHK_RESULT_STR-BNFPO sy-vline 
WA_CCRCS_CHK_RESULT_STR-SUBSEC sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_SUBID_FAIL sy-vline 
WA_CCRCS_CHK_RESULT_STR-REG_STATUS sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_STATUS_BUKRS_DEP sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_SLIMIT_BUKRS_DEP sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_SLIMIT_EXIST sy-vline 
WA_CCRCS_CHK_RESULT_STR-AMOUNT_SUM sy-vline 
WA_CCRCS_CHK_RESULT_STR-REG_DATE sy-vline 
WA_CCRCS_CHK_RESULT_STR-REG_FREQUENT sy-vline 
WA_CCRCS_CHK_RESULT_STR-EINDT sy-vline 
WA_CCRCS_CHK_RESULT_STR-VDATU sy-vline 
WA_CCRCS_CHK_RESULT_STR-DATE sy-vline 
WA_CCRCS_CHK_RESULT_STR-OR_INT sy-vline 
WA_CCRCS_CHK_RESULT_STR-OR_EXT sy-vline 
WA_CCRCS_CHK_RESULT_STR-OR_ADDR_CAT sy-vline 
WA_CCRCS_CHK_RESULT_STR-RECN sy-vline 
WA_CCRCS_CHK_RESULT_STR-FLG_POLYIND sy-vline 
WA_CCRCS_CHK_RESULT_STR-REG_DATEE sy-vline 
WA_CCRCS_CHK_RESULT_STR-REG_TYPE sy-vline      INTO ld_text SEPARATED BY SPACE.

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