ABAP Select data from SAP table HRPAYRU_S_CIA_HWC_V3 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 HRPAYRU_S_CIA_HWC_V3 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 HRPAYRU_S_CIA_HWC_V3. 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 HRPAYRU_S_CIA_HWC_V3 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_HRPAYRU_S_CIA_HWC_V3 TYPE STANDARD TABLE OF HRPAYRU_S_CIA_HWC_V3,
      WA_HRPAYRU_S_CIA_HWC_V3 TYPE HRPAYRU_S_CIA_HWC_V3,
      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: <HRPAYRU_S_CIA_HWC_V3> TYPE HRPAYRU_S_CIA_HWC_V3.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM HRPAYRU_S_CIA_HWC_V3
*  INTO TABLE @DATA(IT_HRPAYRU_S_CIA_HWC_V32).
*--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_HRPAYRU_S_CIA_HWC_V3 INDEX 1 INTO DATA(WA_HRPAYRU_S_CIA_HWC_V32).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<HRPAYRU_S_CIA_HWC_V3>-HWCRS = 1.
<HRPAYRU_S_CIA_HWC_V3>-HWCF1 = 1.
<HRPAYRU_S_CIA_HWC_V3>-KBK1C = 1.
<HRPAYRU_S_CIA_HWC_V3>-HWCF2 = 1.
<HRPAYRU_S_CIA_HWC_V3>-KBK2C = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_HRPAYRU_S_CIA_HWC_V3-T2011, sy-vline,
  WA_HRPAYRU_S_CIA_HWC_V3-T2013, sy-vline,
  WA_HRPAYRU_S_CIA_HWC_V3-T2015, sy-vline,
  WA_HRPAYRU_S_CIA_HWC_V3-T2017, sy-vline,
  WA_HRPAYRU_S_CIA_HWC_V3-T201A, sy-vline,
  WA_HRPAYRU_S_CIA_HWC_V3-ADTFL, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_HRPAYRU_S_CIA_HWC_V3 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_HRPAYRU_S_CIA_HWC_V3 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_HRPAYRU_S_CIA_HWC_V3 INTO WA_HRPAYRU_S_CIA_HWC_V3.


*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_HRPAYRU_S_CIA_HWC_V3_STR, 
HWCRS TYPE STRING,
HWCF1 TYPE STRING,
KBK1C TYPE STRING,
HWCF2 TYPE STRING,
KBK2C TYPE STRING,
T2011 TYPE STRING,
T2013 TYPE STRING,
T2015 TYPE STRING,
T2017 TYPE STRING,
T201A TYPE STRING,
ADTFL TYPE STRING,
KBFLC TYPE STRING,
T201C TYPE STRING,
ADTCO TYPE STRING,
KBCOA TYPE STRING,
T2021 TYPE STRING,
T2023 TYPE STRING,
T2025 TYPE STRING,
T2027 TYPE STRING,
T2029 TYPE STRING,
ADTR1 TYPE STRING,
KBPF1 TYPE STRING,
T2031 TYPE STRING,
T2033 TYPE STRING,
T2035 TYPE STRING,
T2037 TYPE STRING,
T2039 TYPE STRING,
ADT14 TYPE STRING,
T2041 TYPE STRING,
T2043 TYPE STRING,
T2045 TYPE STRING,
T2047 TYPE STRING,
T2049 TYPE STRING,
AD134 TYPE STRING,
T2051 TYPE STRING,
T2053 TYPE STRING,
T2055 TYPE STRING,
T2057 TYPE STRING,
T2059 TYPE STRING,
AD133 TYPE STRING,
T2061 TYPE STRING,
T2063 TYPE STRING,
T2065 TYPE STRING,
T2067 TYPE STRING,
T2069 TYPE STRING,
AD132 TYPE STRING,
T2071 TYPE STRING,
T2073 TYPE STRING,
T2075 TYPE STRING,
T2077 TYPE STRING,
T2079 TYPE STRING,
AD131 TYPE STRING,
T2081 TYPE STRING,
T2083 TYPE STRING,
T2085 TYPE STRING,
T2087 TYPE STRING,
T2089 TYPE STRING,
ADTR2 TYPE STRING,
KBPF2 TYPE STRING,
T2091 TYPE STRING,
T2093 TYPE STRING,
T2095 TYPE STRING,
T2097 TYPE STRING,
T2099 TYPE STRING,
ADT24 TYPE STRING,
T2101 TYPE STRING,
T2103 TYPE STRING,
T2105 TYPE STRING,
T2107 TYPE STRING,
T2109 TYPE STRING,
AD234 TYPE STRING,
T2111 TYPE STRING,
T2113 TYPE STRING,
T2115 TYPE STRING,
T2117 TYPE STRING,
T2119 TYPE STRING,
AD233 TYPE STRING,
T2121 TYPE STRING,
T2123 TYPE STRING,
T2125 TYPE STRING,
T2127 TYPE STRING,
T2129 TYPE STRING,
AD232 TYPE STRING,
T2131 TYPE STRING,
T2133 TYPE STRING,
T2135 TYPE STRING,
T2137 TYPE STRING,
T2139 TYPE STRING,
AD231 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_HRPAYRU_S_CIA_HWC_V3_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_HRPAYRU_S_CIA_HWC_V3_STR-HWCRS sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-HWCF1 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-KBK1C sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-HWCF2 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-KBK2C sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2011 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2013 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2015 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2017 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T201A sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-ADTFL sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-KBFLC sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T201C sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-ADTCO sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-KBCOA sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2021 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2023 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2025 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2027 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2029 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-ADTR1 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-KBPF1 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2031 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2033 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2035 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2037 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2039 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-ADT14 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2041 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2043 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2045 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2047 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2049 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-AD134 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2051 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2053 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2055 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2057 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2059 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-AD133 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2061 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2063 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2065 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2067 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2069 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-AD132 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2071 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2073 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2075 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2077 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2079 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-AD131 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2081 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2083 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2085 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2087 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2089 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-ADTR2 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-KBPF2 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2091 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2093 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2095 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2097 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2099 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-ADT24 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2101 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2103 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2105 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2107 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2109 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-AD234 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2111 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2113 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2115 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2117 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2119 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-AD233 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2121 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2123 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2125 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2127 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2129 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-AD232 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2131 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2133 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2135 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2137 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-T2139 sy-vline 
WA_HRPAYRU_S_CIA_HWC_V3_STR-AD231 sy-vline      INTO ld_text SEPARATED BY SPACE.

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