ABAP Select data from SAP table MIG_CVIS_EI_ADDRESS2 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 MIG_CVIS_EI_ADDRESS2 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 MIG_CVIS_EI_ADDRESS2. 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 MIG_CVIS_EI_ADDRESS2 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_MIG_CVIS_EI_ADDRESS2 TYPE STANDARD TABLE OF MIG_CVIS_EI_ADDRESS2,
      WA_MIG_CVIS_EI_ADDRESS2 TYPE MIG_CVIS_EI_ADDRESS2,
      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: <MIG_CVIS_EI_ADDRESS2> TYPE MIG_CVIS_EI_ADDRESS2.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MIG_CVIS_EI_ADDRESS2
*  INTO TABLE @DATA(IT_MIG_CVIS_EI_ADDRESS22).
*--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_MIG_CVIS_EI_ADDRESS2 INDEX 1 INTO DATA(WA_MIG_CVIS_EI_ADDRESS22).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MIG_CVIS_EI_ADDRESS2>-ADDR_VERSPST = 1.
<MIG_CVIS_EI_ADDRESS2>-FROM_DATEPST = 1.
<MIG_CVIS_EI_ADDRESS2>-TO_DATEPST = 1.
<MIG_CVIS_EI_ADDRESS2>-TITLE_PPST = 1.
<MIG_CVIS_EI_ADDRESS2>-FIRSTNAMEPST = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MIG_CVIS_EI_ADDRESS2-LASTNAMEPST, sy-vline,
  WA_MIG_CVIS_EI_ADDRESS2-BIRTH_NAMEPST, sy-vline,
  WA_MIG_CVIS_EI_ADDRESS2-MIDDLENAMEPST, sy-vline,
  WA_MIG_CVIS_EI_ADDRESS2-SECONDNAMEPST, sy-vline,
  WA_MIG_CVIS_EI_ADDRESS2-FULLNAMEPST, sy-vline,
  WA_MIG_CVIS_EI_ADDRESS2-FULLNAME_XPST, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MIG_CVIS_EI_ADDRESS2 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_MIG_CVIS_EI_ADDRESS2 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_MIG_CVIS_EI_ADDRESS2 INTO WA_MIG_CVIS_EI_ADDRESS2.


*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 ISOLA, internal->external for field LANGU_PPST
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_MIG_CVIS_EI_ADDRESS2-LANGU_PPST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MIG_CVIS_EI_ADDRESS2-LANGU_PPST.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field TOWNSHIP_CODEPST
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MIG_CVIS_EI_ADDRESS2-TOWNSHIP_CODEPST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MIG_CVIS_EI_ADDRESS2-TOWNSHIP_CODEPST.
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_MIG_CVIS_EI_ADDRESS2_STR, 
ADDR_VERSPST TYPE STRING,
FROM_DATEPST TYPE STRING,
TO_DATEPST TYPE STRING,
TITLE_PPST TYPE STRING,
FIRSTNAMEPST TYPE STRING,
LASTNAMEPST TYPE STRING,
BIRTH_NAMEPST TYPE STRING,
MIDDLENAMEPST TYPE STRING,
SECONDNAMEPST TYPE STRING,
FULLNAMEPST TYPE STRING,
FULLNAME_XPST TYPE STRING,
TITLE_ACA1PST TYPE STRING,
TITLE_ACA2PST TYPE STRING,
PREFIX1PST TYPE STRING,
PREFIX2PST TYPE STRING,
TITLE_SPPLPST TYPE STRING,
NICKNAMEPST TYPE STRING,
INITIALSPST TYPE STRING,
NAMEFORMATPST TYPE STRING,
NAMCOUNTRYPST TYPE STRING,
NAMCTRYISOPST TYPE STRING,
PROFESSIONPST TYPE STRING,
SEXPST TYPE STRING,
LANGU_PPST TYPE STRING,
LANGUP_ISOPST TYPE STRING,
SORT1_PPST TYPE STRING,
SORT2_PPST TYPE STRING,
LANGU_CR_PPST TYPE STRING,
LANGUCPISOPST TYPE STRING,
C_O_NAMEPST TYPE STRING,
CITYPST TYPE STRING,
DISTRICTPST TYPE STRING,
CITY_NOPST TYPE STRING,
DISTRCT_NOPST TYPE STRING,
CHCKSTATUSPST TYPE STRING,
REGIOGROUPPST TYPE STRING,
POSTL_COD1PST TYPE STRING,
POSTL_COD2PST TYPE STRING,
PCODE1_EXTPST TYPE STRING,
PCODE2_EXTPST TYPE STRING,
PO_BOXPST TYPE STRING,
PO_W_O_NOPST TYPE STRING,
PO_BOX_CITPST TYPE STRING,
PBOXCIT_NOPST TYPE STRING,
PO_BOX_REGPST TYPE STRING,
POBOX_CTRYPST TYPE STRING,
PO_CTRYISOPST TYPE STRING,
DELIV_DISPST TYPE STRING,
TRANSPZONEPST TYPE STRING,
STREETPST TYPE STRING,
STREET_NOPST TYPE STRING,
STR_ABBRPST TYPE STRING,
HOUSE_NOPST TYPE STRING,
HOUSE_NO2PST TYPE STRING,
HOUSE_NO3PST TYPE STRING,
STR_SUPPL1PST TYPE STRING,
STR_SUPPL2PST TYPE STRING,
STR_SUPPL3PST TYPE STRING,
LOCATIONPST TYPE STRING,
BUILDINGPST TYPE STRING,
FLOORPST TYPE STRING,
ROOM_NOPST TYPE STRING,
COUNTRYPST TYPE STRING,
COUNTRYISOPST TYPE STRING,
REGIONPST TYPE STRING,
EXTENS_1PST TYPE STRING,
EXTENS_2PST TYPE STRING,
TIME_ZONEPST TYPE STRING,
TAXJURCODEPST TYPE STRING,
ADDRESS_IDPST TYPE STRING,
LANGU_CRPST TYPE STRING,
LANGUCRISOPST TYPE STRING,
COMM_TYPEPST TYPE STRING,
PERS_GROUPPST TYPE STRING,
ADDR_GROUPPST TYPE STRING,
HOME_CITYPST TYPE STRING,
HOMECITYNOPST TYPE STRING,
DONT_USE_SPST TYPE STRING,
DONT_USE_PPST TYPE STRING,
PO_BOX_LOBBYPST TYPE STRING,
DELI_SERV_TYPEPST TYPE STRING,
DELI_SERV_NUMBERPST TYPE STRING,
COUNTY_CODEPST TYPE STRING,
COUNTYPST TYPE STRING,
TOWNSHIP_CODEPST TYPE STRING,
TOWNSHIPPST TYPE STRING,
GENDERPST TYPE STRING,
CURRENT_STATEREM TYPE STRING,
REMARKSREM TYPE STRING,
PHONECOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
PHONECOM TYPE STRING,
FAXCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
FAXCOM TYPE STRING,
TTXCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
TTXCOM TYPE STRING,
TLXCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
TLXCOM TYPE STRING,
SMTPCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
SMTPCOM TYPE STRING,
RMLCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
RMLCOM TYPE STRING,
X400COM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
X400COM TYPE STRING,
RFCCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
RFCCOM TYPE STRING,
PRTCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
PRTCOM TYPE STRING,
SSFCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
SSFCOM TYPE STRING,
URICOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
URICOM TYPE STRING,
PAGERCOM TYPE STRING,
CURRENT_STATECOM TYPE STRING,
PAGERCOM TYPE STRING,
CURRENT_STATEVER TYPE STRING,
VERSIONSVER TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MIG_CVIS_EI_ADDRESS2_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_MIG_CVIS_EI_ADDRESS2_STR-ADDR_VERSPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-FROM_DATEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TO_DATEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TITLE_PPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-FIRSTNAMEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-LASTNAMEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-BIRTH_NAMEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-MIDDLENAMEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-SECONDNAMEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-FULLNAMEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-FULLNAME_XPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TITLE_ACA1PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TITLE_ACA2PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PREFIX1PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PREFIX2PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TITLE_SPPLPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-NICKNAMEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-INITIALSPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-NAMEFORMATPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-NAMCOUNTRYPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-NAMCTRYISOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PROFESSIONPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-SEXPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-LANGU_PPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-LANGUP_ISOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-SORT1_PPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-SORT2_PPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-LANGU_CR_PPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-LANGUCPISOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-C_O_NAMEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CITYPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-DISTRICTPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CITY_NOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-DISTRCT_NOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CHCKSTATUSPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-REGIOGROUPPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-POSTL_COD1PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-POSTL_COD2PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PCODE1_EXTPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PCODE2_EXTPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PO_BOXPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PO_W_O_NOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PO_BOX_CITPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PBOXCIT_NOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PO_BOX_REGPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-POBOX_CTRYPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PO_CTRYISOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-DELIV_DISPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TRANSPZONEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-STREETPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-STREET_NOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-STR_ABBRPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-HOUSE_NOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-HOUSE_NO2PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-HOUSE_NO3PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-STR_SUPPL1PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-STR_SUPPL2PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-STR_SUPPL3PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-LOCATIONPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-BUILDINGPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-FLOORPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-ROOM_NOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-COUNTRYPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-COUNTRYISOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-REGIONPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-EXTENS_1PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-EXTENS_2PST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TIME_ZONEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TAXJURCODEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-ADDRESS_IDPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-LANGU_CRPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-LANGUCRISOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-COMM_TYPEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PERS_GROUPPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-ADDR_GROUPPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-HOME_CITYPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-HOMECITYNOPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-DONT_USE_SPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-DONT_USE_PPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PO_BOX_LOBBYPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-DELI_SERV_TYPEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-DELI_SERV_NUMBERPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-COUNTY_CODEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-COUNTYPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TOWNSHIP_CODEPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TOWNSHIPPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-GENDERPST sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATEREM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-REMARKSREM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PHONECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PHONECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-FAXCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-FAXCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TTXCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TTXCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TLXCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-TLXCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-SMTPCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-SMTPCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-RMLCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-RMLCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-X400COM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-X400COM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-RFCCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-RFCCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PRTCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PRTCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-SSFCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-SSFCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-URICOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-URICOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PAGERCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATECOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-PAGERCOM sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-CURRENT_STATEVER sy-vline 
WA_MIG_CVIS_EI_ADDRESS2_STR-VERSIONSVER sy-vline      INTO ld_text SEPARATED BY SPACE.

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