ABAP Select data from SAP table WLF_HILIST_SR 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 WLF_HILIST_SR 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 WLF_HILIST_SR. 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 WLF_HILIST_SR 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_WLF_HILIST_SR TYPE STANDARD TABLE OF WLF_HILIST_SR,
      WA_WLF_HILIST_SR TYPE WLF_HILIST_SR,
      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: <WLF_HILIST_SR> TYPE WLF_HILIST_SR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM WLF_HILIST_SR
*  INTO TABLE @DATA(IT_WLF_HILIST_SR2).
*--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_WLF_HILIST_SR INDEX 1 INTO DATA(WA_WLF_HILIST_SR2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_WLF_HILIST_SR ASSIGNING <WLF_HILIST_SR>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<WLF_HILIST_SR>-WBELN = 1.
<WLF_HILIST_SR>-WRART = 1.
<WLF_HILIST_SR>-WRART_TXT = 1.
<WLF_HILIST_SR>-LFART = 1.
<WLF_HILIST_SR>-LFART_TXT = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_WLF_HILIST_SR-WFDAT, sy-vline,
WA_WLF_HILIST_SR-BLDAT, sy-vline,
WA_WLF_HILIST_SR-LIFRE, sy-vline,
WA_WLF_HILIST_SR-LIFRE_NAME1, sy-vline,
WA_WLF_HILIST_SR-KUNRE, sy-vline,
WA_WLF_HILIST_SR-KUNRE_NAME1, sy-vline.
ENDLOOP. *Add any further fields from structure WA_WLF_HILIST_SR 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_WLF_HILIST_SR 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_WLF_HILIST_SR INTO WA_WLF_HILIST_SR. *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 ALPHA, internal->external for field WBELN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-WBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-WBELN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field LIFRE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-LIFRE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-LIFRE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KUNRE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-KUNRE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-KUNRE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field LNRZB CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-LNRZB IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-LNRZB.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KUNRG CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-KUNRG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-KUNRG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field LIFNR_FI CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-LIFNR_FI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-LIFNR_FI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CONTRACT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-CONTRACT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-CONTRACT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field LFAKS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-LFAKS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-LFAKS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ADRNR_RE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-ADRNR_RE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-ADRNR_RE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ADRNP_RE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-ADRNP_RE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-ADRNP_RE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ADRNR_RS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-ADRNR_RS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-ADRNR_RS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ADRNR_RG CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-ADRNR_RG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-ADRNR_RG.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ADRNR_AZ CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-ADRNR_AZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-ADRNR_AZ.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field WFKME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-WFKME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-WFKME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field FPRME CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-FPRME IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-FPRME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CUSTOMER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-CUSTOMER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-CUSTOMER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KOLIF CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLF_HILIST_SR-KOLIF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLF_HILIST_SR-KOLIF.
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_WLF_HILIST_SR_STR,
WBELN TYPE STRING,
WRART TYPE STRING,
WRART_TXT TYPE STRING,
LFART TYPE STRING,
LFART_TXT TYPE STRING,
WFDAT TYPE STRING,
BLDAT TYPE STRING,
LIFRE TYPE STRING,
LIFRE_NAME1 TYPE STRING,
KUNRE TYPE STRING,
KUNRE_NAME1 TYPE STRING,
LNRZB TYPE STRING,
LNRZB_NAME1 TYPE STRING,
ZTERM TYPE STRING,
ZBD1T TYPE STRING,
ZBD1P TYPE STRING,
ZBD2T TYPE STRING,
ZBD2P TYPE STRING,
ZBD3T TYPE STRING,
VALDT TYPE STRING,
VALTG TYPE STRING,
KUNRG TYPE STRING,
KUNRG_NAME1 TYPE STRING,
ZTERMD TYPE STRING,
ZBD1TD TYPE STRING,
ZBD1PD TYPE STRING,
ZBD2TD TYPE STRING,
ZBD2PD TYPE STRING,
ZBD3TD TYPE STRING,
VALDTD TYPE STRING,
VALTGD TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
BUKRS TYPE STRING,
WAERL TYPE STRING,
RFBSK TYPE STRING,
RFBSK_TXT TYPE STRING,
LFTYP TYPE STRING,
LFTYP_TXT TYPE STRING,
XBLNR TYPE STRING,
ZUONR TYPE STRING,
KIDNO TYPE STRING,
ERDAT TYPE STRING,
ERZET TYPE STRING,
ERNAM TYPE STRING,
ARCHIV TYPE STRING,
SELKZ TYPE STRING,
LIFNR_FI TYPE STRING,
LIFNR_FI_NAME1 TYPE STRING,
CONTRACT TYPE STRING,
SETTLEMENT_DATE TYPE STRING,
REF_SETTL_DATE TYPE STRING,
FKSTO TYPE STRING,
LFAKS TYPE STRING,
ESTATUS TYPE STRING,
WDTYP TYPE STRING,
ADRNR_RE TYPE STRING,
ADDR_TYPE_RE TYPE STRING,
ADRNP_RE TYPE STRING,
ADRNR_RS TYPE STRING,
ADRNR_RG TYPE STRING,
ADRNR_AZ TYPE STRING,
CONTR_TYPE TYPE STRING,
PROCESS_VARIANT TYPE STRING,
POSNR TYPE STRING,
NETWR TYPE STRING,
MWSBP TYPE STRING,
BRTWR TYPE STRING,
MATNR TYPE STRING,
ARKTX TYPE STRING,
MATKL TYPE STRING,
IDNLF TYPE STRING,
EKKOL TYPE STRING,
WERKS TYPE STRING,
MWSKZ TYPE STRING,
MWSK2 TYPE STRING,
MENGE TYPE STRING,
WFKME TYPE STRING,
NETPR TYPE STRING,
PEINH TYPE STRING,
FPRME TYPE STRING,
CUSTOMER TYPE STRING,
CUSTOMER_NAME1 TYPE STRING,
KOLIF TYPE STRING,
KOLIF_NAME1 TYPE STRING,
KZWI1 TYPE STRING,
KZWI2 TYPE STRING,
KZWI3 TYPE STRING,
KZWI4 TYPE STRING,
KZWI5 TYPE STRING,
KZWI6 TYPE STRING,
BONBA TYPE STRING,
EFFWR TYPE STRING,
KZWI1D TYPE STRING,
KZWI2D TYPE STRING,
KZWI3D TYPE STRING,
KZWI4D TYPE STRING,
KZWI5D TYPE STRING,
KZWI6D TYPE STRING,
BONBAD TYPE STRING,
EFFWRD TYPE STRING,
NETWRD TYPE STRING,
MWSBPD TYPE STRING,
BRTWRD TYPE STRING,END OF T_EKKO_STR. DATA: WA_WLF_HILIST_SR_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_WLF_HILIST_SR_STR-WBELN sy-vline
WA_WLF_HILIST_SR_STR-WRART sy-vline
WA_WLF_HILIST_SR_STR-WRART_TXT sy-vline
WA_WLF_HILIST_SR_STR-LFART sy-vline
WA_WLF_HILIST_SR_STR-LFART_TXT sy-vline
WA_WLF_HILIST_SR_STR-WFDAT sy-vline
WA_WLF_HILIST_SR_STR-BLDAT sy-vline
WA_WLF_HILIST_SR_STR-LIFRE sy-vline
WA_WLF_HILIST_SR_STR-LIFRE_NAME1 sy-vline
WA_WLF_HILIST_SR_STR-KUNRE sy-vline
WA_WLF_HILIST_SR_STR-KUNRE_NAME1 sy-vline
WA_WLF_HILIST_SR_STR-LNRZB sy-vline
WA_WLF_HILIST_SR_STR-LNRZB_NAME1 sy-vline
WA_WLF_HILIST_SR_STR-ZTERM sy-vline
WA_WLF_HILIST_SR_STR-ZBD1T sy-vline
WA_WLF_HILIST_SR_STR-ZBD1P sy-vline
WA_WLF_HILIST_SR_STR-ZBD2T sy-vline
WA_WLF_HILIST_SR_STR-ZBD2P sy-vline
WA_WLF_HILIST_SR_STR-ZBD3T sy-vline
WA_WLF_HILIST_SR_STR-VALDT sy-vline
WA_WLF_HILIST_SR_STR-VALTG sy-vline
WA_WLF_HILIST_SR_STR-KUNRG sy-vline
WA_WLF_HILIST_SR_STR-KUNRG_NAME1 sy-vline
WA_WLF_HILIST_SR_STR-ZTERMD sy-vline
WA_WLF_HILIST_SR_STR-ZBD1TD sy-vline
WA_WLF_HILIST_SR_STR-ZBD1PD sy-vline
WA_WLF_HILIST_SR_STR-ZBD2TD sy-vline
WA_WLF_HILIST_SR_STR-ZBD2PD sy-vline
WA_WLF_HILIST_SR_STR-ZBD3TD sy-vline
WA_WLF_HILIST_SR_STR-VALDTD sy-vline
WA_WLF_HILIST_SR_STR-VALTGD sy-vline
WA_WLF_HILIST_SR_STR-EKORG sy-vline
WA_WLF_HILIST_SR_STR-EKGRP sy-vline
WA_WLF_HILIST_SR_STR-VKORG sy-vline
WA_WLF_HILIST_SR_STR-VTWEG sy-vline
WA_WLF_HILIST_SR_STR-SPART sy-vline
WA_WLF_HILIST_SR_STR-BUKRS sy-vline
WA_WLF_HILIST_SR_STR-WAERL sy-vline
WA_WLF_HILIST_SR_STR-RFBSK sy-vline
WA_WLF_HILIST_SR_STR-RFBSK_TXT sy-vline
WA_WLF_HILIST_SR_STR-LFTYP sy-vline
WA_WLF_HILIST_SR_STR-LFTYP_TXT sy-vline
WA_WLF_HILIST_SR_STR-XBLNR sy-vline
WA_WLF_HILIST_SR_STR-ZUONR sy-vline
WA_WLF_HILIST_SR_STR-KIDNO sy-vline
WA_WLF_HILIST_SR_STR-ERDAT sy-vline
WA_WLF_HILIST_SR_STR-ERZET sy-vline
WA_WLF_HILIST_SR_STR-ERNAM sy-vline
WA_WLF_HILIST_SR_STR-ARCHIV sy-vline
WA_WLF_HILIST_SR_STR-SELKZ sy-vline
WA_WLF_HILIST_SR_STR-LIFNR_FI sy-vline
WA_WLF_HILIST_SR_STR-LIFNR_FI_NAME1 sy-vline
WA_WLF_HILIST_SR_STR-CONTRACT sy-vline
WA_WLF_HILIST_SR_STR-SETTLEMENT_DATE sy-vline
WA_WLF_HILIST_SR_STR-REF_SETTL_DATE sy-vline
WA_WLF_HILIST_SR_STR-FKSTO sy-vline
WA_WLF_HILIST_SR_STR-LFAKS sy-vline
WA_WLF_HILIST_SR_STR-ESTATUS sy-vline
WA_WLF_HILIST_SR_STR-WDTYP sy-vline
WA_WLF_HILIST_SR_STR-ADRNR_RE sy-vline
WA_WLF_HILIST_SR_STR-ADDR_TYPE_RE sy-vline
WA_WLF_HILIST_SR_STR-ADRNP_RE sy-vline
WA_WLF_HILIST_SR_STR-ADRNR_RS sy-vline
WA_WLF_HILIST_SR_STR-ADRNR_RG sy-vline
WA_WLF_HILIST_SR_STR-ADRNR_AZ sy-vline
WA_WLF_HILIST_SR_STR-CONTR_TYPE sy-vline
WA_WLF_HILIST_SR_STR-PROCESS_VARIANT sy-vline
WA_WLF_HILIST_SR_STR-POSNR sy-vline
WA_WLF_HILIST_SR_STR-NETWR sy-vline
WA_WLF_HILIST_SR_STR-MWSBP sy-vline
WA_WLF_HILIST_SR_STR-BRTWR sy-vline
WA_WLF_HILIST_SR_STR-MATNR sy-vline
WA_WLF_HILIST_SR_STR-ARKTX sy-vline
WA_WLF_HILIST_SR_STR-MATKL sy-vline
WA_WLF_HILIST_SR_STR-IDNLF sy-vline
WA_WLF_HILIST_SR_STR-EKKOL sy-vline
WA_WLF_HILIST_SR_STR-WERKS sy-vline
WA_WLF_HILIST_SR_STR-MWSKZ sy-vline
WA_WLF_HILIST_SR_STR-MWSK2 sy-vline
WA_WLF_HILIST_SR_STR-MENGE sy-vline
WA_WLF_HILIST_SR_STR-WFKME sy-vline
WA_WLF_HILIST_SR_STR-NETPR sy-vline
WA_WLF_HILIST_SR_STR-PEINH sy-vline
WA_WLF_HILIST_SR_STR-FPRME sy-vline
WA_WLF_HILIST_SR_STR-CUSTOMER sy-vline
WA_WLF_HILIST_SR_STR-CUSTOMER_NAME1 sy-vline
WA_WLF_HILIST_SR_STR-KOLIF sy-vline
WA_WLF_HILIST_SR_STR-KOLIF_NAME1 sy-vline
WA_WLF_HILIST_SR_STR-KZWI1 sy-vline
WA_WLF_HILIST_SR_STR-KZWI2 sy-vline
WA_WLF_HILIST_SR_STR-KZWI3 sy-vline
WA_WLF_HILIST_SR_STR-KZWI4 sy-vline
WA_WLF_HILIST_SR_STR-KZWI5 sy-vline
WA_WLF_HILIST_SR_STR-KZWI6 sy-vline
WA_WLF_HILIST_SR_STR-BONBA sy-vline
WA_WLF_HILIST_SR_STR-EFFWR sy-vline
WA_WLF_HILIST_SR_STR-KZWI1D sy-vline
WA_WLF_HILIST_SR_STR-KZWI2D sy-vline
WA_WLF_HILIST_SR_STR-KZWI3D sy-vline
WA_WLF_HILIST_SR_STR-KZWI4D sy-vline
WA_WLF_HILIST_SR_STR-KZWI5D sy-vline
WA_WLF_HILIST_SR_STR-KZWI6D sy-vline
WA_WLF_HILIST_SR_STR-BONBAD sy-vline
WA_WLF_HILIST_SR_STR-EFFWRD sy-vline
WA_WLF_HILIST_SR_STR-NETWRD sy-vline
WA_WLF_HILIST_SR_STR-MWSBPD sy-vline
WA_WLF_HILIST_SR_STR-BRTWRD sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.