ABAP Select data from SAP table PIQ_STUDENTLDB_ADDRESSDATA 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 PIQ_STUDENTLDB_ADDRESSDATA 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 PIQ_STUDENTLDB_ADDRESSDATA. 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 PIQ_STUDENTLDB_ADDRESSDATA 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_PIQ_STUDENTLDB_ADDRESSDATA TYPE STANDARD TABLE OF PIQ_STUDENTLDB_ADDRESSDATA,
      WA_PIQ_STUDENTLDB_ADDRESSDATA TYPE PIQ_STUDENTLDB_ADDRESSDATA,
      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: <PIQ_STUDENTLDB_ADDRESSDATA> TYPE PIQ_STUDENTLDB_ADDRESSDATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PIQ_STUDENTLDB_ADDRESSDATA
*  INTO TABLE @DATA(IT_PIQ_STUDENTLDB_ADDRESSDATA2).
*--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_PIQ_STUDENTLDB_ADDRESSDATA INDEX 1 INTO DATA(WA_PIQ_STUDENTLDB_ADDRESSDATA2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PIQ_STUDENTLDB_ADDRESSDATA>-STANDARDADDRESS = 1.
<PIQ_STUDENTLDB_ADDRESSDATA>-C_O_NAME = 1.
<PIQ_STUDENTLDB_ADDRESSDATA>-CITY = 1.
<PIQ_STUDENTLDB_ADDRESSDATA>-DISTRICT = 1.
<PIQ_STUDENTLDB_ADDRESSDATA>-REGIOGROUP = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PIQ_STUDENTLDB_ADDRESSDATA-NAMEOFREGIOGROUP, sy-vline,
  WA_PIQ_STUDENTLDB_ADDRESSDATA-POSTL_COD1, sy-vline,
  WA_PIQ_STUDENTLDB_ADDRESSDATA-POSTL_COD2, sy-vline,
  WA_PIQ_STUDENTLDB_ADDRESSDATA-POSTL_COD3, sy-vline,
  WA_PIQ_STUDENTLDB_ADDRESSDATA-PCODE1_EXT, sy-vline,
  WA_PIQ_STUDENTLDB_ADDRESSDATA-PCODE2_EXT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PIQ_STUDENTLDB_ADDRESSDATA 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_PIQ_STUDENTLDB_ADDRESSDATA 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_PIQ_STUDENTLDB_ADDRESSDATA INTO WA_PIQ_STUDENTLDB_ADDRESSDATA.


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

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

*Conversion exit SPDEV, internal->external for field PRINT_DEST
CALL FUNCTION 'CONVERSION_EXIT_SPDEV_OUTPUT'
  EXPORTING
    input =                      WA_PIQ_STUDENTLDB_ADDRESSDATA-PRINT_DEST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_ADDRESSDATA-PRINT_DEST.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ISOLA, internal->external for field COM_LANGU
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_PIQ_STUDENTLDB_ADDRESSDATA-COM_LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_ADDRESSDATA-COM_LANGU.
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_PIQ_STUDENTLDB_ADDRESSDATA_STR, 
STANDARDADDRESS TYPE STRING,
C_O_NAME TYPE STRING,
CITY TYPE STRING,
DISTRICT TYPE STRING,
REGIOGROUP TYPE STRING,
NAMEOFREGIOGROUP 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,
PO_BOX_NAMEOFSTATE TYPE STRING,
POBOX_CTRY TYPE STRING,
PO_CTRYISO TYPE STRING,
PO_BOX_NAMEOFCOUNTRY 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,
NAMEOFCOUNTRY TYPE STRING,
REGION TYPE STRING,
NAMEOFSTATE TYPE STRING,
TIME_ZONE TYPE STRING,
TAXJURCODE TYPE STRING,
HOME_CITY TYPE STRING,
TRANSPZONE TYPE STRING,
LANGU TYPE STRING,
LANGUISO TYPE STRING,
LANGUAGE TYPE STRING,
COMM_TYPE TYPE STRING,
COMM_TYPE_TEXT TYPE STRING,
PHONE_COUNTRY TYPE STRING,
PHONE_COUNTRYISO TYPE STRING,
PHONE_STD_NO TYPE STRING,
TELEPHONE TYPE STRING,
PHONE_EXTENSION TYPE STRING,
TEL_NO TYPE STRING,
CALLER_NO TYPE STRING,
PHONE_STD_RECIP TYPE STRING,
PHONE_R_3_USER TYPE STRING,
PHONE_HOME_FLAG TYPE STRING,
PHONE_CONSNUMBER TYPE STRING,
PHONE_ERRORFLAG TYPE STRING,
FAX_COUNTRY TYPE STRING,
FAX_COUNTRYISO TYPE STRING,
FAX_STD_NO TYPE STRING,
FAX TYPE STRING,
FAX_EXTENSION TYPE STRING,
FAX_NO TYPE STRING,
SENDER_NO TYPE STRING,
FAX_GROUP TYPE STRING,
FAX_STD_RECIP TYPE STRING,
FAX_R_3_USER TYPE STRING,
FAX_HOME_FLAG TYPE STRING,
FAX_CONSNUMBER TYPE STRING,
FAX_ERRORFLAG TYPE STRING,
TTX_COUNTRY TYPE STRING,
TTX_COUNTRYISO TYPE STRING,
TTX_STD_NO TYPE STRING,
TELETEX TYPE STRING,
TTX_STD_RECIP TYPE STRING,
TTX_R_3_USER TYPE STRING,
TTX_HOME_FLAG TYPE STRING,
TTX_CONSNUMBER TYPE STRING,
TTX_ERRORFLAG TYPE STRING,
TLX_COUNTRY TYPE STRING,
TLX_COUNTRYISO TYPE STRING,
TLX_STD_NO TYPE STRING,
TELEX_NO TYPE STRING,
TLX_STD_RECIP TYPE STRING,
TLX_R_3_USER TYPE STRING,
TLX_HOME_FLAG TYPE STRING,
TLX_CONSNUMBER TYPE STRING,
TLX_ERRORFLAG TYPE STRING,
SMTP_STD_NO TYPE STRING,
E_MAIL TYPE STRING,
EMAIL_SRCH TYPE STRING,
SMTP_STD_RECIP TYPE STRING,
SMTP_R_3_USER TYPE STRING,
ENCODE TYPE STRING,
SMTP_TNEF TYPE STRING,
SMTP_HOME_FLAG TYPE STRING,
SMTP_CONSNUMBER TYPE STRING,
SMTP_ERRORFLAG TYPE STRING,
RML_STD_NO TYPE STRING,
SYMB_DEST TYPE STRING,
REC_TYPE TYPE STRING,
R_MAIL_CLT TYPE STRING,
R_MAIL TYPE STRING,
RML_STD_RECIP TYPE STRING,
RML_R_3_USER TYPE STRING,
RML_HOME_FLAG TYPE STRING,
RML_CONSNUMBER TYPE STRING,
RML_ERRORFLAG TYPE STRING,
X400_STD_NO TYPE STRING,
X400_COUNTRY TYPE STRING,
X400_COUNTRYISO TYPE STRING,
ADM_DOM TYPE STRING,
PRIV_DOM TYPE STRING,
ORGANIZATN TYPE STRING,
ORG_UNIT_1 TYPE STRING,
ORG_UNIT_2 TYPE STRING,
ORG_UNIT_3 TYPE STRING,
ORG_UNIT_4 TYPE STRING,
LASTNAME TYPE STRING,
FIRSTNAME TYPE STRING,
X400_INITIALS TYPE STRING,
GENERATION TYPE STRING,
X_121_ADDR TYPE STRING,
TERM_ID TYPE STRING,
TERM_TYPE TYPE STRING,
UANID TYPE STRING,
TYPE1 TYPE STRING,
VALUE1 TYPE STRING,
TYPE2 TYPE STRING,
VALUE2 TYPE STRING,
TYPE3 TYPE STRING,
VALUE3 TYPE STRING,
DDA_TYPE4 TYPE STRING,
DDA_VALUE4 TYPE STRING,
X400_STD_RECIP TYPE STRING,
X400_R_3_USER TYPE STRING,
TXT_ENCODE TYPE STRING,
X400_TNEF TYPE STRING,
X400_HOME_FLAG TYPE STRING,
X400_CONSNUMBER TYPE STRING,
X400_ERRORFLAG TYPE STRING,
RFC_STD_NO TYPE STRING,
LOG_DEST TYPE STRING,
RFC_STD_RECIP TYPE STRING,
RFC_R_3_USER TYPE STRING,
RFC_HOME_FLAG TYPE STRING,
RFC_CONSNUMBER TYPE STRING,
RFC_ERRORFLAG TYPE STRING,
PRT_STD_NO TYPE STRING,
PRINT_DEST TYPE STRING,
PRT_STD_RECIP TYPE STRING,
PRT_HOME_FLAG TYPE STRING,
PRT_CONSNUMBER TYPE STRING,
PRT_ERRORFLAG TYPE STRING,
SSF_STD_NO TYPE STRING,
SSF_DUMMY TYPE STRING,
SSF_STD_RECIP TYPE STRING,
SSF_HOME_FLAG TYPE STRING,
SSF_CONSNUMBER TYPE STRING,
RFCDEST TYPE STRING,
SSFIDSHORT TYPE STRING,
SSF_NS TYPE STRING,
SSF_PROF TYPE STRING,
SSFIDPART1 TYPE STRING,
SSFIDPART2 TYPE STRING,
SSFIDPART3 TYPE STRING,
SSFIDPART4 TYPE STRING,
SSFIDPART5 TYPE STRING,
SSFIDPART6 TYPE STRING,
SSFIDPART7 TYPE STRING,
SSFIDPART8 TYPE STRING,
SSFIDPART9 TYPE STRING,
SSF_ERRORFLAG TYPE STRING,
URI_STD_NO TYPE STRING,
URI_TYPE TYPE STRING,
URI TYPE STRING,
URI_STD_RECIP TYPE STRING,
URI_HOME_FLAG TYPE STRING,
URI_CONSNUMBER TYPE STRING,
URI_PART1 TYPE STRING,
URI_PART2 TYPE STRING,
URI_PART3 TYPE STRING,
URI_PART4 TYPE STRING,
URI_PART5 TYPE STRING,
URI_PART6 TYPE STRING,
URI_PART7 TYPE STRING,
URI_PART8 TYPE STRING,
URI_PART9 TYPE STRING,
URI_ERRORFLAG TYPE STRING,
PAG_COUNTRY TYPE STRING,
PAG_COUNTRYISO TYPE STRING,
PAG_STD_NO TYPE STRING,
PAGER_TYPE TYPE STRING,
PAGER TYPE STRING,
PAGER_NO TYPE STRING,
PAG_CALLER_NO TYPE STRING,
PAG_STD_RECIP TYPE STRING,
PAG_R_3_USER TYPE STRING,
PAG_HOME_FLAG TYPE STRING,
PAG_CONSNUMBER TYPE STRING,
PAG_ERRORFLAG TYPE STRING,
ADDR_VERS TYPE STRING,
REM_LANGU TYPE STRING,
REM_LANGU_ISO TYPE STRING,
ADR_NOTES TYPE STRING,
REM_ERRORFLAG TYPE STRING,
COM_COMM_TYPE TYPE STRING,
COM_LANGU TYPE STRING,
COM_LANGU_ISO TYPE STRING,
COMM_NOTES TYPE STRING,
COM_CONSNUMBER TYPE STRING,
COM_ERRORFLAG TYPE STRING,
ADDRESSTYPE TYPE STRING,
ADDRESSTYPETEXT TYPE STRING,
STANDARDADDRESSUSAGE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PIQ_STUDENTLDB_ADDRESSDATA_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_PIQ_STUDENTLDB_ADDRESSDATA_STR-STANDARDADDRESS sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-C_O_NAME sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-CITY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-DISTRICT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-REGIOGROUP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-NAMEOFREGIOGROUP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-POSTL_COD1 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-POSTL_COD2 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-POSTL_COD3 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PCODE1_EXT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PCODE2_EXT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PCODE3_EXT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PO_BOX sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PO_W_O_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PO_BOX_CIT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PO_BOX_REG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PO_BOX_NAMEOFSTATE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-POBOX_CTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PO_CTRYISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PO_BOX_NAMEOFCOUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-STREET sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-STR_ABBR sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-HOUSE_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-HOUSE_NO2 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-HOUSE_NO3 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-STR_SUPPL1 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-STR_SUPPL2 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-STR_SUPPL3 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-LOCATION sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-BUILDING sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FLOOR sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ROOM_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-NAMEOFCOUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-REGION sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-NAMEOFSTATE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TIME_ZONE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TAXJURCODE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-HOME_CITY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TRANSPZONE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-LANGU sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-LANGUISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-LANGUAGE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COMM_TYPE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COMM_TYPE_TEXT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TELEPHONE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_EXTENSION sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TEL_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-CALLER_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PHONE_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_EXTENSION sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SENDER_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_GROUP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FAX_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TTX_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TTX_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TTX_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TELETEX sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TTX_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TTX_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TTX_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TTX_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TTX_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TLX_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TLX_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TLX_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TELEX_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TLX_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TLX_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TLX_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TLX_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TLX_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SMTP_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-E_MAIL sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-EMAIL_SRCH sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SMTP_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SMTP_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ENCODE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SMTP_TNEF sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SMTP_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SMTP_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SMTP_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RML_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SYMB_DEST sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-REC_TYPE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-R_MAIL_CLT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-R_MAIL sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RML_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RML_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RML_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RML_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RML_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ADM_DOM sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PRIV_DOM sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ORGANIZATN sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ORG_UNIT_1 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ORG_UNIT_2 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ORG_UNIT_3 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ORG_UNIT_4 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-LASTNAME sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-FIRSTNAME sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_INITIALS sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-GENERATION sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X_121_ADDR sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TERM_ID sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TERM_TYPE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-UANID sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TYPE1 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-VALUE1 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TYPE2 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-VALUE2 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TYPE3 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-VALUE3 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-DDA_TYPE4 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-DDA_VALUE4 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-TXT_ENCODE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_TNEF sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-X400_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RFC_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-LOG_DEST sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RFC_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RFC_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RFC_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RFC_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RFC_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PRT_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PRINT_DEST sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PRT_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PRT_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PRT_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PRT_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSF_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSF_DUMMY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSF_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSF_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSF_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-RFCDEST sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDSHORT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSF_NS sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSF_PROF sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART1 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART2 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART3 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART4 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART5 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART6 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART7 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART8 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSFIDPART9 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-SSF_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_TYPE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART1 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART2 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART3 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART4 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART5 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART6 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART7 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART8 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_PART9 sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-URI_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAGER_TYPE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAGER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAGER_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_CALLER_NO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-PAG_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ADDR_VERS sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-REM_LANGU sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-REM_LANGU_ISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ADR_NOTES sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-REM_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COM_COMM_TYPE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COM_LANGU sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COM_LANGU_ISO sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COMM_NOTES sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COM_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-COM_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ADDRESSTYPE sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-ADDRESSTYPETEXT sy-vline 
WA_PIQ_STUDENTLDB_ADDRESSDATA_STR-STANDARDADDRESSUSAGE sy-vline      INTO ld_text SEPARATED BY SPACE.

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