ABAP Select data from SAP table TDS_HVSTATCOMT 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 TDS_HVSTATCOMT 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 TDS_HVSTATCOMT. 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 TDS_HVSTATCOMT 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_TDS_HVSTATCOMT TYPE STANDARD TABLE OF TDS_HVSTATCOMT,
      WA_TDS_HVSTATCOMT TYPE TDS_HVSTATCOMT,
      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: <TDS_HVSTATCOMT> TYPE TDS_HVSTATCOMT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TDS_HVSTATCOMT
*  INTO TABLE @DATA(IT_TDS_HVSTATCOMT2).
*--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_TDS_HVSTATCOMT INDEX 1 INTO DATA(WA_TDS_HVSTATCOMT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TDS_HVSTATCOMT>-ABSTK = 1.
<TDS_HVSTATCOMT>-BESTK = 1.
<TDS_HVSTATCOMT>-BUCHK = 1.
<TDS_HVSTATCOMT>-CMGST = 1.
<TDS_HVSTATCOMT>-CMPS0 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TDS_HVSTATCOMT-CMPS1, sy-vline,
  WA_TDS_HVSTATCOMT-CMPS2, sy-vline,
  WA_TDS_HVSTATCOMT-CMPSA, sy-vline,
  WA_TDS_HVSTATCOMT-CMPSB, sy-vline,
  WA_TDS_HVSTATCOMT-CMPSC, sy-vline,
  WA_TDS_HVSTATCOMT-CMPSD, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TDS_HVSTATCOMT 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_TDS_HVSTATCOMT 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_TDS_HVSTATCOMT INTO WA_TDS_HVSTATCOMT.


*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_TDS_HVSTATCOMT_STR, 
ABSTK TYPE STRING,
BESTK TYPE STRING,
BUCHK TYPE STRING,
CMGST TYPE STRING,
CMPS0 TYPE STRING,
CMPS1 TYPE STRING,
CMPS2 TYPE STRING,
CMPSA TYPE STRING,
CMPSB TYPE STRING,
CMPSC TYPE STRING,
CMPSD TYPE STRING,
CMPSE TYPE STRING,
CMPSF TYPE STRING,
CMPSG TYPE STRING,
CMPSH TYPE STRING,
CMPSI TYPE STRING,
CMPSJ TYPE STRING,
CMPSK TYPE STRING,
CMPSL TYPE STRING,
CMPSM TYPE STRING,
COSTA TYPE STRING,
DCSTK TYPE STRING,
FKIVK TYPE STRING,
FKSAK TYPE STRING,
FKSTK TYPE STRING,
FSSTK TYPE STRING,
GBSTK TYPE STRING,
KOQUK TYPE STRING,
KOSTK TYPE STRING,
LFGSK TYPE STRING,
LFSTK TYPE STRING,
LSSTK TYPE STRING,
LVSTK TYPE STRING,
PDSTK TYPE STRING,
PKSTK TYPE STRING,
RFGSK TYPE STRING,
RFSTK TYPE STRING,
SPSTG TYPE STRING,
TRSTA TYPE STRING,
UVALL TYPE STRING,
UVALS TYPE STRING,
UVFAK TYPE STRING,
UVFAS TYPE STRING,
UVVLK TYPE STRING,
UVVLS TYPE STRING,
WBSTK TYPE STRING,
ABSTK_T TYPE STRING,
BESTK_T TYPE STRING,
BUCHK_T TYPE STRING,
CMGST_T TYPE STRING,
CMPS0_T TYPE STRING,
CMPS1_T TYPE STRING,
CMPS2_T TYPE STRING,
CMPSA_T TYPE STRING,
CMPSB_T TYPE STRING,
CMPSC_T TYPE STRING,
CMPSD_T TYPE STRING,
CMPSE_T TYPE STRING,
CMPSF_T TYPE STRING,
CMPSG_T TYPE STRING,
CMPSH_T TYPE STRING,
CMPSI_T TYPE STRING,
CMPSJ_T TYPE STRING,
CMPSK_T TYPE STRING,
CMPSL_T TYPE STRING,
CMPSM_T TYPE STRING,
COSTA_T TYPE STRING,
DCSTK_T TYPE STRING,
FKIVK_T TYPE STRING,
FKSAK_T TYPE STRING,
FKSTK_T TYPE STRING,
FSSTK_T TYPE STRING,
GBSTK_T TYPE STRING,
KOQUK_T TYPE STRING,
KOSTK_T TYPE STRING,
LFGSK_T TYPE STRING,
LFSTK_T TYPE STRING,
LSSTK_T TYPE STRING,
LVSTK_T TYPE STRING,
PDSTK_T TYPE STRING,
PKSTK_T TYPE STRING,
RFGSK_T TYPE STRING,
RFSTK_T TYPE STRING,
SPSTG_T TYPE STRING,
TRSTA_T TYPE STRING,
UVALL_T TYPE STRING,
UVALS_T TYPE STRING,
UVFAK_T TYPE STRING,
UVFAS_T TYPE STRING,
UVVLK_T TYPE STRING,
UVVLS_T TYPE STRING,
WBSTK_T TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TDS_HVSTATCOMT_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_TDS_HVSTATCOMT_STR-ABSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-BESTK sy-vline 
WA_TDS_HVSTATCOMT_STR-BUCHK sy-vline 
WA_TDS_HVSTATCOMT_STR-CMGST sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPS0 sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPS1 sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPS2 sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSA sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSB sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSC sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSD sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSE sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSF sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSG sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSH sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSI sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSJ sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSK sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSL sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSM sy-vline 
WA_TDS_HVSTATCOMT_STR-COSTA sy-vline 
WA_TDS_HVSTATCOMT_STR-DCSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-FKIVK sy-vline 
WA_TDS_HVSTATCOMT_STR-FKSAK sy-vline 
WA_TDS_HVSTATCOMT_STR-FKSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-FSSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-GBSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-KOQUK sy-vline 
WA_TDS_HVSTATCOMT_STR-KOSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-LFGSK sy-vline 
WA_TDS_HVSTATCOMT_STR-LFSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-LSSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-LVSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-PDSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-PKSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-RFGSK sy-vline 
WA_TDS_HVSTATCOMT_STR-RFSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-SPSTG sy-vline 
WA_TDS_HVSTATCOMT_STR-TRSTA sy-vline 
WA_TDS_HVSTATCOMT_STR-UVALL sy-vline 
WA_TDS_HVSTATCOMT_STR-UVALS sy-vline 
WA_TDS_HVSTATCOMT_STR-UVFAK sy-vline 
WA_TDS_HVSTATCOMT_STR-UVFAS sy-vline 
WA_TDS_HVSTATCOMT_STR-UVVLK sy-vline 
WA_TDS_HVSTATCOMT_STR-UVVLS sy-vline 
WA_TDS_HVSTATCOMT_STR-WBSTK sy-vline 
WA_TDS_HVSTATCOMT_STR-ABSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-BESTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-BUCHK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMGST_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPS0_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPS1_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPS2_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSA_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSB_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSC_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSD_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSE_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSF_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSG_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSH_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSI_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSJ_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSL_T sy-vline 
WA_TDS_HVSTATCOMT_STR-CMPSM_T sy-vline 
WA_TDS_HVSTATCOMT_STR-COSTA_T sy-vline 
WA_TDS_HVSTATCOMT_STR-DCSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-FKIVK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-FKSAK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-FKSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-FSSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-GBSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-KOQUK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-KOSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-LFGSK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-LFSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-LSSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-LVSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-PDSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-PKSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-RFGSK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-RFSTK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-SPSTG_T sy-vline 
WA_TDS_HVSTATCOMT_STR-TRSTA_T sy-vline 
WA_TDS_HVSTATCOMT_STR-UVALL_T sy-vline 
WA_TDS_HVSTATCOMT_STR-UVALS_T sy-vline 
WA_TDS_HVSTATCOMT_STR-UVFAK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-UVFAS_T sy-vline 
WA_TDS_HVSTATCOMT_STR-UVVLK_T sy-vline 
WA_TDS_HVSTATCOMT_STR-UVVLS_T sy-vline 
WA_TDS_HVSTATCOMT_STR-WBSTK_T sy-vline      INTO ld_text SEPARATED BY SPACE.

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