ABAP Select data from SAP table ALMTEDATA into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP ALMTEDATA 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 ALMTEDATA. 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 ALMTEDATA 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_ALMTEDATA TYPE STANDARD TABLE OF ALMTEDATA,
      WA_ALMTEDATA TYPE ALMTEDATA,
      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: <ALMTEDATA> TYPE ALMTEDATA.

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

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

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ALMTEDATA ASSIGNING <ALMTEDATA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ALMTEDATA>-TID = 1.
<ALMTEDATA>-MTSYSID = 1.
<ALMTEDATA>-MTMCNAME = 1.
<ALMTEDATA>-MTNUMRANGE = 1.
<ALMTEDATA>-MTUID = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ALMTEDATA-MTCLASS, sy-vline,
WA_ALMTEDATA-MTINDEX, sy-vline,
WA_ALMTEDATA-EXTINDEX, sy-vline,
WA_ALMTEDATA-MTE_NAME, sy-vline,
WA_ALMTEDATA-BASE_DATA, sy-vline,
WA_ALMTEDATA-RC, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ALMTEDATA 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_ALMTEDATA 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_ALMTEDATA INTO WA_ALMTEDATA. *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.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_ALMTEDATA_STR,
TID TYPE STRING,
MTSYSID TYPE STRING,
MTMCNAME TYPE STRING,
MTNUMRANGE TYPE STRING,
MTUID TYPE STRING,
MTCLASS TYPE STRING,
MTINDEX TYPE STRING,
EXTINDEX TYPE STRING,
MTE_NAME TYPE STRING,
BASE_DATA TYPE STRING,
RC TYPE STRING,
MTSYSID TYPE STRING,
MTMCNAME TYPE STRING,
MTNUMRANGE TYPE STRING,
MTUID TYPE STRING,
MTCLASS TYPE STRING,
MTINDEX TYPE STRING,
EXTINDEX TYPE STRING,
CUSTSTATUS TYPE STRING,
USECLASS TYPE STRING,
SEVERITY TYPE STRING,
STATISTREC TYPE STRING,
VISUSERLEV TYPE STRING,
KEEPALTYPE TYPE STRING,
KEEPALMAX TYPE STRING,
SECTRGTOOL TYPE STRING,
SECINACTIV TYPE STRING,
WARMUPTIME TYPE STRING,
DTEXTCLASS TYPE STRING,
DTEXTID TYPE STRING,
CUSGRPNAME TYPE STRING,
DELIVERSTA TYPE STRING,
HIGHALVAL TYPE STRING,
HIGHALSEV TYPE STRING,
ALSYSID TYPE STRING,
MSEGNAME TYPE STRING,
ALUNIQNUM TYPE STRING,
ALINDEX TYPE STRING,
ALERTDATE TYPE STRING,
ALERTTIME TYPE STRING,
DUMMYALIGN TYPE STRING,
LASTVALDAT TYPE STRING,
LASTVALTIM TYPE STRING,
LASTVALDUM TYPE STRING,
ACTUALVAL TYPE STRING,
ACTUALSEV TYPE STRING,
VALSYSID TYPE STRING,
VMSEGNAME TYPE STRING,
VALUNIQNUM TYPE STRING,
VALINDEX TYPE STRING,
VALERTDATE TYPE STRING,
VALERTTIME TYPE STRING,
VALERTDUM TYPE STRING,
COUNTOFACT TYPE STRING,
COUNTSUM TYPE STRING,
TDSTATUS TYPE STRING,
TRGTDEFNAM TYPE STRING,
TRGTDEFDSP TYPE STRING,
TRGTDEFSTA TYPE STRING,
TRGTDEFCOS TYPE STRING,
ANATDEFNAM TYPE STRING,
ANATDEFDSP TYPE STRING,
ANATDEFSTA TYPE STRING,
ANATDEFCOS TYPE STRING,
ONATDEFNAM TYPE STRING,
ONATDEFDSP TYPE STRING,
ONATDEFSTA TYPE STRING,
ONATDEFCOS TYPE STRING,
TRGTRUNNAM TYPE STRING,
TRGTRUNSTA TYPE STRING,
TRGTRUNDAT TYPE STRING,
TRGTRUNTIM TYPE STRING,
TRGTRUNDUM TYPE STRING,
TRGTRUNDSP TYPE STRING,
ONATRUNNAM TYPE STRING,
ONATRUNSTA TYPE STRING,
ONATRUNDAT TYPE STRING,
ONATRUNTIM TYPE STRING,
ONATRUNDUM TYPE STRING,
ONATRUNDSP TYPE STRING,
OBJECTNAME TYPE STRING,
MTNAMESHRT TYPE STRING,
MTESUBTYPE TYPE STRING,
CNTALINLST TYPE STRING,
CNTMTCHILD TYPE STRING,
SMES_DATA TYPE STRING,
MTSYSID TYPE STRING,
MTMCNAME TYPE STRING,
MTNUMRANGE TYPE STRING,
MTUID TYPE STRING,
MTCLASS TYPE STRING,
MTINDEX TYPE STRING,
EXTINDEX TYPE STRING,
CUSTSTAT TYPE STRING,
ALERTMODE TYPE STRING,
ALERTSHIFT TYPE STRING,
CUSGRPNAME TYPE STRING,
SMSGVALUE TYPE STRING,
SMSGDATE TYPE STRING,
SMSGTIME TYPE STRING,
SMSGDUMMY TYPE STRING,
MSG TYPE STRING,
RC TYPE STRING,
PERF_DATA TYPE STRING,
MTSYSID TYPE STRING,
MTMCNAME TYPE STRING,
MTNUMRANGE TYPE STRING,
MTUID TYPE STRING,
MTCLASS TYPE STRING,
MTINDEX TYPE STRING,
EXTINDEX TYPE STRING,
CUSTSTAT TYPE STRING,
RELVALTYPE TYPE STRING,
THRESHDIR TYPE STRING,
THRESHSTAT TYPE STRING,
ACTIVTHG2Y TYPE STRING,
ACTIVTHY2R TYPE STRING,
ACTIVTHY2G TYPE STRING,
ACTIVTHR2Y TYPE STRING,
DEFAUTHG2Y TYPE STRING,
DEFAUTHY2R TYPE STRING,
DEFAUTHY2G TYPE STRING,
DEFAUTHR2Y TYPE STRING,
MSGCLASS TYPE STRING,
MSGID TYPE STRING,
CUSGRPNAME TYPE STRING,
VALUNIT TYPE STRING,
DECIMALS TYPE STRING,
PERFCNTHIG TYPE STRING,
PERFCNTLOW TYPE STRING,
PERFEVTHIG TYPE STRING,
PERFEVTLOW TYPE STRING,
ALRELEVVAL TYPE STRING,
ALRELVALDT TYPE STRING,
ALRELVALTI TYPE STRING,
ALRELVDUMM TYPE STRING,
LASTALSTAT TYPE STRING,
LASTPERVAL TYPE STRING,
AVG00PVAL TYPE STRING,
AVG01PVAL TYPE STRING,
AVG05PVAL TYPE STRING,
AVG15PVAL TYPE STRING,
AVG01SVAL TYPE STRING,
AVG05SVAL TYPE STRING,
AVG15SVAL TYPE STRING,
AVG01CVAL TYPE STRING,
AVG05CVAL TYPE STRING,
AVG15CVAL TYPE STRING,
MAXPFVALUE TYPE STRING,
MAXPFDATE TYPE STRING,
MAXPFTIME TYPE STRING,
MAXPFDUMMY TYPE STRING,
MINPFVALUE TYPE STRING,
MINPFDATE TYPE STRING,
MINPFTIME TYPE STRING,
MINPFDUMMY TYPE STRING,
RC TYPE STRING,
PERFSMDATA TYPE STRING,
PERFHISTRY TYPE STRING,
MSC_LINES TYPE STRING,
MSC_DATA TYPE STRING,
MTSYSID TYPE STRING,
MTMCNAME TYPE STRING,
MTNUMRANGE TYPE STRING,
MTUID TYPE STRING,
MTCLASS TYPE STRING,
MTINDEX TYPE STRING,
EXTINDEX TYPE STRING,
CUSTSTAT TYPE STRING,
RAISEVALUE TYPE STRING,
RAISESEVER TYPE STRING,
ACTMSGMODE TYPE STRING,
ACTMSGMAXS TYPE STRING,
MAXALPROID TYPE STRING,
KEEPLINTYP TYPE STRING,
KEEPLINMAX TYPE STRING,
CUSGRPNAME TYPE STRING,
MSCGLLID TYPE STRING,
MSCDATE TYPE STRING,
MSCTIME TYPE STRING,
MSCDUMMY TYPE STRING,
VALUEORIG TYPE STRING,
SEVERORIG TYPE STRING,
VALUEFLTRD TYPE STRING,
SEVERFLTRD TYPE STRING,
MANDT TYPE STRING,
USERID TYPE STRING,
MSG TYPE STRING,
MSGCLASS TYPE STRING,
MSGID TYPE STRING,
MSGARG1 TYPE STRING,
ARGTYPE1 TYPE STRING,
MSGARG2 TYPE STRING,
ARGTYPE2 TYPE STRING,
MSGARG3 TYPE STRING,
ARGTYPE3 TYPE STRING,
MSGARG4 TYPE STRING,
ARGTYPE4 TYPE STRING,
MSGTEXT TYPE STRING,
RC TYPE STRING,
TXTLK_DATA TYPE STRING,
MTSYSID TYPE STRING,
MTMCNAME TYPE STRING,
MTNUMRANGE TYPE STRING,
MTUID TYPE STRING,
MTCLASS TYPE STRING,
MTINDEX TYPE STRING,
EXTINDEX TYPE STRING,
MTESUBTYPE TYPE STRING,
ATTRTEXT TYPE STRING,
L_MTSYSID TYPE STRING,
L_MTMCNAME TYPE STRING,
L_MTNUMRG TYPE STRING,
L_MTUID TYPE STRING,
L_MTCLASS TYPE STRING,
L_MTINDEX TYPE STRING,
L_EXTINDEX TYPE STRING,
RC TYPE STRING,
HIGH_ALERT TYPE STRING,
RC TYPE STRING,
ALSYSID TYPE STRING,
MSEGNAME TYPE STRING,
ALUNIQNUM TYPE STRING,
ALINDEX TYPE STRING,
ALERTDATE TYPE STRING,
ALERTTIME TYPE STRING,
DUMMYALIGN TYPE STRING,
MTSYSID TYPE STRING,
MTMCNAME TYPE STRING,
MTNUMRANGE TYPE STRING,
MTUID TYPE STRING,
MTCLASS TYPE STRING,
MTINDEX TYPE STRING,
EXTINDEX TYPE STRING,
VALUE TYPE STRING,
SEVERITY TYPE STRING,
STATUS TYPE STRING,
OBJECTNAME TYPE STRING,
FIELDNAME TYPE STRING,
MANDT TYPE STRING,
USERID TYPE STRING,
GONEDATE TYPE STRING,
GONETIME TYPE STRING,
GONEDUMMY TYPE STRING,
REPORTEDBY TYPE STRING,
STATCHGDAT TYPE STRING,
STATCHGTIM TYPE STRING,
STATCHGDUM TYPE STRING,
STATCHGBY TYPE STRING,
TIMEOUTDAT TYPE STRING,
TIMEOUTTIM TYPE STRING,
TIMEOUTDUM TYPE STRING,
MSGCLASS TYPE STRING,
MSGID TYPE STRING,
MSGARG1 TYPE STRING,
ARGTYPE1 TYPE STRING,
MSGARG2 TYPE STRING,
ARGTYPE2 TYPE STRING,
MSGARG3 TYPE STRING,
ARGTYPE3 TYPE STRING,
MSGARG4 TYPE STRING,
ARGTYPE4 TYPE STRING,
MSGTEXT TYPE STRING,
MSG TYPE STRING,
MSCGLID TYPE STRING,
TREE TYPE STRING,
RC TYPE STRING,END OF T_EKKO_STR. DATA: WA_ALMTEDATA_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_ALMTEDATA_STR-TID sy-vline
WA_ALMTEDATA_STR-MTSYSID sy-vline
WA_ALMTEDATA_STR-MTMCNAME sy-vline
WA_ALMTEDATA_STR-MTNUMRANGE sy-vline
WA_ALMTEDATA_STR-MTUID sy-vline
WA_ALMTEDATA_STR-MTCLASS sy-vline
WA_ALMTEDATA_STR-MTINDEX sy-vline
WA_ALMTEDATA_STR-EXTINDEX sy-vline
WA_ALMTEDATA_STR-MTE_NAME sy-vline
WA_ALMTEDATA_STR-BASE_DATA sy-vline
WA_ALMTEDATA_STR-RC sy-vline
WA_ALMTEDATA_STR-MTSYSID sy-vline
WA_ALMTEDATA_STR-MTMCNAME sy-vline
WA_ALMTEDATA_STR-MTNUMRANGE sy-vline
WA_ALMTEDATA_STR-MTUID sy-vline
WA_ALMTEDATA_STR-MTCLASS sy-vline
WA_ALMTEDATA_STR-MTINDEX sy-vline
WA_ALMTEDATA_STR-EXTINDEX sy-vline
WA_ALMTEDATA_STR-CUSTSTATUS sy-vline
WA_ALMTEDATA_STR-USECLASS sy-vline
WA_ALMTEDATA_STR-SEVERITY sy-vline
WA_ALMTEDATA_STR-STATISTREC sy-vline
WA_ALMTEDATA_STR-VISUSERLEV sy-vline
WA_ALMTEDATA_STR-KEEPALTYPE sy-vline
WA_ALMTEDATA_STR-KEEPALMAX sy-vline
WA_ALMTEDATA_STR-SECTRGTOOL sy-vline
WA_ALMTEDATA_STR-SECINACTIV sy-vline
WA_ALMTEDATA_STR-WARMUPTIME sy-vline
WA_ALMTEDATA_STR-DTEXTCLASS sy-vline
WA_ALMTEDATA_STR-DTEXTID sy-vline
WA_ALMTEDATA_STR-CUSGRPNAME sy-vline
WA_ALMTEDATA_STR-DELIVERSTA sy-vline
WA_ALMTEDATA_STR-HIGHALVAL sy-vline
WA_ALMTEDATA_STR-HIGHALSEV sy-vline
WA_ALMTEDATA_STR-ALSYSID sy-vline
WA_ALMTEDATA_STR-MSEGNAME sy-vline
WA_ALMTEDATA_STR-ALUNIQNUM sy-vline
WA_ALMTEDATA_STR-ALINDEX sy-vline
WA_ALMTEDATA_STR-ALERTDATE sy-vline
WA_ALMTEDATA_STR-ALERTTIME sy-vline
WA_ALMTEDATA_STR-DUMMYALIGN sy-vline
WA_ALMTEDATA_STR-LASTVALDAT sy-vline
WA_ALMTEDATA_STR-LASTVALTIM sy-vline
WA_ALMTEDATA_STR-LASTVALDUM sy-vline
WA_ALMTEDATA_STR-ACTUALVAL sy-vline
WA_ALMTEDATA_STR-ACTUALSEV sy-vline
WA_ALMTEDATA_STR-VALSYSID sy-vline
WA_ALMTEDATA_STR-VMSEGNAME sy-vline
WA_ALMTEDATA_STR-VALUNIQNUM sy-vline
WA_ALMTEDATA_STR-VALINDEX sy-vline
WA_ALMTEDATA_STR-VALERTDATE sy-vline
WA_ALMTEDATA_STR-VALERTTIME sy-vline
WA_ALMTEDATA_STR-VALERTDUM sy-vline
WA_ALMTEDATA_STR-COUNTOFACT sy-vline
WA_ALMTEDATA_STR-COUNTSUM sy-vline
WA_ALMTEDATA_STR-TDSTATUS sy-vline
WA_ALMTEDATA_STR-TRGTDEFNAM sy-vline
WA_ALMTEDATA_STR-TRGTDEFDSP sy-vline
WA_ALMTEDATA_STR-TRGTDEFSTA sy-vline
WA_ALMTEDATA_STR-TRGTDEFCOS sy-vline
WA_ALMTEDATA_STR-ANATDEFNAM sy-vline
WA_ALMTEDATA_STR-ANATDEFDSP sy-vline
WA_ALMTEDATA_STR-ANATDEFSTA sy-vline
WA_ALMTEDATA_STR-ANATDEFCOS sy-vline
WA_ALMTEDATA_STR-ONATDEFNAM sy-vline
WA_ALMTEDATA_STR-ONATDEFDSP sy-vline
WA_ALMTEDATA_STR-ONATDEFSTA sy-vline
WA_ALMTEDATA_STR-ONATDEFCOS sy-vline
WA_ALMTEDATA_STR-TRGTRUNNAM sy-vline
WA_ALMTEDATA_STR-TRGTRUNSTA sy-vline
WA_ALMTEDATA_STR-TRGTRUNDAT sy-vline
WA_ALMTEDATA_STR-TRGTRUNTIM sy-vline
WA_ALMTEDATA_STR-TRGTRUNDUM sy-vline
WA_ALMTEDATA_STR-TRGTRUNDSP sy-vline
WA_ALMTEDATA_STR-ONATRUNNAM sy-vline
WA_ALMTEDATA_STR-ONATRUNSTA sy-vline
WA_ALMTEDATA_STR-ONATRUNDAT sy-vline
WA_ALMTEDATA_STR-ONATRUNTIM sy-vline
WA_ALMTEDATA_STR-ONATRUNDUM sy-vline
WA_ALMTEDATA_STR-ONATRUNDSP sy-vline
WA_ALMTEDATA_STR-OBJECTNAME sy-vline
WA_ALMTEDATA_STR-MTNAMESHRT sy-vline
WA_ALMTEDATA_STR-MTESUBTYPE sy-vline
WA_ALMTEDATA_STR-CNTALINLST sy-vline
WA_ALMTEDATA_STR-CNTMTCHILD sy-vline
WA_ALMTEDATA_STR-SMES_DATA sy-vline
WA_ALMTEDATA_STR-MTSYSID sy-vline
WA_ALMTEDATA_STR-MTMCNAME sy-vline
WA_ALMTEDATA_STR-MTNUMRANGE sy-vline
WA_ALMTEDATA_STR-MTUID sy-vline
WA_ALMTEDATA_STR-MTCLASS sy-vline
WA_ALMTEDATA_STR-MTINDEX sy-vline
WA_ALMTEDATA_STR-EXTINDEX sy-vline
WA_ALMTEDATA_STR-CUSTSTAT sy-vline
WA_ALMTEDATA_STR-ALERTMODE sy-vline
WA_ALMTEDATA_STR-ALERTSHIFT sy-vline
WA_ALMTEDATA_STR-CUSGRPNAME sy-vline
WA_ALMTEDATA_STR-SMSGVALUE sy-vline
WA_ALMTEDATA_STR-SMSGDATE sy-vline
WA_ALMTEDATA_STR-SMSGTIME sy-vline
WA_ALMTEDATA_STR-SMSGDUMMY sy-vline
WA_ALMTEDATA_STR-MSG sy-vline
WA_ALMTEDATA_STR-RC sy-vline
WA_ALMTEDATA_STR-PERF_DATA sy-vline
WA_ALMTEDATA_STR-MTSYSID sy-vline
WA_ALMTEDATA_STR-MTMCNAME sy-vline
WA_ALMTEDATA_STR-MTNUMRANGE sy-vline
WA_ALMTEDATA_STR-MTUID sy-vline
WA_ALMTEDATA_STR-MTCLASS sy-vline
WA_ALMTEDATA_STR-MTINDEX sy-vline
WA_ALMTEDATA_STR-EXTINDEX sy-vline
WA_ALMTEDATA_STR-CUSTSTAT sy-vline
WA_ALMTEDATA_STR-RELVALTYPE sy-vline
WA_ALMTEDATA_STR-THRESHDIR sy-vline
WA_ALMTEDATA_STR-THRESHSTAT sy-vline
WA_ALMTEDATA_STR-ACTIVTHG2Y sy-vline
WA_ALMTEDATA_STR-ACTIVTHY2R sy-vline
WA_ALMTEDATA_STR-ACTIVTHY2G sy-vline
WA_ALMTEDATA_STR-ACTIVTHR2Y sy-vline
WA_ALMTEDATA_STR-DEFAUTHG2Y sy-vline
WA_ALMTEDATA_STR-DEFAUTHY2R sy-vline
WA_ALMTEDATA_STR-DEFAUTHY2G sy-vline
WA_ALMTEDATA_STR-DEFAUTHR2Y sy-vline
WA_ALMTEDATA_STR-MSGCLASS sy-vline
WA_ALMTEDATA_STR-MSGID sy-vline
WA_ALMTEDATA_STR-CUSGRPNAME sy-vline
WA_ALMTEDATA_STR-VALUNIT sy-vline
WA_ALMTEDATA_STR-DECIMALS sy-vline
WA_ALMTEDATA_STR-PERFCNTHIG sy-vline
WA_ALMTEDATA_STR-PERFCNTLOW sy-vline
WA_ALMTEDATA_STR-PERFEVTHIG sy-vline
WA_ALMTEDATA_STR-PERFEVTLOW sy-vline
WA_ALMTEDATA_STR-ALRELEVVAL sy-vline
WA_ALMTEDATA_STR-ALRELVALDT sy-vline
WA_ALMTEDATA_STR-ALRELVALTI sy-vline
WA_ALMTEDATA_STR-ALRELVDUMM sy-vline
WA_ALMTEDATA_STR-LASTALSTAT sy-vline
WA_ALMTEDATA_STR-LASTPERVAL sy-vline
WA_ALMTEDATA_STR-AVG00PVAL sy-vline
WA_ALMTEDATA_STR-AVG01PVAL sy-vline
WA_ALMTEDATA_STR-AVG05PVAL sy-vline
WA_ALMTEDATA_STR-AVG15PVAL sy-vline
WA_ALMTEDATA_STR-AVG01SVAL sy-vline
WA_ALMTEDATA_STR-AVG05SVAL sy-vline
WA_ALMTEDATA_STR-AVG15SVAL sy-vline
WA_ALMTEDATA_STR-AVG01CVAL sy-vline
WA_ALMTEDATA_STR-AVG05CVAL sy-vline
WA_ALMTEDATA_STR-AVG15CVAL sy-vline
WA_ALMTEDATA_STR-MAXPFVALUE sy-vline
WA_ALMTEDATA_STR-MAXPFDATE sy-vline
WA_ALMTEDATA_STR-MAXPFTIME sy-vline
WA_ALMTEDATA_STR-MAXPFDUMMY sy-vline
WA_ALMTEDATA_STR-MINPFVALUE sy-vline
WA_ALMTEDATA_STR-MINPFDATE sy-vline
WA_ALMTEDATA_STR-MINPFTIME sy-vline
WA_ALMTEDATA_STR-MINPFDUMMY sy-vline
WA_ALMTEDATA_STR-RC sy-vline
WA_ALMTEDATA_STR-PERFSMDATA sy-vline
WA_ALMTEDATA_STR-PERFHISTRY sy-vline
WA_ALMTEDATA_STR-MSC_LINES sy-vline
WA_ALMTEDATA_STR-MSC_DATA sy-vline
WA_ALMTEDATA_STR-MTSYSID sy-vline
WA_ALMTEDATA_STR-MTMCNAME sy-vline
WA_ALMTEDATA_STR-MTNUMRANGE sy-vline
WA_ALMTEDATA_STR-MTUID sy-vline
WA_ALMTEDATA_STR-MTCLASS sy-vline
WA_ALMTEDATA_STR-MTINDEX sy-vline
WA_ALMTEDATA_STR-EXTINDEX sy-vline
WA_ALMTEDATA_STR-CUSTSTAT sy-vline
WA_ALMTEDATA_STR-RAISEVALUE sy-vline
WA_ALMTEDATA_STR-RAISESEVER sy-vline
WA_ALMTEDATA_STR-ACTMSGMODE sy-vline
WA_ALMTEDATA_STR-ACTMSGMAXS sy-vline
WA_ALMTEDATA_STR-MAXALPROID sy-vline
WA_ALMTEDATA_STR-KEEPLINTYP sy-vline
WA_ALMTEDATA_STR-KEEPLINMAX sy-vline
WA_ALMTEDATA_STR-CUSGRPNAME sy-vline
WA_ALMTEDATA_STR-MSCGLLID sy-vline
WA_ALMTEDATA_STR-MSCDATE sy-vline
WA_ALMTEDATA_STR-MSCTIME sy-vline
WA_ALMTEDATA_STR-MSCDUMMY sy-vline
WA_ALMTEDATA_STR-VALUEORIG sy-vline
WA_ALMTEDATA_STR-SEVERORIG sy-vline
WA_ALMTEDATA_STR-VALUEFLTRD sy-vline
WA_ALMTEDATA_STR-SEVERFLTRD sy-vline
WA_ALMTEDATA_STR-MANDT sy-vline
WA_ALMTEDATA_STR-USERID sy-vline
WA_ALMTEDATA_STR-MSG sy-vline
WA_ALMTEDATA_STR-MSGCLASS sy-vline
WA_ALMTEDATA_STR-MSGID sy-vline
WA_ALMTEDATA_STR-MSGARG1 sy-vline
WA_ALMTEDATA_STR-ARGTYPE1 sy-vline
WA_ALMTEDATA_STR-MSGARG2 sy-vline
WA_ALMTEDATA_STR-ARGTYPE2 sy-vline
WA_ALMTEDATA_STR-MSGARG3 sy-vline
WA_ALMTEDATA_STR-ARGTYPE3 sy-vline
WA_ALMTEDATA_STR-MSGARG4 sy-vline
WA_ALMTEDATA_STR-ARGTYPE4 sy-vline
WA_ALMTEDATA_STR-MSGTEXT sy-vline
WA_ALMTEDATA_STR-RC sy-vline
WA_ALMTEDATA_STR-TXTLK_DATA sy-vline
WA_ALMTEDATA_STR-MTSYSID sy-vline
WA_ALMTEDATA_STR-MTMCNAME sy-vline
WA_ALMTEDATA_STR-MTNUMRANGE sy-vline
WA_ALMTEDATA_STR-MTUID sy-vline
WA_ALMTEDATA_STR-MTCLASS sy-vline
WA_ALMTEDATA_STR-MTINDEX sy-vline
WA_ALMTEDATA_STR-EXTINDEX sy-vline
WA_ALMTEDATA_STR-MTESUBTYPE sy-vline
WA_ALMTEDATA_STR-ATTRTEXT sy-vline
WA_ALMTEDATA_STR-L_MTSYSID sy-vline
WA_ALMTEDATA_STR-L_MTMCNAME sy-vline
WA_ALMTEDATA_STR-L_MTNUMRG sy-vline
WA_ALMTEDATA_STR-L_MTUID sy-vline
WA_ALMTEDATA_STR-L_MTCLASS sy-vline
WA_ALMTEDATA_STR-L_MTINDEX sy-vline
WA_ALMTEDATA_STR-L_EXTINDEX sy-vline
WA_ALMTEDATA_STR-RC sy-vline
WA_ALMTEDATA_STR-HIGH_ALERT sy-vline
WA_ALMTEDATA_STR-RC sy-vline
WA_ALMTEDATA_STR-ALSYSID sy-vline
WA_ALMTEDATA_STR-MSEGNAME sy-vline
WA_ALMTEDATA_STR-ALUNIQNUM sy-vline
WA_ALMTEDATA_STR-ALINDEX sy-vline
WA_ALMTEDATA_STR-ALERTDATE sy-vline
WA_ALMTEDATA_STR-ALERTTIME sy-vline
WA_ALMTEDATA_STR-DUMMYALIGN sy-vline
WA_ALMTEDATA_STR-MTSYSID sy-vline
WA_ALMTEDATA_STR-MTMCNAME sy-vline
WA_ALMTEDATA_STR-MTNUMRANGE sy-vline
WA_ALMTEDATA_STR-MTUID sy-vline
WA_ALMTEDATA_STR-MTCLASS sy-vline
WA_ALMTEDATA_STR-MTINDEX sy-vline
WA_ALMTEDATA_STR-EXTINDEX sy-vline
WA_ALMTEDATA_STR-VALUE sy-vline
WA_ALMTEDATA_STR-SEVERITY sy-vline
WA_ALMTEDATA_STR-STATUS sy-vline
WA_ALMTEDATA_STR-OBJECTNAME sy-vline
WA_ALMTEDATA_STR-FIELDNAME sy-vline
WA_ALMTEDATA_STR-MANDT sy-vline
WA_ALMTEDATA_STR-USERID sy-vline
WA_ALMTEDATA_STR-GONEDATE sy-vline
WA_ALMTEDATA_STR-GONETIME sy-vline
WA_ALMTEDATA_STR-GONEDUMMY sy-vline
WA_ALMTEDATA_STR-REPORTEDBY sy-vline
WA_ALMTEDATA_STR-STATCHGDAT sy-vline
WA_ALMTEDATA_STR-STATCHGTIM sy-vline
WA_ALMTEDATA_STR-STATCHGDUM sy-vline
WA_ALMTEDATA_STR-STATCHGBY sy-vline
WA_ALMTEDATA_STR-TIMEOUTDAT sy-vline
WA_ALMTEDATA_STR-TIMEOUTTIM sy-vline
WA_ALMTEDATA_STR-TIMEOUTDUM sy-vline
WA_ALMTEDATA_STR-MSGCLASS sy-vline
WA_ALMTEDATA_STR-MSGID sy-vline
WA_ALMTEDATA_STR-MSGARG1 sy-vline
WA_ALMTEDATA_STR-ARGTYPE1 sy-vline
WA_ALMTEDATA_STR-MSGARG2 sy-vline
WA_ALMTEDATA_STR-ARGTYPE2 sy-vline
WA_ALMTEDATA_STR-MSGARG3 sy-vline
WA_ALMTEDATA_STR-ARGTYPE3 sy-vline
WA_ALMTEDATA_STR-MSGARG4 sy-vline
WA_ALMTEDATA_STR-ARGTYPE4 sy-vline
WA_ALMTEDATA_STR-MSGTEXT sy-vline
WA_ALMTEDATA_STR-MSG sy-vline
WA_ALMTEDATA_STR-MSCGLID sy-vline
WA_ALMTEDATA_STR-TREE sy-vline
WA_ALMTEDATA_STR-RC sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.