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

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

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

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


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

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

ENDLOOP.

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

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


*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-STUDENTNUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_US_ITEM-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-DATE_BIRTH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQ_US_ITEM-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_STR, 
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,END OF T_EKKO_STR.
DATA: WA_PIQ_US_ITEM_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_STR-IPEDSREPORT_DATEIDT sy-vline 
WA_PIQ_US_ITEM_STR-STUDENTNUMBER sy-vline 
WA_PIQ_US_ITEM_STR-FIRST_NAME sy-vline 
WA_PIQ_US_ITEM_STR-LAST_NAME sy-vline 
WA_PIQ_US_ITEM_STR-DATE_BIRTH sy-vline 
WA_PIQ_US_ITEM_STR-GENDER_KEY sy-vline 
WA_PIQ_US_ITEM_STR-STD_ETHNIC sy-vline 
WA_PIQ_US_ITEM_STR-ETHNIC_GRP_TXT sy-vline 
WA_PIQ_US_ITEM_STR-RESIDENCY_STATUS sy-vline 
WA_PIQ_US_ITEM_STR-RESIDENCY_STATUS_TXT sy-vline 
WA_PIQ_US_ITEM_STR-RESIDENCY_COUNTRY sy-vline 
WA_PIQ_US_ITEM_STR-RESIDENCY_REGION sy-vline 
WA_PIQ_US_ITEM_STR-STUDENT_OBJECTID sy-vline 
WA_PIQ_US_ITEM_STR-STUDY_OBJECTID sy-vline 
WA_PIQ_US_ITEM_STR-PROGRAM_OBJECTID sy-vline 
WA_PIQ_US_ITEM_STR-OPTLENGTH sy-vline 
WA_PIQ_US_ITEM_STR-TIMEUNIT sy-vline 
WA_PIQ_US_ITEM_STR-GRPVAR sy-vline 
WA_PIQ_US_ITEM_STR-GRPVARTXT sy-vline 
WA_PIQ_US_ITEM_STR-PROG_TYPE sy-vline 
WA_PIQ_US_ITEM_STR-PROG_TYPET sy-vline 
WA_PIQ_US_ITEM_STR-PROGRESSION_RESULT sy-vline 
WA_PIQ_US_ITEM_STR-MODULEGROUP_OBJECTID sy-vline 
WA_PIQ_US_ITEM_STR-MODULEGROUP_CATEGORY sy-vline 
WA_PIQ_US_ITEM_STR-CATEGORY_TEXT sy-vline 
WA_PIQ_US_ITEM_STR-MODULEGROUP_PRIORITY sy-vline 
WA_PIQ_US_ITEM_STR-ADMIS_CATEGORY sy-vline 
WA_PIQ_US_ITEM_STR-QUAL_LEVEL sy-vline 
WA_PIQ_US_ITEM_STR-QUAL_CLASS sy-vline 
WA_PIQ_US_ITEM_STR-CQ_OTYPE sy-vline 
WA_PIQ_US_ITEM_STR-CQ_OBJID sy-vline 
WA_PIQ_US_ITEM_STR-VALID_FROM sy-vline 
WA_PIQ_US_ITEM_STR-ACAD_YEAR sy-vline 
WA_PIQ_US_ITEM_STR-ACAC_SESSION sy-vline 
WA_PIQ_US_ITEM_STR-REGIST_DATE sy-vline 
WA_PIQ_US_ITEM_STR-PARTTIME sy-vline 
WA_PIQ_US_ITEM_STR-PROGCLASS sy-vline 
WA_PIQ_US_ITEM_STR-CLASS_BEGDATE sy-vline 
WA_PIQ_US_ITEM_STR-DISPL sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR1 sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR1TEXT sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR1PRIO sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR1DISP sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR1DISPTEXT sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR2 sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR2TEXT sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR2PRIO sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR2DISP sy-vline 
WA_PIQ_US_ITEM_STR-MAJOR2DISPTEXT sy-vline 
WA_PIQ_US_ITEM_STR-CIPCODE_DERIVE sy-vline 
WA_PIQ_US_ITEM_STR-US_STUDENTLEVEL sy-vline 
WA_PIQ_US_ITEM_STR-STUDENT_LEVELT sy-vline 
WA_PIQ_US_ITEM_STR-US_ETHNIC sy-vline 
WA_PIQ_US_ITEM_STR-ETHNICT sy-vline 
WA_PIQ_US_ITEM_STR-US_CIPCODE sy-vline 
WA_PIQ_US_ITEM_STR-END_PROCESS sy-vline 
WA_PIQ_US_ITEM_STR-END_REASON sy-vline 
WA_PIQ_US_ITEM_STR-END_KEY_DATE sy-vline 
WA_PIQ_US_ITEM_STR-AWARD_LEVEL sy-vline 
WA_PIQ_US_ITEM_STR-AWARD_LEVELT sy-vline 
WA_PIQ_US_ITEM_STR-FIRST_TIME sy-vline 
WA_PIQ_US_ITEM_STR-SECOND_MAJOR sy-vline 
WA_PIQ_US_ITEM_STR-DEGREE_SEEKING sy-vline 
WA_PIQ_US_ITEM_STR-CERTI_SEEKING sy-vline 
WA_PIQ_US_ITEM_STR-FALLENROLLMENT sy-vline 
WA_PIQ_US_ITEM_STR-FPRCD sy-vline 
WA_PIQ_US_ITEM_STR-SPORTS_TYPE sy-vline 
WA_PIQ_US_ITEM_STR-SVBYEAR sy-vline 
WA_PIQ_US_ITEM_STR-SVBSESSION sy-vline 
WA_PIQ_US_ITEM_STR-SVEYEAR sy-vline 
WA_PIQ_US_ITEM_STR-SVESESSION sy-vline 
WA_PIQ_US_ITEM_STR-SCHOLARSHIP sy-vline 
WA_PIQ_US_ITEM_STR-TRANSTYPE sy-vline 
WA_PIQ_US_ITEM_STR-REPSTATE sy-vline 
WA_PIQ_US_ITEM_STR-ISSUEDATE sy-vline 
WA_PIQ_US_ITEM_STR-HIGH_SCHOOL sy-vline 
WA_PIQ_US_ITEM_STR-CATEGORY sy-vline 
WA_PIQ_US_ITEM_STR-MGCATMAJOR sy-vline 
WA_PIQ_US_ITEM_STR-RESID_STATUS sy-vline 
WA_PIQ_US_ITEM_STR-DEREG_REASON sy-vline 
WA_PIQ_US_ITEM_STR-FIRST_YEAR sy-vline 
WA_PIQ_US_ITEM_STR-GRS_LINE_SEC23 sy-vline 
WA_PIQ_US_ITEM_STR-GRS_LINE_SEC6 sy-vline 
WA_PIQ_US_ITEM_STR-ST_GRS5 sy-vline 
WA_PIQ_US_ITEM_STR-ST_GRS6 sy-vline 
WA_PIQ_US_ITEM_STR-FE_LINE_PARTA sy-vline 
WA_PIQ_US_ITEM_STR-FE_LINE_PARTB sy-vline 
WA_PIQ_US_ITEM_STR-FE_EFRES01_PARTC sy-vline 
WA_PIQ_US_ITEM_STR-FE_EFRES02_PARTC sy-vline 
WA_PIQ_US_ITEM_STR-FE_EFE01_PARTD sy-vline 
WA_PIQ_US_ITEM_STR-FE_CREDHRSU_PARTF sy-vline 
WA_PIQ_US_ITEM_STR-FE_CONTHRS_PARTF sy-vline 
WA_PIQ_US_ITEM_STR-FE_CREDHRSG_PARTF sy-vline 
WA_PIQ_US_ITEM_STR-FE_REP_YEAR_PARTF sy-vline 
WA_PIQ_US_ITEM_STR-BACHELOR_DEGREE sy-vline 
WA_PIQ_US_ITEM_STR-IPEDSREPORT_DATEID sy-vline 
WA_PIQ_US_ITEM_STR-ACTION sy-vline 
WA_PIQ_US_ITEM_STR-TESTCODE sy-vline 
WA_PIQ_US_ITEM_STR-P1SCORE sy-vline 
WA_PIQ_US_ITEM_STR-P2SCORE sy-vline 
WA_PIQ_US_ITEM_STR-P3SCORE sy-vline 
WA_PIQ_US_ITEM_STR-P4SCORE sy-vline 
WA_PIQ_US_ITEM_STR-P5SCORE sy-vline 
WA_PIQ_US_ITEM_STR-TESTDATE sy-vline 
WA_PIQ_US_ITEM_STR-SCRRECDATE sy-vline 
WA_PIQ_US_ITEM_STR-SATSCORE sy-vline 
WA_PIQ_US_ITEM_STR-ACTSCORE sy-vline 
WA_PIQ_US_ITEM_STR-COMMENTS sy-vline 
WA_PIQ_US_ITEM_STR-CLASSDESC sy-vline 
WA_PIQ_US_ITEM_STR-DEGREEID sy-vline 
WA_PIQ_US_ITEM_STR-DEGREEDATE sy-vline 
WA_PIQ_US_ITEM_STR-FULTIME sy-vline 
WA_PIQ_US_ITEM_STR-SASTMT sy-vline 
WA_PIQ_US_ITEM_STR-SAAFFIRM sy-vline 
WA_PIQ_US_ITEM_STR-DRUGTEST sy-vline 
WA_PIQ_US_ITEM_STR-SAAIDID sy-vline 
WA_PIQ_US_ITEM_STR-FUNDCODE sy-vline 
WA_PIQ_US_ITEM_STR-AWARDDATE sy-vline 
WA_PIQ_US_ITEM_STR-AWARDPERIOD sy-vline 
WA_PIQ_US_ITEM_STR-AWARDAMT sy-vline 
WA_PIQ_US_ITEM_STR-SPORTCODE sy-vline 
WA_PIQ_US_ITEM_STR-ROLLOVERFLAG sy-vline 
WA_PIQ_US_ITEM_STR-SCHOOLAIDID sy-vline 
WA_PIQ_US_ITEM_STR-VALUE sy-vline 
WA_PIQ_US_ITEM_STR-GUARDIANNAME sy-vline 
WA_PIQ_US_ITEM_STR-ADDRESS1 sy-vline 
WA_PIQ_US_ITEM_STR-ADDRESS2 sy-vline 
WA_PIQ_US_ITEM_STR-PROVINCE sy-vline 
WA_PIQ_US_ITEM_STR-COUNTRY sy-vline 
WA_PIQ_US_ITEM_STR-XFERTYPE sy-vline 
WA_PIQ_US_ITEM_STR-STUDID sy-vline 
WA_PIQ_US_ITEM_STR-SSN sy-vline 
WA_PIQ_US_ITEM_STR-NCAA_GENDER sy-vline 
WA_PIQ_US_ITEM_STR-RECRUITED sy-vline 
WA_PIQ_US_ITEM_STR-EMAIL sy-vline 
WA_PIQ_US_ITEM_STR-PHONE sy-vline 
WA_PIQ_US_ITEM_STR-CELLPHONE sy-vline 
WA_PIQ_US_ITEM_STR-ONCAMPUS sy-vline 
WA_PIQ_US_ITEM_STR-STATRES sy-vline 
WA_PIQ_US_ITEM_STR-RACECODE sy-vline 
WA_PIQ_US_ITEM_STR-HSGRADDATE sy-vline 
WA_PIQ_US_ITEM_STR-FULENRTMANY sy-vline 
WA_PIQ_US_ITEM_STR-FULENTMHERE sy-vline 
WA_PIQ_US_ITEM_STR-FULENYRANY sy-vline 
WA_PIQ_US_ITEM_STR-FULENYRHERE sy-vline 
WA_PIQ_US_ITEM_STR-ORGID sy-vline 
WA_PIQ_US_ITEM_STR-ORGPWD sy-vline 
WA_PIQ_US_ITEM_STR-USERID sy-vline 
WA_PIQ_US_ITEM_STR-USERPWD sy-vline 
WA_PIQ_US_ITEM_STR-MIDDLE_NAME sy-vline 
WA_PIQ_US_ITEM_STR-NCAA_DOB sy-vline 
WA_PIQ_US_ITEM_STR-SPORTCODE_AWARD sy-vline 
WA_PIQ_US_ITEM_STR-CHANGEDATE sy-vline 
WA_PIQ_US_ITEM_STR-CHANGESTATUS sy-vline      INTO ld_text SEPARATED BY SPACE.

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