ABAP Select data from SAP table RCA80 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 RCA80 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 RCA80. 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 RCA80 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_RCA80 TYPE STANDARD TABLE OF RCA80,
      WA_RCA80 TYPE RCA80,
      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: <RCA80> TYPE RCA80.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RCA80
*  INTO TABLE @DATA(IT_RCA802).
*--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_RCA80 INDEX 1 INTO DATA(WA_RCA802).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<RCA80>-MANDT = 1.
<RCA80>-ARBPL = 1.
<RCA80>-ARBPL_N = 1.
<RCA80>-KOKRS = 1.
<RCA80>-KOKRS_N = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RCA80-KOSTL, sy-vline,
  WA_RCA80-KOSTL_N, sy-vline,
  WA_RCA80-WERKS, sy-vline,
  WA_RCA80-WERKS_N, sy-vline,
  WA_RCA80-ARBID, sy-vline,
  WA_RCA80-ARBID_N, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_RCA80 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_RCA80 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_RCA80 INTO WA_RCA80.


*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_RCA80-KOSTL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RCA80-KOSTL.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit FHMAR, internal->external for field FHMAR
CALL FUNCTION 'CONVERSION_EXIT_FHMAR_OUTPUT'
  EXPORTING
    input =                      WA_RCA80-FHMAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RCA80-FHMAR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit FHMAR, internal->external for field FHMAR_N
CALL FUNCTION 'CONVERSION_EXIT_FHMAR_OUTPUT'
  EXPORTING
    input =                      WA_RCA80-FHMAR_N
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RCA80-FHMAR_N.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field EQPNT_N
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_RCA80-EQPNT_N
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_RCA80-EQPNT_N.
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_RCA80_STR, 
MANDT TYPE STRING,
ARBPL TYPE STRING,
ARBPL_N TYPE STRING,
KOKRS TYPE STRING,
KOKRS_N TYPE STRING,
KOSTL TYPE STRING,
KOSTL_N TYPE STRING,
WERKS TYPE STRING,
WERKS_N TYPE STRING,
ARBID TYPE STRING,
ARBID_N TYPE STRING,
KTEXT TYPE STRING,
KTEXT_N TYPE STRING,
DATUV_NARB TYPE STRING,
AENNR TYPE STRING,
KTSCH TYPE STRING,
KTSCH_N TYPE STRING,
KTSCH_REF TYPE STRING,
KTSCH_REFN TYPE STRING,
KTSCH_CHN TYPE STRING,
LAR01 TYPE STRING,
LAR01_N TYPE STRING,
LAR01_REF TYPE STRING,
LAR01_REFN TYPE STRING,
LAR01_CHN TYPE STRING,
LAR02 TYPE STRING,
LAR02_N TYPE STRING,
LAR02_REF TYPE STRING,
LAR02_REFN TYPE STRING,
LAR02_CHN TYPE STRING,
LAR03 TYPE STRING,
LAR03_N TYPE STRING,
LAR03_REF TYPE STRING,
LAR03_REFN TYPE STRING,
LAR03_CHN TYPE STRING,
LAR04 TYPE STRING,
LAR04_N TYPE STRING,
LAR04_REF TYPE STRING,
LAR04_REFN TYPE STRING,
LAR04_CHN TYPE STRING,
LAR05 TYPE STRING,
LAR05_N TYPE STRING,
LAR05_REF TYPE STRING,
LAR05_REFN TYPE STRING,
LAR05_CHN TYPE STRING,
LAR06 TYPE STRING,
LAR06_N TYPE STRING,
LAR06_REF TYPE STRING,
LAR06_REFN TYPE STRING,
LAR06_CHN TYPE STRING,
LOANZ TYPE STRING,
LOANZ_N TYPE STRING,
LOANZ_REF TYPE STRING,
LOANZ_REFN TYPE STRING,
LOANZ_CHN TYPE STRING,
LOART TYPE STRING,
LOART_N TYPE STRING,
LOART_REF TYPE STRING,
LOART_REFN TYPE STRING,
LOART_CHN TYPE STRING,
LOGRP TYPE STRING,
LOGRP_N TYPE STRING,
LOGRP_REF TYPE STRING,
LOGRP_REFN TYPE STRING,
LOGRP_CHN TYPE STRING,
QUALF TYPE STRING,
QUALF_N TYPE STRING,
QUALF_REF TYPE STRING,
QUALF_REFN TYPE STRING,
QUALF_CHN TYPE STRING,
RASCH TYPE STRING,
RASCH_N TYPE STRING,
RASCH_REF TYPE STRING,
RASCH_REFN TYPE STRING,
RASCH_CHN TYPE STRING,
STATUS TYPE STRING,
STATUS_N TYPE STRING,
STEUS TYPE STRING,
STEUS_N TYPE STRING,
STEUS_REF TYPE STRING,
STEUS_REFN TYPE STRING,
STEUS_CHN TYPE STRING,
RSANZ TYPE STRING,
RSANZ_N TYPE STRING,
RSANZ_REF TYPE STRING,
RSANZREF_N TYPE STRING,
RSANZ_CHN TYPE STRING,
VGW01 TYPE STRING,
VGW01_N TYPE STRING,
VGE01 TYPE STRING,
VGE01_N TYPE STRING,
VGW01_CHN TYPE STRING,
VGW02 TYPE STRING,
VGW02_N TYPE STRING,
VGE02 TYPE STRING,
VGE02_N TYPE STRING,
VGW02_CHN TYPE STRING,
VGW03 TYPE STRING,
VGW03_N TYPE STRING,
VGE03 TYPE STRING,
VGE03_N TYPE STRING,
VGW03_CHN TYPE STRING,
VGW04 TYPE STRING,
VGW04_N TYPE STRING,
VGE04 TYPE STRING,
VGE04_N TYPE STRING,
VGW04_CHN TYPE STRING,
VGW05 TYPE STRING,
VGW05_N TYPE STRING,
VGE05 TYPE STRING,
VGE05_N TYPE STRING,
VGW05_CHN TYPE STRING,
VGW06 TYPE STRING,
VGW06_N TYPE STRING,
VGE06 TYPE STRING,
VGE06_N TYPE STRING,
VGW06_CHN TYPE STRING,
PARTX01 TYPE STRING,
PARTX02 TYPE STRING,
PARTX03 TYPE STRING,
PARTX04 TYPE STRING,
PARTX05 TYPE STRING,
PARTX06 TYPE STRING,
VGWTS TYPE STRING,
VGWTS_N TYPE STRING,
PLNTY_V TYPE STRING,
PLNTY_B TYPE STRING,
STATU_V TYPE STRING,
STATU_B TYPE STRING,
VERWE_V TYPE STRING,
VERWE_B TYPE STRING,
VAGRP_V TYPE STRING,
VAGRP_B TYPE STRING,
MATNR_V TYPE STRING,
MATNR_B TYPE STRING,
MAKTX_V TYPE STRING,
MAKTX_B TYPE STRING,
PLNTY TYPE STRING,
PLNNR TYPE STRING,
PLNNR_S TYPE STRING,
PLNNR_N TYPE STRING,
KTEXT_S TYPE STRING,
KTEXT_SN TYPE STRING,
BUKRS TYPE STRING,
VERWE TYPE STRING,
STATU TYPE STRING,
PLNAL TYPE STRING,
PLNAL_N TYPE STRING,
FHMAR TYPE STRING,
FHMAR_N TYPE STRING,
SFHNR TYPE STRING,
SFHNR_N TYPE STRING,
MATNR TYPE STRING,
MATNR_N TYPE STRING,
FHKTX TYPE STRING,
FHKTX_N TYPE STRING,
FHWRK TYPE STRING,
FHWRK_N TYPE STRING,
F_OBJTY TYPE STRING,
F_OBJID TYPE STRING,
BDCFUNC TYPE STRING,
BDCMODE TYPE STRING,
BDCGROUP TYPE STRING,
BTCHUSER TYPE STRING,
BDCUPMODE TYPE STRING,
VINTV TYPE STRING,
PLNAW TYPE STRING,
DOKNR TYPE STRING,
DOKNR_N TYPE STRING,
DOKTL TYPE STRING,
DOKTL_N TYPE STRING,
DOKAR TYPE STRING,
DOKAR_N TYPE STRING,
DOKVR TYPE STRING,
DOKVR_N TYPE STRING,
STYPM TYPE STRING,
STYPS TYPE STRING,
EQUNR TYPE STRING,
EQUNR_N TYPE STRING,
MRC_PLNTY TYPE STRING,
DATUV_NO TYPE STRING,
COSTR TYPE STRING,
COSTR_N TYPE STRING,
CSTYP TYPE STRING,
NGT_LST TYPE STRING,
PLANWERK TYPE STRING,
EQPNT TYPE STRING,
EQPNT_N TYPE STRING,END OF T_EKKO_STR.
DATA: WA_RCA80_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_RCA80_STR-MANDT sy-vline 
WA_RCA80_STR-ARBPL sy-vline 
WA_RCA80_STR-ARBPL_N sy-vline 
WA_RCA80_STR-KOKRS sy-vline 
WA_RCA80_STR-KOKRS_N sy-vline 
WA_RCA80_STR-KOSTL sy-vline 
WA_RCA80_STR-KOSTL_N sy-vline 
WA_RCA80_STR-WERKS sy-vline 
WA_RCA80_STR-WERKS_N sy-vline 
WA_RCA80_STR-ARBID sy-vline 
WA_RCA80_STR-ARBID_N sy-vline 
WA_RCA80_STR-KTEXT sy-vline 
WA_RCA80_STR-KTEXT_N sy-vline 
WA_RCA80_STR-DATUV_NARB sy-vline 
WA_RCA80_STR-AENNR sy-vline 
WA_RCA80_STR-KTSCH sy-vline 
WA_RCA80_STR-KTSCH_N sy-vline 
WA_RCA80_STR-KTSCH_REF sy-vline 
WA_RCA80_STR-KTSCH_REFN sy-vline 
WA_RCA80_STR-KTSCH_CHN sy-vline 
WA_RCA80_STR-LAR01 sy-vline 
WA_RCA80_STR-LAR01_N sy-vline 
WA_RCA80_STR-LAR01_REF sy-vline 
WA_RCA80_STR-LAR01_REFN sy-vline 
WA_RCA80_STR-LAR01_CHN sy-vline 
WA_RCA80_STR-LAR02 sy-vline 
WA_RCA80_STR-LAR02_N sy-vline 
WA_RCA80_STR-LAR02_REF sy-vline 
WA_RCA80_STR-LAR02_REFN sy-vline 
WA_RCA80_STR-LAR02_CHN sy-vline 
WA_RCA80_STR-LAR03 sy-vline 
WA_RCA80_STR-LAR03_N sy-vline 
WA_RCA80_STR-LAR03_REF sy-vline 
WA_RCA80_STR-LAR03_REFN sy-vline 
WA_RCA80_STR-LAR03_CHN sy-vline 
WA_RCA80_STR-LAR04 sy-vline 
WA_RCA80_STR-LAR04_N sy-vline 
WA_RCA80_STR-LAR04_REF sy-vline 
WA_RCA80_STR-LAR04_REFN sy-vline 
WA_RCA80_STR-LAR04_CHN sy-vline 
WA_RCA80_STR-LAR05 sy-vline 
WA_RCA80_STR-LAR05_N sy-vline 
WA_RCA80_STR-LAR05_REF sy-vline 
WA_RCA80_STR-LAR05_REFN sy-vline 
WA_RCA80_STR-LAR05_CHN sy-vline 
WA_RCA80_STR-LAR06 sy-vline 
WA_RCA80_STR-LAR06_N sy-vline 
WA_RCA80_STR-LAR06_REF sy-vline 
WA_RCA80_STR-LAR06_REFN sy-vline 
WA_RCA80_STR-LAR06_CHN sy-vline 
WA_RCA80_STR-LOANZ sy-vline 
WA_RCA80_STR-LOANZ_N sy-vline 
WA_RCA80_STR-LOANZ_REF sy-vline 
WA_RCA80_STR-LOANZ_REFN sy-vline 
WA_RCA80_STR-LOANZ_CHN sy-vline 
WA_RCA80_STR-LOART sy-vline 
WA_RCA80_STR-LOART_N sy-vline 
WA_RCA80_STR-LOART_REF sy-vline 
WA_RCA80_STR-LOART_REFN sy-vline 
WA_RCA80_STR-LOART_CHN sy-vline 
WA_RCA80_STR-LOGRP sy-vline 
WA_RCA80_STR-LOGRP_N sy-vline 
WA_RCA80_STR-LOGRP_REF sy-vline 
WA_RCA80_STR-LOGRP_REFN sy-vline 
WA_RCA80_STR-LOGRP_CHN sy-vline 
WA_RCA80_STR-QUALF sy-vline 
WA_RCA80_STR-QUALF_N sy-vline 
WA_RCA80_STR-QUALF_REF sy-vline 
WA_RCA80_STR-QUALF_REFN sy-vline 
WA_RCA80_STR-QUALF_CHN sy-vline 
WA_RCA80_STR-RASCH sy-vline 
WA_RCA80_STR-RASCH_N sy-vline 
WA_RCA80_STR-RASCH_REF sy-vline 
WA_RCA80_STR-RASCH_REFN sy-vline 
WA_RCA80_STR-RASCH_CHN sy-vline 
WA_RCA80_STR-STATUS sy-vline 
WA_RCA80_STR-STATUS_N sy-vline 
WA_RCA80_STR-STEUS sy-vline 
WA_RCA80_STR-STEUS_N sy-vline 
WA_RCA80_STR-STEUS_REF sy-vline 
WA_RCA80_STR-STEUS_REFN sy-vline 
WA_RCA80_STR-STEUS_CHN sy-vline 
WA_RCA80_STR-RSANZ sy-vline 
WA_RCA80_STR-RSANZ_N sy-vline 
WA_RCA80_STR-RSANZ_REF sy-vline 
WA_RCA80_STR-RSANZREF_N sy-vline 
WA_RCA80_STR-RSANZ_CHN sy-vline 
WA_RCA80_STR-VGW01 sy-vline 
WA_RCA80_STR-VGW01_N sy-vline 
WA_RCA80_STR-VGE01 sy-vline 
WA_RCA80_STR-VGE01_N sy-vline 
WA_RCA80_STR-VGW01_CHN sy-vline 
WA_RCA80_STR-VGW02 sy-vline 
WA_RCA80_STR-VGW02_N sy-vline 
WA_RCA80_STR-VGE02 sy-vline 
WA_RCA80_STR-VGE02_N sy-vline 
WA_RCA80_STR-VGW02_CHN sy-vline 
WA_RCA80_STR-VGW03 sy-vline 
WA_RCA80_STR-VGW03_N sy-vline 
WA_RCA80_STR-VGE03 sy-vline 
WA_RCA80_STR-VGE03_N sy-vline 
WA_RCA80_STR-VGW03_CHN sy-vline 
WA_RCA80_STR-VGW04 sy-vline 
WA_RCA80_STR-VGW04_N sy-vline 
WA_RCA80_STR-VGE04 sy-vline 
WA_RCA80_STR-VGE04_N sy-vline 
WA_RCA80_STR-VGW04_CHN sy-vline 
WA_RCA80_STR-VGW05 sy-vline 
WA_RCA80_STR-VGW05_N sy-vline 
WA_RCA80_STR-VGE05 sy-vline 
WA_RCA80_STR-VGE05_N sy-vline 
WA_RCA80_STR-VGW05_CHN sy-vline 
WA_RCA80_STR-VGW06 sy-vline 
WA_RCA80_STR-VGW06_N sy-vline 
WA_RCA80_STR-VGE06 sy-vline 
WA_RCA80_STR-VGE06_N sy-vline 
WA_RCA80_STR-VGW06_CHN sy-vline 
WA_RCA80_STR-PARTX01 sy-vline 
WA_RCA80_STR-PARTX02 sy-vline 
WA_RCA80_STR-PARTX03 sy-vline 
WA_RCA80_STR-PARTX04 sy-vline 
WA_RCA80_STR-PARTX05 sy-vline 
WA_RCA80_STR-PARTX06 sy-vline 
WA_RCA80_STR-VGWTS sy-vline 
WA_RCA80_STR-VGWTS_N sy-vline 
WA_RCA80_STR-PLNTY_V sy-vline 
WA_RCA80_STR-PLNTY_B sy-vline 
WA_RCA80_STR-STATU_V sy-vline 
WA_RCA80_STR-STATU_B sy-vline 
WA_RCA80_STR-VERWE_V sy-vline 
WA_RCA80_STR-VERWE_B sy-vline 
WA_RCA80_STR-VAGRP_V sy-vline 
WA_RCA80_STR-VAGRP_B sy-vline 
WA_RCA80_STR-MATNR_V sy-vline 
WA_RCA80_STR-MATNR_B sy-vline 
WA_RCA80_STR-MAKTX_V sy-vline 
WA_RCA80_STR-MAKTX_B sy-vline 
WA_RCA80_STR-PLNTY sy-vline 
WA_RCA80_STR-PLNNR sy-vline 
WA_RCA80_STR-PLNNR_S sy-vline 
WA_RCA80_STR-PLNNR_N sy-vline 
WA_RCA80_STR-KTEXT_S sy-vline 
WA_RCA80_STR-KTEXT_SN sy-vline 
WA_RCA80_STR-BUKRS sy-vline 
WA_RCA80_STR-VERWE sy-vline 
WA_RCA80_STR-STATU sy-vline 
WA_RCA80_STR-PLNAL sy-vline 
WA_RCA80_STR-PLNAL_N sy-vline 
WA_RCA80_STR-FHMAR sy-vline 
WA_RCA80_STR-FHMAR_N sy-vline 
WA_RCA80_STR-SFHNR sy-vline 
WA_RCA80_STR-SFHNR_N sy-vline 
WA_RCA80_STR-MATNR sy-vline 
WA_RCA80_STR-MATNR_N sy-vline 
WA_RCA80_STR-FHKTX sy-vline 
WA_RCA80_STR-FHKTX_N sy-vline 
WA_RCA80_STR-FHWRK sy-vline 
WA_RCA80_STR-FHWRK_N sy-vline 
WA_RCA80_STR-F_OBJTY sy-vline 
WA_RCA80_STR-F_OBJID sy-vline 
WA_RCA80_STR-BDCFUNC sy-vline 
WA_RCA80_STR-BDCMODE sy-vline 
WA_RCA80_STR-BDCGROUP sy-vline 
WA_RCA80_STR-BTCHUSER sy-vline 
WA_RCA80_STR-BDCUPMODE sy-vline 
WA_RCA80_STR-VINTV sy-vline 
WA_RCA80_STR-PLNAW sy-vline 
WA_RCA80_STR-DOKNR sy-vline 
WA_RCA80_STR-DOKNR_N sy-vline 
WA_RCA80_STR-DOKTL sy-vline 
WA_RCA80_STR-DOKTL_N sy-vline 
WA_RCA80_STR-DOKAR sy-vline 
WA_RCA80_STR-DOKAR_N sy-vline 
WA_RCA80_STR-DOKVR sy-vline 
WA_RCA80_STR-DOKVR_N sy-vline 
WA_RCA80_STR-STYPM sy-vline 
WA_RCA80_STR-STYPS sy-vline 
WA_RCA80_STR-EQUNR sy-vline 
WA_RCA80_STR-EQUNR_N sy-vline 
WA_RCA80_STR-MRC_PLNTY sy-vline 
WA_RCA80_STR-DATUV_NO sy-vline 
WA_RCA80_STR-COSTR sy-vline 
WA_RCA80_STR-COSTR_N sy-vline 
WA_RCA80_STR-CSTYP sy-vline 
WA_RCA80_STR-NGT_LST sy-vline 
WA_RCA80_STR-PLANWERK sy-vline 
WA_RCA80_STR-EQPNT sy-vline 
WA_RCA80_STR-EQPNT_N sy-vline      INTO ld_text SEPARATED BY SPACE.

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