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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</SAPTRX/BAPI_EVM_EE_MODIFY>-EVTCNT = 1.
</SAPTRX/BAPI_EVM_EE_MODIFY>-MODCNT = 1.
</SAPTRX/BAPI_EVM_EE_MODIFY>-EVTCOD = 1.
</SAPTRX/BAPI_EVM_EE_MODIFY>-EVTID = 1.
</SAPTRX/BAPI_EVM_EE_MODIFY>-EVTACT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SAPTRX/BAPI_EVM_EE_MODIFY-MODREF, sy-vline,
  WA_/SAPTRX/BAPI_EVM_EE_MODIFY-ESTATT, sy-vline,
  WA_/SAPTRX/BAPI_EVM_EE_MODIFY-LOCCOD, sy-vline,
  WA_/SAPTRX/BAPI_EVM_EE_MODIFY-LOCID1, sy-vline,
  WA_/SAPTRX/BAPI_EVM_EE_MODIFY-LOCID2, sy-vline,
  WA_/SAPTRX/BAPI_EVM_EE_MODIFY-LOCNAM, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/SAPTRX/BAPI_EVM_EE_MODIFY 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_/SAPTRX/BAPI_EVM_EE_MODIFY 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_/SAPTRX/BAPI_EVM_EE_MODIFY INTO WA_/SAPTRX/BAPI_EVM_EE_MODIFY.


*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.

*Conversion exit ISOLA, internal->external for field LANGUAGE
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-LANGUAGE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-LANGUAGE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field ETXTST
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-ETXTST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-ETXTST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field ETEATS
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-ETEATS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-ETEATS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field ETLTTS
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-ETLTTS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-ETLTTS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field MSGTST
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-MSGTST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-MSGTST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field MSEATS
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-MSEATS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-MSEATS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field MSLTTS
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-MSLTTS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-MSLTTS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field TS_UTC1
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC1
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC1.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field TS_UTC2
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC2
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC2.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field TS_UTC3
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC3
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC3.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field TS_UTC4
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC4
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC4.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field TS_UTC5
CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT'
  EXPORTING
    input =                      WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC5
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPTRX/BAPI_EVM_EE_MODIFY-TS_UTC5.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_/SAPTRX/BAPI_EVM_EE_MODIFY_STR, 
EVTCNT TYPE STRING,
MODCNT TYPE STRING,
EVTCOD TYPE STRING,
EVTID TYPE STRING,
EVTACT TYPE STRING,
MODREF TYPE STRING,
ESTATT TYPE STRING,
LOCCOD TYPE STRING,
LOCID1 TYPE STRING,
LOCID2 TYPE STRING,
LOCNAM TYPE STRING,
LOCZON TYPE STRING,
PARCOD TYPE STRING,
PARID TYPE STRING,
PARNAM TYPE STRING,
LANGUAGE TYPE STRING,
CRCCOD TYPE STRING,
CRCID TYPE STRING,
CHRTX TYPE STRING,
ETADUR TYPE STRING,
ETXDAT TYPE STRING,
ETXTIM TYPE STRING,
ETXZON TYPE STRING,
ETXTST TYPE STRING,
ETEADT TYPE STRING,
ETEATI TYPE STRING,
ETEATS TYPE STRING,
ETLTDT TYPE STRING,
ETLTTI TYPE STRING,
ETLTTS TYPE STRING,
MSGDUR TYPE STRING,
MSGDAT TYPE STRING,
MSGTIM TYPE STRING,
MSGZON TYPE STRING,
MSGTST TYPE STRING,
MSEADT TYPE STRING,
MSEATI TYPE STRING,
MSEATS TYPE STRING,
MSLTDT TYPE STRING,
MSLTTI TYPE STRING,
MSLTTS TYPE STRING,
DATE1 TYPE STRING,
TIME1 TYPE STRING,
TZONE1 TYPE STRING,
TS_UTC1 TYPE STRING,
DATE2 TYPE STRING,
TIME2 TYPE STRING,
TZONE2 TYPE STRING,
TS_UTC2 TYPE STRING,
DATE3 TYPE STRING,
TIME3 TYPE STRING,
TZONE3 TYPE STRING,
TS_UTC3 TYPE STRING,
DATE4 TYPE STRING,
TIME4 TYPE STRING,
TZONE4 TYPE STRING,
TS_UTC4 TYPE STRING,
DATE5 TYPE STRING,
TIME5 TYPE STRING,
TZONE5 TYPE STRING,
TS_UTC5 TYPE STRING,
DATACS TYPE STRING,
DATAID TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/SAPTRX/BAPI_EVM_EE_MODIFY_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_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-EVTCNT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MODCNT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-EVTCOD sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-EVTID sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-EVTACT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MODREF sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ESTATT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-LOCCOD sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-LOCID1 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-LOCID2 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-LOCNAM sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-LOCZON sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-PARCOD sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-PARID sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-PARNAM sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-LANGUAGE sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-CRCCOD sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-CRCID sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-CHRTX sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETADUR sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETXDAT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETXTIM sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETXZON sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETXTST sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETEADT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETEATI sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETEATS sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETLTDT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETLTTI sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-ETLTTS sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSGDUR sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSGDAT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSGTIM sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSGZON sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSGTST sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSEADT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSEATI sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSEATS sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSLTDT sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSLTTI sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-MSLTTS sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-DATE1 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TIME1 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TZONE1 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TS_UTC1 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-DATE2 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TIME2 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TZONE2 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TS_UTC2 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-DATE3 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TIME3 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TZONE3 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TS_UTC3 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-DATE4 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TIME4 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TZONE4 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TS_UTC4 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-DATE5 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TIME5 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TZONE5 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-TS_UTC5 sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-DATACS sy-vline 
WA_/SAPTRX/BAPI_EVM_EE_MODIFY_STR-DATAID sy-vline      INTO ld_text SEPARATED BY SPACE.

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