ABAP Select data from SAP table ALMTDATA 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 ALMTDATA 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 ALMTDATA. 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 ALMTDATA 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_ALMTDATA TYPE STANDARD TABLE OF ALMTDATA, WA_ALMTDATA TYPE ALMTDATA, 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: <ALMTDATA> TYPE ALMTDATA. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_ALMTDATA. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM ALMTDATA INTO TABLE IT_ALMTDATA. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM ALMTDATA * INTO TABLE @DATA(IT_ALMTDATA2). *--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_ALMTDATA INDEX 1 INTO DATA(WA_ALMTDATA2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_ALMTDATA ASSIGNING <ALMTDATA>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<ALMTDATA>-TID = 1.
<ALMTDATA>-MTSYSID = 1.
<ALMTDATA>-MTMCNAME = 1.
<ALMTDATA>-MTNUMRANGE = 1.
<ALMTDATA>-MTUID = 1.
ENDLOOP. LOOP AT IT_ALMTDATA INTO WA_ALMTDATA. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_ALMTDATA-MTCLASS, sy-vline,
WA_ALMTDATA-MTINDEX, sy-vline,
WA_ALMTDATA-EXTINDEX, sy-vline,
WA_ALMTDATA-MT_NAME, sy-vline,
WA_ALMTDATA-BASE_DATA, sy-vline,
WA_ALMTDATA-MTSYSID, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ALMTDATA 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_ALMTDATA 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_ALMTDATA INTO WA_ALMTDATA. *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_ALMTDATA_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,
MT_NAME TYPE STRING,
BASE_DATA 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,
ALTREENUM TYPE STRING,
ALIDXINTRE TYPE STRING,
ALLEVINTRE TYPE STRING,
ALPARINTRE TYPE STRING,
ALMTFULLNM TYPE STRING,
RC TYPE STRING,
EXPAND TYPE STRING,
MARKED TYPE STRING,
TOPNODE TYPE STRING,
MAXVISLEV TYPE STRING,
SNGMSG_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,
PERF_SMOOTH_DATA 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,
AID_TBL TYPE STRING,
SHOW_30MIN_PERFDAT TYPE STRING,
SHOW_15MIN_PERFDAT TYPE STRING,
SHOW_24H_PERFDAT TYPE STRING,
SHOW_PERF_DB_DAT TYPE STRING,
PERFHISTORY TYPE STRING,
DISP_THESE_PERFHIST TYPE STRING,
RC TYPE STRING,END OF T_EKKO_STR. DATA: WA_ALMTDATA_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_ALMTDATA_STR-TID sy-vline
WA_ALMTDATA_STR-MTSYSID sy-vline
WA_ALMTDATA_STR-MTMCNAME sy-vline
WA_ALMTDATA_STR-MTNUMRANGE sy-vline
WA_ALMTDATA_STR-MTUID sy-vline
WA_ALMTDATA_STR-MTCLASS sy-vline
WA_ALMTDATA_STR-MTINDEX sy-vline
WA_ALMTDATA_STR-EXTINDEX sy-vline
WA_ALMTDATA_STR-MT_NAME sy-vline
WA_ALMTDATA_STR-BASE_DATA sy-vline
WA_ALMTDATA_STR-MTSYSID sy-vline
WA_ALMTDATA_STR-MTMCNAME sy-vline
WA_ALMTDATA_STR-MTNUMRANGE sy-vline
WA_ALMTDATA_STR-MTUID sy-vline
WA_ALMTDATA_STR-MTCLASS sy-vline
WA_ALMTDATA_STR-MTINDEX sy-vline
WA_ALMTDATA_STR-EXTINDEX sy-vline
WA_ALMTDATA_STR-CUSTSTATUS sy-vline
WA_ALMTDATA_STR-USECLASS sy-vline
WA_ALMTDATA_STR-SEVERITY sy-vline
WA_ALMTDATA_STR-STATISTREC sy-vline
WA_ALMTDATA_STR-VISUSERLEV sy-vline
WA_ALMTDATA_STR-KEEPALTYPE sy-vline
WA_ALMTDATA_STR-KEEPALMAX sy-vline
WA_ALMTDATA_STR-SECTRGTOOL sy-vline
WA_ALMTDATA_STR-SECINACTIV sy-vline
WA_ALMTDATA_STR-WARMUPTIME sy-vline
WA_ALMTDATA_STR-DTEXTCLASS sy-vline
WA_ALMTDATA_STR-DTEXTID sy-vline
WA_ALMTDATA_STR-CUSGRPNAME sy-vline
WA_ALMTDATA_STR-DELIVERSTA sy-vline
WA_ALMTDATA_STR-HIGHALVAL sy-vline
WA_ALMTDATA_STR-HIGHALSEV sy-vline
WA_ALMTDATA_STR-ALSYSID sy-vline
WA_ALMTDATA_STR-MSEGNAME sy-vline
WA_ALMTDATA_STR-ALUNIQNUM sy-vline
WA_ALMTDATA_STR-ALINDEX sy-vline
WA_ALMTDATA_STR-ALERTDATE sy-vline
WA_ALMTDATA_STR-ALERTTIME sy-vline
WA_ALMTDATA_STR-DUMMYALIGN sy-vline
WA_ALMTDATA_STR-LASTVALDAT sy-vline
WA_ALMTDATA_STR-LASTVALTIM sy-vline
WA_ALMTDATA_STR-LASTVALDUM sy-vline
WA_ALMTDATA_STR-ACTUALVAL sy-vline
WA_ALMTDATA_STR-ACTUALSEV sy-vline
WA_ALMTDATA_STR-VALSYSID sy-vline
WA_ALMTDATA_STR-VMSEGNAME sy-vline
WA_ALMTDATA_STR-VALUNIQNUM sy-vline
WA_ALMTDATA_STR-VALINDEX sy-vline
WA_ALMTDATA_STR-VALERTDATE sy-vline
WA_ALMTDATA_STR-VALERTTIME sy-vline
WA_ALMTDATA_STR-VALERTDUM sy-vline
WA_ALMTDATA_STR-COUNTOFACT sy-vline
WA_ALMTDATA_STR-COUNTSUM sy-vline
WA_ALMTDATA_STR-TDSTATUS sy-vline
WA_ALMTDATA_STR-TRGTDEFNAM sy-vline
WA_ALMTDATA_STR-TRGTDEFDSP sy-vline
WA_ALMTDATA_STR-TRGTDEFSTA sy-vline
WA_ALMTDATA_STR-TRGTDEFCOS sy-vline
WA_ALMTDATA_STR-ANATDEFNAM sy-vline
WA_ALMTDATA_STR-ANATDEFDSP sy-vline
WA_ALMTDATA_STR-ANATDEFSTA sy-vline
WA_ALMTDATA_STR-ANATDEFCOS sy-vline
WA_ALMTDATA_STR-ONATDEFNAM sy-vline
WA_ALMTDATA_STR-ONATDEFDSP sy-vline
WA_ALMTDATA_STR-ONATDEFSTA sy-vline
WA_ALMTDATA_STR-ONATDEFCOS sy-vline
WA_ALMTDATA_STR-TRGTRUNNAM sy-vline
WA_ALMTDATA_STR-TRGTRUNSTA sy-vline
WA_ALMTDATA_STR-TRGTRUNDAT sy-vline
WA_ALMTDATA_STR-TRGTRUNTIM sy-vline
WA_ALMTDATA_STR-TRGTRUNDUM sy-vline
WA_ALMTDATA_STR-TRGTRUNDSP sy-vline
WA_ALMTDATA_STR-ONATRUNNAM sy-vline
WA_ALMTDATA_STR-ONATRUNSTA sy-vline
WA_ALMTDATA_STR-ONATRUNDAT sy-vline
WA_ALMTDATA_STR-ONATRUNTIM sy-vline
WA_ALMTDATA_STR-ONATRUNDUM sy-vline
WA_ALMTDATA_STR-ONATRUNDSP sy-vline
WA_ALMTDATA_STR-OBJECTNAME sy-vline
WA_ALMTDATA_STR-MTNAMESHRT sy-vline
WA_ALMTDATA_STR-MTESUBTYPE sy-vline
WA_ALMTDATA_STR-CNTALINLST sy-vline
WA_ALMTDATA_STR-CNTMTCHILD sy-vline
WA_ALMTDATA_STR-ALTREENUM sy-vline
WA_ALMTDATA_STR-ALIDXINTRE sy-vline
WA_ALMTDATA_STR-ALLEVINTRE sy-vline
WA_ALMTDATA_STR-ALPARINTRE sy-vline
WA_ALMTDATA_STR-ALMTFULLNM sy-vline
WA_ALMTDATA_STR-RC sy-vline
WA_ALMTDATA_STR-EXPAND sy-vline
WA_ALMTDATA_STR-MARKED sy-vline
WA_ALMTDATA_STR-TOPNODE sy-vline
WA_ALMTDATA_STR-MAXVISLEV sy-vline
WA_ALMTDATA_STR-SNGMSG_DATA sy-vline
WA_ALMTDATA_STR-MTSYSID sy-vline
WA_ALMTDATA_STR-MTMCNAME sy-vline
WA_ALMTDATA_STR-MTNUMRANGE sy-vline
WA_ALMTDATA_STR-MTUID sy-vline
WA_ALMTDATA_STR-MTCLASS sy-vline
WA_ALMTDATA_STR-MTINDEX sy-vline
WA_ALMTDATA_STR-EXTINDEX sy-vline
WA_ALMTDATA_STR-CUSTSTAT sy-vline
WA_ALMTDATA_STR-ALERTMODE sy-vline
WA_ALMTDATA_STR-ALERTSHIFT sy-vline
WA_ALMTDATA_STR-CUSGRPNAME sy-vline
WA_ALMTDATA_STR-SMSGVALUE sy-vline
WA_ALMTDATA_STR-SMSGDATE sy-vline
WA_ALMTDATA_STR-SMSGTIME sy-vline
WA_ALMTDATA_STR-SMSGDUMMY sy-vline
WA_ALMTDATA_STR-MSG sy-vline
WA_ALMTDATA_STR-RC sy-vline
WA_ALMTDATA_STR-PERF_DATA sy-vline
WA_ALMTDATA_STR-MTSYSID sy-vline
WA_ALMTDATA_STR-MTMCNAME sy-vline
WA_ALMTDATA_STR-MTNUMRANGE sy-vline
WA_ALMTDATA_STR-MTUID sy-vline
WA_ALMTDATA_STR-MTCLASS sy-vline
WA_ALMTDATA_STR-MTINDEX sy-vline
WA_ALMTDATA_STR-EXTINDEX sy-vline
WA_ALMTDATA_STR-CUSTSTAT sy-vline
WA_ALMTDATA_STR-RELVALTYPE sy-vline
WA_ALMTDATA_STR-THRESHDIR sy-vline
WA_ALMTDATA_STR-THRESHSTAT sy-vline
WA_ALMTDATA_STR-ACTIVTHG2Y sy-vline
WA_ALMTDATA_STR-ACTIVTHY2R sy-vline
WA_ALMTDATA_STR-ACTIVTHY2G sy-vline
WA_ALMTDATA_STR-ACTIVTHR2Y sy-vline
WA_ALMTDATA_STR-DEFAUTHG2Y sy-vline
WA_ALMTDATA_STR-DEFAUTHY2R sy-vline
WA_ALMTDATA_STR-DEFAUTHY2G sy-vline
WA_ALMTDATA_STR-DEFAUTHR2Y sy-vline
WA_ALMTDATA_STR-MSGCLASS sy-vline
WA_ALMTDATA_STR-MSGID sy-vline
WA_ALMTDATA_STR-CUSGRPNAME sy-vline
WA_ALMTDATA_STR-VALUNIT sy-vline
WA_ALMTDATA_STR-DECIMALS sy-vline
WA_ALMTDATA_STR-PERFCNTHIG sy-vline
WA_ALMTDATA_STR-PERFCNTLOW sy-vline
WA_ALMTDATA_STR-PERFEVTHIG sy-vline
WA_ALMTDATA_STR-PERFEVTLOW sy-vline
WA_ALMTDATA_STR-ALRELEVVAL sy-vline
WA_ALMTDATA_STR-ALRELVALDT sy-vline
WA_ALMTDATA_STR-ALRELVALTI sy-vline
WA_ALMTDATA_STR-ALRELVDUMM sy-vline
WA_ALMTDATA_STR-LASTALSTAT sy-vline
WA_ALMTDATA_STR-LASTPERVAL sy-vline
WA_ALMTDATA_STR-AVG00PVAL sy-vline
WA_ALMTDATA_STR-AVG01PVAL sy-vline
WA_ALMTDATA_STR-AVG05PVAL sy-vline
WA_ALMTDATA_STR-AVG15PVAL sy-vline
WA_ALMTDATA_STR-AVG01SVAL sy-vline
WA_ALMTDATA_STR-AVG05SVAL sy-vline
WA_ALMTDATA_STR-AVG15SVAL sy-vline
WA_ALMTDATA_STR-AVG01CVAL sy-vline
WA_ALMTDATA_STR-AVG05CVAL sy-vline
WA_ALMTDATA_STR-AVG15CVAL sy-vline
WA_ALMTDATA_STR-MAXPFVALUE sy-vline
WA_ALMTDATA_STR-MAXPFDATE sy-vline
WA_ALMTDATA_STR-MAXPFTIME sy-vline
WA_ALMTDATA_STR-MAXPFDUMMY sy-vline
WA_ALMTDATA_STR-MINPFVALUE sy-vline
WA_ALMTDATA_STR-MINPFDATE sy-vline
WA_ALMTDATA_STR-MINPFTIME sy-vline
WA_ALMTDATA_STR-MINPFDUMMY sy-vline
WA_ALMTDATA_STR-RC sy-vline
WA_ALMTDATA_STR-PERF_SMOOTH_DATA sy-vline
WA_ALMTDATA_STR-MSC_LINES sy-vline
WA_ALMTDATA_STR-MSC_DATA sy-vline
WA_ALMTDATA_STR-MTSYSID sy-vline
WA_ALMTDATA_STR-MTMCNAME sy-vline
WA_ALMTDATA_STR-MTNUMRANGE sy-vline
WA_ALMTDATA_STR-MTUID sy-vline
WA_ALMTDATA_STR-MTCLASS sy-vline
WA_ALMTDATA_STR-MTINDEX sy-vline
WA_ALMTDATA_STR-EXTINDEX sy-vline
WA_ALMTDATA_STR-CUSTSTAT sy-vline
WA_ALMTDATA_STR-RAISEVALUE sy-vline
WA_ALMTDATA_STR-RAISESEVER sy-vline
WA_ALMTDATA_STR-ACTMSGMODE sy-vline
WA_ALMTDATA_STR-ACTMSGMAXS sy-vline
WA_ALMTDATA_STR-MAXALPROID sy-vline
WA_ALMTDATA_STR-KEEPLINTYP sy-vline
WA_ALMTDATA_STR-KEEPLINMAX sy-vline
WA_ALMTDATA_STR-CUSGRPNAME sy-vline
WA_ALMTDATA_STR-MSCGLLID sy-vline
WA_ALMTDATA_STR-MSCDATE sy-vline
WA_ALMTDATA_STR-MSCTIME sy-vline
WA_ALMTDATA_STR-MSCDUMMY sy-vline
WA_ALMTDATA_STR-VALUEORIG sy-vline
WA_ALMTDATA_STR-SEVERORIG sy-vline
WA_ALMTDATA_STR-VALUEFLTRD sy-vline
WA_ALMTDATA_STR-SEVERFLTRD sy-vline
WA_ALMTDATA_STR-MANDT sy-vline
WA_ALMTDATA_STR-USERID sy-vline
WA_ALMTDATA_STR-MSG sy-vline
WA_ALMTDATA_STR-MSGCLASS sy-vline
WA_ALMTDATA_STR-MSGID sy-vline
WA_ALMTDATA_STR-MSGARG1 sy-vline
WA_ALMTDATA_STR-ARGTYPE1 sy-vline
WA_ALMTDATA_STR-MSGARG2 sy-vline
WA_ALMTDATA_STR-ARGTYPE2 sy-vline
WA_ALMTDATA_STR-MSGARG3 sy-vline
WA_ALMTDATA_STR-ARGTYPE3 sy-vline
WA_ALMTDATA_STR-MSGARG4 sy-vline
WA_ALMTDATA_STR-ARGTYPE4 sy-vline
WA_ALMTDATA_STR-MSGTEXT sy-vline
WA_ALMTDATA_STR-RC sy-vline
WA_ALMTDATA_STR-AID_TBL sy-vline
WA_ALMTDATA_STR-SHOW_30MIN_PERFDAT sy-vline
WA_ALMTDATA_STR-SHOW_15MIN_PERFDAT sy-vline
WA_ALMTDATA_STR-SHOW_24H_PERFDAT sy-vline
WA_ALMTDATA_STR-SHOW_PERF_DB_DAT sy-vline
WA_ALMTDATA_STR-PERFHISTORY sy-vline
WA_ALMTDATA_STR-DISP_THESE_PERFHIST sy-vline
WA_ALMTDATA_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.