ABAP Select data from SAP table PIQ_US_ITEM_S 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_US_ITEM_S 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_US_ITEM_S. 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_US_ITEM_S 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_US_ITEM_S TYPE STANDARD TABLE OF PIQ_US_ITEM_S,
      WA_PIQ_US_ITEM_S TYPE PIQ_US_ITEM_S,
      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_US_ITEM_S> TYPE PIQ_US_ITEM_S.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PIQ_US_ITEM_S
*  INTO TABLE @DATA(IT_PIQ_US_ITEM_S2).
*--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_US_ITEM_S INDEX 1 INTO DATA(WA_PIQ_US_ITEM_S2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PIQ_US_ITEM_S>-PIQ_US_ITEM = 1.
<PIQ_US_ITEM_S>-IPEDSREPORT_DATEIDT = 1.
<PIQ_US_ITEM_S>-STUDENTNUMBER = 1.
<PIQ_US_ITEM_S>-FIRST_NAME = 1.
<PIQ_US_ITEM_S>-LAST_NAME = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PIQ_US_ITEM_S-DATE_BIRTH, sy-vline,
  WA_PIQ_US_ITEM_S-GENDER_KEY, sy-vline,
  WA_PIQ_US_ITEM_S-STD_ETHNIC, sy-vline,
  WA_PIQ_US_ITEM_S-ETHNIC_GRP_TXT, sy-vline,
  WA_PIQ_US_ITEM_S-RESIDENCY_STATUS, sy-vline,
  WA_PIQ_US_ITEM_S-RESIDENCY_STATUS_TXT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PIQ_US_ITEM_S 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_US_ITEM_S 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_US_ITEM_S INTO WA_PIQ_US_ITEM_S.


*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_US_ITEM_S-STUDENTNUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_US_ITEM_S-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_US_ITEM_S-DATE_BIRTH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_US_ITEM_S-DATE_BIRTH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PIQST, internal->external for field STUDENTNUMBER
CALL FUNCTION 'CONVERSION_EXIT_PIQST_OUTPUT'
  EXPORTING
    input =                      WA_PIQ_US_ITEM_S-STUDENTNUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_US_ITEM_S-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_US_ITEM_S-DATE_BIRTH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_US_ITEM_S-DATE_BIRTH.
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_US_ITEM_S_STR, 
PIQ_US_ITEM TYPE STRING,
IPEDSREPORT_DATEIDT TYPE STRING,
STUDENTNUMBER TYPE STRING,
FIRST_NAME TYPE STRING,
LAST_NAME TYPE STRING,
DATE_BIRTH TYPE STRING,
GENDER_KEY TYPE STRING,
STD_ETHNIC TYPE STRING,
ETHNIC_GRP_TXT TYPE STRING,
RESIDENCY_STATUS TYPE STRING,
RESIDENCY_STATUS_TXT TYPE STRING,
RESIDENCY_COUNTRY TYPE STRING,
RESIDENCY_REGION TYPE STRING,
STUDENT_OBJECTID TYPE STRING,
STUDY_OBJECTID TYPE STRING,
PROGRAM_OBJECTID TYPE STRING,
OPTLENGTH TYPE STRING,
TIMEUNIT TYPE STRING,
GRPVAR TYPE STRING,
GRPVARTXT TYPE STRING,
PROG_TYPE TYPE STRING,
PROG_TYPET TYPE STRING,
PROGRESSION_RESULT TYPE STRING,
MODULEGROUP_OBJECTID TYPE STRING,
MODULEGROUP_CATEGORY TYPE STRING,
CATEGORY_TEXT TYPE STRING,
MODULEGROUP_PRIORITY TYPE STRING,
ADMIS_CATEGORY TYPE STRING,
QUAL_LEVEL TYPE STRING,
QUAL_CLASS TYPE STRING,
CQ_OTYPE TYPE STRING,
CQ_OBJID TYPE STRING,
VALID_FROM TYPE STRING,
ACAD_YEAR TYPE STRING,
ACAC_SESSION TYPE STRING,
REGIST_DATE TYPE STRING,
PARTTIME TYPE STRING,
PROGCLASS TYPE STRING,
CLASS_BEGDATE TYPE STRING,
DISPL TYPE STRING,
MAJOR1 TYPE STRING,
MAJOR1TEXT TYPE STRING,
MAJOR1PRIO TYPE STRING,
MAJOR1DISP TYPE STRING,
MAJOR1DISPTEXT TYPE STRING,
MAJOR2 TYPE STRING,
MAJOR2TEXT TYPE STRING,
MAJOR2PRIO TYPE STRING,
MAJOR2DISP TYPE STRING,
MAJOR2DISPTEXT TYPE STRING,
CIPCODE_DERIVE TYPE STRING,
US_STUDENTLEVEL TYPE STRING,
STUDENT_LEVELT TYPE STRING,
US_ETHNIC TYPE STRING,
ETHNICT TYPE STRING,
US_CIPCODE TYPE STRING,
END_PROCESS TYPE STRING,
END_REASON TYPE STRING,
END_KEY_DATE TYPE STRING,
AWARD_LEVEL TYPE STRING,
AWARD_LEVELT TYPE STRING,
FIRST_TIME TYPE STRING,
SECOND_MAJOR TYPE STRING,
DEGREE_SEEKING TYPE STRING,
CERTI_SEEKING TYPE STRING,
FALLENROLLMENT TYPE STRING,
FPRCD TYPE STRING,
SPORTS_TYPE TYPE STRING,
SVBYEAR TYPE STRING,
SVBSESSION TYPE STRING,
SVEYEAR TYPE STRING,
SVESESSION TYPE STRING,
SCHOLARSHIP TYPE STRING,
TRANSTYPE TYPE STRING,
REPSTATE TYPE STRING,
ISSUEDATE TYPE STRING,
HIGH_SCHOOL TYPE STRING,
CATEGORY TYPE STRING,
MGCATMAJOR TYPE STRING,
RESID_STATUS TYPE STRING,
DEREG_REASON TYPE STRING,
FIRST_YEAR TYPE STRING,
GRS_LINE_SEC23 TYPE STRING,
GRS_LINE_SEC6 TYPE STRING,
ST_GRS5 TYPE STRING,
ST_GRS6 TYPE STRING,
FE_LINE_PARTA TYPE STRING,
FE_LINE_PARTB TYPE STRING,
FE_EFRES01_PARTC TYPE STRING,
FE_EFRES02_PARTC TYPE STRING,
FE_EFE01_PARTD TYPE STRING,
FE_CREDHRSU_PARTF TYPE STRING,
FE_CONTHRS_PARTF TYPE STRING,
FE_CREDHRSG_PARTF TYPE STRING,
FE_REP_YEAR_PARTF TYPE STRING,
BACHELOR_DEGREE TYPE STRING,
IPEDSREPORT_DATEID TYPE STRING,
ACTION TYPE STRING,
TESTCODE TYPE STRING,
P1SCORE TYPE STRING,
P2SCORE TYPE STRING,
P3SCORE TYPE STRING,
P4SCORE TYPE STRING,
P5SCORE TYPE STRING,
TESTDATE TYPE STRING,
SCRRECDATE TYPE STRING,
SATSCORE TYPE STRING,
ACTSCORE TYPE STRING,
COMMENTS TYPE STRING,
CLASSDESC TYPE STRING,
DEGREEID TYPE STRING,
DEGREEDATE TYPE STRING,
FULTIME TYPE STRING,
SASTMT TYPE STRING,
SAAFFIRM TYPE STRING,
DRUGTEST TYPE STRING,
SAAIDID TYPE STRING,
FUNDCODE TYPE STRING,
AWARDDATE TYPE STRING,
AWARDPERIOD TYPE STRING,
AWARDAMT TYPE STRING,
SPORTCODE TYPE STRING,
ROLLOVERFLAG TYPE STRING,
SCHOOLAIDID TYPE STRING,
VALUE TYPE STRING,
GUARDIANNAME TYPE STRING,
ADDRESS1 TYPE STRING,
ADDRESS2 TYPE STRING,
PROVINCE TYPE STRING,
COUNTRY TYPE STRING,
XFERTYPE TYPE STRING,
STUDID TYPE STRING,
SSN TYPE STRING,
NCAA_GENDER TYPE STRING,
RECRUITED TYPE STRING,
EMAIL TYPE STRING,
PHONE TYPE STRING,
CELLPHONE TYPE STRING,
ONCAMPUS TYPE STRING,
STATRES TYPE STRING,
RACECODE TYPE STRING,
HSGRADDATE TYPE STRING,
FULENRTMANY TYPE STRING,
FULENTMHERE TYPE STRING,
FULENYRANY TYPE STRING,
FULENYRHERE TYPE STRING,
ORGID TYPE STRING,
ORGPWD TYPE STRING,
USERID TYPE STRING,
USERPWD TYPE STRING,
MIDDLE_NAME TYPE STRING,
NCAA_DOB TYPE STRING,
SPORTCODE_AWARD TYPE STRING,
CHANGEDATE TYPE STRING,
CHANGESTATUS TYPE STRING,
PIQ_US_NSCH_ITEM TYPE STRING,
ORG_OBJECTID TYPE STRING,
STUDENT_OBJID TYPE STRING,
STUDENTNUMBER TYPE STRING,
PERSIDNO TYPE STRING,
FIRST_NAME TYPE STRING,
MIDDLE_NAME TYPE STRING,
LAST_NAME TYPE STRING,
INITIALS TYPE STRING,
NAME_AT_BIRTH TYPE STRING,
ENROLLMENT_STATUS TYPE STRING,
ENROLL_START_DATE TYPE STRING,
STREET TYPE STRING,
STR_SUPPL1 TYPE STRING,
CITY TYPE STRING,
REGION TYPE STRING,
POSTL_COD1 TYPE STRING,
COUNTRY TYPE STRING,
ANTICIP_GRAD_DATE TYPE STRING,
DATE_BIRTH TYPE STRING,
TERM_BEGDA TYPE STRING,
TERM_ENDDA TYPE STRING,
NSCH_GRAD_LEVEL TYPE STRING,
DATA_BLOCK_INDICATOR TYPE STRING,
NSCH_DEGREE_LEVEL TYPE STRING,
CQ_OBJID TYPE STRING,
QUAL_DESC TYPE STRING,
QUAL_SHORT TYPE STRING,
SCHOOL_AWARDING_DEGREE TYPE STRING,
QUAL_CONFER_DATE TYPE STRING,
PROGRAM_OBJECTID TYPE STRING,
PROGRAM_NAME TYPE STRING,
REGIST_DATE TYPE STRING,
MAJOR1 TYPE STRING,
MAJOR2 TYPE STRING,
MAJOR3 TYPE STRING,
MAJOR4 TYPE STRING,
MINOR1 TYPE STRING,
MINOR2 TYPE STRING,
MINOR3 TYPE STRING,
MINOR4 TYPE STRING,
MAJOR1_TXT TYPE STRING,
MAJOR2_TXT TYPE STRING,
MAJOR3_TXT TYPE STRING,
MAJOR4_TXT TYPE STRING,
MINOR1_TXT TYPE STRING,
MINOR2_TXT TYPE STRING,
MINOR3_TXT TYPE STRING,
MINOR4_TXT TYPE STRING,
CIP_MAJOR1 TYPE STRING,
CIP_MAJOR2 TYPE STRING,
CIP_MAJOR3 TYPE STRING,
CIP_MAJOR4 TYPE STRING,
CIP_MINOR1 TYPE STRING,
CIP_MINOR2 TYPE STRING,
CIP_MINOR3 TYPE STRING,
CIP_MINOR4 TYPE STRING,
CIP_TXT_MAJOR1 TYPE STRING,
CIP_TXT_MAJOR2 TYPE STRING,
CIP_TXT_MAJOR3 TYPE STRING,
CIP_TXT_MAJOR4 TYPE STRING,
CIP_TXT_MINOR1 TYPE STRING,
CIP_TXT_MINOR2 TYPE STRING,
CIP_TXT_MINOR3 TYPE STRING,
CIP_TXT_MINOR4 TYPE STRING,
CLASS TYPE STRING,
FIRST_TIME_FULL_TIME TYPE STRING,
DEGREE_SEEKING TYPE STRING,
HIGH_SCHOOL_CODE TYPE STRING,
GENDER TYPE STRING,
RACE_ETHINICITY TYPE STRING,
COLLEGE_STUDENT_ID TYPE STRING,
STATE_STUDENT_ID TYPE STRING,
EMAIL_ID TYPE STRING,
GOOD_STUDENT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PIQ_US_ITEM_S_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_US_ITEM_S_STR-PIQ_US_ITEM sy-vline 
WA_PIQ_US_ITEM_S_STR-IPEDSREPORT_DATEIDT sy-vline 
WA_PIQ_US_ITEM_S_STR-STUDENTNUMBER sy-vline 
WA_PIQ_US_ITEM_S_STR-FIRST_NAME sy-vline 
WA_PIQ_US_ITEM_S_STR-LAST_NAME sy-vline 
WA_PIQ_US_ITEM_S_STR-DATE_BIRTH sy-vline 
WA_PIQ_US_ITEM_S_STR-GENDER_KEY sy-vline 
WA_PIQ_US_ITEM_S_STR-STD_ETHNIC sy-vline 
WA_PIQ_US_ITEM_S_STR-ETHNIC_GRP_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-RESIDENCY_STATUS sy-vline 
WA_PIQ_US_ITEM_S_STR-RESIDENCY_STATUS_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-RESIDENCY_COUNTRY sy-vline 
WA_PIQ_US_ITEM_S_STR-RESIDENCY_REGION sy-vline 
WA_PIQ_US_ITEM_S_STR-STUDENT_OBJECTID sy-vline 
WA_PIQ_US_ITEM_S_STR-STUDY_OBJECTID sy-vline 
WA_PIQ_US_ITEM_S_STR-PROGRAM_OBJECTID sy-vline 
WA_PIQ_US_ITEM_S_STR-OPTLENGTH sy-vline 
WA_PIQ_US_ITEM_S_STR-TIMEUNIT sy-vline 
WA_PIQ_US_ITEM_S_STR-GRPVAR sy-vline 
WA_PIQ_US_ITEM_S_STR-GRPVARTXT sy-vline 
WA_PIQ_US_ITEM_S_STR-PROG_TYPE sy-vline 
WA_PIQ_US_ITEM_S_STR-PROG_TYPET sy-vline 
WA_PIQ_US_ITEM_S_STR-PROGRESSION_RESULT sy-vline 
WA_PIQ_US_ITEM_S_STR-MODULEGROUP_OBJECTID sy-vline 
WA_PIQ_US_ITEM_S_STR-MODULEGROUP_CATEGORY sy-vline 
WA_PIQ_US_ITEM_S_STR-CATEGORY_TEXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MODULEGROUP_PRIORITY sy-vline 
WA_PIQ_US_ITEM_S_STR-ADMIS_CATEGORY sy-vline 
WA_PIQ_US_ITEM_S_STR-QUAL_LEVEL sy-vline 
WA_PIQ_US_ITEM_S_STR-QUAL_CLASS sy-vline 
WA_PIQ_US_ITEM_S_STR-CQ_OTYPE sy-vline 
WA_PIQ_US_ITEM_S_STR-CQ_OBJID sy-vline 
WA_PIQ_US_ITEM_S_STR-VALID_FROM sy-vline 
WA_PIQ_US_ITEM_S_STR-ACAD_YEAR sy-vline 
WA_PIQ_US_ITEM_S_STR-ACAC_SESSION sy-vline 
WA_PIQ_US_ITEM_S_STR-REGIST_DATE sy-vline 
WA_PIQ_US_ITEM_S_STR-PARTTIME sy-vline 
WA_PIQ_US_ITEM_S_STR-PROGCLASS sy-vline 
WA_PIQ_US_ITEM_S_STR-CLASS_BEGDATE sy-vline 
WA_PIQ_US_ITEM_S_STR-DISPL sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR1 sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR1TEXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR1PRIO sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR1DISP sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR1DISPTEXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR2 sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR2TEXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR2PRIO sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR2DISP sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR2DISPTEXT sy-vline 
WA_PIQ_US_ITEM_S_STR-CIPCODE_DERIVE sy-vline 
WA_PIQ_US_ITEM_S_STR-US_STUDENTLEVEL sy-vline 
WA_PIQ_US_ITEM_S_STR-STUDENT_LEVELT sy-vline 
WA_PIQ_US_ITEM_S_STR-US_ETHNIC sy-vline 
WA_PIQ_US_ITEM_S_STR-ETHNICT sy-vline 
WA_PIQ_US_ITEM_S_STR-US_CIPCODE sy-vline 
WA_PIQ_US_ITEM_S_STR-END_PROCESS sy-vline 
WA_PIQ_US_ITEM_S_STR-END_REASON sy-vline 
WA_PIQ_US_ITEM_S_STR-END_KEY_DATE sy-vline 
WA_PIQ_US_ITEM_S_STR-AWARD_LEVEL sy-vline 
WA_PIQ_US_ITEM_S_STR-AWARD_LEVELT sy-vline 
WA_PIQ_US_ITEM_S_STR-FIRST_TIME sy-vline 
WA_PIQ_US_ITEM_S_STR-SECOND_MAJOR sy-vline 
WA_PIQ_US_ITEM_S_STR-DEGREE_SEEKING sy-vline 
WA_PIQ_US_ITEM_S_STR-CERTI_SEEKING sy-vline 
WA_PIQ_US_ITEM_S_STR-FALLENROLLMENT sy-vline 
WA_PIQ_US_ITEM_S_STR-FPRCD sy-vline 
WA_PIQ_US_ITEM_S_STR-SPORTS_TYPE sy-vline 
WA_PIQ_US_ITEM_S_STR-SVBYEAR sy-vline 
WA_PIQ_US_ITEM_S_STR-SVBSESSION sy-vline 
WA_PIQ_US_ITEM_S_STR-SVEYEAR sy-vline 
WA_PIQ_US_ITEM_S_STR-SVESESSION sy-vline 
WA_PIQ_US_ITEM_S_STR-SCHOLARSHIP sy-vline 
WA_PIQ_US_ITEM_S_STR-TRANSTYPE sy-vline 
WA_PIQ_US_ITEM_S_STR-REPSTATE sy-vline 
WA_PIQ_US_ITEM_S_STR-ISSUEDATE sy-vline 
WA_PIQ_US_ITEM_S_STR-HIGH_SCHOOL sy-vline 
WA_PIQ_US_ITEM_S_STR-CATEGORY sy-vline 
WA_PIQ_US_ITEM_S_STR-MGCATMAJOR sy-vline 
WA_PIQ_US_ITEM_S_STR-RESID_STATUS sy-vline 
WA_PIQ_US_ITEM_S_STR-DEREG_REASON sy-vline 
WA_PIQ_US_ITEM_S_STR-FIRST_YEAR sy-vline 
WA_PIQ_US_ITEM_S_STR-GRS_LINE_SEC23 sy-vline 
WA_PIQ_US_ITEM_S_STR-GRS_LINE_SEC6 sy-vline 
WA_PIQ_US_ITEM_S_STR-ST_GRS5 sy-vline 
WA_PIQ_US_ITEM_S_STR-ST_GRS6 sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_LINE_PARTA sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_LINE_PARTB sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_EFRES01_PARTC sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_EFRES02_PARTC sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_EFE01_PARTD sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_CREDHRSU_PARTF sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_CONTHRS_PARTF sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_CREDHRSG_PARTF sy-vline 
WA_PIQ_US_ITEM_S_STR-FE_REP_YEAR_PARTF sy-vline 
WA_PIQ_US_ITEM_S_STR-BACHELOR_DEGREE sy-vline 
WA_PIQ_US_ITEM_S_STR-IPEDSREPORT_DATEID sy-vline 
WA_PIQ_US_ITEM_S_STR-ACTION sy-vline 
WA_PIQ_US_ITEM_S_STR-TESTCODE sy-vline 
WA_PIQ_US_ITEM_S_STR-P1SCORE sy-vline 
WA_PIQ_US_ITEM_S_STR-P2SCORE sy-vline 
WA_PIQ_US_ITEM_S_STR-P3SCORE sy-vline 
WA_PIQ_US_ITEM_S_STR-P4SCORE sy-vline 
WA_PIQ_US_ITEM_S_STR-P5SCORE sy-vline 
WA_PIQ_US_ITEM_S_STR-TESTDATE sy-vline 
WA_PIQ_US_ITEM_S_STR-SCRRECDATE sy-vline 
WA_PIQ_US_ITEM_S_STR-SATSCORE sy-vline 
WA_PIQ_US_ITEM_S_STR-ACTSCORE sy-vline 
WA_PIQ_US_ITEM_S_STR-COMMENTS sy-vline 
WA_PIQ_US_ITEM_S_STR-CLASSDESC sy-vline 
WA_PIQ_US_ITEM_S_STR-DEGREEID sy-vline 
WA_PIQ_US_ITEM_S_STR-DEGREEDATE sy-vline 
WA_PIQ_US_ITEM_S_STR-FULTIME sy-vline 
WA_PIQ_US_ITEM_S_STR-SASTMT sy-vline 
WA_PIQ_US_ITEM_S_STR-SAAFFIRM sy-vline 
WA_PIQ_US_ITEM_S_STR-DRUGTEST sy-vline 
WA_PIQ_US_ITEM_S_STR-SAAIDID sy-vline 
WA_PIQ_US_ITEM_S_STR-FUNDCODE sy-vline 
WA_PIQ_US_ITEM_S_STR-AWARDDATE sy-vline 
WA_PIQ_US_ITEM_S_STR-AWARDPERIOD sy-vline 
WA_PIQ_US_ITEM_S_STR-AWARDAMT sy-vline 
WA_PIQ_US_ITEM_S_STR-SPORTCODE sy-vline 
WA_PIQ_US_ITEM_S_STR-ROLLOVERFLAG sy-vline 
WA_PIQ_US_ITEM_S_STR-SCHOOLAIDID sy-vline 
WA_PIQ_US_ITEM_S_STR-VALUE sy-vline 
WA_PIQ_US_ITEM_S_STR-GUARDIANNAME sy-vline 
WA_PIQ_US_ITEM_S_STR-ADDRESS1 sy-vline 
WA_PIQ_US_ITEM_S_STR-ADDRESS2 sy-vline 
WA_PIQ_US_ITEM_S_STR-PROVINCE sy-vline 
WA_PIQ_US_ITEM_S_STR-COUNTRY sy-vline 
WA_PIQ_US_ITEM_S_STR-XFERTYPE sy-vline 
WA_PIQ_US_ITEM_S_STR-STUDID sy-vline 
WA_PIQ_US_ITEM_S_STR-SSN sy-vline 
WA_PIQ_US_ITEM_S_STR-NCAA_GENDER sy-vline 
WA_PIQ_US_ITEM_S_STR-RECRUITED sy-vline 
WA_PIQ_US_ITEM_S_STR-EMAIL sy-vline 
WA_PIQ_US_ITEM_S_STR-PHONE sy-vline 
WA_PIQ_US_ITEM_S_STR-CELLPHONE sy-vline 
WA_PIQ_US_ITEM_S_STR-ONCAMPUS sy-vline 
WA_PIQ_US_ITEM_S_STR-STATRES sy-vline 
WA_PIQ_US_ITEM_S_STR-RACECODE sy-vline 
WA_PIQ_US_ITEM_S_STR-HSGRADDATE sy-vline 
WA_PIQ_US_ITEM_S_STR-FULENRTMANY sy-vline 
WA_PIQ_US_ITEM_S_STR-FULENTMHERE sy-vline 
WA_PIQ_US_ITEM_S_STR-FULENYRANY sy-vline 
WA_PIQ_US_ITEM_S_STR-FULENYRHERE sy-vline 
WA_PIQ_US_ITEM_S_STR-ORGID sy-vline 
WA_PIQ_US_ITEM_S_STR-ORGPWD sy-vline 
WA_PIQ_US_ITEM_S_STR-USERID sy-vline 
WA_PIQ_US_ITEM_S_STR-USERPWD sy-vline 
WA_PIQ_US_ITEM_S_STR-MIDDLE_NAME sy-vline 
WA_PIQ_US_ITEM_S_STR-NCAA_DOB sy-vline 
WA_PIQ_US_ITEM_S_STR-SPORTCODE_AWARD sy-vline 
WA_PIQ_US_ITEM_S_STR-CHANGEDATE sy-vline 
WA_PIQ_US_ITEM_S_STR-CHANGESTATUS sy-vline 
WA_PIQ_US_ITEM_S_STR-PIQ_US_NSCH_ITEM sy-vline 
WA_PIQ_US_ITEM_S_STR-ORG_OBJECTID sy-vline 
WA_PIQ_US_ITEM_S_STR-STUDENT_OBJID sy-vline 
WA_PIQ_US_ITEM_S_STR-STUDENTNUMBER sy-vline 
WA_PIQ_US_ITEM_S_STR-PERSIDNO sy-vline 
WA_PIQ_US_ITEM_S_STR-FIRST_NAME sy-vline 
WA_PIQ_US_ITEM_S_STR-MIDDLE_NAME sy-vline 
WA_PIQ_US_ITEM_S_STR-LAST_NAME sy-vline 
WA_PIQ_US_ITEM_S_STR-INITIALS sy-vline 
WA_PIQ_US_ITEM_S_STR-NAME_AT_BIRTH sy-vline 
WA_PIQ_US_ITEM_S_STR-ENROLLMENT_STATUS sy-vline 
WA_PIQ_US_ITEM_S_STR-ENROLL_START_DATE sy-vline 
WA_PIQ_US_ITEM_S_STR-STREET sy-vline 
WA_PIQ_US_ITEM_S_STR-STR_SUPPL1 sy-vline 
WA_PIQ_US_ITEM_S_STR-CITY sy-vline 
WA_PIQ_US_ITEM_S_STR-REGION sy-vline 
WA_PIQ_US_ITEM_S_STR-POSTL_COD1 sy-vline 
WA_PIQ_US_ITEM_S_STR-COUNTRY sy-vline 
WA_PIQ_US_ITEM_S_STR-ANTICIP_GRAD_DATE sy-vline 
WA_PIQ_US_ITEM_S_STR-DATE_BIRTH sy-vline 
WA_PIQ_US_ITEM_S_STR-TERM_BEGDA sy-vline 
WA_PIQ_US_ITEM_S_STR-TERM_ENDDA sy-vline 
WA_PIQ_US_ITEM_S_STR-NSCH_GRAD_LEVEL sy-vline 
WA_PIQ_US_ITEM_S_STR-DATA_BLOCK_INDICATOR sy-vline 
WA_PIQ_US_ITEM_S_STR-NSCH_DEGREE_LEVEL sy-vline 
WA_PIQ_US_ITEM_S_STR-CQ_OBJID sy-vline 
WA_PIQ_US_ITEM_S_STR-QUAL_DESC sy-vline 
WA_PIQ_US_ITEM_S_STR-QUAL_SHORT sy-vline 
WA_PIQ_US_ITEM_S_STR-SCHOOL_AWARDING_DEGREE sy-vline 
WA_PIQ_US_ITEM_S_STR-QUAL_CONFER_DATE sy-vline 
WA_PIQ_US_ITEM_S_STR-PROGRAM_OBJECTID sy-vline 
WA_PIQ_US_ITEM_S_STR-PROGRAM_NAME sy-vline 
WA_PIQ_US_ITEM_S_STR-REGIST_DATE sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR1 sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR2 sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR3 sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR4 sy-vline 
WA_PIQ_US_ITEM_S_STR-MINOR1 sy-vline 
WA_PIQ_US_ITEM_S_STR-MINOR2 sy-vline 
WA_PIQ_US_ITEM_S_STR-MINOR3 sy-vline 
WA_PIQ_US_ITEM_S_STR-MINOR4 sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR1_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR2_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR3_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MAJOR4_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MINOR1_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MINOR2_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MINOR3_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-MINOR4_TXT sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_MAJOR1 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_MAJOR2 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_MAJOR3 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_MAJOR4 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_MINOR1 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_MINOR2 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_MINOR3 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_MINOR4 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_TXT_MAJOR1 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_TXT_MAJOR2 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_TXT_MAJOR3 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_TXT_MAJOR4 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_TXT_MINOR1 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_TXT_MINOR2 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_TXT_MINOR3 sy-vline 
WA_PIQ_US_ITEM_S_STR-CIP_TXT_MINOR4 sy-vline 
WA_PIQ_US_ITEM_S_STR-CLASS sy-vline 
WA_PIQ_US_ITEM_S_STR-FIRST_TIME_FULL_TIME sy-vline 
WA_PIQ_US_ITEM_S_STR-DEGREE_SEEKING sy-vline 
WA_PIQ_US_ITEM_S_STR-HIGH_SCHOOL_CODE sy-vline 
WA_PIQ_US_ITEM_S_STR-GENDER sy-vline 
WA_PIQ_US_ITEM_S_STR-RACE_ETHINICITY sy-vline 
WA_PIQ_US_ITEM_S_STR-COLLEGE_STUDENT_ID sy-vline 
WA_PIQ_US_ITEM_S_STR-STATE_STUDENT_ID sy-vline 
WA_PIQ_US_ITEM_S_STR-EMAIL_ID sy-vline 
WA_PIQ_US_ITEM_S_STR-GOOD_STUDENT sy-vline      INTO ld_text SEPARATED BY SPACE.

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