ABAP Select data from SAP table HRDEBW_DBEK_V1 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 HRDEBW_DBEK_V1 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 HRDEBW_DBEK_V1. 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 HRDEBW_DBEK_V1 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_HRDEBW_DBEK_V1 TYPE STANDARD TABLE OF HRDEBW_DBEK_V1,
      WA_HRDEBW_DBEK_V1 TYPE HRDEBW_DBEK_V1,
      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: <HRDEBW_DBEK_V1> TYPE HRDEBW_DBEK_V1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM HRDEBW_DBEK_V1
*  INTO TABLE @DATA(IT_HRDEBW_DBEK_V12).
*--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_HRDEBW_DBEK_V1 INDEX 1 INTO DATA(WA_HRDEBW_DBEK_V12).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<HRDEBW_DBEK_V1>-KENNG = 1.
<HRDEBW_DBEK_V1>-KNZST = 1.
<HRDEBW_DBEK_V1>-WAERS = 1.
<HRDEBW_DBEK_V1>-NAMEK = 1.
<HRDEBW_DBEK_V1>-VNAMK = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_HRDEBW_DBEK_V1-GBDAT, sy-vline,
  WA_HRDEBW_DBEK_V1-FLEDT, sy-vline,
  WA_HRDEBW_DBEK_V1-KISTA, sy-vline,
  WA_HRDEBW_DBEK_V1-STRKL, sy-vline,
  WA_HRDEBW_DBEK_V1-FRB1M, sy-vline,
  WA_HRDEBW_DBEK_V1-FRBDT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_HRDEBW_DBEK_V1 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_HRDEBW_DBEK_V1 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_HRDEBW_DBEK_V1 INTO WA_HRDEBW_DBEK_V1.


*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_HRDEBW_DBEK_V1_STR, 
KENNG TYPE STRING,
KNZST TYPE STRING,
WAERS TYPE STRING,
NAMEK TYPE STRING,
VNAMK TYPE STRING,
GBDAT TYPE STRING,
FLEDT TYPE STRING,
KISTA TYPE STRING,
STRKL TYPE STRING,
FRB1M TYPE STRING,
FRBDT TYPE STRING,
LADAY TYPE STRING,
FIDAY TYPE STRING,
NET1D TYPE STRING,
KUWAG TYPE STRING,
WVLDT TYPE STRING,
WALAZ TYPE STRING,
STWAG TYPE STRING,
LFZED TYPE STRING,
VWBIS TYPE STRING,
VWBET TYPE STRING,
VWRHT TYPE STRING,
ZSBTG TYPE STRING,
KDGAM TYPE STRING,
KDZUM TYPE STRING,
KDGRD TYPE STRING,
LRBEG TYPE STRING,
LREND TYPE STRING,
LRBRT TYPE STRING,
LRNET TYPE STRING,
ABART TYPE STRING,
VRBRT TYPE STRING,
VRNET TYPE STRING,
UBEG1 TYPE STRING,
UEND1 TYPE STRING,
UBRT1 TYPE STRING,
UNET1 TYPE STRING,
UBEG2 TYPE STRING,
UEND2 TYPE STRING,
UBRT2 TYPE STRING,
UNET2 TYPE STRING,
UBEG3 TYPE STRING,
UEND3 TYPE STRING,
UBRT3 TYPE STRING,
UNET3 TYPE STRING,
XBEG1 TYPE STRING,
XEND1 TYPE STRING,
XBRT1 TYPE STRING,
XNET1 TYPE STRING,
XBEG2 TYPE STRING,
XEND2 TYPE STRING,
XBRT2 TYPE STRING,
XNET2 TYPE STRING,
XBEG3 TYPE STRING,
XEND3 TYPE STRING,
XBRT3 TYPE STRING,
XNET3 TYPE STRING,
EINKV TYPE STRING,
EINRV TYPE STRING,
BRTAE TYPE STRING,
BRTTG TYPE STRING,
YBEG1 TYPE STRING,
YEND1 TYPE STRING,
YTAG1 TYPE STRING,
YBEG2 TYPE STRING,
YEND2 TYPE STRING,
YTAG2 TYPE STRING,
YBEG3 TYPE STRING,
YEND3 TYPE STRING,
YTAG3 TYPE STRING,
KRZAE TYPE STRING,
KRZTG TYPE STRING,
FBEG1 TYPE STRING,
FEND1 TYPE STRING,
FTAG1 TYPE STRING,
FBEG2 TYPE STRING,
FEND2 TYPE STRING,
FTAG2 TYPE STRING,
FBEG3 TYPE STRING,
FEND3 TYPE STRING,
FTAG3 TYPE STRING,
FTG01 TYPE STRING,
FTG02 TYPE STRING,
FTG03 TYPE STRING,
FTG04 TYPE STRING,
FTG05 TYPE STRING,
FTG06 TYPE STRING,
FTG07 TYPE STRING,
FTG08 TYPE STRING,
FTG09 TYPE STRING,
FTG10 TYPE STRING,
FTG11 TYPE STRING,
FTG12 TYPE STRING,
FTG13 TYPE STRING,
FTG14 TYPE STRING,
FTG15 TYPE STRING,
FTG16 TYPE STRING,
FTG17 TYPE STRING,
FTG18 TYPE STRING,
FTG19 TYPE STRING,
FTG20 TYPE STRING,
KBEG1 TYPE STRING,
KEND1 TYPE STRING,
KTAG1 TYPE STRING,
KBEG2 TYPE STRING,
KEND2 TYPE STRING,
KTAG2 TYPE STRING,
ANGRD TYPE STRING,
ANFRT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_HRDEBW_DBEK_V1_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_HRDEBW_DBEK_V1_STR-KENNG sy-vline 
WA_HRDEBW_DBEK_V1_STR-KNZST sy-vline 
WA_HRDEBW_DBEK_V1_STR-WAERS sy-vline 
WA_HRDEBW_DBEK_V1_STR-NAMEK sy-vline 
WA_HRDEBW_DBEK_V1_STR-VNAMK sy-vline 
WA_HRDEBW_DBEK_V1_STR-GBDAT sy-vline 
WA_HRDEBW_DBEK_V1_STR-FLEDT sy-vline 
WA_HRDEBW_DBEK_V1_STR-KISTA sy-vline 
WA_HRDEBW_DBEK_V1_STR-STRKL sy-vline 
WA_HRDEBW_DBEK_V1_STR-FRB1M sy-vline 
WA_HRDEBW_DBEK_V1_STR-FRBDT sy-vline 
WA_HRDEBW_DBEK_V1_STR-LADAY sy-vline 
WA_HRDEBW_DBEK_V1_STR-FIDAY sy-vline 
WA_HRDEBW_DBEK_V1_STR-NET1D sy-vline 
WA_HRDEBW_DBEK_V1_STR-KUWAG sy-vline 
WA_HRDEBW_DBEK_V1_STR-WVLDT sy-vline 
WA_HRDEBW_DBEK_V1_STR-WALAZ sy-vline 
WA_HRDEBW_DBEK_V1_STR-STWAG sy-vline 
WA_HRDEBW_DBEK_V1_STR-LFZED sy-vline 
WA_HRDEBW_DBEK_V1_STR-VWBIS sy-vline 
WA_HRDEBW_DBEK_V1_STR-VWBET sy-vline 
WA_HRDEBW_DBEK_V1_STR-VWRHT sy-vline 
WA_HRDEBW_DBEK_V1_STR-ZSBTG sy-vline 
WA_HRDEBW_DBEK_V1_STR-KDGAM sy-vline 
WA_HRDEBW_DBEK_V1_STR-KDZUM sy-vline 
WA_HRDEBW_DBEK_V1_STR-KDGRD sy-vline 
WA_HRDEBW_DBEK_V1_STR-LRBEG sy-vline 
WA_HRDEBW_DBEK_V1_STR-LREND sy-vline 
WA_HRDEBW_DBEK_V1_STR-LRBRT sy-vline 
WA_HRDEBW_DBEK_V1_STR-LRNET sy-vline 
WA_HRDEBW_DBEK_V1_STR-ABART sy-vline 
WA_HRDEBW_DBEK_V1_STR-VRBRT sy-vline 
WA_HRDEBW_DBEK_V1_STR-VRNET sy-vline 
WA_HRDEBW_DBEK_V1_STR-UBEG1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UEND1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UBRT1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UNET1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UBEG2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UEND2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UBRT2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UNET2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UBEG3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UEND3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UBRT3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-UNET3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XBEG1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XEND1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XBRT1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XNET1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XBEG2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XEND2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XBRT2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XNET2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XBEG3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XEND3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XBRT3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-XNET3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-EINKV sy-vline 
WA_HRDEBW_DBEK_V1_STR-EINRV sy-vline 
WA_HRDEBW_DBEK_V1_STR-BRTAE sy-vline 
WA_HRDEBW_DBEK_V1_STR-BRTTG sy-vline 
WA_HRDEBW_DBEK_V1_STR-YBEG1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-YEND1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-YTAG1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-YBEG2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-YEND2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-YTAG2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-YBEG3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-YEND3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-YTAG3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-KRZAE sy-vline 
WA_HRDEBW_DBEK_V1_STR-KRZTG sy-vline 
WA_HRDEBW_DBEK_V1_STR-FBEG1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FEND1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTAG1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FBEG2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FEND2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTAG2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FBEG3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FEND3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTAG3 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG01 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG02 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG03 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG04 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG05 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG06 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG07 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG08 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG09 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG10 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG11 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG12 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG13 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG14 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG15 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG16 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG17 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG18 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG19 sy-vline 
WA_HRDEBW_DBEK_V1_STR-FTG20 sy-vline 
WA_HRDEBW_DBEK_V1_STR-KBEG1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-KEND1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-KTAG1 sy-vline 
WA_HRDEBW_DBEK_V1_STR-KBEG2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-KEND2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-KTAG2 sy-vline 
WA_HRDEBW_DBEK_V1_STR-ANGRD sy-vline 
WA_HRDEBW_DBEK_V1_STR-ANFRT sy-vline      INTO ld_text SEPARATED BY SPACE.

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