ABAP Select data from SAP table PIQRULEMASTERS 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 PIQRULEMASTERS 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 PIQRULEMASTERS. 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 PIQRULEMASTERS 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_PIQRULEMASTERS TYPE STANDARD TABLE OF PIQRULEMASTERS,
      WA_PIQRULEMASTERS TYPE PIQRULEMASTERS,
      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: <PIQRULEMASTERS> TYPE PIQRULEMASTERS.

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PIQRULEMASTERS>-CNT_ID = 1.
<PIQRULEMASTERS>-ONE = 1.
<PIQRULEMASTERS>-SM_PLVAR = 1.
<PIQRULEMASTERS>-SM_OBJID = 1.
<PIQRULEMASTERS>-SM_SHORT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PIQRULEMASTERS-SM_STEXT, sy-vline,
  WA_PIQRULEMASTERS-SM_1746_SEVERITY, sy-vline,
  WA_PIQRULEMASTERS-SM_1746_CATEGORY, sy-vline,
  WA_PIQRULEMASTERS-SM_1746_MODREPTYPE, sy-vline,
  WA_PIQRULEMASTERS-SM_1746_SHOWINCAT, sy-vline,
  WA_PIQRULEMASTERS-SM_1744_DISZIPRIMARY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PIQRULEMASTERS 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_PIQRULEMASTERS 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_PIQRULEMASTERS INTO WA_PIQRULEMASTERS.


*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 SM_506_CPUNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PIQRULEMASTERS-SM_506_CPUNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTERS-SM_506_CPUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TOTEXTCREDTYPE_HD
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PIQRULEMASTERS-TOTEXTCREDTYPE_HD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTERS-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_PIQRULEMASTERS-TOTINTCREDTYPE_HD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTERS-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_PIQRULEMASTERS-EXTSESCREDTYPE_PR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTERS-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_PIQRULEMASTERS-INTSESCREDTYPE_PR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTERS-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_PIQRULEMASTERS-EXTCOCREDTYPE_SU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTERS-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_PIQRULEMASTERS-INTCOCREDTYPE_SU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PIQRULEMASTERS-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_PIQRULEMASTERS_STR, 
CNT_ID TYPE STRING,
ONE TYPE STRING,
SM_PLVAR TYPE STRING,
SM_OBJID TYPE STRING,
SM_SHORT TYPE STRING,
SM_STEXT TYPE STRING,
SM_1746_SEVERITY TYPE STRING,
SM_1746_CATEGORY TYPE STRING,
SM_1746_MODREPTYPE TYPE STRING,
SM_1746_SHOWINCAT TYPE STRING,
SM_1744_DISZIPRIMARY TYPE STRING,
SM_506_BEGDA TYPE STRING,
SM_506_ENDDA TYPE STRING,
SM_506_PRIOX TYPE STRING,
SM_506_SMSTATUS TYPE STRING,
SM_506_STORREASON TYPE STRING,
SM_506_STORDATE TYPE STRING,
SM_506_CPATTEMP TYPE STRING,
SM_506_CPUNIT TYPE STRING,
SM_506_BOOKDATE TYPE STRING,
SM_506_SMRATING TYPE STRING,
SM_506_CHARGEFREE TYPE STRING,
SM_506_TRANSFERFLAG TYPE STRING,
SM_506_PACKNUMBER TYPE STRING,
SM_506_PERID TYPE STRING,
SM_506_PERYR TYPE STRING,
SM_506_BOOKREASON TYPE STRING,
SM_506_ANNULMENT TYPE STRING,
SM_SE_LOCATION TYPE STRING,
SM_ACTIVE_PERYR TYPE STRING,
SM_ACTIVE_PERID TYPE STRING,
SM_SC_OBJID TYPE STRING,
SM_BOOKID TYPE STRING,
CG_OBJID TYPE STRING,
CG_CATEGORY TYPE STRING,
CG_DISZIPPRIMARY TYPE STRING,
CG_ACTIVITY TYPE STRING,
ACLEVEL_BEG TYPE STRING,
ACLEVEL_END TYPE STRING,
CA_OOOTYPE TYPE STRING,
CA_OOOBJID TYPE STRING,
CA_OTYPE TYPE STRING,
CA_OBJID TYPE STRING,
CA_TIMELIMITUP TYPE STRING,
CA_TIMELIMIT TYPE STRING,
CA_PERYR TYPE STRING,
CA_PERID TYPE STRING,
CA_LBEGDA TYPE STRING,
CA_LBEGTIME TYPE STRING,
CA_LENDDA TYPE STRING,
CA_LENDTIME TYPE STRING,
CA_NUMBER_FROM TYPE STRING,
CA_UNIT_FROM TYPE STRING,
CA_POINT_FROM TYPE STRING,
CA_NUMBER_TO TYPE STRING,
CA_UNIT_TO TYPE STRING,
CA_POINT_TO TYPE STRING,
CA_REFERENCE TYPE STRING,
CA_TIMELIMIT_R TYPE STRING,
SE_OBJID TYPE STRING,
SE_SHORT TYPE STRING,
SE_STEXT TYPE STRING,
D_OBJID TYPE STRING,
D_SHORT TYPE STRING,
D_STEXT TYPE STRING,
E_OBJID TYPE STRING,
E_OTYPE TYPE STRING,
E_SHORT TYPE STRING,
E_STEXT TYPE STRING,
SE_LOCATION TYPE STRING,
E_LOCATION TYPE STRING,
D_DELMODE TYPE STRING,
D_CATEGORY TYPE STRING,
D_TEACHMETHOD TYPE STRING,
E_STATUS TYPE STRING,
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,
QQ_OBT_OTYPE TYPE STRING,
QQ_OBT_OBJID TYPE STRING,
QQ_OBT_SHORT TYPE STRING,
QQ_QUAL_OTYPE TYPE STRING,
QQ_QUAL_OBJID TYPE STRING,
QQ_QUAL_BEGDA TYPE STRING,
QQ_QUAL_ENDDA TYPE STRING,
QQ_QUAL_SHORT TYPE STRING,
QQ_QUAL_GROUP TYPE STRING,
QQ_QUAL_DISCI TYPE STRING,
QQ_QUAL_LEVEL TYPE STRING,
QQ_QUAL_CLASS TYPE STRING,
QQ_QUAL_VALUE TYPE STRING,
QQ_OBTAINDATE TYPE STRING,
QQ_GRADE_INTERNAL TYPE STRING,
QQ_GRADE_INTERNALT TYPE STRING,
QQ_GRADE_INTNORMVALUE TYPE STRING,
QQ_SCALE_INTERNAL TYPE STRING,
QQ_SCALE_INTERNALT TYPE STRING,
QQ_GRADE_EXTERNAL TYPE STRING,
QQ_GRADE_EXTERNALT TYPE STRING,
QQ_SCALE_EXTERNAL TYPE STRING,
QQ_SCALE_EXTERNALT TYPE STRING,
QQ_TRANSFERFLAG TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PIQRULEMASTERS_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_PIQRULEMASTERS_STR-CNT_ID sy-vline 
WA_PIQRULEMASTERS_STR-ONE sy-vline 
WA_PIQRULEMASTERS_STR-SM_PLVAR sy-vline 
WA_PIQRULEMASTERS_STR-SM_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-SM_SHORT sy-vline 
WA_PIQRULEMASTERS_STR-SM_STEXT sy-vline 
WA_PIQRULEMASTERS_STR-SM_1746_SEVERITY sy-vline 
WA_PIQRULEMASTERS_STR-SM_1746_CATEGORY sy-vline 
WA_PIQRULEMASTERS_STR-SM_1746_MODREPTYPE sy-vline 
WA_PIQRULEMASTERS_STR-SM_1746_SHOWINCAT sy-vline 
WA_PIQRULEMASTERS_STR-SM_1744_DISZIPRIMARY sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_BEGDA sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_ENDDA sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_PRIOX sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_SMSTATUS sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_STORREASON sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_STORDATE sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_CPATTEMP sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_CPUNIT sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_BOOKDATE sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_SMRATING sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_CHARGEFREE sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_TRANSFERFLAG sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_PACKNUMBER sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_PERID sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_PERYR sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_BOOKREASON sy-vline 
WA_PIQRULEMASTERS_STR-SM_506_ANNULMENT sy-vline 
WA_PIQRULEMASTERS_STR-SM_SE_LOCATION sy-vline 
WA_PIQRULEMASTERS_STR-SM_ACTIVE_PERYR sy-vline 
WA_PIQRULEMASTERS_STR-SM_ACTIVE_PERID sy-vline 
WA_PIQRULEMASTERS_STR-SM_SC_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-SM_BOOKID sy-vline 
WA_PIQRULEMASTERS_STR-CG_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-CG_CATEGORY sy-vline 
WA_PIQRULEMASTERS_STR-CG_DISZIPPRIMARY sy-vline 
WA_PIQRULEMASTERS_STR-CG_ACTIVITY sy-vline 
WA_PIQRULEMASTERS_STR-ACLEVEL_BEG sy-vline 
WA_PIQRULEMASTERS_STR-ACLEVEL_END sy-vline 
WA_PIQRULEMASTERS_STR-CA_OOOTYPE sy-vline 
WA_PIQRULEMASTERS_STR-CA_OOOBJID sy-vline 
WA_PIQRULEMASTERS_STR-CA_OTYPE sy-vline 
WA_PIQRULEMASTERS_STR-CA_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-CA_TIMELIMITUP sy-vline 
WA_PIQRULEMASTERS_STR-CA_TIMELIMIT sy-vline 
WA_PIQRULEMASTERS_STR-CA_PERYR sy-vline 
WA_PIQRULEMASTERS_STR-CA_PERID sy-vline 
WA_PIQRULEMASTERS_STR-CA_LBEGDA sy-vline 
WA_PIQRULEMASTERS_STR-CA_LBEGTIME sy-vline 
WA_PIQRULEMASTERS_STR-CA_LENDDA sy-vline 
WA_PIQRULEMASTERS_STR-CA_LENDTIME sy-vline 
WA_PIQRULEMASTERS_STR-CA_NUMBER_FROM sy-vline 
WA_PIQRULEMASTERS_STR-CA_UNIT_FROM sy-vline 
WA_PIQRULEMASTERS_STR-CA_POINT_FROM sy-vline 
WA_PIQRULEMASTERS_STR-CA_NUMBER_TO sy-vline 
WA_PIQRULEMASTERS_STR-CA_UNIT_TO sy-vline 
WA_PIQRULEMASTERS_STR-CA_POINT_TO sy-vline 
WA_PIQRULEMASTERS_STR-CA_REFERENCE sy-vline 
WA_PIQRULEMASTERS_STR-CA_TIMELIMIT_R sy-vline 
WA_PIQRULEMASTERS_STR-SE_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-SE_SHORT sy-vline 
WA_PIQRULEMASTERS_STR-SE_STEXT sy-vline 
WA_PIQRULEMASTERS_STR-D_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-D_SHORT sy-vline 
WA_PIQRULEMASTERS_STR-D_STEXT sy-vline 
WA_PIQRULEMASTERS_STR-E_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-E_OTYPE sy-vline 
WA_PIQRULEMASTERS_STR-E_SHORT sy-vline 
WA_PIQRULEMASTERS_STR-E_STEXT sy-vline 
WA_PIQRULEMASTERS_STR-SE_LOCATION sy-vline 
WA_PIQRULEMASTERS_STR-E_LOCATION sy-vline 
WA_PIQRULEMASTERS_STR-D_DELMODE sy-vline 
WA_PIQRULEMASTERS_STR-D_CATEGORY sy-vline 
WA_PIQRULEMASTERS_STR-D_TEACHMETHOD sy-vline 
WA_PIQRULEMASTERS_STR-E_STATUS sy-vline 
WA_PIQRULEMASTERS_STR-ADDRESS_TYPE sy-vline 
WA_PIQRULEMASTERS_STR-HOUSE_NO sy-vline 
WA_PIQRULEMASTERS_STR-STREET sy-vline 
WA_PIQRULEMASTERS_STR-STREET2 sy-vline 
WA_PIQRULEMASTERS_STR-CITY sy-vline 
WA_PIQRULEMASTERS_STR-POSTAL_CD sy-vline 
WA_PIQRULEMASTERS_STR-COUNTRY sy-vline 
WA_PIQRULEMASTERS_STR-REGION sy-vline 
WA_PIQRULEMASTERS_STR-TEL_NO sy-vline 
WA_PIQRULEMASTERS_STR-FAX_NO sy-vline 
WA_PIQRULEMASTERS_STR-CG_OBJID_CG sy-vline 
WA_PIQRULEMASTERS_STR-TRANS_GUID_HD sy-vline 
WA_PIQRULEMASTERS_STR-TRANSTYPE_HD sy-vline 
WA_PIQRULEMASTERS_STR-ISSEO_HD sy-vline 
WA_PIQRULEMASTERS_STR-TRANSEO_HD sy-vline 
WA_PIQRULEMASTERS_STR-TRSTATUS_HD sy-vline 
WA_PIQRULEMASTERS_STR-REGPERIODFROM_HD sy-vline 
WA_PIQRULEMASTERS_STR-REGPERIODTO_HD sy-vline 
WA_PIQRULEMASTERS_STR-RANKING_HD sy-vline 
WA_PIQRULEMASTERS_STR-SIZEOFCLASS_HD sy-vline 
WA_PIQRULEMASTERS_STR-RETURNINDIC_HD sy-vline 
WA_PIQRULEMASTERS_STR-RETURNDATE_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTSELFGPA_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTSELFGPANORM_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTSELFGPASCALE_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA1_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA1NORM_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA1SCALE_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA2_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA2NORM_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA2SCALE_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA3_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA3NORM_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGPA3SCALE_HD sy-vline 
WA_PIQRULEMASTERS_STR-CALCGPAMANFLAG_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTCALCGPA_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTCALCGPANORM_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTCALCGPASCALE_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTATMCRED_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTGRDCRED_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTERNCRED_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTEXTCREDTYPE_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTCREDMANFLAG_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTINTATMCRED_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTINTGRDCRED_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTINTERNCRED_HD sy-vline 
WA_PIQRULEMASTERS_STR-TOTINTCREDTYPE_HD sy-vline 
WA_PIQRULEMASTERS_STR-DEGREENR_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGREEID_DG sy-vline 
WA_PIQRULEMASTERS_STR-PROGRAMID_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGERNFLAG_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGDATE_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGEXTGRADE_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGEXTGRADENORM_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGEXTSCALEID_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGMANFLAG_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGINTGRADE_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGINTGRADENORM_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGINTSCALEID_DG sy-vline 
WA_PIQRULEMASTERS_STR-DEGHONORS_DG sy-vline 
WA_PIQRULEMASTERS_STR-SPECDEGREENR_DS sy-vline 
WA_PIQRULEMASTERS_STR-SPECID_DS sy-vline 
WA_PIQRULEMASTERS_STR-SPECTYPE_DS sy-vline 
WA_PIQRULEMASTERS_STR-SESSIONID_PR sy-vline 
WA_PIQRULEMASTERS_STR-SESSIONYEAR_PR sy-vline 
WA_PIQRULEMASTERS_STR-SESBEGDATE_PR sy-vline 
WA_PIQRULEMASTERS_STR-SESENDDATE_PR sy-vline 
WA_PIQRULEMASTERS_STR-SESWITHDRDATE_PR sy-vline 
WA_PIQRULEMASTERS_STR-SESDEGREEID_PR sy-vline 
WA_PIQRULEMASTERS_STR-SESPROGRAMID_PR sy-vline 
WA_PIQRULEMASTERS_STR-STAGEID_PR sy-vline 
WA_PIQRULEMASTERS_STR-PROGCLASSID_PR sy-vline 
WA_PIQRULEMASTERS_STR-PROGACST_PR sy-vline 
WA_PIQRULEMASTERS_STR-PROGSTAT_PR sy-vline 
WA_PIQRULEMASTERS_STR-EXTSESGPA_PR sy-vline 
WA_PIQRULEMASTERS_STR-EXTSESGPANORM_PR sy-vline 
WA_PIQRULEMASTERS_STR-EXTSESGPASCALE_PR sy-vline 
WA_PIQRULEMASTERS_STR-SESGPAMANFLAG_PR sy-vline 
WA_PIQRULEMASTERS_STR-INTSESGPA_PR sy-vline 
WA_PIQRULEMASTERS_STR-INTSESGPANORM_PR sy-vline 
WA_PIQRULEMASTERS_STR-INTSESGPASCALE_PR sy-vline 
WA_PIQRULEMASTERS_STR-EXTSESATMCRED_PR sy-vline 
WA_PIQRULEMASTERS_STR-EXTSESGRDCRED_PR sy-vline 
WA_PIQRULEMASTERS_STR-EXTSESERNCRED_PR sy-vline 
WA_PIQRULEMASTERS_STR-EXTSESCREDTYPE_PR sy-vline 
WA_PIQRULEMASTERS_STR-SESCREDMANFLAG_PR sy-vline 
WA_PIQRULEMASTERS_STR-INTSESATMCRED_PR sy-vline 
WA_PIQRULEMASTERS_STR-INTSESGRDCRED_PR sy-vline 
WA_PIQRULEMASTERS_STR-INTSESERNCRED_PR sy-vline 
WA_PIQRULEMASTERS_STR-INTSESCREDTYPE_PR sy-vline 
WA_PIQRULEMASTERS_STR-COURSEID_SU sy-vline 
WA_PIQRULEMASTERS_STR-EXTGRADE_SU sy-vline 
WA_PIQRULEMASTERS_STR-EXTGRADENORM_SU sy-vline 
WA_PIQRULEMASTERS_STR-EXTGRADESCALE_SU sy-vline 
WA_PIQRULEMASTERS_STR-GRADEMANFLAG_SU sy-vline 
WA_PIQRULEMASTERS_STR-INTGRADE_SU sy-vline 
WA_PIQRULEMASTERS_STR-INTGRADENORM_SU sy-vline 
WA_PIQRULEMASTERS_STR-INTGRADESCALE_SU sy-vline 
WA_PIQRULEMASTERS_STR-COREPEATFLAG_SU sy-vline 
WA_PIQRULEMASTERS_STR-HONORSINDIC_SU sy-vline 
WA_PIQRULEMASTERS_STR-EXTCOATMCRED_SU sy-vline 
WA_PIQRULEMASTERS_STR-EXTCOGRDCRED_SU sy-vline 
WA_PIQRULEMASTERS_STR-EXTCOERNCRED_SU sy-vline 
WA_PIQRULEMASTERS_STR-EXTCOCREDTYPE_SU sy-vline 
WA_PIQRULEMASTERS_STR-COCREDMANFLAG_SU sy-vline 
WA_PIQRULEMASTERS_STR-INTCOATMCRED_SU sy-vline 
WA_PIQRULEMASTERS_STR-INTCOGRDCRED_SU sy-vline 
WA_PIQRULEMASTERS_STR-INTCOERNCRED_SU sy-vline 
WA_PIQRULEMASTERS_STR-INTCOCREDTYPE_SU sy-vline 
WA_PIQRULEMASTERS_STR-BASFORCOCRED_SU sy-vline 
WA_PIQRULEMASTERS_STR-COREFLAG_SU sy-vline 
WA_PIQRULEMASTERS_STR-COWITHDRDATE_SU sy-vline 
WA_PIQRULEMASTERS_STR-COSESID_SU sy-vline 
WA_PIQRULEMASTERS_STR-COSESYEAR_SU sy-vline 
WA_PIQRULEMASTERS_STR-COBEGDATE_SU sy-vline 
WA_PIQRULEMASTERS_STR-COENDDATE_SU sy-vline 
WA_PIQRULEMASTERS_STR-ATTNO_TW_SU sy-vline 
WA_PIQRULEMASTERS_STR-CODEDNOTEID_CN sy-vline 
WA_PIQRULEMASTERS_STR-COMMENTLINE_CN sy-vline 
WA_PIQRULEMASTERS_STR-TEST_GUIDTST sy-vline 
WA_PIQRULEMASTERS_STR-TESTEOTST sy-vline 
WA_PIQRULEMASTERS_STR-TRANSEOTST sy-vline 
WA_PIQRULEMASTERS_STR-TESTTYPETST sy-vline 
WA_PIQRULEMASTERS_STR-SESSIONIDTST sy-vline 
WA_PIQRULEMASTERS_STR-SESSIONYEARTST sy-vline 
WA_PIQRULEMASTERS_STR-ENTRYDATETST sy-vline 
WA_PIQRULEMASTERS_STR-TESTPASSFAILTST sy-vline 
WA_PIQRULEMASTERS_STR-TESTTOTRESTST sy-vline 
WA_PIQRULEMASTERS_STR-TESTTOTRESNORMTST sy-vline 
WA_PIQRULEMASTERS_STR-TESTSCALE_IDTST sy-vline 
WA_PIQRULEMASTERS_STR-TOTALPERCENT1TST sy-vline 
WA_PIQRULEMASTERS_STR-TOTALPERCENT2TST sy-vline 
WA_PIQRULEMASTERS_STR-ENTRYMODETST sy-vline 
WA_PIQRULEMASTERS_STR-RESULTSTATUSTST sy-vline 
WA_PIQRULEMASTERS_STR-STATUSREASONTST sy-vline 
WA_PIQRULEMASTERS_STR-SUBTESTIDSTS sy-vline 
WA_PIQRULEMASTERS_STR-SUBTESTRESSTS sy-vline 
WA_PIQRULEMASTERS_STR-SUBTESTRESNORMSTS sy-vline 
WA_PIQRULEMASTERS_STR-SUBTESTSCALE_IDSTS sy-vline 
WA_PIQRULEMASTERS_STR-SUBPERCENT1STS sy-vline 
WA_PIQRULEMASTERS_STR-SUBPERCENT2STS sy-vline 
WA_PIQRULEMASTERS_STR-QQ_OBT_OTYPE sy-vline 
WA_PIQRULEMASTERS_STR-QQ_OBT_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-QQ_OBT_SHORT sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_OTYPE sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_OBJID sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_BEGDA sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_ENDDA sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_SHORT sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_GROUP sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_DISCI sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_LEVEL sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_CLASS sy-vline 
WA_PIQRULEMASTERS_STR-QQ_QUAL_VALUE sy-vline 
WA_PIQRULEMASTERS_STR-QQ_OBTAINDATE sy-vline 
WA_PIQRULEMASTERS_STR-QQ_GRADE_INTERNAL sy-vline 
WA_PIQRULEMASTERS_STR-QQ_GRADE_INTERNALT sy-vline 
WA_PIQRULEMASTERS_STR-QQ_GRADE_INTNORMVALUE sy-vline 
WA_PIQRULEMASTERS_STR-QQ_SCALE_INTERNAL sy-vline 
WA_PIQRULEMASTERS_STR-QQ_SCALE_INTERNALT sy-vline 
WA_PIQRULEMASTERS_STR-QQ_GRADE_EXTERNAL sy-vline 
WA_PIQRULEMASTERS_STR-QQ_GRADE_EXTERNALT sy-vline 
WA_PIQRULEMASTERS_STR-QQ_SCALE_EXTERNAL sy-vline 
WA_PIQRULEMASTERS_STR-QQ_SCALE_EXTERNALT sy-vline 
WA_PIQRULEMASTERS_STR-QQ_TRANSFERFLAG sy-vline      INTO ld_text SEPARATED BY SPACE.

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