ABAP Select data from SAP table WLFS_LIST_KOMLRK 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 WLFS_LIST_KOMLRK 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 WLFS_LIST_KOMLRK. 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 WLFS_LIST_KOMLRK 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_WLFS_LIST_KOMLRK TYPE STANDARD TABLE OF WLFS_LIST_KOMLRK,
      WA_WLFS_LIST_KOMLRK TYPE WLFS_LIST_KOMLRK,
      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: <WLFS_LIST_KOMLRK> TYPE WLFS_LIST_KOMLRK.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM WLFS_LIST_KOMLRK
*  INTO TABLE @DATA(IT_WLFS_LIST_KOMLRK2).
*--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_WLFS_LIST_KOMLRK INDEX 1 INTO DATA(WA_WLFS_LIST_KOMLRK2).


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

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_WLFS_LIST_KOMLRK-WRART_TXT, sy-vline,
WA_WLFS_LIST_KOMLRK-WFDAT, sy-vline,
WA_WLFS_LIST_KOMLRK-WFDAT_RL, sy-vline,
WA_WLFS_LIST_KOMLRK-BLDAT, sy-vline,
WA_WLFS_LIST_KOMLRK-EKORG, sy-vline,
WA_WLFS_LIST_KOMLRK-EKGRP, sy-vline.
ENDLOOP. *Add any further fields from structure WA_WLFS_LIST_KOMLRK 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_WLFS_LIST_KOMLRK 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_WLFS_LIST_KOMLRK INTO WA_WLFS_LIST_KOMLRK. *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_WLFS_LIST_KOMLRK-WBELN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLFS_LIST_KOMLRK-WBELN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field ADRNR_RE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLFS_LIST_KOMLRK-ADRNR_RE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLFS_LIST_KOMLRK-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_WLFS_LIST_KOMLRK-ADRNP_RE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLFS_LIST_KOMLRK-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_WLFS_LIST_KOMLRK-ADRNR_RS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLFS_LIST_KOMLRK-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_WLFS_LIST_KOMLRK-ADRNR_RG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLFS_LIST_KOMLRK-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_WLFS_LIST_KOMLRK-ADRNR_AZ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLFS_LIST_KOMLRK-ADRNR_AZ.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ALPHA, internal->external for field CP_LOGSYS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_WLFS_LIST_KOMLRK-CP_LOGSYS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_WLFS_LIST_KOMLRK-CP_LOGSYS.
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_WLFS_LIST_KOMLRK_STR,
WBELN TYPE STRING,
WBELN_RL TYPE STRING,
LFART TYPE STRING,
LFART_TXT TYPE STRING,
WRART TYPE STRING,
WRART_TXT TYPE STRING,
WFDAT TYPE STRING,
WFDAT_RL TYPE STRING,
BLDAT TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
BUKRS TYPE STRING,
SPART TYPE STRING,
WAERL TYPE STRING,
NETWR TYPE STRING,
MWSBK TYPE STRING,
BRTWR TYPE STRING,
NETWRD TYPE STRING,
MWSBKD TYPE STRING,
BRTWRD TYPE STRING,
LIFRE TYPE STRING,
LIF_NAME1 TYPE STRING,
LNRZB TYPE STRING,
LZB_NAME1 TYPE STRING,
ZTERM TYPE STRING,
ZBD1T TYPE STRING,
ZBD1P TYPE STRING,
ZBD2T TYPE STRING,
ZBD2P TYPE STRING,
ZBD3T TYPE STRING,
ZLSCH TYPE STRING,
KUNRE TYPE STRING,
KND_NAME1 TYPE STRING,
KUNRG TYPE STRING,
KRG_NAME1 TYPE STRING,
ZTERMD TYPE STRING,
ZBD1TD TYPE STRING,
ZBD1PD TYPE STRING,
ZBD2TD TYPE STRING,
ZBD2PD TYPE STRING,
ZBD3TD TYPE STRING,
ZLSCHD TYPE STRING,
RFBSK TYPE STRING,
RFBSK_TXT TYPE STRING,
ZUONR TYPE STRING,
XBLNR TYPE STRING,
ERDAT TYPE STRING,
ERNAM TYPE STRING,
LFTYP TYPE STRING,
VTEXT TYPE STRING,
WRTYP TYPE STRING,
ARCHIV TYPE STRING,
SELKZ TYPE STRING,
FKSTO TYPE STRING,
LFAKS TYPE STRING,
ESTATUS 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,
LIFNR_FI TYPE STRING,
LIFNR_FI_NAME1 TYPE STRING,
CONTRACT TYPE STRING,
SETTLEMENT_DATE TYPE STRING,
WDTYP TYPE STRING,
CONTR_TYPE TYPE STRING,
PROCESS_VARIANT TYPE STRING,
CP_WBELN_RFC TYPE STRING,
CP_LOG_HANDLE TYPE STRING,
CP_TOTAL TYPE STRING,
CP_WBRK TYPE STRING,
CP_WBRP TYPE STRING,
CP_KONV TYPE STRING,
CP_WBRR TYPE STRING,
CP_WBPA TYPE STRING,
CP_BKPF TYPE STRING,
CP_BSEG TYPE STRING,
CP_BSET TYPE STRING,
CP_ICON_LOG TYPE STRING,
CP_LOGSYS TYPE STRING,
NAST_OBJKY TYPE STRING,
NAST_KSCHL TYPE STRING,
NAST_KSCHL_TEXT TYPE STRING,
NAST_VSTAT TYPE STRING,
NAST_VSTAT_TEXT TYPE STRING,
NAST_ERDAT TYPE STRING,
NAST_ERUHR TYPE STRING,
NAST_DATVR TYPE STRING,
NAST_UHRVR TYPE STRING,
NAST_NACHA TYPE STRING,
NAST_NACHA_TEXT TYPE STRING,
NAST_DIFF TYPE STRING,END OF T_EKKO_STR. DATA: WA_WLFS_LIST_KOMLRK_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_WLFS_LIST_KOMLRK_STR-WBELN sy-vline
WA_WLFS_LIST_KOMLRK_STR-WBELN_RL sy-vline
WA_WLFS_LIST_KOMLRK_STR-LFART sy-vline
WA_WLFS_LIST_KOMLRK_STR-LFART_TXT sy-vline
WA_WLFS_LIST_KOMLRK_STR-WRART sy-vline
WA_WLFS_LIST_KOMLRK_STR-WRART_TXT sy-vline
WA_WLFS_LIST_KOMLRK_STR-WFDAT sy-vline
WA_WLFS_LIST_KOMLRK_STR-WFDAT_RL sy-vline
WA_WLFS_LIST_KOMLRK_STR-BLDAT sy-vline
WA_WLFS_LIST_KOMLRK_STR-EKORG sy-vline
WA_WLFS_LIST_KOMLRK_STR-EKGRP sy-vline
WA_WLFS_LIST_KOMLRK_STR-VKORG sy-vline
WA_WLFS_LIST_KOMLRK_STR-VTWEG sy-vline
WA_WLFS_LIST_KOMLRK_STR-BUKRS sy-vline
WA_WLFS_LIST_KOMLRK_STR-SPART sy-vline
WA_WLFS_LIST_KOMLRK_STR-WAERL sy-vline
WA_WLFS_LIST_KOMLRK_STR-NETWR sy-vline
WA_WLFS_LIST_KOMLRK_STR-MWSBK sy-vline
WA_WLFS_LIST_KOMLRK_STR-BRTWR sy-vline
WA_WLFS_LIST_KOMLRK_STR-NETWRD sy-vline
WA_WLFS_LIST_KOMLRK_STR-MWSBKD sy-vline
WA_WLFS_LIST_KOMLRK_STR-BRTWRD sy-vline
WA_WLFS_LIST_KOMLRK_STR-LIFRE sy-vline
WA_WLFS_LIST_KOMLRK_STR-LIF_NAME1 sy-vline
WA_WLFS_LIST_KOMLRK_STR-LNRZB sy-vline
WA_WLFS_LIST_KOMLRK_STR-LZB_NAME1 sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZTERM sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD1T sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD1P sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD2T sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD2P sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD3T sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZLSCH sy-vline
WA_WLFS_LIST_KOMLRK_STR-KUNRE sy-vline
WA_WLFS_LIST_KOMLRK_STR-KND_NAME1 sy-vline
WA_WLFS_LIST_KOMLRK_STR-KUNRG sy-vline
WA_WLFS_LIST_KOMLRK_STR-KRG_NAME1 sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZTERMD sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD1TD sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD1PD sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD2TD sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD2PD sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZBD3TD sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZLSCHD sy-vline
WA_WLFS_LIST_KOMLRK_STR-RFBSK sy-vline
WA_WLFS_LIST_KOMLRK_STR-RFBSK_TXT sy-vline
WA_WLFS_LIST_KOMLRK_STR-ZUONR sy-vline
WA_WLFS_LIST_KOMLRK_STR-XBLNR sy-vline
WA_WLFS_LIST_KOMLRK_STR-ERDAT sy-vline
WA_WLFS_LIST_KOMLRK_STR-ERNAM sy-vline
WA_WLFS_LIST_KOMLRK_STR-LFTYP sy-vline
WA_WLFS_LIST_KOMLRK_STR-VTEXT sy-vline
WA_WLFS_LIST_KOMLRK_STR-WRTYP sy-vline
WA_WLFS_LIST_KOMLRK_STR-ARCHIV sy-vline
WA_WLFS_LIST_KOMLRK_STR-SELKZ sy-vline
WA_WLFS_LIST_KOMLRK_STR-FKSTO sy-vline
WA_WLFS_LIST_KOMLRK_STR-LFAKS sy-vline
WA_WLFS_LIST_KOMLRK_STR-ESTATUS sy-vline
WA_WLFS_LIST_KOMLRK_STR-ADRNR_RE sy-vline
WA_WLFS_LIST_KOMLRK_STR-ADDR_TYPE_RE sy-vline
WA_WLFS_LIST_KOMLRK_STR-ADRNP_RE sy-vline
WA_WLFS_LIST_KOMLRK_STR-ADRNR_RS sy-vline
WA_WLFS_LIST_KOMLRK_STR-ADRNR_RG sy-vline
WA_WLFS_LIST_KOMLRK_STR-ADRNR_AZ sy-vline
WA_WLFS_LIST_KOMLRK_STR-LIFNR_FI sy-vline
WA_WLFS_LIST_KOMLRK_STR-LIFNR_FI_NAME1 sy-vline
WA_WLFS_LIST_KOMLRK_STR-CONTRACT sy-vline
WA_WLFS_LIST_KOMLRK_STR-SETTLEMENT_DATE sy-vline
WA_WLFS_LIST_KOMLRK_STR-WDTYP sy-vline
WA_WLFS_LIST_KOMLRK_STR-CONTR_TYPE sy-vline
WA_WLFS_LIST_KOMLRK_STR-PROCESS_VARIANT sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_WBELN_RFC sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_LOG_HANDLE sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_TOTAL sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_WBRK sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_WBRP sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_KONV sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_WBRR sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_WBPA sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_BKPF sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_BSEG sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_BSET sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_ICON_LOG sy-vline
WA_WLFS_LIST_KOMLRK_STR-CP_LOGSYS sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_OBJKY sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_KSCHL sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_KSCHL_TEXT sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_VSTAT sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_VSTAT_TEXT sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_ERDAT sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_ERUHR sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_DATVR sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_UHRVR sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_NACHA sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_NACHA_TEXT sy-vline
WA_WLFS_LIST_KOMLRK_STR-NAST_DIFF sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.