ABAP Select data from SAP table PIQ_STUDENTLDB_DETAILDATA 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_DETAILDATA 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_DETAILDATA. 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_DETAILDATA 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_DETAILDATA TYPE STANDARD TABLE OF PIQ_STUDENTLDB_DETAILDATA,
      WA_PIQ_STUDENTLDB_DETAILDATA TYPE PIQ_STUDENTLDB_DETAILDATA,
      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_DETAILDATA> TYPE PIQ_STUDENTLDB_DETAILDATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PIQ_STUDENTLDB_DETAILDATA
*  INTO TABLE @DATA(IT_PIQ_STUDENTLDB_DETAILDATA2).
*--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_DETAILDATA INDEX 1 INTO DATA(WA_PIQ_STUDENTLDB_DETAILDATA2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PIQ_STUDENTLDB_DETAILDATA>-PLVAR = 1.
<PIQ_STUDENTLDB_DETAILDATA>-OTYPE = 1.
<PIQ_STUDENTLDB_DETAILDATA>-OBJID = 1.
<PIQ_STUDENTLDB_DETAILDATA>-FLAG1_DETAIL3 = 1.
<PIQ_STUDENTLDB_DETAILDATA>-STUDENTNUMBER = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PIQ_STUDENTLDB_DETAILDATA-FORM_OF_ADDRESS_KEY, sy-vline,
  WA_PIQ_STUDENTLDB_DETAILDATA-FORM_OF_ADDRESS_KEY_TXT, sy-vline,
  WA_PIQ_STUDENTLDB_DETAILDATA-INITIALS, sy-vline,
  WA_PIQ_STUDENTLDB_DETAILDATA-FIRST_NAME, sy-vline,
  WA_PIQ_STUDENTLDB_DETAILDATA-LAST_NAME, sy-vline,
  WA_PIQ_STUDENTLDB_DETAILDATA-MIDDLE_NAME, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PIQ_STUDENTLDB_DETAILDATA 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_DETAILDATA 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_DETAILDATA INTO WA_PIQ_STUDENTLDB_DETAILDATA.


*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 PIQST, internal->external for field STUDENTNUMBER
CALL FUNCTION 'CONVERSION_EXIT_PIQST_OUTPUT'
  EXPORTING
    input =                      WA_PIQ_STUDENTLDB_DETAILDATA-STUDENTNUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_DETAILDATA-STUDENTNUMBER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PDATE, internal->external for field DATE_BIRTH
CALL FUNCTION 'CONVERSION_EXIT_PDATE_OUTPUT'
  EXPORTING
    input =                      WA_PIQ_STUDENTLDB_DETAILDATA-DATE_BIRTH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_DETAILDATA-DATE_BIRTH.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ISOLA, internal->external for field LANGU
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_PIQ_STUDENTLDB_DETAILDATA-LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_DETAILDATA-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_DETAILDATA-E_MAIL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_DETAILDATA-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_DETAILDATA-PRINT_DEST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_DETAILDATA-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_DETAILDATA-REM_LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_DETAILDATA-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_DETAILDATA-COM_LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_STUDENTLDB_DETAILDATA-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_DETAILDATA_STR, 
PLVAR TYPE STRING,
OTYPE TYPE STRING,
OBJID TYPE STRING,
FLAG1_DETAIL3 TYPE STRING,
STUDENTNUMBER TYPE STRING,
FORM_OF_ADDRESS_KEY TYPE STRING,
FORM_OF_ADDRESS_KEY_TXT TYPE STRING,
INITIALS TYPE STRING,
FIRST_NAME TYPE STRING,
LAST_NAME TYPE STRING,
MIDDLE_NAME TYPE STRING,
TITEL TYPE STRING,
TITEL_TXT TYPE STRING,
NAME_AFFIX TYPE STRING,
NAME_AFFIX_TXT TYPE STRING,
ARISTOCRATIC_TITLE TYPE STRING,
ARISTOCRATIC_TITLE_TXT TYPE STRING,
NICKNAME TYPE STRING,
NAME_AT_BIRTH TYPE STRING,
DATE_BIRTH TYPE STRING,
BIRTHPLACE TYPE STRING,
COUNTRY_OF_BIRTH TYPE STRING,
COUNTRY_OF_BIRTH_ISO TYPE STRING,
NAMEOFBIRTHCOUNTRY TYPE STRING,
REGION_OF_BIRTH TYPE STRING,
NAMEOFBIRTHSTATE TYPE STRING,
NATIONALITY_AT_BIRTH TYPE STRING,
NATIONALITY_AT_BIRTH_ISO TYPE STRING,
NATIONALITY_AT_BIRTH_TXT TYPE STRING,
NATIONALITY TYPE STRING,
NATIONALITY_ISO TYPE STRING,
NATIONALITY_TXT TYPE STRING,
SECOND_NATIONALITY TYPE STRING,
SECOND_NATIONALITY_ISO TYPE STRING,
SECOND_NATIONALITY_TXT TYPE STRING,
THIRD_NATIONALITY TYPE STRING,
THIRD_NATIONALITY_ISO TYPE STRING,
THIRD_NATIONALITY_TXT TYPE STRING,
GENDER_KEY TYPE STRING,
GENDER_KEY_TXT TYPE STRING,
MARITAL_STATUS TYPE STRING,
MARITAL_STATUS_TXT TYPE STRING,
PERSIDNO TYPE STRING,
CORRESP_LANGUAGE TYPE STRING,
CORRESP_LANGUAGE_ISO TYPE STRING,
CORRESP_LANGUAGE_TXT TYPE STRING,
DEATH_DATE TYPE STRING,
DEATH_REGDATE TYPE STRING,
RELIGION TYPE STRING,
RELIGION_TXT TYPE STRING,
ETHNIC_GRP TYPE STRING,
ETHNIC_GRP_TXT TYPE STRING,
JOB TYPE STRING,
JOB_TXT TYPE STRING,
SOCIAL_GRP TYPE STRING,
SOCIAL_GRP_TXT TYPE STRING,
SERVICE_STATUS TYPE STRING,
SERVICE_STATUS_TXT TYPE STRING,
SERVICE_NUMBER TYPE STRING,
VETERAN_NUMBER TYPE STRING,
DRIVERS_LICENSE_NO TYPE STRING,
DRIVERS_LICENSE_COUNTRY TYPE STRING,
DRIVERS_LICENSE_COUNTRY_ISO TYPE STRING,
NAMEOFLICENCECOUNTRY TYPE STRING,
DRIVERS_LICENSE_REGION TYPE STRING,
NAMEOFLICENSESTATE TYPE STRING,
CHALL_GRP TYPE STRING,
CHALL_GRP_TXT TYPE STRING,
CHALL_PERC TYPE STRING,
CHALL_TYPE TYPE STRING,
CHALL_TYPE_TXT TYPE STRING,
DATE_CHALL_CERT TYPE STRING,
RESIDENCY_STATUS TYPE STRING,
RESIDENCY_STATUS_TXT TYPE STRING,
RESIDENCY_COUNTRY TYPE STRING,
RESIDENCY_COUNTRY_ISO TYPE STRING,
NAMEOFRESIDENCYCOUNTRY TYPE STRING,
RESIDENCY_REGION TYPE STRING,
NAMEOFRESIDENCYSTATE TYPE STRING,
RESIDENCY_COUNTY TYPE STRING,
NAMEOFRESIDENCYCOUNTY TYPE STRING,
PASSPORT_NUMBER TYPE STRING,
ORIGIN TYPE STRING,
ORIGIN_TXT TYPE STRING,
ALTERNAT_STUDENT_NO TYPE STRING,
STUDENTGRP TYPE STRING,
STUDENTGRP_TXT TYPE STRING,
REGISTWINDOW TYPE STRING,
STUDENT_FEE_CATEG TYPE STRING,
STUDENT_FEE_CATEG_TXT TYPE STRING,
BENEFIT_CATEG TYPE STRING,
BENEFIT_CATEG_TXT TYPE STRING,
PERS_DISCOUNT1 TYPE STRING,
PERS_DISCOUNT1_TXT TYPE STRING,
PERS_DISCOUNT2 TYPE STRING,
PERS_DISCOUNT2_TXT TYPE STRING,
PERS_DISCOUNT3 TYPE STRING,
PERS_DISCOUNT3_TXT TYPE STRING,
PERS_DISCOUNT4 TYPE STRING,
PERS_DISCOUNT4_TXT TYPE STRING,
PERS_DISCOUNT5 TYPE STRING,
PERS_DISCOUNT5_TXT TYPE STRING,
PERS_DISCOUNT6 TYPE STRING,
PERS_DISCOUNT6_TXT TYPE STRING,
ASSIGNED_ORGUNIT TYPE STRING,
ASSIGNED_ORGUNIT_TXT TYPE STRING,
ASSIGNED_ORGUNIT_SHT TYPE STRING,
CAMPUS TYPE STRING,
CAMPUS_TXT TYPE STRING,
CAMPUS_SHT TYPE STRING,
CONFIDENTIALITY TYPE STRING,
CONFIDENTIALITY_TXT TYPE STRING,
FLAG2_DETAIL3 TYPE STRING,
IDENTIFICATIONTYPE TYPE STRING,
IDENTIFICATIONNUMBER TYPE STRING,
FROM_DATE TYPE STRING,
TO_DATE TYPE STRING,
ISSUING_INSTITUTION TYPE STRING,
DATE_OF_ISSUE TYPE STRING,
ISSUING_COUNTRY TYPE STRING,
ISSUING_COUNTRY_ISO TYPE STRING,
FLAG1_ADDRESS TYPE STRING,
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,
FLAG2_ADDRESS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PIQ_STUDENTLDB_DETAILDATA_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_DETAILDATA_STR-PLVAR sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-OTYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-OBJID sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FLAG1_DETAIL3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STUDENTNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FORM_OF_ADDRESS_KEY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FORM_OF_ADDRESS_KEY_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-INITIALS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FIRST_NAME sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-LAST_NAME sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-MIDDLE_NAME sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TITEL sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TITEL_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAME_AFFIX sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAME_AFFIX_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ARISTOCRATIC_TITLE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ARISTOCRATIC_TITLE_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NICKNAME sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAME_AT_BIRTH sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DATE_BIRTH sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-BIRTHPLACE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COUNTRY_OF_BIRTH sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COUNTRY_OF_BIRTH_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFBIRTHCOUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-REGION_OF_BIRTH sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFBIRTHSTATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NATIONALITY_AT_BIRTH sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NATIONALITY_AT_BIRTH_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NATIONALITY_AT_BIRTH_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NATIONALITY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NATIONALITY_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NATIONALITY_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SECOND_NATIONALITY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SECOND_NATIONALITY_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SECOND_NATIONALITY_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-THIRD_NATIONALITY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-THIRD_NATIONALITY_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-THIRD_NATIONALITY_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-GENDER_KEY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-GENDER_KEY_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-MARITAL_STATUS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-MARITAL_STATUS_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERSIDNO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CORRESP_LANGUAGE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CORRESP_LANGUAGE_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CORRESP_LANGUAGE_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DEATH_DATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DEATH_REGDATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RELIGION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RELIGION_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ETHNIC_GRP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ETHNIC_GRP_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-JOB sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-JOB_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SOCIAL_GRP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SOCIAL_GRP_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SERVICE_STATUS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SERVICE_STATUS_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SERVICE_NUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-VETERAN_NUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DRIVERS_LICENSE_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DRIVERS_LICENSE_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DRIVERS_LICENSE_COUNTRY_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFLICENCECOUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DRIVERS_LICENSE_REGION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFLICENSESTATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CHALL_GRP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CHALL_GRP_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CHALL_PERC sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CHALL_TYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CHALL_TYPE_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DATE_CHALL_CERT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RESIDENCY_STATUS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RESIDENCY_STATUS_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RESIDENCY_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RESIDENCY_COUNTRY_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFRESIDENCYCOUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RESIDENCY_REGION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFRESIDENCYSTATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RESIDENCY_COUNTY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFRESIDENCYCOUNTY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PASSPORT_NUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ORIGIN sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ORIGIN_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ALTERNAT_STUDENT_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STUDENTGRP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STUDENTGRP_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-REGISTWINDOW sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STUDENT_FEE_CATEG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STUDENT_FEE_CATEG_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-BENEFIT_CATEG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-BENEFIT_CATEG_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT1 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT1_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT2_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT3_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT4 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT4_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT5 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT5_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT6 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PERS_DISCOUNT6_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ASSIGNED_ORGUNIT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ASSIGNED_ORGUNIT_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ASSIGNED_ORGUNIT_SHT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CAMPUS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CAMPUS_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CAMPUS_SHT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CONFIDENTIALITY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CONFIDENTIALITY_TXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FLAG2_DETAIL3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-IDENTIFICATIONTYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-IDENTIFICATIONNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FROM_DATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TO_DATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ISSUING_INSTITUTION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DATE_OF_ISSUE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ISSUING_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ISSUING_COUNTRY_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FLAG1_ADDRESS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STANDARDADDRESS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-C_O_NAME sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CITY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DISTRICT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-REGIOGROUP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFREGIOGROUP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-POSTL_COD1 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-POSTL_COD2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-POSTL_COD3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PCODE1_EXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PCODE2_EXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PCODE3_EXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PO_BOX sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PO_W_O_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PO_BOX_CIT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PO_BOX_REG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PO_BOX_NAMEOFSTATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-POBOX_CTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PO_CTRYISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PO_BOX_NAMEOFCOUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STREET sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STR_ABBR sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-HOUSE_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-HOUSE_NO2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-HOUSE_NO3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STR_SUPPL1 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STR_SUPPL2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STR_SUPPL3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-LOCATION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-BUILDING sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FLOOR sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ROOM_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFCOUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-REGION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-NAMEOFSTATE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TIME_ZONE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TAXJURCODE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-HOME_CITY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TRANSPZONE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-LANGU sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-LANGUISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-LANGUAGE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COMM_TYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COMM_TYPE_TEXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TELEPHONE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_EXTENSION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TEL_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-CALLER_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PHONE_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_EXTENSION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SENDER_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_GROUP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FAX_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TTX_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TTX_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TTX_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TELETEX sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TTX_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TTX_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TTX_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TTX_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TTX_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TLX_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TLX_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TLX_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TELEX_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TLX_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TLX_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TLX_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TLX_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TLX_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SMTP_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-E_MAIL sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-EMAIL_SRCH sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SMTP_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SMTP_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ENCODE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SMTP_TNEF sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SMTP_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SMTP_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SMTP_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RML_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SYMB_DEST sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-REC_TYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-R_MAIL_CLT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-R_MAIL sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RML_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RML_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RML_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RML_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RML_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ADM_DOM sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PRIV_DOM sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ORGANIZATN sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ORG_UNIT_1 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ORG_UNIT_2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ORG_UNIT_3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ORG_UNIT_4 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-LASTNAME sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FIRSTNAME sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_INITIALS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-GENERATION sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X_121_ADDR sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TERM_ID sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TERM_TYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-UANID sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TYPE1 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-VALUE1 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TYPE2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-VALUE2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TYPE3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-VALUE3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DDA_TYPE4 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-DDA_VALUE4 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-TXT_ENCODE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_TNEF sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-X400_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RFC_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-LOG_DEST sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RFC_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RFC_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RFC_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RFC_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RFC_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PRT_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PRINT_DEST sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PRT_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PRT_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PRT_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PRT_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSF_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSF_DUMMY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSF_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSF_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSF_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-RFCDEST sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDSHORT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSF_NS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSF_PROF sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART1 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART4 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART5 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART6 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART7 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART8 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSFIDPART9 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-SSF_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_TYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART1 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART2 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART3 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART4 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART5 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART6 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART7 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART8 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_PART9 sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-URI_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_COUNTRY sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_COUNTRYISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_STD_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAGER_TYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAGER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAGER_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_CALLER_NO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_STD_RECIP sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_R_3_USER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_HOME_FLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-PAG_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ADDR_VERS sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-REM_LANGU sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-REM_LANGU_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ADR_NOTES sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-REM_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COM_COMM_TYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COM_LANGU sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COM_LANGU_ISO sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COMM_NOTES sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COM_CONSNUMBER sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-COM_ERRORFLAG sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ADDRESSTYPE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-ADDRESSTYPETEXT sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-STANDARDADDRESSUSAGE sy-vline 
WA_PIQ_STUDENTLDB_DETAILDATA_STR-FLAG2_ADDRESS sy-vline      INTO ld_text SEPARATED BY SPACE.

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