ABAP Select data from SAP table /GBHCM/S_MA_TS_TIME_ENTRY 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 /GBHCM/S_MA_TS_TIME_ENTRY 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 /GBHCM/S_MA_TS_TIME_ENTRY. 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 /GBHCM/S_MA_TS_TIME_ENTRY 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_/GBHCM/S_MA_TS_TIME_ENTRY TYPE STANDARD TABLE OF /GBHCM/S_MA_TS_TIME_ENTRY,
      WA_/GBHCM/S_MA_TS_TIME_ENTRY TYPE /GBHCM/S_MA_TS_TIME_ENTRY,
      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: </GBHCM/S_MA_TS_TIME_ENTRY> TYPE /GBHCM/S_MA_TS_TIME_ENTRY.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /GBHCM/S_MA_TS_TIME_ENTRY
  INTO TABLE IT_/GBHCM/S_MA_TS_TIME_ENTRY.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /GBHCM/S_MA_TS_TIME_ENTRY
*  INTO TABLE @DATA(IT_/GBHCM/S_MA_TS_TIME_ENTRY2).
*--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_/GBHCM/S_MA_TS_TIME_ENTRY INDEX 1 INTO DATA(WA_/GBHCM/S_MA_TS_TIME_ENTRY2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/GBHCM/S_MA_TS_TIME_ENTRY ASSIGNING </GBHCM/S_MA_TS_TIME_ENTRY>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</GBHCM/S_MA_TS_TIME_ENTRY>-COUNTER = 1.
</GBHCM/S_MA_TS_TIME_ENTRY>-WORKDATE = 1.
</GBHCM/S_MA_TS_TIME_ENTRY>-EMPLOYEENUMBER = 1.
</GBHCM/S_MA_TS_TIME_ENTRY>-SEND_CCTR = 1.
</GBHCM/S_MA_TS_TIME_ENTRY>-SENBUSPROC = 1.

ENDLOOP.

LOOP AT IT_/GBHCM/S_MA_TS_TIME_ENTRY INTO WA_/GBHCM/S_MA_TS_TIME_ENTRY.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/GBHCM/S_MA_TS_TIME_ENTRY-ACTTYPE, sy-vline,
  WA_/GBHCM/S_MA_TS_TIME_ENTRY-PO_NUMBER, sy-vline,
  WA_/GBHCM/S_MA_TS_TIME_ENTRY-PO_ITEM, sy-vline,
  WA_/GBHCM/S_MA_TS_TIME_ENTRY-SERVICE, sy-vline,
  WA_/GBHCM/S_MA_TS_TIME_ENTRY-REC_CCTR, sy-vline,
  WA_/GBHCM/S_MA_TS_TIME_ENTRY-REC_ORDER, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/GBHCM/S_MA_TS_TIME_ENTRY 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_/GBHCM/S_MA_TS_TIME_ENTRY 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_/GBHCM/S_MA_TS_TIME_ENTRY INTO WA_/GBHCM/S_MA_TS_TIME_ENTRY.


*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_/GBHCM/S_MA_TS_TIME_ENTRY_STR, 
COUNTER TYPE STRING,
WORKDATE TYPE STRING,
EMPLOYEENUMBER TYPE STRING,
SEND_CCTR TYPE STRING,
SENBUSPROC TYPE STRING,
ACTTYPE TYPE STRING,
PO_NUMBER TYPE STRING,
PO_ITEM TYPE STRING,
SERVICE TYPE STRING,
REC_CCTR TYPE STRING,
REC_ORDER TYPE STRING,
NETWORK TYPE STRING,
AVTIVITY TYPE STRING,
SUB_ACTIVITY TYPE STRING,
WORK_CNTR TYPE STRING,
CAPA_CATEGORY TYPE STRING,
SPLIT TYPE STRING,
WBS_ELEMENT TYPE STRING,
RECSALEORD TYPE STRING,
RECITEM TYPE STRING,
RECCOSTOBJ TYPE STRING,
RECBUSPROC TYPE STRING,
ABS_ATT_TYPE TYPE STRING,
WAGETYPE TYPE STRING,
TRIPNO TYPE STRING,
OT_COMP_TYPE TYPE STRING,
WORKTAXAREA TYPE STRING,
VALUATION_BASIS TYPE STRING,
CURRENCY TYPE STRING,
CURRENCY_DESC TYPE STRING,
EXTRA_PAY_INDIC TYPE STRING,
PAYSCALEGROUP TYPE STRING,
PAYSCALELEVEL TYPE STRING,
BONUSTYPE TYPE STRING,
BONUSVALUE TYPE STRING,
POSITION TYPE STRING,
CO_AREA TYPE STRING,
TRANS_CURR TYPE STRING,
TRANS_CURR_DESC TYPE STRING,
PRICE TYPE STRING,
PLANT TYPE STRING,
CALC_MOTIVE TYPE STRING,
CATSHOURS TYPE STRING,
UNIT TYPE STRING,
UNIT_DESC TYPE STRING,
STARTTIME TYPE STRING,
ENDTIME TYPE STRING,
PREVIOUS_DAY TYPE STRING,
ALL_DAY_FLAG TYPE STRING,
REM_WORK TYPE STRING,
FCST_FIN_DATE TYPE STRING,
FIN_CONF TYPE STRING,
SHORTTEXT TYPE STRING,
PART_CONF TYPE STRING,
STATUS TYPE STRING,
REASON TYPE STRING,
STATKEYFIG TYPE STRING,
QUANTITY TYPE STRING,
UNITQ TYPE STRING,
UNITQ_DESC TYPE STRING,
AMOUNT TYPE STRING,
LONGTEXT TYPE STRING,
FUND TYPE STRING,
FUNC_AREA TYPE STRING,
GRANT_NBR TYPE STRING,
SEND_FUND TYPE STRING,
SEND_FUNCTION TYPE STRING,
SEND_GRANT TYPE STRING,
CPR_GUID TYPE STRING,
CPR_EXTID TYPE STRING,
CPR_OBJGUID TYPE STRING,
CPR_OBJGEXTID TYPE STRING,
CPR_OBJTYPE TYPE STRING,
FIELD1 TYPE STRING,
FIELD2 TYPE STRING,
FIELD3 TYPE STRING,
FIELD4 TYPE STRING,
FIELD5 TYPE STRING,
FIELD6 TYPE STRING,
FIELD7 TYPE STRING,
FIELD8 TYPE STRING,
FIELD9 TYPE STRING,
FIELD10 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/GBHCM/S_MA_TS_TIME_ENTRY_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_/GBHCM/S_MA_TS_TIME_ENTRY_STR-COUNTER sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-WORKDATE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-EMPLOYEENUMBER sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SEND_CCTR sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SENBUSPROC sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-ACTTYPE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-PO_NUMBER sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-PO_ITEM sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SERVICE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-REC_CCTR sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-REC_ORDER sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-NETWORK sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-AVTIVITY sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SUB_ACTIVITY sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-WORK_CNTR sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CAPA_CATEGORY sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SPLIT sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-WBS_ELEMENT sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-RECSALEORD sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-RECITEM sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-RECCOSTOBJ sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-RECBUSPROC sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-ABS_ATT_TYPE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-WAGETYPE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-TRIPNO sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-OT_COMP_TYPE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-WORKTAXAREA sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-VALUATION_BASIS sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CURRENCY sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CURRENCY_DESC sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-EXTRA_PAY_INDIC sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-PAYSCALEGROUP sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-PAYSCALELEVEL sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-BONUSTYPE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-BONUSVALUE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-POSITION sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CO_AREA sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-TRANS_CURR sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-TRANS_CURR_DESC sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-PRICE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-PLANT sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CALC_MOTIVE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CATSHOURS sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-UNIT sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-UNIT_DESC sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-STARTTIME sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-ENDTIME sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-PREVIOUS_DAY sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-ALL_DAY_FLAG sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-REM_WORK sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FCST_FIN_DATE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIN_CONF sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SHORTTEXT sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-PART_CONF sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-STATUS sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-REASON sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-STATKEYFIG sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-QUANTITY sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-UNITQ sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-UNITQ_DESC sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-AMOUNT sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-LONGTEXT sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FUND sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FUNC_AREA sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-GRANT_NBR sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SEND_FUND sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SEND_FUNCTION sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-SEND_GRANT sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CPR_GUID sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CPR_EXTID sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CPR_OBJGUID sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CPR_OBJGEXTID sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-CPR_OBJTYPE sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD1 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD2 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD3 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD4 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD5 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD6 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD7 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD8 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD9 sy-vline 
WA_/GBHCM/S_MA_TS_TIME_ENTRY_STR-FIELD10 sy-vline      INTO ld_text SEPARATED BY SPACE.

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