ABAP Select data from SAP table /SCWM/S_QSETUP_GET_DATA 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 /SCWM/S_QSETUP_GET_DATA 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 /SCWM/S_QSETUP_GET_DATA. 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 /SCWM/S_QSETUP_GET_DATA 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_/SCWM/S_QSETUP_GET_DATA TYPE STANDARD TABLE OF /SCWM/S_QSETUP_GET_DATA,
      WA_/SCWM/S_QSETUP_GET_DATA TYPE /SCWM/S_QSETUP_GET_DATA,
      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: </SCWM/S_QSETUP_GET_DATA> TYPE /SCWM/S_QSETUP_GET_DATA.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /SCWM/S_QSETUP_GET_DATA
  INTO TABLE IT_/SCWM/S_QSETUP_GET_DATA.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /SCWM/S_QSETUP_GET_DATA
*  INTO TABLE @DATA(IT_/SCWM/S_QSETUP_GET_DATA2).
*--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_/SCWM/S_QSETUP_GET_DATA INDEX 1 INTO DATA(WA_/SCWM/S_QSETUP_GET_DATA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SCWM/S_QSETUP_GET_DATA ASSIGNING </SCWM/S_QSETUP_GET_DATA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</SCWM/S_QSETUP_GET_DATA>-GRQIE = 1.
</SCWM/S_QSETUP_GET_DATA>-GRPAR = 1.
</SCWM/S_QSETUP_GET_DATA>-SPECIFICITY = 1.
</SCWM/S_QSETUP_GET_DATA>-XLEAF = 1.
</SCWM/S_QSETUP_GET_DATA>-XREAD_ONLY = 1.
ENDLOOP.

LOOP AT IT_/SCWM/S_QSETUP_GET_DATA INTO WA_/SCWM/S_QSETUP_GET_DATA.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SCWM/S_QSETUP_GET_DATA-XDOC_ASSIGNED, sy-vline,
WA_/SCWM/S_QSETUP_GET_DATA-XSTRUCTURAL, sy-vline,
WA_/SCWM/S_QSETUP_GET_DATA-VERSION, sy-vline,
WA_/SCWM/S_QSETUP_GET_DATA-LGNUM, sy-vline,
WA_/SCWM/S_QSETUP_GET_DATA-DOCTYPE, sy-vline,
WA_/SCWM/S_QSETUP_GET_DATA-ITEMTYPE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SCWM/S_QSETUP_GET_DATA 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_/SCWM/S_QSETUP_GET_DATA 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_/SCWM/S_QSETUP_GET_DATA INTO WA_/SCWM/S_QSETUP_GET_DATA. *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 ALPHA, internal->external for field VERSION CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-VERSION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-VERSION.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BPMAP, internal->external for field PARTYNO CALL FUNCTION 'CONVERSION_EXIT_BPMAP_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-PARTYNO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-PARTYNO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MDLPD, internal->external for field PRODUCTID CALL FUNCTION 'CONVERSION_EXIT_MDLPD_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-PRODUCTID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-PRODUCTID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ENTITLED CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-ENTITLED IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-ENTITLED.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit ALPHA, internal->external for field S_PLNNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-S_PLNNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-S_PLNNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field S_PLNAL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-S_PLNAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-S_PLNAL.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHA, internal->external for field PLNNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-PLNNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-PLNNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PLNAL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-PLNAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-PLNAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field AUFNR_CO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-AUFNR_CO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-AUFNR_CO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field CREATED_ON CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-CREATED_ON IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-CREATED_ON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTPS, internal->external for field CHANGED_ON CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_/SCWM/S_QSETUP_GET_DATA-CHANGED_ON IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_QSETUP_GET_DATA-CHANGED_ON.
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_/SCWM/S_QSETUP_GET_DATA_STR,
GRQIE TYPE STRING,
GRPAR TYPE STRING,
SPECIFICITY TYPE STRING,
XLEAF TYPE STRING,
XREAD_ONLY TYPE STRING,
XDOC_ASSIGNED TYPE STRING,
XSTRUCTURAL TYPE STRING,
VERSION TYPE STRING,
LGNUM TYPE STRING,
DOCTYPE TYPE STRING,
ITEMTYPE TYPE STRING,
PARTYNO TYPE STRING,
PRODUCTID TYPE STRING,
ENTITLED TYPE STRING,
QGRP TYPE STRING,
COO TYPE STRING,
ICATLOCN TYPE STRING,
UPPERVAL TYPE STRING,
UPPERQTY TYPE STRING,
INB_PROC TYPE STRING,
INSP_PROC_WHS TYPE STRING,
IOT_ENH_DUMMY TYPE STRING,
INSP_PROC TYPE STRING,
DMOD_RULE_ID TYPE STRING,
DCOD_BUND_ID TYPE STRING,
DMOD_CRIT_ID TYPE STRING,
ITEM_DCBD_ID TYPE STRING,
AUTH_GROUP TYPE STRING,
SAMPLE_TYPE TYPE STRING,
SAMPLE_SIZE_FIX TYPE STRING,
SAMPLE_UNIT TYPE STRING,
NUMB_ACCEPT TYPE STRING,
SAMPLE_SIZE_PRC TYPE STRING,
NUMB_ACCEPT_PRC TYPE STRING,
SAMP_SCHM_ID TYPE STRING,
INSP_LEVEL TYPE STRING,
INSP_SEVERITY TYPE STRING,
AQL_VALUE TYPE STRING,
CRULE_SAMPSIZE TYPE STRING,
VALUATION_MODE TYPE STRING,
ELEMENT_TYPE TYPE STRING,
SAMP_DRWP_ID TYPE STRING,
SAMP_DRW_INT TYPE STRING,
SAMP_DRW_UNIT TYPE STRING,
SAMP_DCBD_ID TYPE STRING,
TOREL TYPE STRING,
FUREL TYPE STRING,
PROCTY TYPE STRING,
NR_RANGE_ID TYPE STRING,
SYST_ID TYPE STRING,
INST_ID TYPE STRING,
S_ART TYPE STRING,
S_PLNTY TYPE STRING,
S_PLNNR TYPE STRING,
S_PLNAL TYPE STRING,
SYST_ATT_ENH_DUMMY TYPE STRING,
FIND_TYPE_ID TYPE STRING,
CAT_FILTER_ID TYPE STRING,
RLGRP TYPE STRING,
DURATION TYPE STRING,
DURAUNIT TYPE STRING,
CATLOCN TYPE STRING,
PROCS TYPE STRING,
ACTVT_PROF TYPE STRING,
QDOC_CNTRL TYPE STRING,
GR_BLOCK_BY_QINF TYPE STRING,
INSP_CONTROL TYPE STRING,
QCONTROL_EXTERN TYPE STRING,
ART TYPE STRING,
PPL TYPE STRING,
PLNTY TYPE STRING,
PLNNR TYPE STRING,
PLNAL TYPE STRING,
APP TYPE STRING,
MER TYPE STRING,
AVE TYPE STRING,
STICHPRVER TYPE STRING,
DYNREGEL TYPE STRING,
SPROZ TYPE STRING,
HPZ TYPE STRING,
DYN TYPE STRING,
MST TYPE STRING,
MPDAU TYPE STRING,
QKZVERF TYPE STRING,
QPMAT TYPE STRING,
KZPRFKOST TYPE STRING,
AUFNR_CO TYPE STRING,
AKTIV TYPE STRING,
MS_FLAG TYPE STRING,
ART_TXT TYPE STRING,
PLNTY_TXT TYPE STRING,
STICHPRVER_TXT TYPE STRING,
DYNREGEL_TXT TYPE STRING,
PLNNR_TXT TYPE STRING,
CREATED_BY TYPE STRING,
CREATED_ON TYPE STRING,
CHANGED_BY TYPE STRING,
CHANGED_ON TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SCWM/S_QSETUP_GET_DATA_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_/SCWM/S_QSETUP_GET_DATA_STR-GRQIE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-GRPAR sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SPECIFICITY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-XLEAF sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-XREAD_ONLY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-XDOC_ASSIGNED sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-XSTRUCTURAL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-VERSION sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-LGNUM sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DOCTYPE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-ITEMTYPE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PARTYNO sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PRODUCTID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-ENTITLED sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-QGRP sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-COO sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-ICATLOCN sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-UPPERVAL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-UPPERQTY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-INB_PROC sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-INSP_PROC_WHS sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-IOT_ENH_DUMMY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-INSP_PROC sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DMOD_RULE_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DCOD_BUND_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DMOD_CRIT_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-ITEM_DCBD_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-AUTH_GROUP sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMPLE_TYPE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMPLE_SIZE_FIX sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMPLE_UNIT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-NUMB_ACCEPT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMPLE_SIZE_PRC sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-NUMB_ACCEPT_PRC sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMP_SCHM_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-INSP_LEVEL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-INSP_SEVERITY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-AQL_VALUE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-CRULE_SAMPSIZE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-VALUATION_MODE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-ELEMENT_TYPE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMP_DRWP_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMP_DRW_INT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMP_DRW_UNIT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SAMP_DCBD_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-TOREL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-FUREL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PROCTY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-NR_RANGE_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SYST_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-INST_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-S_ART sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-S_PLNTY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-S_PLNNR sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-S_PLNAL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SYST_ATT_ENH_DUMMY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-FIND_TYPE_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-CAT_FILTER_ID sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-RLGRP sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DURATION sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DURAUNIT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-CATLOCN sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PROCS sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-ACTVT_PROF sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-QDOC_CNTRL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-GR_BLOCK_BY_QINF sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-INSP_CONTROL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-QCONTROL_EXTERN sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-ART sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PPL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PLNTY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PLNNR sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PLNAL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-APP sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-MER sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-AVE sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-STICHPRVER sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DYNREGEL sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-SPROZ sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-HPZ sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DYN sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-MST sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-MPDAU sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-QKZVERF sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-QPMAT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-KZPRFKOST sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-AUFNR_CO sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-AKTIV sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-MS_FLAG sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-ART_TXT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PLNTY_TXT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-STICHPRVER_TXT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-DYNREGEL_TXT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-PLNNR_TXT sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-CREATED_BY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-CREATED_ON sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-CHANGED_BY sy-vline
WA_/SCWM/S_QSETUP_GET_DATA_STR-CHANGED_ON sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.