ABAP Select data from SAP table HRDEBW_DBKR 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_DBKR 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_DBKR. 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_DBKR 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_DBKR TYPE STANDARD TABLE OF HRDEBW_DBKR,
      WA_HRDEBW_DBKR TYPE HRDEBW_DBKR,
      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_DBKR> TYPE HRDEBW_DBKR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM HRDEBW_DBKR
*  INTO TABLE @DATA(IT_HRDEBW_DBKR2).
*--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_DBKR INDEX 1 INTO DATA(WA_HRDEBW_DBKR2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<HRDEBW_DBKR>-KENNG = 1.
<HRDEBW_DBKR>-KNZST = 1.
<HRDEBW_DBKR>-ABBEG = 1.
<HRDEBW_DBKR>-WAERS = 1.
<HRDEBW_DBKR>-STELL = 1.

ENDLOOP.

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

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


*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_DBKR_STR, 
KENNG TYPE STRING,
KNZST TYPE STRING,
ABBEG TYPE STRING,
WAERS TYPE STRING,
STELL TYPE STRING,
ENTRY TYPE STRING,
FLEDT TYPE STRING,
KISTA TYPE STRING,
STRKL TYPE STRING,
FRB1M TYPE STRING,
FRBDT TYPE STRING,
LADAY TYPE STRING,
FIDAY TYPE STRING,
KUWAG TYPE STRING,
KUWAD TYPE STRING,
WVLDT TYPE STRING,
WALAZ TYPE STRING,
STWAG TYPE STRING,
LFZED TYPE STRING,
VBEG1 TYPE STRING,
VEND1 TYPE STRING,
VBEG2 TYPE STRING,
VEND2 TYPE STRING,
EFZGD TYPE STRING,
AEBIS TYPE STRING,
ZABRT TYPE STRING,
ZANTO TYPE STRING,
ZLRHT TYPE STRING,
VWBET TYPE STRING,
VWBIS TYPE STRING,
VWRHT TYPE STRING,
ZSBTG TYPE STRING,
LBEG1 TYPE STRING,
LEND1 TYPE STRING,
LBEG2 TYPE STRING,
LEND2 TYPE STRING,
RVBEF TYPE STRING,
KDZUM TYPE STRING,
KDGAM 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,
ANSTD TYPE STRING,
WOSTD TYPE STRING,
MBEG1 TYPE STRING,
MEND1 TYPE STRING,
MSTD1 TYPE STRING,
MBEG2 TYPE STRING,
MEND2 TYPE STRING,
MSTD2 TYPE STRING,
MBEG3 TYPE STRING,
MEND3 TYPE STRING,
MSTD3 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,
UFTAG TYPE STRING,
UVTRG TYPE STRING,
LSTFZ TYPE STRING,
LSTB1 TYPE STRING,
LSTE1 TYPE STRING,
LSTZ1 TYPE STRING,
LSTB2 TYPE STRING,
LSTE2 TYPE STRING,
LSTZ2 TYPE STRING,
LSTB3 TYPE STRING,
LSTE3 TYPE STRING,
LSTZ3 TYPE STRING,
SBKNA TYPE STRING,
AVMGG TYPE STRING,END OF T_EKKO_STR.
DATA: WA_HRDEBW_DBKR_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_DBKR_STR-KENNG sy-vline 
WA_HRDEBW_DBKR_STR-KNZST sy-vline 
WA_HRDEBW_DBKR_STR-ABBEG sy-vline 
WA_HRDEBW_DBKR_STR-WAERS sy-vline 
WA_HRDEBW_DBKR_STR-STELL sy-vline 
WA_HRDEBW_DBKR_STR-ENTRY sy-vline 
WA_HRDEBW_DBKR_STR-FLEDT sy-vline 
WA_HRDEBW_DBKR_STR-KISTA sy-vline 
WA_HRDEBW_DBKR_STR-STRKL sy-vline 
WA_HRDEBW_DBKR_STR-FRB1M sy-vline 
WA_HRDEBW_DBKR_STR-FRBDT sy-vline 
WA_HRDEBW_DBKR_STR-LADAY sy-vline 
WA_HRDEBW_DBKR_STR-FIDAY sy-vline 
WA_HRDEBW_DBKR_STR-KUWAG sy-vline 
WA_HRDEBW_DBKR_STR-KUWAD sy-vline 
WA_HRDEBW_DBKR_STR-WVLDT sy-vline 
WA_HRDEBW_DBKR_STR-WALAZ sy-vline 
WA_HRDEBW_DBKR_STR-STWAG sy-vline 
WA_HRDEBW_DBKR_STR-LFZED sy-vline 
WA_HRDEBW_DBKR_STR-VBEG1 sy-vline 
WA_HRDEBW_DBKR_STR-VEND1 sy-vline 
WA_HRDEBW_DBKR_STR-VBEG2 sy-vline 
WA_HRDEBW_DBKR_STR-VEND2 sy-vline 
WA_HRDEBW_DBKR_STR-EFZGD sy-vline 
WA_HRDEBW_DBKR_STR-AEBIS sy-vline 
WA_HRDEBW_DBKR_STR-ZABRT sy-vline 
WA_HRDEBW_DBKR_STR-ZANTO sy-vline 
WA_HRDEBW_DBKR_STR-ZLRHT sy-vline 
WA_HRDEBW_DBKR_STR-VWBET sy-vline 
WA_HRDEBW_DBKR_STR-VWBIS sy-vline 
WA_HRDEBW_DBKR_STR-VWRHT sy-vline 
WA_HRDEBW_DBKR_STR-ZSBTG sy-vline 
WA_HRDEBW_DBKR_STR-LBEG1 sy-vline 
WA_HRDEBW_DBKR_STR-LEND1 sy-vline 
WA_HRDEBW_DBKR_STR-LBEG2 sy-vline 
WA_HRDEBW_DBKR_STR-LEND2 sy-vline 
WA_HRDEBW_DBKR_STR-RVBEF sy-vline 
WA_HRDEBW_DBKR_STR-KDZUM sy-vline 
WA_HRDEBW_DBKR_STR-KDGAM sy-vline 
WA_HRDEBW_DBKR_STR-KDGRD sy-vline 
WA_HRDEBW_DBKR_STR-LRBEG sy-vline 
WA_HRDEBW_DBKR_STR-LREND sy-vline 
WA_HRDEBW_DBKR_STR-LRBRT sy-vline 
WA_HRDEBW_DBKR_STR-LRNET sy-vline 
WA_HRDEBW_DBKR_STR-ABART sy-vline 
WA_HRDEBW_DBKR_STR-VRBRT sy-vline 
WA_HRDEBW_DBKR_STR-VRNET sy-vline 
WA_HRDEBW_DBKR_STR-UBEG1 sy-vline 
WA_HRDEBW_DBKR_STR-UEND1 sy-vline 
WA_HRDEBW_DBKR_STR-UBRT1 sy-vline 
WA_HRDEBW_DBKR_STR-UNET1 sy-vline 
WA_HRDEBW_DBKR_STR-UBEG2 sy-vline 
WA_HRDEBW_DBKR_STR-UEND2 sy-vline 
WA_HRDEBW_DBKR_STR-UBRT2 sy-vline 
WA_HRDEBW_DBKR_STR-UNET2 sy-vline 
WA_HRDEBW_DBKR_STR-UBEG3 sy-vline 
WA_HRDEBW_DBKR_STR-UEND3 sy-vline 
WA_HRDEBW_DBKR_STR-UBRT3 sy-vline 
WA_HRDEBW_DBKR_STR-UNET3 sy-vline 
WA_HRDEBW_DBKR_STR-XBEG1 sy-vline 
WA_HRDEBW_DBKR_STR-XEND1 sy-vline 
WA_HRDEBW_DBKR_STR-XBRT1 sy-vline 
WA_HRDEBW_DBKR_STR-XNET1 sy-vline 
WA_HRDEBW_DBKR_STR-XBEG2 sy-vline 
WA_HRDEBW_DBKR_STR-XEND2 sy-vline 
WA_HRDEBW_DBKR_STR-XBRT2 sy-vline 
WA_HRDEBW_DBKR_STR-XNET2 sy-vline 
WA_HRDEBW_DBKR_STR-XBEG3 sy-vline 
WA_HRDEBW_DBKR_STR-XEND3 sy-vline 
WA_HRDEBW_DBKR_STR-XBRT3 sy-vline 
WA_HRDEBW_DBKR_STR-XNET3 sy-vline 
WA_HRDEBW_DBKR_STR-EINKV sy-vline 
WA_HRDEBW_DBKR_STR-EINRV sy-vline 
WA_HRDEBW_DBKR_STR-ANSTD sy-vline 
WA_HRDEBW_DBKR_STR-WOSTD sy-vline 
WA_HRDEBW_DBKR_STR-MBEG1 sy-vline 
WA_HRDEBW_DBKR_STR-MEND1 sy-vline 
WA_HRDEBW_DBKR_STR-MSTD1 sy-vline 
WA_HRDEBW_DBKR_STR-MBEG2 sy-vline 
WA_HRDEBW_DBKR_STR-MEND2 sy-vline 
WA_HRDEBW_DBKR_STR-MSTD2 sy-vline 
WA_HRDEBW_DBKR_STR-MBEG3 sy-vline 
WA_HRDEBW_DBKR_STR-MEND3 sy-vline 
WA_HRDEBW_DBKR_STR-MSTD3 sy-vline 
WA_HRDEBW_DBKR_STR-FBEG1 sy-vline 
WA_HRDEBW_DBKR_STR-FEND1 sy-vline 
WA_HRDEBW_DBKR_STR-FTAG1 sy-vline 
WA_HRDEBW_DBKR_STR-FBEG2 sy-vline 
WA_HRDEBW_DBKR_STR-FEND2 sy-vline 
WA_HRDEBW_DBKR_STR-FTAG2 sy-vline 
WA_HRDEBW_DBKR_STR-FBEG3 sy-vline 
WA_HRDEBW_DBKR_STR-FEND3 sy-vline 
WA_HRDEBW_DBKR_STR-FTAG3 sy-vline 
WA_HRDEBW_DBKR_STR-UFTAG sy-vline 
WA_HRDEBW_DBKR_STR-UVTRG sy-vline 
WA_HRDEBW_DBKR_STR-LSTFZ sy-vline 
WA_HRDEBW_DBKR_STR-LSTB1 sy-vline 
WA_HRDEBW_DBKR_STR-LSTE1 sy-vline 
WA_HRDEBW_DBKR_STR-LSTZ1 sy-vline 
WA_HRDEBW_DBKR_STR-LSTB2 sy-vline 
WA_HRDEBW_DBKR_STR-LSTE2 sy-vline 
WA_HRDEBW_DBKR_STR-LSTZ2 sy-vline 
WA_HRDEBW_DBKR_STR-LSTB3 sy-vline 
WA_HRDEBW_DBKR_STR-LSTE3 sy-vline 
WA_HRDEBW_DBKR_STR-LSTZ3 sy-vline 
WA_HRDEBW_DBKR_STR-SBKNA sy-vline 
WA_HRDEBW_DBKR_STR-AVMGG sy-vline      INTO ld_text SEPARATED BY SPACE.

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