ABAP Select data from SAP table PIQRULEMASTER_APP 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 PIQRULEMASTER_APP 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 PIQRULEMASTER_APP. 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 PIQRULEMASTER_APP 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_PIQRULEMASTER_APP TYPE STANDARD TABLE OF PIQRULEMASTER_APP,
      WA_PIQRULEMASTER_APP TYPE PIQRULEMASTER_APP,
      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: <PIQRULEMASTER_APP> TYPE PIQRULEMASTER_APP.

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PIQRULEMASTER_APP>-ADDRESS_TYPE = 1.
<PIQRULEMASTER_APP>-HOUSE_NO = 1.
<PIQRULEMASTER_APP>-STREET = 1.
<PIQRULEMASTER_APP>-STREET2 = 1.
<PIQRULEMASTER_APP>-CITY = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PIQRULEMASTER_APP-POSTAL_CD, sy-vline,
  WA_PIQRULEMASTER_APP-COUNTRY, sy-vline,
  WA_PIQRULEMASTER_APP-REGION, sy-vline,
  WA_PIQRULEMASTER_APP-TEL_NO, sy-vline,
  WA_PIQRULEMASTER_APP-FAX_NO, sy-vline,
  WA_PIQRULEMASTER_APP-CG_OBJID_CG, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PIQRULEMASTER_APP 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_PIQRULEMASTER_APP 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_PIQRULEMASTER_APP INTO WA_PIQRULEMASTER_APP.


*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 CUNIT, internal->external for field TOTEXTCREDTYPE_HD
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PIQRULEMASTER_APP-TOTEXTCREDTYPE_HD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTER_APP-TOTEXTCREDTYPE_HD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TOTINTCREDTYPE_HD
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PIQRULEMASTER_APP-TOTINTCREDTYPE_HD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTER_APP-TOTINTCREDTYPE_HD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field EXTSESCREDTYPE_PR
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PIQRULEMASTER_APP-EXTSESCREDTYPE_PR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTER_APP-EXTSESCREDTYPE_PR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field INTSESCREDTYPE_PR
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PIQRULEMASTER_APP-INTSESCREDTYPE_PR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTER_APP-INTSESCREDTYPE_PR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field EXTCOCREDTYPE_SU
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PIQRULEMASTER_APP-EXTCOCREDTYPE_SU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTER_APP-EXTCOCREDTYPE_SU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field INTCOCREDTYPE_SU
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PIQRULEMASTER_APP-INTCOCREDTYPE_SU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTER_APP-INTCOCREDTYPE_SU.
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_PIQRULEMASTER_APP_STR, 
ADDRESS_TYPE TYPE STRING,
HOUSE_NO TYPE STRING,
STREET TYPE STRING,
STREET2 TYPE STRING,
CITY TYPE STRING,
POSTAL_CD TYPE STRING,
COUNTRY TYPE STRING,
REGION TYPE STRING,
TEL_NO TYPE STRING,
FAX_NO TYPE STRING,
CG_OBJID_CG TYPE STRING,
TRANS_GUID_HD TYPE STRING,
TRANSTYPE_HD TYPE STRING,
ISSEO_HD TYPE STRING,
TRANSEO_HD TYPE STRING,
TRSTATUS_HD TYPE STRING,
REGPERIODFROM_HD TYPE STRING,
REGPERIODTO_HD TYPE STRING,
RANKING_HD TYPE STRING,
SIZEOFCLASS_HD TYPE STRING,
RETURNINDIC_HD TYPE STRING,
RETURNDATE_HD TYPE STRING,
TOTSELFGPA_HD TYPE STRING,
TOTSELFGPANORM_HD TYPE STRING,
TOTSELFGPASCALE_HD TYPE STRING,
TOTEXTGPA1_HD TYPE STRING,
TOTEXTGPA1NORM_HD TYPE STRING,
TOTEXTGPA1SCALE_HD TYPE STRING,
TOTEXTGPA2_HD TYPE STRING,
TOTEXTGPA2NORM_HD TYPE STRING,
TOTEXTGPA2SCALE_HD TYPE STRING,
TOTEXTGPA3_HD TYPE STRING,
TOTEXTGPA3NORM_HD TYPE STRING,
TOTEXTGPA3SCALE_HD TYPE STRING,
CALCGPAMANFLAG_HD TYPE STRING,
TOTCALCGPA_HD TYPE STRING,
TOTCALCGPANORM_HD TYPE STRING,
TOTCALCGPASCALE_HD TYPE STRING,
TOTEXTATMCRED_HD TYPE STRING,
TOTEXTGRDCRED_HD TYPE STRING,
TOTEXTERNCRED_HD TYPE STRING,
TOTEXTCREDTYPE_HD TYPE STRING,
TOTCREDMANFLAG_HD TYPE STRING,
TOTINTATMCRED_HD TYPE STRING,
TOTINTGRDCRED_HD TYPE STRING,
TOTINTERNCRED_HD TYPE STRING,
TOTINTCREDTYPE_HD TYPE STRING,
DEGREENR_DG TYPE STRING,
DEGREEID_DG TYPE STRING,
PROGRAMID_DG TYPE STRING,
DEGERNFLAG_DG TYPE STRING,
DEGDATE_DG TYPE STRING,
DEGEXTGRADE_DG TYPE STRING,
DEGEXTGRADENORM_DG TYPE STRING,
DEGEXTSCALEID_DG TYPE STRING,
DEGMANFLAG_DG TYPE STRING,
DEGINTGRADE_DG TYPE STRING,
DEGINTGRADENORM_DG TYPE STRING,
DEGINTSCALEID_DG TYPE STRING,
DEGHONORS_DG TYPE STRING,
SPECDEGREENR_DS TYPE STRING,
SPECID_DS TYPE STRING,
SPECTYPE_DS TYPE STRING,
SESSIONID_PR TYPE STRING,
SESSIONYEAR_PR TYPE STRING,
SESBEGDATE_PR TYPE STRING,
SESENDDATE_PR TYPE STRING,
SESWITHDRDATE_PR TYPE STRING,
SESDEGREEID_PR TYPE STRING,
SESPROGRAMID_PR TYPE STRING,
STAGEID_PR TYPE STRING,
PROGCLASSID_PR TYPE STRING,
PROGACST_PR TYPE STRING,
PROGSTAT_PR TYPE STRING,
EXTSESGPA_PR TYPE STRING,
EXTSESGPANORM_PR TYPE STRING,
EXTSESGPASCALE_PR TYPE STRING,
SESGPAMANFLAG_PR TYPE STRING,
INTSESGPA_PR TYPE STRING,
INTSESGPANORM_PR TYPE STRING,
INTSESGPASCALE_PR TYPE STRING,
EXTSESATMCRED_PR TYPE STRING,
EXTSESGRDCRED_PR TYPE STRING,
EXTSESERNCRED_PR TYPE STRING,
EXTSESCREDTYPE_PR TYPE STRING,
SESCREDMANFLAG_PR TYPE STRING,
INTSESATMCRED_PR TYPE STRING,
INTSESGRDCRED_PR TYPE STRING,
INTSESERNCRED_PR TYPE STRING,
INTSESCREDTYPE_PR TYPE STRING,
COURSEID_SU TYPE STRING,
EXTGRADE_SU TYPE STRING,
EXTGRADENORM_SU TYPE STRING,
EXTGRADESCALE_SU TYPE STRING,
GRADEMANFLAG_SU TYPE STRING,
INTGRADE_SU TYPE STRING,
INTGRADENORM_SU TYPE STRING,
INTGRADESCALE_SU TYPE STRING,
COREPEATFLAG_SU TYPE STRING,
HONORSINDIC_SU TYPE STRING,
EXTCOATMCRED_SU TYPE STRING,
EXTCOGRDCRED_SU TYPE STRING,
EXTCOERNCRED_SU TYPE STRING,
EXTCOCREDTYPE_SU TYPE STRING,
COCREDMANFLAG_SU TYPE STRING,
INTCOATMCRED_SU TYPE STRING,
INTCOGRDCRED_SU TYPE STRING,
INTCOERNCRED_SU TYPE STRING,
INTCOCREDTYPE_SU TYPE STRING,
BASFORCOCRED_SU TYPE STRING,
COREFLAG_SU TYPE STRING,
COWITHDRDATE_SU TYPE STRING,
COSESID_SU TYPE STRING,
COSESYEAR_SU TYPE STRING,
COBEGDATE_SU TYPE STRING,
COENDDATE_SU TYPE STRING,
ATTNO_TW_SU TYPE STRING,
CODEDNOTEID_CN TYPE STRING,
COMMENTLINE_CN TYPE STRING,
TEST_GUIDTST TYPE STRING,
TESTEOTST TYPE STRING,
TRANSEOTST TYPE STRING,
TESTTYPETST TYPE STRING,
SESSIONIDTST TYPE STRING,
SESSIONYEARTST TYPE STRING,
ENTRYDATETST TYPE STRING,
TESTPASSFAILTST TYPE STRING,
TESTTOTRESTST TYPE STRING,
TESTTOTRESNORMTST TYPE STRING,
TESTSCALE_IDTST TYPE STRING,
TOTALPERCENT1TST TYPE STRING,
TOTALPERCENT2TST TYPE STRING,
ENTRYMODETST TYPE STRING,
RESULTSTATUSTST TYPE STRING,
STATUSREASONTST TYPE STRING,
SUBTESTIDSTS TYPE STRING,
SUBTESTRESSTS TYPE STRING,
SUBTESTRESNORMSTS TYPE STRING,
SUBTESTSCALE_IDSTS TYPE STRING,
SUBPERCENT1STS TYPE STRING,
SUBPERCENT2STS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PIQRULEMASTER_APP_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_PIQRULEMASTER_APP_STR-ADDRESS_TYPE sy-vline 
WA_PIQRULEMASTER_APP_STR-HOUSE_NO sy-vline 
WA_PIQRULEMASTER_APP_STR-STREET sy-vline 
WA_PIQRULEMASTER_APP_STR-STREET2 sy-vline 
WA_PIQRULEMASTER_APP_STR-CITY sy-vline 
WA_PIQRULEMASTER_APP_STR-POSTAL_CD sy-vline 
WA_PIQRULEMASTER_APP_STR-COUNTRY sy-vline 
WA_PIQRULEMASTER_APP_STR-REGION sy-vline 
WA_PIQRULEMASTER_APP_STR-TEL_NO sy-vline 
WA_PIQRULEMASTER_APP_STR-FAX_NO sy-vline 
WA_PIQRULEMASTER_APP_STR-CG_OBJID_CG sy-vline 
WA_PIQRULEMASTER_APP_STR-TRANS_GUID_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TRANSTYPE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-ISSEO_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TRANSEO_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TRSTATUS_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-REGPERIODFROM_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-REGPERIODTO_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-RANKING_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-SIZEOFCLASS_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-RETURNINDIC_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-RETURNDATE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTSELFGPA_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTSELFGPANORM_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTSELFGPASCALE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA1_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA1NORM_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA1SCALE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA2_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA2NORM_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA2SCALE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA3_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA3NORM_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGPA3SCALE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-CALCGPAMANFLAG_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTCALCGPA_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTCALCGPANORM_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTCALCGPASCALE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTATMCRED_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTGRDCRED_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTERNCRED_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTEXTCREDTYPE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTCREDMANFLAG_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTINTATMCRED_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTINTGRDCRED_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTINTERNCRED_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTINTCREDTYPE_HD sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGREENR_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGREEID_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-PROGRAMID_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGERNFLAG_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGDATE_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGEXTGRADE_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGEXTGRADENORM_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGEXTSCALEID_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGMANFLAG_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGINTGRADE_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGINTGRADENORM_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGINTSCALEID_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-DEGHONORS_DG sy-vline 
WA_PIQRULEMASTER_APP_STR-SPECDEGREENR_DS sy-vline 
WA_PIQRULEMASTER_APP_STR-SPECID_DS sy-vline 
WA_PIQRULEMASTER_APP_STR-SPECTYPE_DS sy-vline 
WA_PIQRULEMASTER_APP_STR-SESSIONID_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-SESSIONYEAR_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-SESBEGDATE_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-SESENDDATE_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-SESWITHDRDATE_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-SESDEGREEID_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-SESPROGRAMID_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-STAGEID_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-PROGCLASSID_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-PROGACST_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-PROGSTAT_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTSESGPA_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTSESGPANORM_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTSESGPASCALE_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-SESGPAMANFLAG_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-INTSESGPA_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-INTSESGPANORM_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-INTSESGPASCALE_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTSESATMCRED_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTSESGRDCRED_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTSESERNCRED_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTSESCREDTYPE_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-SESCREDMANFLAG_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-INTSESATMCRED_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-INTSESGRDCRED_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-INTSESERNCRED_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-INTSESCREDTYPE_PR sy-vline 
WA_PIQRULEMASTER_APP_STR-COURSEID_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTGRADE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTGRADENORM_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTGRADESCALE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-GRADEMANFLAG_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-INTGRADE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-INTGRADENORM_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-INTGRADESCALE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-COREPEATFLAG_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-HONORSINDIC_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTCOATMCRED_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTCOGRDCRED_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTCOERNCRED_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-EXTCOCREDTYPE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-COCREDMANFLAG_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-INTCOATMCRED_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-INTCOGRDCRED_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-INTCOERNCRED_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-INTCOCREDTYPE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-BASFORCOCRED_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-COREFLAG_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-COWITHDRDATE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-COSESID_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-COSESYEAR_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-COBEGDATE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-COENDDATE_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-ATTNO_TW_SU sy-vline 
WA_PIQRULEMASTER_APP_STR-CODEDNOTEID_CN sy-vline 
WA_PIQRULEMASTER_APP_STR-COMMENTLINE_CN sy-vline 
WA_PIQRULEMASTER_APP_STR-TEST_GUIDTST sy-vline 
WA_PIQRULEMASTER_APP_STR-TESTEOTST sy-vline 
WA_PIQRULEMASTER_APP_STR-TRANSEOTST sy-vline 
WA_PIQRULEMASTER_APP_STR-TESTTYPETST sy-vline 
WA_PIQRULEMASTER_APP_STR-SESSIONIDTST sy-vline 
WA_PIQRULEMASTER_APP_STR-SESSIONYEARTST sy-vline 
WA_PIQRULEMASTER_APP_STR-ENTRYDATETST sy-vline 
WA_PIQRULEMASTER_APP_STR-TESTPASSFAILTST sy-vline 
WA_PIQRULEMASTER_APP_STR-TESTTOTRESTST sy-vline 
WA_PIQRULEMASTER_APP_STR-TESTTOTRESNORMTST sy-vline 
WA_PIQRULEMASTER_APP_STR-TESTSCALE_IDTST sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTALPERCENT1TST sy-vline 
WA_PIQRULEMASTER_APP_STR-TOTALPERCENT2TST sy-vline 
WA_PIQRULEMASTER_APP_STR-ENTRYMODETST sy-vline 
WA_PIQRULEMASTER_APP_STR-RESULTSTATUSTST sy-vline 
WA_PIQRULEMASTER_APP_STR-STATUSREASONTST sy-vline 
WA_PIQRULEMASTER_APP_STR-SUBTESTIDSTS sy-vline 
WA_PIQRULEMASTER_APP_STR-SUBTESTRESSTS sy-vline 
WA_PIQRULEMASTER_APP_STR-SUBTESTRESNORMSTS sy-vline 
WA_PIQRULEMASTER_APP_STR-SUBTESTSCALE_IDSTS sy-vline 
WA_PIQRULEMASTER_APP_STR-SUBPERCENT1STS sy-vline 
WA_PIQRULEMASTER_APP_STR-SUBPERCENT2STS sy-vline      INTO ld_text SEPARATED BY SPACE.

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