ABAP Select data from SAP table ACPVALLINE_I 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 ACPVALLINE_I 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 ACPVALLINE_I. 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 ACPVALLINE_I 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_ACPVALLINE_I TYPE STANDARD TABLE OF ACPVALLINE_I,
      WA_ACPVALLINE_I TYPE ACPVALLINE_I,
      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: <ACPVALLINE_I> TYPE ACPVALLINE_I.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ACPVALLINE_I
*  INTO TABLE @DATA(IT_ACPVALLINE_I2).
*--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_ACPVALLINE_I INDEX 1 INTO DATA(WA_ACPVALLINE_I2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<ACPVALLINE_I>-KOSTL = 1.
<ACPVALLINE_I>-LSTAR = 1.
<ACPVALLINE_I>-PRZNR = 1.
<ACPVALLINE_I>-LST001 = 1.
<ACPVALLINE_I>-LST002 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ACPVALLINE_I-LST003, sy-vline,
  WA_ACPVALLINE_I-LST004, sy-vline,
  WA_ACPVALLINE_I-LST005, sy-vline,
  WA_ACPVALLINE_I-LST006, sy-vline,
  WA_ACPVALLINE_I-LST007, sy-vline,
  WA_ACPVALLINE_I-LST008, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_ACPVALLINE_I 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_ACPVALLINE_I 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_ACPVALLINE_I INTO WA_ACPVALLINE_I.


*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 KOSTL
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-KOSTL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-KOSTL.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AC112, internal->external for field TKF001
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF001
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF001.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF002
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF002
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF002.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF003
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF003
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF003.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF004
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF004
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF004.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF005
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF005
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF005.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF006
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF006
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF006.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF007
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF007
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF007.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF008
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF008
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF008.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF009
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF009
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF009.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF010
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF010
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF010.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF011
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF011
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF011.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF012
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF012
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF012.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF013
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF013
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF013.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF014
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF014
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF014.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF015
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF015
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF015.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKF016
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKF016
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKF016.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV001
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV001
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV001.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV002
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV002
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV002.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV003
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV003
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV003.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV004
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV004
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV004.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV005
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV005
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV005.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV006
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV006
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV006.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV007
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV007
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV007.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV008
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV008
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV008.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV009
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV009
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV009.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV010
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV010
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV010.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV011
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV011
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV011.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV012
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV012
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV012.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV013
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV013
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV013.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV014
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV014
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV014.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV015
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV015
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV015.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC112, internal->external for field TKV016
CALL FUNCTION 'CONVERSION_EXIT_AC112_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-TKV016
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-TKV016.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit CUNIT, internal->external for field AUSEH
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_ACPVALLINE_I-AUSEH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_ACPVALLINE_I-AUSEH.
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_ACPVALLINE_I_STR, 
KOSTL TYPE STRING,
LSTAR TYPE STRING,
PRZNR TYPE STRING,
LST001 TYPE STRING,
LST002 TYPE STRING,
LST003 TYPE STRING,
LST004 TYPE STRING,
LST005 TYPE STRING,
LST006 TYPE STRING,
LST007 TYPE STRING,
LST008 TYPE STRING,
LST009 TYPE STRING,
LST010 TYPE STRING,
LST011 TYPE STRING,
LST012 TYPE STRING,
LST013 TYPE STRING,
LST014 TYPE STRING,
LST015 TYPE STRING,
LST016 TYPE STRING,
KAP001 TYPE STRING,
KAP002 TYPE STRING,
KAP003 TYPE STRING,
KAP004 TYPE STRING,
KAP005 TYPE STRING,
KAP006 TYPE STRING,
KAP007 TYPE STRING,
KAP008 TYPE STRING,
KAP009 TYPE STRING,
KAP010 TYPE STRING,
KAP011 TYPE STRING,
KAP012 TYPE STRING,
KAP013 TYPE STRING,
KAP014 TYPE STRING,
KAP015 TYPE STRING,
KAP016 TYPE STRING,
TKF001 TYPE STRING,
TKF002 TYPE STRING,
TKF003 TYPE STRING,
TKF004 TYPE STRING,
TKF005 TYPE STRING,
TKF006 TYPE STRING,
TKF007 TYPE STRING,
TKF008 TYPE STRING,
TKF009 TYPE STRING,
TKF010 TYPE STRING,
TKF011 TYPE STRING,
TKF012 TYPE STRING,
TKF013 TYPE STRING,
TKF014 TYPE STRING,
TKF015 TYPE STRING,
TKF016 TYPE STRING,
TKV001 TYPE STRING,
TKV002 TYPE STRING,
TKV003 TYPE STRING,
TKV004 TYPE STRING,
TKV005 TYPE STRING,
TKV006 TYPE STRING,
TKV007 TYPE STRING,
TKV008 TYPE STRING,
TKV009 TYPE STRING,
TKV010 TYPE STRING,
TKV011 TYPE STRING,
TKV012 TYPE STRING,
TKV013 TYPE STRING,
TKV014 TYPE STRING,
TKV015 TYPE STRING,
TKV016 TYPE STRING,
TKE001 TYPE STRING,
TKE002 TYPE STRING,
TKE003 TYPE STRING,
TKE004 TYPE STRING,
TKE005 TYPE STRING,
TKE006 TYPE STRING,
TKE007 TYPE STRING,
TKE008 TYPE STRING,
TKE009 TYPE STRING,
TKE010 TYPE STRING,
TKE011 TYPE STRING,
TKE012 TYPE STRING,
TKE013 TYPE STRING,
TKE014 TYPE STRING,
TKE015 TYPE STRING,
TKE016 TYPE STRING,
AEQ001 TYPE STRING,
AEQ002 TYPE STRING,
AEQ003 TYPE STRING,
AEQ004 TYPE STRING,
AEQ005 TYPE STRING,
AEQ006 TYPE STRING,
AEQ007 TYPE STRING,
AEQ008 TYPE STRING,
AEQ009 TYPE STRING,
AEQ010 TYPE STRING,
AEQ011 TYPE STRING,
AEQ012 TYPE STRING,
AEQ013 TYPE STRING,
AEQ014 TYPE STRING,
AEQ015 TYPE STRING,
AEQ016 TYPE STRING,
LATYP TYPE STRING,
LATYPI TYPE STRING,
TARKZ TYPE STRING,
TARKZ_I TYPE STRING,
VKSTA TYPE STRING,
FIXVO TYPE STRING,
MANIST TYPE STRING,
YRATE TYPE STRING,
SWSMH TYPE STRING,
WAERS TYPE STRING,
ROW_ID TYPE STRING,
AUSEH TYPE STRING,
AUS001 TYPE STRING,
AUS002 TYPE STRING,
AUS003 TYPE STRING,
AUS004 TYPE STRING,
AUS005 TYPE STRING,
AUS006 TYPE STRING,
AUS007 TYPE STRING,
AUS008 TYPE STRING,
AUS009 TYPE STRING,
AUS010 TYPE STRING,
AUS011 TYPE STRING,
AUS012 TYPE STRING,
AUS013 TYPE STRING,
AUS014 TYPE STRING,
AUS015 TYPE STRING,
AUS016 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_ACPVALLINE_I_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_ACPVALLINE_I_STR-KOSTL sy-vline 
WA_ACPVALLINE_I_STR-LSTAR sy-vline 
WA_ACPVALLINE_I_STR-PRZNR sy-vline 
WA_ACPVALLINE_I_STR-LST001 sy-vline 
WA_ACPVALLINE_I_STR-LST002 sy-vline 
WA_ACPVALLINE_I_STR-LST003 sy-vline 
WA_ACPVALLINE_I_STR-LST004 sy-vline 
WA_ACPVALLINE_I_STR-LST005 sy-vline 
WA_ACPVALLINE_I_STR-LST006 sy-vline 
WA_ACPVALLINE_I_STR-LST007 sy-vline 
WA_ACPVALLINE_I_STR-LST008 sy-vline 
WA_ACPVALLINE_I_STR-LST009 sy-vline 
WA_ACPVALLINE_I_STR-LST010 sy-vline 
WA_ACPVALLINE_I_STR-LST011 sy-vline 
WA_ACPVALLINE_I_STR-LST012 sy-vline 
WA_ACPVALLINE_I_STR-LST013 sy-vline 
WA_ACPVALLINE_I_STR-LST014 sy-vline 
WA_ACPVALLINE_I_STR-LST015 sy-vline 
WA_ACPVALLINE_I_STR-LST016 sy-vline 
WA_ACPVALLINE_I_STR-KAP001 sy-vline 
WA_ACPVALLINE_I_STR-KAP002 sy-vline 
WA_ACPVALLINE_I_STR-KAP003 sy-vline 
WA_ACPVALLINE_I_STR-KAP004 sy-vline 
WA_ACPVALLINE_I_STR-KAP005 sy-vline 
WA_ACPVALLINE_I_STR-KAP006 sy-vline 
WA_ACPVALLINE_I_STR-KAP007 sy-vline 
WA_ACPVALLINE_I_STR-KAP008 sy-vline 
WA_ACPVALLINE_I_STR-KAP009 sy-vline 
WA_ACPVALLINE_I_STR-KAP010 sy-vline 
WA_ACPVALLINE_I_STR-KAP011 sy-vline 
WA_ACPVALLINE_I_STR-KAP012 sy-vline 
WA_ACPVALLINE_I_STR-KAP013 sy-vline 
WA_ACPVALLINE_I_STR-KAP014 sy-vline 
WA_ACPVALLINE_I_STR-KAP015 sy-vline 
WA_ACPVALLINE_I_STR-KAP016 sy-vline 
WA_ACPVALLINE_I_STR-TKF001 sy-vline 
WA_ACPVALLINE_I_STR-TKF002 sy-vline 
WA_ACPVALLINE_I_STR-TKF003 sy-vline 
WA_ACPVALLINE_I_STR-TKF004 sy-vline 
WA_ACPVALLINE_I_STR-TKF005 sy-vline 
WA_ACPVALLINE_I_STR-TKF006 sy-vline 
WA_ACPVALLINE_I_STR-TKF007 sy-vline 
WA_ACPVALLINE_I_STR-TKF008 sy-vline 
WA_ACPVALLINE_I_STR-TKF009 sy-vline 
WA_ACPVALLINE_I_STR-TKF010 sy-vline 
WA_ACPVALLINE_I_STR-TKF011 sy-vline 
WA_ACPVALLINE_I_STR-TKF012 sy-vline 
WA_ACPVALLINE_I_STR-TKF013 sy-vline 
WA_ACPVALLINE_I_STR-TKF014 sy-vline 
WA_ACPVALLINE_I_STR-TKF015 sy-vline 
WA_ACPVALLINE_I_STR-TKF016 sy-vline 
WA_ACPVALLINE_I_STR-TKV001 sy-vline 
WA_ACPVALLINE_I_STR-TKV002 sy-vline 
WA_ACPVALLINE_I_STR-TKV003 sy-vline 
WA_ACPVALLINE_I_STR-TKV004 sy-vline 
WA_ACPVALLINE_I_STR-TKV005 sy-vline 
WA_ACPVALLINE_I_STR-TKV006 sy-vline 
WA_ACPVALLINE_I_STR-TKV007 sy-vline 
WA_ACPVALLINE_I_STR-TKV008 sy-vline 
WA_ACPVALLINE_I_STR-TKV009 sy-vline 
WA_ACPVALLINE_I_STR-TKV010 sy-vline 
WA_ACPVALLINE_I_STR-TKV011 sy-vline 
WA_ACPVALLINE_I_STR-TKV012 sy-vline 
WA_ACPVALLINE_I_STR-TKV013 sy-vline 
WA_ACPVALLINE_I_STR-TKV014 sy-vline 
WA_ACPVALLINE_I_STR-TKV015 sy-vline 
WA_ACPVALLINE_I_STR-TKV016 sy-vline 
WA_ACPVALLINE_I_STR-TKE001 sy-vline 
WA_ACPVALLINE_I_STR-TKE002 sy-vline 
WA_ACPVALLINE_I_STR-TKE003 sy-vline 
WA_ACPVALLINE_I_STR-TKE004 sy-vline 
WA_ACPVALLINE_I_STR-TKE005 sy-vline 
WA_ACPVALLINE_I_STR-TKE006 sy-vline 
WA_ACPVALLINE_I_STR-TKE007 sy-vline 
WA_ACPVALLINE_I_STR-TKE008 sy-vline 
WA_ACPVALLINE_I_STR-TKE009 sy-vline 
WA_ACPVALLINE_I_STR-TKE010 sy-vline 
WA_ACPVALLINE_I_STR-TKE011 sy-vline 
WA_ACPVALLINE_I_STR-TKE012 sy-vline 
WA_ACPVALLINE_I_STR-TKE013 sy-vline 
WA_ACPVALLINE_I_STR-TKE014 sy-vline 
WA_ACPVALLINE_I_STR-TKE015 sy-vline 
WA_ACPVALLINE_I_STR-TKE016 sy-vline 
WA_ACPVALLINE_I_STR-AEQ001 sy-vline 
WA_ACPVALLINE_I_STR-AEQ002 sy-vline 
WA_ACPVALLINE_I_STR-AEQ003 sy-vline 
WA_ACPVALLINE_I_STR-AEQ004 sy-vline 
WA_ACPVALLINE_I_STR-AEQ005 sy-vline 
WA_ACPVALLINE_I_STR-AEQ006 sy-vline 
WA_ACPVALLINE_I_STR-AEQ007 sy-vline 
WA_ACPVALLINE_I_STR-AEQ008 sy-vline 
WA_ACPVALLINE_I_STR-AEQ009 sy-vline 
WA_ACPVALLINE_I_STR-AEQ010 sy-vline 
WA_ACPVALLINE_I_STR-AEQ011 sy-vline 
WA_ACPVALLINE_I_STR-AEQ012 sy-vline 
WA_ACPVALLINE_I_STR-AEQ013 sy-vline 
WA_ACPVALLINE_I_STR-AEQ014 sy-vline 
WA_ACPVALLINE_I_STR-AEQ015 sy-vline 
WA_ACPVALLINE_I_STR-AEQ016 sy-vline 
WA_ACPVALLINE_I_STR-LATYP sy-vline 
WA_ACPVALLINE_I_STR-LATYPI sy-vline 
WA_ACPVALLINE_I_STR-TARKZ sy-vline 
WA_ACPVALLINE_I_STR-TARKZ_I sy-vline 
WA_ACPVALLINE_I_STR-VKSTA sy-vline 
WA_ACPVALLINE_I_STR-FIXVO sy-vline 
WA_ACPVALLINE_I_STR-MANIST sy-vline 
WA_ACPVALLINE_I_STR-YRATE sy-vline 
WA_ACPVALLINE_I_STR-SWSMH sy-vline 
WA_ACPVALLINE_I_STR-WAERS sy-vline 
WA_ACPVALLINE_I_STR-ROW_ID sy-vline 
WA_ACPVALLINE_I_STR-AUSEH sy-vline 
WA_ACPVALLINE_I_STR-AUS001 sy-vline 
WA_ACPVALLINE_I_STR-AUS002 sy-vline 
WA_ACPVALLINE_I_STR-AUS003 sy-vline 
WA_ACPVALLINE_I_STR-AUS004 sy-vline 
WA_ACPVALLINE_I_STR-AUS005 sy-vline 
WA_ACPVALLINE_I_STR-AUS006 sy-vline 
WA_ACPVALLINE_I_STR-AUS007 sy-vline 
WA_ACPVALLINE_I_STR-AUS008 sy-vline 
WA_ACPVALLINE_I_STR-AUS009 sy-vline 
WA_ACPVALLINE_I_STR-AUS010 sy-vline 
WA_ACPVALLINE_I_STR-AUS011 sy-vline 
WA_ACPVALLINE_I_STR-AUS012 sy-vline 
WA_ACPVALLINE_I_STR-AUS013 sy-vline 
WA_ACPVALLINE_I_STR-AUS014 sy-vline 
WA_ACPVALLINE_I_STR-AUS015 sy-vline 
WA_ACPVALLINE_I_STR-AUS016 sy-vline      INTO ld_text SEPARATED BY SPACE.

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