ABAP Select data from SAP table /SAPWF/HREIC_S_EXTENDED_ACTI00 into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP /SAPWF/HREIC_S_EXTENDED_ACTI00 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 /SAPWF/HREIC_S_EXTENDED_ACTI00. 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 /SAPWF/HREIC_S_EXTENDED_ACTI00 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_/SAPWF/HREIC_S_EXTENDED_ACTI00 TYPE STANDARD TABLE OF /SAPWF/HREIC_S_EXTENDED_ACTI00,
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00 TYPE /SAPWF/HREIC_S_EXTENDED_ACTI00,
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: </SAPWF/HREIC_S_EXTENDED_ACTI00> TYPE /SAPWF/HREIC_S_EXTENDED_ACTI00.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_/SAPWF/HREIC_S_EXTENDED_ACTI00.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM /SAPWF/HREIC_S_EXTENDED_ACTI00
INTO TABLE IT_/SAPWF/HREIC_S_EXTENDED_ACTI00.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM /SAPWF/HREIC_S_EXTENDED_ACTI00
* INTO TABLE @DATA(IT_/SAPWF/HREIC_S_EXTENDED_ACTI002).
*--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_/SAPWF/HREIC_S_EXTENDED_ACTI00 INDEX 1 INTO DATA(WA_/SAPWF/HREIC_S_EXTENDED_ACTI002).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SAPWF/HREIC_S_EXTENDED_ACTI00 ASSIGNING </SAPWF/HREIC_S_EXTENDED_ACTI00>.
*To update a field value using a field symbol simply change the value via the field symbol pointer</SAPWF/HREIC_S_EXTENDED_ACTI00>-CASE_TYPE = 1.
</SAPWF/HREIC_S_EXTENDED_ACTI00>-EXT_KEY = 1.
</SAPWF/HREIC_S_EXTENDED_ACTI00>-EXT_REF = 1.
</SAPWF/HREIC_S_EXTENDED_ACTI00>-CREATED_BY = 1.
</SAPWF/HREIC_S_EXTENDED_ACTI00>-CREATE_TIME = 1.
ENDLOOP. LOOP AT IT_/SAPWF/HREIC_S_EXTENDED_ACTI00 INTO WA_/SAPWF/HREIC_S_EXTENDED_ACTI00. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/SAPWF/HREIC_S_EXTENDED_ACTI00-CHANGED_BY, sy-vline,
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00-CHANGE_TIME, sy-vline,
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00-CLOSED_BY, sy-vline,
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00-CLOSING_TIME, sy-vline,
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00-PLAN_END_DATE, sy-vline,
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00-PROCESSOR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SAPWF/HREIC_S_EXTENDED_ACTI00 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_/SAPWF/HREIC_S_EXTENDED_ACTI00 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_/SAPWF/HREIC_S_EXTENDED_ACTI00 INTO WA_/SAPWF/HREIC_S_EXTENDED_ACTI00. *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_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR,
CASE_TYPE TYPE STRING,
EXT_KEY TYPE STRING,
EXT_REF TYPE STRING,
CREATED_BY TYPE STRING,
CREATE_TIME TYPE STRING,
CHANGED_BY TYPE STRING,
CHANGE_TIME TYPE STRING,
CLOSED_BY TYPE STRING,
CLOSING_TIME TYPE STRING,
PLAN_END_DATE TYPE STRING,
PROCESSOR TYPE STRING,
RESPONSIBLE TYPE STRING,
CASE_TITLE TYPE STRING,
ESCAL_REASON TYPE STRING,
CATEGORY TYPE STRING,
PRIORITY TYPE STRING,
SECURE_LEVEL TYPE STRING,
PROFILE_ID TYPE STRING,
STAT_ORDERNO TYPE STRING,
STAT_PARA TYPE STRING,
STAT_OBJNR TYPE STRING,
STAT_LINE TYPE STRING,
STAT_USER_LINE TYPE STRING,
REASON_CODE TYPE STRING,
EIC_CATEGORY TYPE STRING,
EIC_SUBCATEGORY TYPE STRING,
EIC_SUBCATEGORY2 TYPE STRING,
EIC_SUBCATEGORY3 TYPE STRING,
EIC_SUBCATEGORY4 TYPE STRING,
EIC_PRIORITY TYPE STRING,
EIC_PERNR TYPE STRING,
EIC_PERSONID TYPE STRING,
EIC_CREATOR TYPE STRING,
EIC_CREAORGUNIT TYPE STRING,
EIC_OWNAGENT TYPE STRING,
EIC_OWNORGUNIT TYPE STRING,
EIC_PROCAGENT TYPE STRING,
EIC_PROCORGUNIT TYPE STRING,
CONTRACT TYPE STRING,
EIC_DUEDATE TYPE STRING,
EIC_REMINDDATE TYPE STRING,
EIC_COMPLETETIME TYPE STRING,
EIC_EXECUTETIME TYPE STRING,
STATCHNGTIME TYPE STRING,
TOTWTNGTIME TYPE STRING,
SERVICE TYPE STRING,
INITIATOR TYPE STRING,
INITIATOR_USER TYPE STRING,
OTYPE TYPE STRING,
PLVAR TYPE STRING,
OBJECTID TYPE STRING,
RESOLUTION TYPE STRING,
CATEGORYTEXT TYPE STRING,
SUBCATEGORYTEXT TYPE STRING,
PRIORITYTEXT TYPE STRING,
STATUSTEXT TYPE STRING,
CHANNELTEXT TYPE STRING,
REASONTEXT TYPE STRING,
PROCESSORTEXT TYPE STRING,
CREAORGUNIT TYPE STRING,
CREATOR TYPE STRING,
OWNORGUNIT TYPE STRING,
OWNAGENT TYPE STRING,
PROCORGUNIT TYPE STRING,
PROCAGENT TYPE STRING,
SLADATE TYPE STRING,
CREATEDATE TYPE STRING,
SUBCATEGORYTEXT2 TYPE STRING,
SUBCATEGORYTEXT3 TYPE STRING,
SUBCATEGORYTEXT4 TYPE STRING,
RESOLUTIONTEXT TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_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_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CASE_TYPE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EXT_KEY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EXT_REF sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CREATED_BY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CREATE_TIME sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CHANGED_BY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CHANGE_TIME sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CLOSED_BY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CLOSING_TIME sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PLAN_END_DATE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PROCESSOR sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-RESPONSIBLE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CASE_TITLE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-ESCAL_REASON sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CATEGORY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PRIORITY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-SECURE_LEVEL sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PROFILE_ID sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-STAT_ORDERNO sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-STAT_PARA sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-STAT_OBJNR sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-STAT_LINE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-STAT_USER_LINE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-REASON_CODE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_CATEGORY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_SUBCATEGORY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_SUBCATEGORY2 sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_SUBCATEGORY3 sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_SUBCATEGORY4 sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_PRIORITY sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_PERNR sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_PERSONID sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_CREATOR sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_CREAORGUNIT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_OWNAGENT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_OWNORGUNIT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_PROCAGENT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_PROCORGUNIT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CONTRACT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_DUEDATE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_REMINDDATE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_COMPLETETIME sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-EIC_EXECUTETIME sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-STATCHNGTIME sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-TOTWTNGTIME sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-SERVICE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-INITIATOR sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-INITIATOR_USER sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-OTYPE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PLVAR sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-OBJECTID sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-RESOLUTION sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CATEGORYTEXT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-SUBCATEGORYTEXT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PRIORITYTEXT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-STATUSTEXT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CHANNELTEXT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-REASONTEXT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PROCESSORTEXT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CREAORGUNIT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CREATOR sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-OWNORGUNIT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-OWNAGENT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PROCORGUNIT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-PROCAGENT sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-SLADATE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-CREATEDATE sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-SUBCATEGORYTEXT2 sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-SUBCATEGORYTEXT3 sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-SUBCATEGORYTEXT4 sy-vline
WA_/SAPWF/HREIC_S_EXTENDED_ACTI00_STR-RESOLUTIONTEXT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
