ABAP Select data from SAP table HRDEPBSVASENS_LOG_P14N91_KAPP 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 HRDEPBSVASENS_LOG_P14N91_KAPP 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 HRDEPBSVASENS_LOG_P14N91_KAPP. 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 HRDEPBSVASENS_LOG_P14N91_KAPP 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_HRDEPBSVASENS_LOG_P14N91_KAPP TYPE STANDARD TABLE OF HRDEPBSVASENS_LOG_P14N91_KAPP,
      WA_HRDEPBSVASENS_LOG_P14N91_KAPP TYPE HRDEPBSVASENS_LOG_P14N91_KAPP,
      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: <HRDEPBSVASENS_LOG_P14N91_KAPP> TYPE HRDEPBSVASENS_LOG_P14N91_KAPP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM HRDEPBSVASENS_LOG_P14N91_KAPP
*  INTO TABLE @DATA(IT_HRDEPBSVASENS_LOG_P14N91_KAPP2).
*--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_HRDEPBSVASENS_LOG_P14N91_KAPP INDEX 1 INTO DATA(WA_HRDEPBSVASENS_LOG_P14N91_KAPP2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<HRDEPBSVASENS_LOG_P14N91_KAPP>-CALYYNFH = 1.
<HRDEPBSVASENS_LOG_P14N91_KAPP>-CALMMNFH = 1.
<HRDEPBSVASENS_LOG_P14N91_KAPP>-CALDDNFH = 1.
<HRDEPBSVASENS_LOG_P14N91_KAPP>-CALYYNF = 1.
<HRDEPBSVASENS_LOG_P14N91_KAPP>-CALMMNF = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_HRDEPBSVASENS_LOG_P14N91_KAPP-CALDDNF, sy-vline,
  WA_HRDEPBSVASENS_LOG_P14N91_KAPP-JAHRERYDNF, sy-vline,
  WA_HRDEPBSVASENS_LOG_P14N91_KAPP-TAGERYDNF, sy-vline,
  WA_HRDEPBSVASENS_LOG_P14N91_KAPP-CVDDYNF, sy-vline,
  WA_HRDEPBSVASENS_LOG_P14N91_KAPP-CVYDYNF, sy-vline,
  WA_HRDEPBSVASENS_LOG_P14N91_KAPP-RGYDNF, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_HRDEPBSVASENS_LOG_P14N91_KAPP 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_HRDEPBSVASENS_LOG_P14N91_KAPP 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_HRDEPBSVASENS_LOG_P14N91_KAPP INTO WA_HRDEPBSVASENS_LOG_P14N91_KAPP.


*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_HRDEPBSVASENS_LOG_P14N91_KAPP_STR, 
CALYYNFH TYPE STRING,
CALMMNFH TYPE STRING,
CALDDNFH TYPE STRING,
CALYYNF TYPE STRING,
CALMMNF TYPE STRING,
CALDDNF TYPE STRING,
JAHRERYDNF TYPE STRING,
TAGERYDNF TYPE STRING,
CVDDYNF TYPE STRING,
CVYDYNF TYPE STRING,
RGYDNF TYPE STRING,
FARGSNF TYPE STRING,
VHSVB_NF TYPE STRING,
CALYY3Y TYPE STRING,
CALMM3Y TYPE STRING,
CALDD3Y TYPE STRING,
JAHRERYD3Y TYPE STRING,
TAGERYD3Y TYPE STRING,
CVDDY3Y TYPE STRING,
CVYDY3Y TYPE STRING,
RGYD3Y TYPE STRING,
FARGS3Y TYPE STRING,
VHSVB_3Y TYPE STRING,
CURRENCY TYPE STRING,
RGF_DIENSTBEZUEGE TYPE STRING,
FAKTOR_P5ABS1 TYPE STRING,
RGF_DIENSTBEZ_P5ABS1 TYPE STRING,
ANPF_OV69E TYPE STRING,
ERDNT_RUHG_69E TYPE STRING,
ERDNT_RUHEGEHALT_NF TYPE STRING,
ERDNT_RUHEGEHALT_3Y TYPE STRING,
DIFFERENZ_RUHEGEHALT TYPE STRING,
AKTRW TYPE STRING,
KAPPUNGSGRENZE TYPE STRING,
DIFF_KAPP_RUHEGEHALT TYPE STRING,
ANTEILIGER_RGVH TYPE STRING,
ANT_RGF_DIENSTZEIT TYPE STRING,
CALYYKAP TYPE STRING,
CALMMKAP TYPE STRING,
CALDDKAP TYPE STRING,
RGVH_VOR_ERHNF TYPE STRING,
ERHOEHUNGNF TYPE STRING,
RGVH_NACH_ERHNF TYPE STRING,
RGVH_VOR_ERH3Y TYPE STRING,
ERHOEHUNG3Y TYPE STRING,
RGVH_NACH_ERH3Y TYPE STRING,
CALYYCAL TYPE STRING,
CALMMCAL TYPE STRING,
CALDDCAL TYPE STRING,
RGVH_OHNE_SOCKELNF TYPE STRING,
SOCKELNF TYPE STRING,
RGVH_GESAMTNF TYPE STRING,
RGVH_OHNE_SOCKEL3Y TYPE STRING,
SOCKEL3Y TYPE STRING,
RGVH_GESAMT3Y TYPE STRING,
MAX_HOCHSCHULZEIT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_HRDEPBSVASENS_LOG_P14N91_KAPP_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_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALYYNFH sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALMMNFH sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALDDNFH sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALYYNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALMMNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALDDNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-JAHRERYDNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-TAGERYDNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CVDDYNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CVYDYNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGYDNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-FARGSNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-VHSVB_NF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALYY3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALMM3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALDD3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-JAHRERYD3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-TAGERYD3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CVDDY3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CVYDY3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGYD3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-FARGS3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-VHSVB_3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CURRENCY sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGF_DIENSTBEZUEGE sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-FAKTOR_P5ABS1 sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGF_DIENSTBEZ_P5ABS1 sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-ANPF_OV69E sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-ERDNT_RUHG_69E sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-ERDNT_RUHEGEHALT_NF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-ERDNT_RUHEGEHALT_3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-DIFFERENZ_RUHEGEHALT sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-AKTRW sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-KAPPUNGSGRENZE sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-DIFF_KAPP_RUHEGEHALT sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-ANTEILIGER_RGVH sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-ANT_RGF_DIENSTZEIT sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALYYKAP sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALMMKAP sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALDDKAP sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGVH_VOR_ERHNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-ERHOEHUNGNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGVH_NACH_ERHNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGVH_VOR_ERH3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-ERHOEHUNG3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGVH_NACH_ERH3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALYYCAL sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALMMCAL sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-CALDDCAL sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGVH_OHNE_SOCKELNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-SOCKELNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGVH_GESAMTNF sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGVH_OHNE_SOCKEL3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-SOCKEL3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-RGVH_GESAMT3Y sy-vline 
WA_HRDEPBSVASENS_LOG_P14N91_KAPP_STR-MAX_HOCHSCHULZEIT sy-vline      INTO ld_text SEPARATED BY SPACE.

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