ABAP Select data from SAP table PIQCORR_STRU_S00_STUDENT 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 PIQCORR_STRU_S00_STUDENT 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 PIQCORR_STRU_S00_STUDENT. 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 PIQCORR_STRU_S00_STUDENT 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_PIQCORR_STRU_S00_STUDENT TYPE STANDARD TABLE OF PIQCORR_STRU_S00_STUDENT,
      WA_PIQCORR_STRU_S00_STUDENT TYPE PIQCORR_STRU_S00_STUDENT,
      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: <PIQCORR_STRU_S00_STUDENT> TYPE PIQCORR_STRU_S00_STUDENT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PIQCORR_STRU_S00_STUDENT
*  INTO TABLE @DATA(IT_PIQCORR_STRU_S00_STUDENT2).
*--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_PIQCORR_STRU_S00_STUDENT INDEX 1 INTO DATA(WA_PIQCORR_STRU_S00_STUDENT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PIQCORR_STRU_S00_STUDENT>-WA_STUDENT = 1.
<PIQCORR_STRU_S00_STUDENT>-PLVAR = 1.
<PIQCORR_STRU_S00_STUDENT>-OTYPE = 1.
<PIQCORR_STRU_S00_STUDENT>-OBJID = 1.
<PIQCORR_STRU_S00_STUDENT>-WA_STD_ADDR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PIQCORR_STRU_S00_STUDENT-STANDARDADDRESS, sy-vline,
  WA_PIQCORR_STRU_S00_STUDENT-C_O_NAME, sy-vline,
  WA_PIQCORR_STRU_S00_STUDENT-CITY, sy-vline,
  WA_PIQCORR_STRU_S00_STUDENT-DISTRICT, sy-vline,
  WA_PIQCORR_STRU_S00_STUDENT-REGIOGROUP, sy-vline,
  WA_PIQCORR_STRU_S00_STUDENT-POSTL_COD1, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PIQCORR_STRU_S00_STUDENT 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_PIQCORR_STRU_S00_STUDENT 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_PIQCORR_STRU_S00_STUDENT INTO WA_PIQCORR_STRU_S00_STUDENT.


*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_PIQCORR_STRU_S00_STUDENT-LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-LANGU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field MOVE_ADDRESS
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PIQCORR_STRU_S00_STUDENT-MOVE_ADDRESS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-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_PIQCORR_STRU_S00_STUDENT-CITY_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-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_PIQCORR_STRU_S00_STUDENT-DISTRCT_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-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_PIQCORR_STRU_S00_STUDENT-PBOXCIT_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-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_PIQCORR_STRU_S00_STUDENT-STREET_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-STREET_NO.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHA, internal->external for field COUNTY_NO
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PIQCORR_STRU_S00_STUDENT-COUNTY_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-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_PIQCORR_STRU_S00_STUDENT-TOWNSHIP_NO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-TOWNSHIP_NO.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit PDATE, internal->external for field DATE_BIRTH
CALL FUNCTION 'CONVERSION_EXIT_PDATE_OUTPUT'
  EXPORTING
    input =                      WA_PIQCORR_STRU_S00_STUDENT-DATE_BIRTH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-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_PIQCORR_STRU_S00_STUDENT-CORRESP_LANGUAGE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-CORRESP_LANGUAGE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PDATE, internal->external for field DATE_BIRTH
CALL FUNCTION 'CONVERSION_EXIT_PDATE_OUTPUT'
  EXPORTING
    input =                      WA_PIQCORR_STRU_S00_STUDENT-DATE_BIRTH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-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_PIQCORR_STRU_S00_STUDENT-CORRESP_LANGUAGE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQCORR_STRU_S00_STUDENT-CORRESP_LANGUAGE.
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_PIQCORR_STRU_S00_STUDENT_STR, 
WA_STUDENT TYPE STRING,
PLVAR TYPE STRING,
OTYPE TYPE STRING,
OBJID TYPE STRING,
WA_STD_ADDR 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,
WA_STD_ADDRT 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,
WA_STATUS TYPE STRING,
CONFIDENTIALITY TYPE STRING,
WA_STATUST TYPE STRING,
CONFIDENTIALITY TYPE STRING,
CONFIDENTIALITY_TXT TYPE STRING,
WA_CAMPUS TYPE STRING,
CAMPUS TYPE STRING,
WA_CAMPUST TYPE STRING,
CAMPUS TYPE STRING,
CAMPUS_TXT TYPE STRING,
CAMPUS_SHT TYPE STRING,
WA_ORGUNIT TYPE STRING,
ASSIGNED_ORGUNIT TYPE STRING,
WA_ORGUNITT TYPE STRING,
ASSIGNED_ORGUNIT TYPE STRING,
ASSIGNED_ORGUNIT_TXT TYPE STRING,
ASSIGNED_ORGUNIT_SHT TYPE STRING,
WA_FEEDAT TYPE STRING,
STUDENT_FEE_CATEG TYPE STRING,
BENEFIT_CATEG TYPE STRING,
PERS_DISCOUNT1 TYPE STRING,
PERS_DISCOUNT2 TYPE STRING,
PERS_DISCOUNT3 TYPE STRING,
PERS_DISCOUNT4 TYPE STRING,
PERS_DISCOUNT5 TYPE STRING,
PERS_DISCOUNT6 TYPE STRING,
WA_FEEDATT 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,
WA_STUDY TYPE STRING,
ALTERNAT_STUDENT_NO TYPE STRING,
STUDENTGRP TYPE STRING,
REGISTWINDOW TYPE STRING,
WA_STUDYT TYPE STRING,
ALTERNAT_STUDENT_NO TYPE STRING,
STUDENTGRP TYPE STRING,
STUDENTGRP_TXT TYPE STRING,
REGISTWINDOW TYPE STRING,
WA_RESIDENCY TYPE STRING,
RESIDENCY_STATUS TYPE STRING,
RESIDENCY_COUNTRY TYPE STRING,
RESIDENCY_COUNTRY_ISO TYPE STRING,
RESIDENCY_REGION TYPE STRING,
RESIDENCY_COUNTY TYPE STRING,
PASSPORT_NUMBER TYPE STRING,
ORIGIN TYPE STRING,
WA_RESIDENCYT 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,
WA_CHALLENGE TYPE STRING,
CHALL_GRP TYPE STRING,
CHALL_PERC TYPE STRING,
CHALL_TYPE TYPE STRING,
DATE_CHALL_CERT TYPE STRING,
WA_CHALLENGET 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,
WA_ADDPERS TYPE STRING,
RELIGION TYPE STRING,
ETHNIC_GRP TYPE STRING,
JOB TYPE STRING,
SOCIAL_GRP TYPE STRING,
SERVICE_STATUS 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,
DRIVERS_LICENSE_REGION TYPE STRING,
WA_ADDPERST 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,
WA_STNO TYPE STRING,
STUDENTID TYPE STRING,
WA_PERSDATA TYPE STRING,
FORM_OF_ADDRESS_KEY TYPE STRING,
INITIALS TYPE STRING,
FIRST_NAME TYPE STRING,
LAST_NAME TYPE STRING,
MIDDLE_NAME TYPE STRING,
TITEL TYPE STRING,
NAME_AFFIX TYPE STRING,
ARISTOCRATIC_TITLE 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,
REGION_OF_BIRTH TYPE STRING,
NATIONALITY_AT_BIRTH TYPE STRING,
NATIONALITY_AT_BIRTH_ISO TYPE STRING,
NATIONALITY TYPE STRING,
NATIONALITY_ISO TYPE STRING,
SECOND_NATIONALITY TYPE STRING,
SECOND_NATIONALITY_ISO TYPE STRING,
THIRD_NATIONALITY TYPE STRING,
THIRD_NATIONALITY_ISO TYPE STRING,
GENDER_KEY TYPE STRING,
MARITAL_STATUS TYPE STRING,
PERSIDNO TYPE STRING,
CORRESP_LANGUAGE TYPE STRING,
CORRESP_LANGUAGE_ISO TYPE STRING,
DEATH_DATE TYPE STRING,
DEATH_REGDATE TYPE STRING,
WA_PERSDATAT 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,
T_IDENT TYPE STRING,
T_PROGR TYPE STRING,
T_STATINDIC TYPE STRING,
T_STUD_SEG TYPE STRING,
T_STUD_SES TYPE STRING,
T_STUD_ADM TYPE STRING,
T_STUD_SPEC TYPE STRING,
T_STUD_AGD TYPE STRING,
T_PINDEX TYPE STRING,
T_ACWORK TYPE STRING,
T_CONFQ TYPE STRING,
T_ADDRESS TYPE STRING,
T_EXT_TEST TYPE STRING,
T_EXT_TR_H TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PIQCORR_STRU_S00_STUDENT_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_PIQCORR_STRU_S00_STUDENT_STR-WA_STUDENT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PLVAR sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-OTYPE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-OBJID sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_STD_ADDR sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STANDARDADDRESS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-C_O_NAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DISTRICT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-REGIOGROUP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-POSTL_COD1 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-POSTL_COD2 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-POSTL_COD3 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PCODE1_EXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PCODE2_EXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PCODE3_EXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_W_O_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX_CIT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX_REG sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-POBOX_CTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_CTRYISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STREET sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STR_ABBR sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOUSE_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOUSE_NO2 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOUSE_NO3 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STR_SUPPL1 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STR_SUPPL2 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STR_SUPPL3 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LOCATION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-BUILDING sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-FLOOR sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ROOM_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTRYISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-REGION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TIME_ZONE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TAXJURCODE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOME_CITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TRANSPZONE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LANGU sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LANGUISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COMM_TYPE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-EXTADDRESSNUMBER sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DONT_USE_P sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DONT_USE_S sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-MOVE_DATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-MOVE_ADDRESS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-VALIDFROMDATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-VALIDTODATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-MOVE_ADDR_GUID sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CITY_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DISTRCT_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHCKSTATUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PBOXCIT_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STREET_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOMECITYNO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX_LOBBY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DELI_SERV_TYPE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DELI_SERV_NUMBER sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTY_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TOWNSHIP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TOWNSHIP_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_STD_ADDRT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STANDARDADDRESS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-C_O_NAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DISTRICT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-REGIOGROUP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFREGIOGROUP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-POSTL_COD1 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-POSTL_COD2 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-POSTL_COD3 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PCODE1_EXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PCODE2_EXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PCODE3_EXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_W_O_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX_CIT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX_REG sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX_NAMEOFSTATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-POBOX_CTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_CTRYISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PO_BOX_NAMEOFCOUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STREET sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STR_ABBR sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOUSE_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOUSE_NO2 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOUSE_NO3 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STR_SUPPL1 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STR_SUPPL2 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STR_SUPPL3 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LOCATION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-BUILDING sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-FLOOR sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ROOM_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTRYISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFCOUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-REGION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFSTATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TIME_ZONE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TAXJURCODE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-HOME_CITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TRANSPZONE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LANGU sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LANGUISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LANGUAGE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COMM_TYPE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COMM_TYPE_TEXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_STATUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CONFIDENTIALITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_STATUST sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CONFIDENTIALITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CONFIDENTIALITY_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_CAMPUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CAMPUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_CAMPUST sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CAMPUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CAMPUS_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CAMPUS_SHT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_ORGUNIT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ASSIGNED_ORGUNIT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_ORGUNITT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ASSIGNED_ORGUNIT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ASSIGNED_ORGUNIT_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ASSIGNED_ORGUNIT_SHT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_FEEDAT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STUDENT_FEE_CATEG sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-BENEFIT_CATEG sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT1 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT2 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT3 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT4 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT5 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT6 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_FEEDATT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STUDENT_FEE_CATEG sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STUDENT_FEE_CATEG_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-BENEFIT_CATEG sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-BENEFIT_CATEG_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT1 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT1_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT2 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT2_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT3 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT3_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT4 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT4_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT5 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT5_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT6 sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERS_DISCOUNT6_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_STUDY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ALTERNAT_STUDENT_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STUDENTGRP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-REGISTWINDOW sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_STUDYT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ALTERNAT_STUDENT_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STUDENTGRP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STUDENTGRP_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-REGISTWINDOW sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_RESIDENCY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_STATUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_COUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_COUNTRY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_REGION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_COUNTY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PASSPORT_NUMBER sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ORIGIN sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_RESIDENCYT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_STATUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_STATUS_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_COUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_COUNTRY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFRESIDENCYCOUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_REGION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFRESIDENCYSTATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RESIDENCY_COUNTY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFRESIDENCYCOUNTY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PASSPORT_NUMBER sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ORIGIN sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ORIGIN_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_CHALLENGE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHALL_GRP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHALL_PERC sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHALL_TYPE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DATE_CHALL_CERT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_CHALLENGET sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHALL_GRP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHALL_GRP_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHALL_PERC sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHALL_TYPE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CHALL_TYPE_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DATE_CHALL_CERT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_ADDPERS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RELIGION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ETHNIC_GRP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-JOB sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SOCIAL_GRP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SERVICE_STATUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SERVICE_NUMBER sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-VETERAN_NUMBER sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DRIVERS_LICENSE_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DRIVERS_LICENSE_COUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DRIVERS_LICENSE_COUNTRY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DRIVERS_LICENSE_REGION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_ADDPERST sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RELIGION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-RELIGION_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ETHNIC_GRP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ETHNIC_GRP_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-JOB sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-JOB_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SOCIAL_GRP sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SOCIAL_GRP_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SERVICE_STATUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SERVICE_STATUS_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SERVICE_NUMBER sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-VETERAN_NUMBER sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DRIVERS_LICENSE_NO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DRIVERS_LICENSE_COUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DRIVERS_LICENSE_COUNTRY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFLICENCECOUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DRIVERS_LICENSE_REGION sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFLICENSESTATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_STNO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-STUDENTID sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_PERSDATA sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-FORM_OF_ADDRESS_KEY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-INITIALS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-FIRST_NAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LAST_NAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-MIDDLE_NAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TITEL sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAME_AFFIX sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ARISTOCRATIC_TITLE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NICKNAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAME_AT_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DATE_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-BIRTHPLACE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTRY_OF_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTRY_OF_BIRTH_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-REGION_OF_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY_AT_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY_AT_BIRTH_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SECOND_NATIONALITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SECOND_NATIONALITY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-THIRD_NATIONALITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-THIRD_NATIONALITY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-GENDER_KEY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-MARITAL_STATUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERSIDNO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CORRESP_LANGUAGE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CORRESP_LANGUAGE_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DEATH_DATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DEATH_REGDATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-WA_PERSDATAT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-FORM_OF_ADDRESS_KEY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-FORM_OF_ADDRESS_KEY_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-INITIALS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-FIRST_NAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-LAST_NAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-MIDDLE_NAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TITEL sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-TITEL_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAME_AFFIX sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAME_AFFIX_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ARISTOCRATIC_TITLE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-ARISTOCRATIC_TITLE_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NICKNAME sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAME_AT_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DATE_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-BIRTHPLACE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTRY_OF_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-COUNTRY_OF_BIRTH_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFBIRTHCOUNTRY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-REGION_OF_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NAMEOFBIRTHSTATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY_AT_BIRTH sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY_AT_BIRTH_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY_AT_BIRTH_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-NATIONALITY_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SECOND_NATIONALITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SECOND_NATIONALITY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-SECOND_NATIONALITY_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-THIRD_NATIONALITY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-THIRD_NATIONALITY_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-THIRD_NATIONALITY_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-GENDER_KEY sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-GENDER_KEY_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-MARITAL_STATUS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-MARITAL_STATUS_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-PERSIDNO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CORRESP_LANGUAGE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CORRESP_LANGUAGE_ISO sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-CORRESP_LANGUAGE_TXT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DEATH_DATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-DEATH_REGDATE sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_IDENT sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_PROGR sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_STATINDIC sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_STUD_SEG sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_STUD_SES sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_STUD_ADM sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_STUD_SPEC sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_STUD_AGD sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_PINDEX sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_ACWORK sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_CONFQ sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_ADDRESS sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_EXT_TEST sy-vline 
WA_PIQCORR_STRU_S00_STUDENT_STR-T_EXT_TR_H sy-vline      INTO ld_text SEPARATED BY SPACE.

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