ABAP Select data from SAP table REIS_CN_BP_L 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 REIS_CN_BP_L 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 REIS_CN_BP_L. 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 REIS_CN_BP_L 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_REIS_CN_BP_L TYPE STANDARD TABLE OF REIS_CN_BP_L,
      WA_REIS_CN_BP_L TYPE REIS_CN_BP_L,
      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: <REIS_CN_BP_L> TYPE REIS_CN_BP_L.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM REIS_CN_BP_L
*  INTO TABLE @DATA(IT_REIS_CN_BP_L2).
*--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_REIS_CN_BP_L INDEX 1 INTO DATA(WA_REIS_CN_BP_L2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<REIS_CN_BP_L>-NAMEGROUP1 = 1.
<REIS_CN_BP_L>-NAMEGROUP2 = 1.
<REIS_CN_BP_L>-GROUPTYPE = 1.
<REIS_CN_BP_L>-MANDT = 1.
<REIS_CN_BP_L>-INTRENO = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_REIS_CN_BP_L-BUKRS, sy-vline,
  WA_REIS_CN_BP_L-RECNNR, sy-vline,
  WA_REIS_CN_BP_L-OBJNR, sy-vline,
  WA_REIS_CN_BP_L-IMKEY, sy-vline,
  WA_REIS_CN_BP_L-CREATIONTYPE, sy-vline,
  WA_REIS_CN_BP_L-RERF, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_REIS_CN_BP_L 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_REIS_CN_BP_L 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_REIS_CN_BP_L INTO WA_REIS_CN_BP_L.


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

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

*Conversion exit REDAT, internal->external for field RECNENDABS
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_CN_BP_L-RECNENDABS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_BP_L-RECNENDABS.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit SWENR, internal->external for field BENOCN
CALL FUNCTION 'CONVERSION_EXIT_SWENR_OUTPUT'
  EXPORTING
    input =                      WA_REIS_CN_BP_L-BENOCN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_BP_L-BENOCN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field TRANSPOSSTO
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_CN_BP_L-TRANSPOSSTO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_BP_L-TRANSPOSSTO.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ABPSP, internal->external for field PSPNR
CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT'
  EXPORTING
    input =                      WA_REIS_CN_BP_L-PSPNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_BP_L-PSPNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit REDAT, internal->external for field VALIDTO
CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT'
  EXPORTING
    input =                      WA_REIS_CN_BP_L-VALIDTO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_BP_L-VALIDTO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SXIDN, internal->external for field SMTP_ADDR
CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT'
  EXPORTING
    input =                      WA_REIS_CN_BP_L-SMTP_ADDR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_BP_L-SMTP_ADDR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ISOLA, internal->external for field LANGU
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_REIS_CN_BP_L-LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_BP_L-LANGU.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit ISOLA, internal->external for field CORRESPONDLANGUAGE
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_REIS_CN_BP_L-CORRESPONDLANGUAGE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_REIS_CN_BP_L-CORRESPONDLANGUAGE.
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_REIS_CN_BP_L_STR, 
NAMEGROUP1 TYPE STRING,
NAMEGROUP2 TYPE STRING,
GROUPTYPE TYPE STRING,
MANDT TYPE STRING,
INTRENO TYPE STRING,
BUKRS TYPE STRING,
RECNNR TYPE STRING,
OBJNR TYPE STRING,
IMKEY TYPE STRING,
CREATIONTYPE TYPE STRING,
RERF TYPE STRING,
DERF TYPE STRING,
TERF TYPE STRING,
REHER TYPE STRING,
RBEAR TYPE STRING,
DBEAR TYPE STRING,
TBEAR TYPE STRING,
RBHER TYPE STRING,
RESPONSIBLE TYPE STRING,
USEREXCLUSIVE TYPE STRING,
AUTHGRP TYPE STRING,
RECNTYPE TYPE STRING,
RECNBEG TYPE STRING,
RECNENDABS TYPE STRING,
RECNTXT TYPE STRING,
RECNDACTIV TYPE STRING,
RECNTLAW TYPE STRING,
RECNTXTOLD TYPE STRING,
RECNBUKRSCOLLECT TYPE STRING,
RECNNRCOLLECT TYPE STRING,
RECNCNCURR TYPE STRING,
INDUSTRY TYPE STRING,
SRRELEVANT TYPE STRING,
DPTARGETTYPE TYPE STRING,
RECNDAT TYPE STRING,
RECN2DAT TYPE STRING,
RECNDPO TYPE STRING,
RECNEND1ST TYPE STRING,
RECNNOTPER TYPE STRING,
RECNNOTRECEIPT TYPE STRING,
RECNNOTREASON TYPE STRING,
RECNDAKTKU TYPE STRING,
CFARCHIVEDTO TYPE STRING,
CFLOCKEDTO TYPE STRING,
CFPOSTINGFROM TYPE STRING,
BENOCN TYPE STRING,
TRANSPOSSFROM TYPE STRING,
TRANSPOSSTO TYPE STRING,
HASMULTIASSIGN TYPE STRING,
POSSDATEFROM TYPE STRING,
POSSDATETO TYPE STRING,
RELEVANTEVAL TYPE STRING,
DUMMY_REC_PS TYPE STRING,
SECDEPRELEVANT TYPE STRING,
NOTADJSDCN TYPE STRING,
XRECNNRCOL TYPE STRING,
XBUKRS TYPE STRING,
XRECNTYPE TYPE STRING,
GSBER TYPE STRING,
PRCTR TYPE STRING,
KOSTL TYPE STRING,
AUFNR TYPE STRING,
XTENANCYLAW TYPE STRING,
XCOLLECT TYPE STRING,
XAUTHGRP TYPE STRING,
XINDUSTRY TYPE STRING,
XTRANSPOSSPERIOD TYPE STRING,
PSPNR TYPE STRING,
XRELEVANTEVAL TYPE STRING,
KOSTLX TYPE STRING,
AUFNRX TYPE STRING,
PSPNRX TYPE STRING,
PARTNER TYPE STRING,
ROLE TYPE STRING,
SUBROLE TYPE STRING,
APPL TYPE STRING,
VALIDFROM TYPE STRING,
VALIDTO TYPE STRING,
ADDRTYPE TYPE STRING,
BRUTEIL TYPE STRING,
BMITEIG TYPE STRING,
PANTEIL TYPE STRING,
RFAKT TYPE STRING,
XNAME TYPE STRING,
XPARTNER TYPE STRING,
ROLECATE TYPE STRING,
XROLE TYPE STRING,
XSUBROLE TYPE STRING,
XOBJTYPE TYPE STRING,
IDENTKEY TYPE STRING,
TEL_NUMBER_LONG TYPE STRING,
FAX_NUMBER_LONG TYPE STRING,
SMTP_ADDR TYPE STRING,
XTITLE_ACA1 TYPE STRING,
XTITLE_ACA2 TYPE STRING,
XTITLE_SPPL TYPE STRING,
XPREFIX1 TYPE STRING,
XPREFIX2 TYPE STRING,
STANDARDADDRESS TYPE STRING,
C_O_NAME TYPE STRING,
CITY TYPE STRING,
DISTRICT TYPE STRING,
REGIOGROUP TYPE STRING,
POSTL_COD1 TYPE STRING,
POSTL_COD2 TYPE STRING,
POSTL_COD3 TYPE STRING,
PCODE1_EXT TYPE STRING,
PCODE2_EXT TYPE STRING,
PCODE3_EXT TYPE STRING,
PO_BOX TYPE STRING,
PO_W_O_NO TYPE STRING,
PO_BOX_CIT TYPE STRING,
PO_BOX_REG TYPE STRING,
POBOX_CTRY TYPE STRING,
PO_CTRYISO TYPE STRING,
STREET TYPE STRING,
STR_ABBR TYPE STRING,
HOUSE_NO TYPE STRING,
HOUSE_NO2 TYPE STRING,
HOUSE_NO3 TYPE STRING,
STR_SUPPL1 TYPE STRING,
STR_SUPPL2 TYPE STRING,
STR_SUPPL3 TYPE STRING,
LOCATION TYPE STRING,
BUILDING TYPE STRING,
FLOOR TYPE STRING,
ROOM_NO TYPE STRING,
COUNTRY TYPE STRING,
COUNTRYISO TYPE STRING,
REGION TYPE STRING,
TIME_ZONE TYPE STRING,
TAXJURCODE TYPE STRING,
HOME_CITY TYPE STRING,
TRANSPZONE TYPE STRING,
LANGU TYPE STRING,
LANGUISO TYPE STRING,
COMM_TYPE TYPE STRING,
EXTADDRESSNUMBER TYPE STRING,
DONT_USE_P TYPE STRING,
DONT_USE_S TYPE STRING,
MOVE_DATE TYPE STRING,
MOVE_ADDRESS TYPE STRING,
VALIDFROMDATE TYPE STRING,
VALIDTODATE TYPE STRING,
MOVE_ADDR_GUID TYPE STRING,
CITY_NO TYPE STRING,
DISTRCT_NO TYPE STRING,
CHCKSTATUS TYPE STRING,
PBOXCIT_NO TYPE STRING,
STREET_NO TYPE STRING,
HOMECITYNO TYPE STRING,
PO_BOX_LOBBY TYPE STRING,
DELI_SERV_TYPE TYPE STRING,
DELI_SERV_NUMBER TYPE STRING,
COUNTY TYPE STRING,
COUNTY_NO TYPE STRING,
TOWNSHIP TYPE STRING,
TOWNSHIP_NO TYPE STRING,
FIRSTNAME TYPE STRING,
LASTNAME TYPE STRING,
BIRTHNAME TYPE STRING,
MIDDLENAME TYPE STRING,
SECONDNAME TYPE STRING,
TITLE_ACA1 TYPE STRING,
TITLE_ACA2 TYPE STRING,
TITLE_SPPL TYPE STRING,
PREFIX1 TYPE STRING,
PREFIX2 TYPE STRING,
NICKNAME TYPE STRING,
INITIALS TYPE STRING,
NAMEFORMAT TYPE STRING,
NAMCOUNTRY TYPE STRING,
NAMCOUNTRYISO TYPE STRING,
SEX TYPE STRING,
BIRTHPLACE TYPE STRING,
BIRTHDATE TYPE STRING,
DEATHDATE TYPE STRING,
MARITALSTATUS TYPE STRING,
CORRESPONDLANGUAGE TYPE STRING,
CORRESPONDLANGUAGEISO TYPE STRING,
FULLNAME TYPE STRING,
EMPLOYER TYPE STRING,
OCCUPATION TYPE STRING,
NATIONALITY TYPE STRING,
NATIONALITYISO TYPE STRING,
COUNTRYORIGIN TYPE STRING,
BIRTHDT_STATUS TYPE STRING,
GENDER TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
NAME3 TYPE STRING,
NAME4 TYPE STRING,
LEGALFORM TYPE STRING,
INDUSTRYSECTORKEYSYSTEM TYPE STRING,
INDUSTRYSECTOR TYPE STRING,
FOUNDATIONDATE TYPE STRING,
LIQUIDATIONDATE TYPE STRING,
LOC_NO_1 TYPE STRING,
LOC_NO_2 TYPE STRING,
CHK_DIGIT TYPE STRING,
LEGALORG TYPE STRING,
RECISVALIDFROM TYPE STRING,
RECISVALIDTO TYPE STRING,
XSEX TYPE STRING,
MOB_NUMBER TYPE STRING,END OF T_EKKO_STR.
DATA: WA_REIS_CN_BP_L_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_REIS_CN_BP_L_STR-NAMEGROUP1 sy-vline 
WA_REIS_CN_BP_L_STR-NAMEGROUP2 sy-vline 
WA_REIS_CN_BP_L_STR-GROUPTYPE sy-vline 
WA_REIS_CN_BP_L_STR-MANDT sy-vline 
WA_REIS_CN_BP_L_STR-INTRENO sy-vline 
WA_REIS_CN_BP_L_STR-BUKRS sy-vline 
WA_REIS_CN_BP_L_STR-RECNNR sy-vline 
WA_REIS_CN_BP_L_STR-OBJNR sy-vline 
WA_REIS_CN_BP_L_STR-IMKEY sy-vline 
WA_REIS_CN_BP_L_STR-CREATIONTYPE sy-vline 
WA_REIS_CN_BP_L_STR-RERF sy-vline 
WA_REIS_CN_BP_L_STR-DERF sy-vline 
WA_REIS_CN_BP_L_STR-TERF sy-vline 
WA_REIS_CN_BP_L_STR-REHER sy-vline 
WA_REIS_CN_BP_L_STR-RBEAR sy-vline 
WA_REIS_CN_BP_L_STR-DBEAR sy-vline 
WA_REIS_CN_BP_L_STR-TBEAR sy-vline 
WA_REIS_CN_BP_L_STR-RBHER sy-vline 
WA_REIS_CN_BP_L_STR-RESPONSIBLE sy-vline 
WA_REIS_CN_BP_L_STR-USEREXCLUSIVE sy-vline 
WA_REIS_CN_BP_L_STR-AUTHGRP sy-vline 
WA_REIS_CN_BP_L_STR-RECNTYPE sy-vline 
WA_REIS_CN_BP_L_STR-RECNBEG sy-vline 
WA_REIS_CN_BP_L_STR-RECNENDABS sy-vline 
WA_REIS_CN_BP_L_STR-RECNTXT sy-vline 
WA_REIS_CN_BP_L_STR-RECNDACTIV sy-vline 
WA_REIS_CN_BP_L_STR-RECNTLAW sy-vline 
WA_REIS_CN_BP_L_STR-RECNTXTOLD sy-vline 
WA_REIS_CN_BP_L_STR-RECNBUKRSCOLLECT sy-vline 
WA_REIS_CN_BP_L_STR-RECNNRCOLLECT sy-vline 
WA_REIS_CN_BP_L_STR-RECNCNCURR sy-vline 
WA_REIS_CN_BP_L_STR-INDUSTRY sy-vline 
WA_REIS_CN_BP_L_STR-SRRELEVANT sy-vline 
WA_REIS_CN_BP_L_STR-DPTARGETTYPE sy-vline 
WA_REIS_CN_BP_L_STR-RECNDAT sy-vline 
WA_REIS_CN_BP_L_STR-RECN2DAT sy-vline 
WA_REIS_CN_BP_L_STR-RECNDPO sy-vline 
WA_REIS_CN_BP_L_STR-RECNEND1ST sy-vline 
WA_REIS_CN_BP_L_STR-RECNNOTPER sy-vline 
WA_REIS_CN_BP_L_STR-RECNNOTRECEIPT sy-vline 
WA_REIS_CN_BP_L_STR-RECNNOTREASON sy-vline 
WA_REIS_CN_BP_L_STR-RECNDAKTKU sy-vline 
WA_REIS_CN_BP_L_STR-CFARCHIVEDTO sy-vline 
WA_REIS_CN_BP_L_STR-CFLOCKEDTO sy-vline 
WA_REIS_CN_BP_L_STR-CFPOSTINGFROM sy-vline 
WA_REIS_CN_BP_L_STR-BENOCN sy-vline 
WA_REIS_CN_BP_L_STR-TRANSPOSSFROM sy-vline 
WA_REIS_CN_BP_L_STR-TRANSPOSSTO sy-vline 
WA_REIS_CN_BP_L_STR-HASMULTIASSIGN sy-vline 
WA_REIS_CN_BP_L_STR-POSSDATEFROM sy-vline 
WA_REIS_CN_BP_L_STR-POSSDATETO sy-vline 
WA_REIS_CN_BP_L_STR-RELEVANTEVAL sy-vline 
WA_REIS_CN_BP_L_STR-DUMMY_REC_PS sy-vline 
WA_REIS_CN_BP_L_STR-SECDEPRELEVANT sy-vline 
WA_REIS_CN_BP_L_STR-NOTADJSDCN sy-vline 
WA_REIS_CN_BP_L_STR-XRECNNRCOL sy-vline 
WA_REIS_CN_BP_L_STR-XBUKRS sy-vline 
WA_REIS_CN_BP_L_STR-XRECNTYPE sy-vline 
WA_REIS_CN_BP_L_STR-GSBER sy-vline 
WA_REIS_CN_BP_L_STR-PRCTR sy-vline 
WA_REIS_CN_BP_L_STR-KOSTL sy-vline 
WA_REIS_CN_BP_L_STR-AUFNR sy-vline 
WA_REIS_CN_BP_L_STR-XTENANCYLAW sy-vline 
WA_REIS_CN_BP_L_STR-XCOLLECT sy-vline 
WA_REIS_CN_BP_L_STR-XAUTHGRP sy-vline 
WA_REIS_CN_BP_L_STR-XINDUSTRY sy-vline 
WA_REIS_CN_BP_L_STR-XTRANSPOSSPERIOD sy-vline 
WA_REIS_CN_BP_L_STR-PSPNR sy-vline 
WA_REIS_CN_BP_L_STR-XRELEVANTEVAL sy-vline 
WA_REIS_CN_BP_L_STR-KOSTLX sy-vline 
WA_REIS_CN_BP_L_STR-AUFNRX sy-vline 
WA_REIS_CN_BP_L_STR-PSPNRX sy-vline 
WA_REIS_CN_BP_L_STR-PARTNER sy-vline 
WA_REIS_CN_BP_L_STR-ROLE sy-vline 
WA_REIS_CN_BP_L_STR-SUBROLE sy-vline 
WA_REIS_CN_BP_L_STR-APPL sy-vline 
WA_REIS_CN_BP_L_STR-VALIDFROM sy-vline 
WA_REIS_CN_BP_L_STR-VALIDTO sy-vline 
WA_REIS_CN_BP_L_STR-ADDRTYPE sy-vline 
WA_REIS_CN_BP_L_STR-BRUTEIL sy-vline 
WA_REIS_CN_BP_L_STR-BMITEIG sy-vline 
WA_REIS_CN_BP_L_STR-PANTEIL sy-vline 
WA_REIS_CN_BP_L_STR-RFAKT sy-vline 
WA_REIS_CN_BP_L_STR-XNAME sy-vline 
WA_REIS_CN_BP_L_STR-XPARTNER sy-vline 
WA_REIS_CN_BP_L_STR-ROLECATE sy-vline 
WA_REIS_CN_BP_L_STR-XROLE sy-vline 
WA_REIS_CN_BP_L_STR-XSUBROLE sy-vline 
WA_REIS_CN_BP_L_STR-XOBJTYPE sy-vline 
WA_REIS_CN_BP_L_STR-IDENTKEY sy-vline 
WA_REIS_CN_BP_L_STR-TEL_NUMBER_LONG sy-vline 
WA_REIS_CN_BP_L_STR-FAX_NUMBER_LONG sy-vline 
WA_REIS_CN_BP_L_STR-SMTP_ADDR sy-vline 
WA_REIS_CN_BP_L_STR-XTITLE_ACA1 sy-vline 
WA_REIS_CN_BP_L_STR-XTITLE_ACA2 sy-vline 
WA_REIS_CN_BP_L_STR-XTITLE_SPPL sy-vline 
WA_REIS_CN_BP_L_STR-XPREFIX1 sy-vline 
WA_REIS_CN_BP_L_STR-XPREFIX2 sy-vline 
WA_REIS_CN_BP_L_STR-STANDARDADDRESS sy-vline 
WA_REIS_CN_BP_L_STR-C_O_NAME sy-vline 
WA_REIS_CN_BP_L_STR-CITY sy-vline 
WA_REIS_CN_BP_L_STR-DISTRICT sy-vline 
WA_REIS_CN_BP_L_STR-REGIOGROUP sy-vline 
WA_REIS_CN_BP_L_STR-POSTL_COD1 sy-vline 
WA_REIS_CN_BP_L_STR-POSTL_COD2 sy-vline 
WA_REIS_CN_BP_L_STR-POSTL_COD3 sy-vline 
WA_REIS_CN_BP_L_STR-PCODE1_EXT sy-vline 
WA_REIS_CN_BP_L_STR-PCODE2_EXT sy-vline 
WA_REIS_CN_BP_L_STR-PCODE3_EXT sy-vline 
WA_REIS_CN_BP_L_STR-PO_BOX sy-vline 
WA_REIS_CN_BP_L_STR-PO_W_O_NO sy-vline 
WA_REIS_CN_BP_L_STR-PO_BOX_CIT sy-vline 
WA_REIS_CN_BP_L_STR-PO_BOX_REG sy-vline 
WA_REIS_CN_BP_L_STR-POBOX_CTRY sy-vline 
WA_REIS_CN_BP_L_STR-PO_CTRYISO sy-vline 
WA_REIS_CN_BP_L_STR-STREET sy-vline 
WA_REIS_CN_BP_L_STR-STR_ABBR sy-vline 
WA_REIS_CN_BP_L_STR-HOUSE_NO sy-vline 
WA_REIS_CN_BP_L_STR-HOUSE_NO2 sy-vline 
WA_REIS_CN_BP_L_STR-HOUSE_NO3 sy-vline 
WA_REIS_CN_BP_L_STR-STR_SUPPL1 sy-vline 
WA_REIS_CN_BP_L_STR-STR_SUPPL2 sy-vline 
WA_REIS_CN_BP_L_STR-STR_SUPPL3 sy-vline 
WA_REIS_CN_BP_L_STR-LOCATION sy-vline 
WA_REIS_CN_BP_L_STR-BUILDING sy-vline 
WA_REIS_CN_BP_L_STR-FLOOR sy-vline 
WA_REIS_CN_BP_L_STR-ROOM_NO sy-vline 
WA_REIS_CN_BP_L_STR-COUNTRY sy-vline 
WA_REIS_CN_BP_L_STR-COUNTRYISO sy-vline 
WA_REIS_CN_BP_L_STR-REGION sy-vline 
WA_REIS_CN_BP_L_STR-TIME_ZONE sy-vline 
WA_REIS_CN_BP_L_STR-TAXJURCODE sy-vline 
WA_REIS_CN_BP_L_STR-HOME_CITY sy-vline 
WA_REIS_CN_BP_L_STR-TRANSPZONE sy-vline 
WA_REIS_CN_BP_L_STR-LANGU sy-vline 
WA_REIS_CN_BP_L_STR-LANGUISO sy-vline 
WA_REIS_CN_BP_L_STR-COMM_TYPE sy-vline 
WA_REIS_CN_BP_L_STR-EXTADDRESSNUMBER sy-vline 
WA_REIS_CN_BP_L_STR-DONT_USE_P sy-vline 
WA_REIS_CN_BP_L_STR-DONT_USE_S sy-vline 
WA_REIS_CN_BP_L_STR-MOVE_DATE sy-vline 
WA_REIS_CN_BP_L_STR-MOVE_ADDRESS sy-vline 
WA_REIS_CN_BP_L_STR-VALIDFROMDATE sy-vline 
WA_REIS_CN_BP_L_STR-VALIDTODATE sy-vline 
WA_REIS_CN_BP_L_STR-MOVE_ADDR_GUID sy-vline 
WA_REIS_CN_BP_L_STR-CITY_NO sy-vline 
WA_REIS_CN_BP_L_STR-DISTRCT_NO sy-vline 
WA_REIS_CN_BP_L_STR-CHCKSTATUS sy-vline 
WA_REIS_CN_BP_L_STR-PBOXCIT_NO sy-vline 
WA_REIS_CN_BP_L_STR-STREET_NO sy-vline 
WA_REIS_CN_BP_L_STR-HOMECITYNO sy-vline 
WA_REIS_CN_BP_L_STR-PO_BOX_LOBBY sy-vline 
WA_REIS_CN_BP_L_STR-DELI_SERV_TYPE sy-vline 
WA_REIS_CN_BP_L_STR-DELI_SERV_NUMBER sy-vline 
WA_REIS_CN_BP_L_STR-COUNTY sy-vline 
WA_REIS_CN_BP_L_STR-COUNTY_NO sy-vline 
WA_REIS_CN_BP_L_STR-TOWNSHIP sy-vline 
WA_REIS_CN_BP_L_STR-TOWNSHIP_NO sy-vline 
WA_REIS_CN_BP_L_STR-FIRSTNAME sy-vline 
WA_REIS_CN_BP_L_STR-LASTNAME sy-vline 
WA_REIS_CN_BP_L_STR-BIRTHNAME sy-vline 
WA_REIS_CN_BP_L_STR-MIDDLENAME sy-vline 
WA_REIS_CN_BP_L_STR-SECONDNAME sy-vline 
WA_REIS_CN_BP_L_STR-TITLE_ACA1 sy-vline 
WA_REIS_CN_BP_L_STR-TITLE_ACA2 sy-vline 
WA_REIS_CN_BP_L_STR-TITLE_SPPL sy-vline 
WA_REIS_CN_BP_L_STR-PREFIX1 sy-vline 
WA_REIS_CN_BP_L_STR-PREFIX2 sy-vline 
WA_REIS_CN_BP_L_STR-NICKNAME sy-vline 
WA_REIS_CN_BP_L_STR-INITIALS sy-vline 
WA_REIS_CN_BP_L_STR-NAMEFORMAT sy-vline 
WA_REIS_CN_BP_L_STR-NAMCOUNTRY sy-vline 
WA_REIS_CN_BP_L_STR-NAMCOUNTRYISO sy-vline 
WA_REIS_CN_BP_L_STR-SEX sy-vline 
WA_REIS_CN_BP_L_STR-BIRTHPLACE sy-vline 
WA_REIS_CN_BP_L_STR-BIRTHDATE sy-vline 
WA_REIS_CN_BP_L_STR-DEATHDATE sy-vline 
WA_REIS_CN_BP_L_STR-MARITALSTATUS sy-vline 
WA_REIS_CN_BP_L_STR-CORRESPONDLANGUAGE sy-vline 
WA_REIS_CN_BP_L_STR-CORRESPONDLANGUAGEISO sy-vline 
WA_REIS_CN_BP_L_STR-FULLNAME sy-vline 
WA_REIS_CN_BP_L_STR-EMPLOYER sy-vline 
WA_REIS_CN_BP_L_STR-OCCUPATION sy-vline 
WA_REIS_CN_BP_L_STR-NATIONALITY sy-vline 
WA_REIS_CN_BP_L_STR-NATIONALITYISO sy-vline 
WA_REIS_CN_BP_L_STR-COUNTRYORIGIN sy-vline 
WA_REIS_CN_BP_L_STR-BIRTHDT_STATUS sy-vline 
WA_REIS_CN_BP_L_STR-GENDER sy-vline 
WA_REIS_CN_BP_L_STR-NAME1 sy-vline 
WA_REIS_CN_BP_L_STR-NAME2 sy-vline 
WA_REIS_CN_BP_L_STR-NAME3 sy-vline 
WA_REIS_CN_BP_L_STR-NAME4 sy-vline 
WA_REIS_CN_BP_L_STR-LEGALFORM sy-vline 
WA_REIS_CN_BP_L_STR-INDUSTRYSECTORKEYSYSTEM sy-vline 
WA_REIS_CN_BP_L_STR-INDUSTRYSECTOR sy-vline 
WA_REIS_CN_BP_L_STR-FOUNDATIONDATE sy-vline 
WA_REIS_CN_BP_L_STR-LIQUIDATIONDATE sy-vline 
WA_REIS_CN_BP_L_STR-LOC_NO_1 sy-vline 
WA_REIS_CN_BP_L_STR-LOC_NO_2 sy-vline 
WA_REIS_CN_BP_L_STR-CHK_DIGIT sy-vline 
WA_REIS_CN_BP_L_STR-LEGALORG sy-vline 
WA_REIS_CN_BP_L_STR-RECISVALIDFROM sy-vline 
WA_REIS_CN_BP_L_STR-RECISVALIDTO sy-vline 
WA_REIS_CN_BP_L_STR-XSEX sy-vline 
WA_REIS_CN_BP_L_STR-MOB_NUMBER sy-vline      INTO ld_text SEPARATED BY SPACE.

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