ABAP Select data from SAP table HRFPM_BULIST 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 HRFPM_BULIST 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 HRFPM_BULIST. 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 HRFPM_BULIST 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_HRFPM_BULIST TYPE STANDARD TABLE OF HRFPM_BULIST,
      WA_HRFPM_BULIST TYPE HRFPM_BULIST,
      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: <HRFPM_BULIST> TYPE HRFPM_BULIST.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM HRFPM_BULIST
*  INTO TABLE @DATA(IT_HRFPM_BULIST2).
*--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_HRFPM_BULIST INDEX 1 INTO DATA(WA_HRFPM_BULIST2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<HRFPM_BULIST>-COLS01 = 1.
<HRFPM_BULIST>-COLL01 = 1.
<HRFPM_BULIST>-COLS02 = 1.
<HRFPM_BULIST>-COLL02 = 1.
<HRFPM_BULIST>-COLS03 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_HRFPM_BULIST-COLL03, sy-vline,
  WA_HRFPM_BULIST-COLS04, sy-vline,
  WA_HRFPM_BULIST-COLL04, sy-vline,
  WA_HRFPM_BULIST-COLS05, sy-vline,
  WA_HRFPM_BULIST-COLL05, sy-vline,
  WA_HRFPM_BULIST-COLS06, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_HRFPM_BULIST 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_HRFPM_BULIST 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_HRFPM_BULIST INTO WA_HRFPM_BULIST.


*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_HRFPM_BULIST_STR, 
COLS01 TYPE STRING,
COLL01 TYPE STRING,
COLS02 TYPE STRING,
COLL02 TYPE STRING,
COLS03 TYPE STRING,
COLL03 TYPE STRING,
COLS04 TYPE STRING,
COLL04 TYPE STRING,
COLS05 TYPE STRING,
COLL05 TYPE STRING,
COLS06 TYPE STRING,
COLL06 TYPE STRING,
COLS07 TYPE STRING,
COLL07 TYPE STRING,
COLS08 TYPE STRING,
COLL08 TYPE STRING,
COLS09 TYPE STRING,
COLL09 TYPE STRING,
COLS10 TYPE STRING,
COLL10 TYPE STRING,
COLS11 TYPE STRING,
COLL11 TYPE STRING,
COLS12 TYPE STRING,
COLL12 TYPE STRING,
COLS13 TYPE STRING,
COLL13 TYPE STRING,
COLS14 TYPE STRING,
COLL14 TYPE STRING,
COLS15 TYPE STRING,
COLL15 TYPE STRING,
COLS16 TYPE STRING,
COLL16 TYPE STRING,
COLS17 TYPE STRING,
COLL17 TYPE STRING,
COLS18 TYPE STRING,
COLL18 TYPE STRING,
COLS19 TYPE STRING,
COLL19 TYPE STRING,
COLS20 TYPE STRING,
COLL20 TYPE STRING,
KEYDATE TYPE STRING,
KEYDATE_COMP TYPE STRING,
KEYDATE_OCC TYPE STRING,
PLVAR TYPE STRING,
OTYPE TYPE STRING,
OBJID TYPE STRING,
SHORT TYPE STRING,
STEXT TYPE STRING,
GDATE TYPE STRING,
TOTAL_ABS TYPE STRING,
TOTAL_ABS_COMP TYPE STRING,
TOTAL_ABS_OCC TYPE STRING,
PLUS_ABS TYPE STRING,
MINUS_ABS TYPE STRING,
TOTAL_FTE TYPE STRING,
TOTAL_FTE_COMP TYPE STRING,
TOTAL_FTE_OCC TYPE STRING,
PLUS_FTE TYPE STRING,
MINUS_FTE TYPE STRING,
VAC_FTE TYPE STRING,
OCC_FTE TYPE STRING,
TOTAL_AMNT TYPE STRING,
CURCY TYPE STRING,
TOTAL_AMNT_COMP TYPE STRING,
TOTAL_AMNT_OCC TYPE STRING,
PLUS_AMNT TYPE STRING,
MINUS_AMNT TYPE STRING,
VAC_AMNT TYPE STRING,
OCC_AMNT TYPE STRING,
AVAIL_FTE TYPE STRING,
AVAIL_FTE_OCC TYPE STRING,
AVAIL_FTE_COMP TYPE STRING,
LOCKS_FTE TYPE STRING,
LOCKS_FTE_C TYPE STRING,
LOCKS_FTE_O TYPE STRING,
NOTED_FTE TYPE STRING,
NOTED_FTE_C TYPE STRING,
NOTED_FTE_O TYPE STRING,
RECL_NAME TYPE STRING,
RECL_FTE TYPE STRING,
RECL_FTE_C TYPE STRING,
RECL_FTE_O TYPE STRING,
PERSG TYPE STRING,
PERSG_TEXT TYPE STRING,
PERSK TYPE STRING,
PERSK_TEXT TYPE STRING,
MOLGA TYPE STRING,
TRFAR TYPE STRING,
TARTX TYPE STRING,
TRFGB TYPE STRING,
TGBTX TYPE STRING,
TRFKZ TYPE STRING,
TRFGR TYPE STRING,
VGRPW TYPE STRING,
LFBGR TYPE STRING,
LFBGT TYPE STRING,
AREA TYPE STRING,
AREA_TEXT TYPE STRING,
DAKAT TYPE STRING,
DART TYPE STRING,
UDART TYPE STRING,
ADTKEY TYPE STRING,
ADTTEXT TYPE STRING,
ADTABBRE TYPE STRING,
FALGK TYPE STRING,
FALGK2 TYPE STRING,
FALGR TYPE STRING,
FALGR2 TYPE STRING,
ANLAG TYPE STRING,
ANLAG2 TYPE STRING,
TTEIL TYPE STRING,
TTEIL2 TYPE STRING,
ABSNT TYPE STRING,
ABSNT2 TYPE STRING,
EXT_NUMBER TYPE STRING,
EXT_TEXT TYPE STRING,
FINYR TYPE STRING,
AKTE TYPE STRING,
KOMM TYPE STRING,
RECLD TYPE STRING,END OF T_EKKO_STR.
DATA: WA_HRFPM_BULIST_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_HRFPM_BULIST_STR-COLS01 sy-vline 
WA_HRFPM_BULIST_STR-COLL01 sy-vline 
WA_HRFPM_BULIST_STR-COLS02 sy-vline 
WA_HRFPM_BULIST_STR-COLL02 sy-vline 
WA_HRFPM_BULIST_STR-COLS03 sy-vline 
WA_HRFPM_BULIST_STR-COLL03 sy-vline 
WA_HRFPM_BULIST_STR-COLS04 sy-vline 
WA_HRFPM_BULIST_STR-COLL04 sy-vline 
WA_HRFPM_BULIST_STR-COLS05 sy-vline 
WA_HRFPM_BULIST_STR-COLL05 sy-vline 
WA_HRFPM_BULIST_STR-COLS06 sy-vline 
WA_HRFPM_BULIST_STR-COLL06 sy-vline 
WA_HRFPM_BULIST_STR-COLS07 sy-vline 
WA_HRFPM_BULIST_STR-COLL07 sy-vline 
WA_HRFPM_BULIST_STR-COLS08 sy-vline 
WA_HRFPM_BULIST_STR-COLL08 sy-vline 
WA_HRFPM_BULIST_STR-COLS09 sy-vline 
WA_HRFPM_BULIST_STR-COLL09 sy-vline 
WA_HRFPM_BULIST_STR-COLS10 sy-vline 
WA_HRFPM_BULIST_STR-COLL10 sy-vline 
WA_HRFPM_BULIST_STR-COLS11 sy-vline 
WA_HRFPM_BULIST_STR-COLL11 sy-vline 
WA_HRFPM_BULIST_STR-COLS12 sy-vline 
WA_HRFPM_BULIST_STR-COLL12 sy-vline 
WA_HRFPM_BULIST_STR-COLS13 sy-vline 
WA_HRFPM_BULIST_STR-COLL13 sy-vline 
WA_HRFPM_BULIST_STR-COLS14 sy-vline 
WA_HRFPM_BULIST_STR-COLL14 sy-vline 
WA_HRFPM_BULIST_STR-COLS15 sy-vline 
WA_HRFPM_BULIST_STR-COLL15 sy-vline 
WA_HRFPM_BULIST_STR-COLS16 sy-vline 
WA_HRFPM_BULIST_STR-COLL16 sy-vline 
WA_HRFPM_BULIST_STR-COLS17 sy-vline 
WA_HRFPM_BULIST_STR-COLL17 sy-vline 
WA_HRFPM_BULIST_STR-COLS18 sy-vline 
WA_HRFPM_BULIST_STR-COLL18 sy-vline 
WA_HRFPM_BULIST_STR-COLS19 sy-vline 
WA_HRFPM_BULIST_STR-COLL19 sy-vline 
WA_HRFPM_BULIST_STR-COLS20 sy-vline 
WA_HRFPM_BULIST_STR-COLL20 sy-vline 
WA_HRFPM_BULIST_STR-KEYDATE sy-vline 
WA_HRFPM_BULIST_STR-KEYDATE_COMP sy-vline 
WA_HRFPM_BULIST_STR-KEYDATE_OCC sy-vline 
WA_HRFPM_BULIST_STR-PLVAR sy-vline 
WA_HRFPM_BULIST_STR-OTYPE sy-vline 
WA_HRFPM_BULIST_STR-OBJID sy-vline 
WA_HRFPM_BULIST_STR-SHORT sy-vline 
WA_HRFPM_BULIST_STR-STEXT sy-vline 
WA_HRFPM_BULIST_STR-GDATE sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_ABS sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_ABS_COMP sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_ABS_OCC sy-vline 
WA_HRFPM_BULIST_STR-PLUS_ABS sy-vline 
WA_HRFPM_BULIST_STR-MINUS_ABS sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_FTE sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_FTE_COMP sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_FTE_OCC sy-vline 
WA_HRFPM_BULIST_STR-PLUS_FTE sy-vline 
WA_HRFPM_BULIST_STR-MINUS_FTE sy-vline 
WA_HRFPM_BULIST_STR-VAC_FTE sy-vline 
WA_HRFPM_BULIST_STR-OCC_FTE sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_AMNT sy-vline 
WA_HRFPM_BULIST_STR-CURCY sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_AMNT_COMP sy-vline 
WA_HRFPM_BULIST_STR-TOTAL_AMNT_OCC sy-vline 
WA_HRFPM_BULIST_STR-PLUS_AMNT sy-vline 
WA_HRFPM_BULIST_STR-MINUS_AMNT sy-vline 
WA_HRFPM_BULIST_STR-VAC_AMNT sy-vline 
WA_HRFPM_BULIST_STR-OCC_AMNT sy-vline 
WA_HRFPM_BULIST_STR-AVAIL_FTE sy-vline 
WA_HRFPM_BULIST_STR-AVAIL_FTE_OCC sy-vline 
WA_HRFPM_BULIST_STR-AVAIL_FTE_COMP sy-vline 
WA_HRFPM_BULIST_STR-LOCKS_FTE sy-vline 
WA_HRFPM_BULIST_STR-LOCKS_FTE_C sy-vline 
WA_HRFPM_BULIST_STR-LOCKS_FTE_O sy-vline 
WA_HRFPM_BULIST_STR-NOTED_FTE sy-vline 
WA_HRFPM_BULIST_STR-NOTED_FTE_C sy-vline 
WA_HRFPM_BULIST_STR-NOTED_FTE_O sy-vline 
WA_HRFPM_BULIST_STR-RECL_NAME sy-vline 
WA_HRFPM_BULIST_STR-RECL_FTE sy-vline 
WA_HRFPM_BULIST_STR-RECL_FTE_C sy-vline 
WA_HRFPM_BULIST_STR-RECL_FTE_O sy-vline 
WA_HRFPM_BULIST_STR-PERSG sy-vline 
WA_HRFPM_BULIST_STR-PERSG_TEXT sy-vline 
WA_HRFPM_BULIST_STR-PERSK sy-vline 
WA_HRFPM_BULIST_STR-PERSK_TEXT sy-vline 
WA_HRFPM_BULIST_STR-MOLGA sy-vline 
WA_HRFPM_BULIST_STR-TRFAR sy-vline 
WA_HRFPM_BULIST_STR-TARTX sy-vline 
WA_HRFPM_BULIST_STR-TRFGB sy-vline 
WA_HRFPM_BULIST_STR-TGBTX sy-vline 
WA_HRFPM_BULIST_STR-TRFKZ sy-vline 
WA_HRFPM_BULIST_STR-TRFGR sy-vline 
WA_HRFPM_BULIST_STR-VGRPW sy-vline 
WA_HRFPM_BULIST_STR-LFBGR sy-vline 
WA_HRFPM_BULIST_STR-LFBGT sy-vline 
WA_HRFPM_BULIST_STR-AREA sy-vline 
WA_HRFPM_BULIST_STR-AREA_TEXT sy-vline 
WA_HRFPM_BULIST_STR-DAKAT sy-vline 
WA_HRFPM_BULIST_STR-DART sy-vline 
WA_HRFPM_BULIST_STR-UDART sy-vline 
WA_HRFPM_BULIST_STR-ADTKEY sy-vline 
WA_HRFPM_BULIST_STR-ADTTEXT sy-vline 
WA_HRFPM_BULIST_STR-ADTABBRE sy-vline 
WA_HRFPM_BULIST_STR-FALGK sy-vline 
WA_HRFPM_BULIST_STR-FALGK2 sy-vline 
WA_HRFPM_BULIST_STR-FALGR sy-vline 
WA_HRFPM_BULIST_STR-FALGR2 sy-vline 
WA_HRFPM_BULIST_STR-ANLAG sy-vline 
WA_HRFPM_BULIST_STR-ANLAG2 sy-vline 
WA_HRFPM_BULIST_STR-TTEIL sy-vline 
WA_HRFPM_BULIST_STR-TTEIL2 sy-vline 
WA_HRFPM_BULIST_STR-ABSNT sy-vline 
WA_HRFPM_BULIST_STR-ABSNT2 sy-vline 
WA_HRFPM_BULIST_STR-EXT_NUMBER sy-vline 
WA_HRFPM_BULIST_STR-EXT_TEXT sy-vline 
WA_HRFPM_BULIST_STR-FINYR sy-vline 
WA_HRFPM_BULIST_STR-AKTE sy-vline 
WA_HRFPM_BULIST_STR-KOMM sy-vline 
WA_HRFPM_BULIST_STR-RECLD sy-vline      INTO ld_text SEPARATED BY SPACE.

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