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

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

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

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SCWM/S_RF_ADHOC ASSIGNING </SCWM/S_RF_ADHOC>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</SCWM/S_RF_ADHOC>-LGNUM = 1.
</SCWM/S_RF_ADHOC>-SEQNO = 1.
</SCWM/S_RF_ADHOC>-GUID_HU = 1.
</SCWM/S_RF_ADHOC>-MATID = 1.
</SCWM/S_RF_ADHOC>-GUID_STOCK = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SCWM/S_RF_ADHOC-GUID_PARENT, sy-vline,
WA_/SCWM/S_RF_ADHOC-MATNR, sy-vline,
WA_/SCWM/S_RF_ADHOC-MATNR40, sy-vline,
WA_/SCWM/S_RF_ADHOC-MAKTX, sy-vline,
WA_/SCWM/S_RF_ADHOC-OWNER, sy-vline,
WA_/SCWM/S_RF_ADHOC-ENTITLED, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SCWM/S_RF_ADHOC 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_RF_ADHOC 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_RF_ADHOC INTO WA_/SCWM/S_RF_ADHOC. *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 MDLPD, internal->external for field MATID CALL FUNCTION 'CONVERSION_EXIT_MDLPD_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-MATID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-MATID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MDLP1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MDLP1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MDLP1, internal->external for field MATNR40 CALL FUNCTION 'CONVERSION_EXIT_MDLP1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-MATNR40 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-MATNR40.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit HUID, internal->external for field VLENR CALL FUNCTION 'CONVERSION_EXIT_HUID_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-VLENR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-VLENR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit HUID, internal->external for field HUIDENT CALL FUNCTION 'CONVERSION_EXIT_HUID_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-HUIDENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-HUIDENT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit QNTY1, internal->external for field AVAIL_QUAN CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-AVAIL_QUAN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-AVAIL_QUAN.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit QTYCH, internal->external for field VSOLA CALL FUNCTION 'CONVERSION_EXIT_QTYCH_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-VSOLA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-VSOLA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit QNTY1, internal->external for field VSOLA_ORIG CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-VSOLA_ORIG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-VSOLA_ORIG.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit HUID, internal->external for field NLENR CALL FUNCTION 'CONVERSION_EXIT_HUID_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-NLENR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-NLENR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit QNTY1, internal->external for field KQUAN CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-KQUAN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-KQUAN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPH0, internal->external for field TANUM CALL FUNCTION 'CONVERSION_EXIT_ALPH0_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-TANUM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-TANUM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SPDEV, internal->external for field LDEST CALL FUNCTION 'CONVERSION_EXIT_SPDEV_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-LDEST IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-LDEST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MDLPS, internal->external for field MATNR_VERIF CALL FUNCTION 'CONVERSION_EXIT_MDLPS_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-MATNR_VERIF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-MATNR_VERIF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit QNTY1, internal->external for field BRVOL CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-BRVOL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-BRVOL.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit QNTY1, internal->external for field BRGEW CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-BRGEW IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-BRGEW.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit TSTRG, internal->external for field SHELF_LIFE_DUR CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-SHELF_LIFE_DUR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-SHELF_LIFE_DUR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit QNTY1, internal->external for field NSOLA CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-NSOLA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-NSOLA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit QNTY1, internal->external for field NISTA CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-NISTA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-NISTA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit QNTY1, internal->external for field NDIFA CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-NDIFA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-NDIFA.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTWH, internal->external for field CREATED_AT CALL FUNCTION 'CONVERSION_EXIT_TSTWH_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-CREATED_AT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-CREATED_AT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPH0, internal->external for field TU_SR_ACT_NUM CALL FUNCTION 'CONVERSION_EXIT_ALPH0_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-TU_SR_ACT_NUM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-TU_SR_ACT_NUM.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPH0, internal->external for field WHO CALL FUNCTION 'CONVERSION_EXIT_ALPH0_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-WHO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-WHO.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit RFHU, internal->external for field VRFHU CALL FUNCTION 'CONVERSION_EXIT_RFHU_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-VRFHU IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-VRFHU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RFHU, internal->external for field NRFHU CALL FUNCTION 'CONVERSION_EXIT_RFHU_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-NRFHU IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-NRFHU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPH0, internal->external for field TANUM_OPEN_WT CALL FUNCTION 'CONVERSION_EXIT_ALPH0_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-TANUM_OPEN_WT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-TANUM_OPEN_WT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit QTYCH, internal->external for field RESTA_VERIF CALL FUNCTION 'CONVERSION_EXIT_QTYCH_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-RESTA_VERIF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-RESTA_VERIF.
WRITE:/ 'New Value:', ld_input.

*Conversion exit QNTY1, internal->external for field VSOLA_CHR CALL FUNCTION 'CONVERSION_EXIT_QNTY1_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-VSOLA_CHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-VSOLA_CHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RFPR, internal->external for field RFPROD CALL FUNCTION 'CONVERSION_EXIT_RFPR_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-RFPROD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-RFPROD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit RFBA, internal->external for field RFBATCH CALL FUNCTION 'CONVERSION_EXIT_RFBA_OUTPUT' EXPORTING input = WA_/SCWM/S_RF_ADHOC-RFBATCH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCWM/S_RF_ADHOC-RFBATCH.
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_RF_ADHOC_STR,
LGNUM TYPE STRING,
SEQNO TYPE STRING,
GUID_HU TYPE STRING,
MATID TYPE STRING,
GUID_STOCK TYPE STRING,
GUID_PARENT TYPE STRING,
MATNR TYPE STRING,
MATNR40 TYPE STRING,
MAKTX TYPE STRING,
OWNER TYPE STRING,
ENTITLED TYPE STRING,
VLPLA TYPE STRING,
VLTYP TYPE STRING,
VLENR TYPE STRING,
HUIDENT TYPE STRING,
SRSRC TYPE STRING,
LETYP TYPE STRING,
AVAIL_QUAN TYPE STRING,
MEINS TYPE STRING,
ANFME TYPE STRING,
ALTME TYPE STRING,
AUNIT_KEEP TYPE STRING,
VSOLA TYPE STRING,
VSOLA_ORIG TYPE STRING,
ALTME_1 TYPE STRING,
VSOLM TYPE STRING,
MEINS_1 TYPE STRING,
PROCTY TYPE STRING,
NLTYPG TYPE STRING,
NLTYP TYPE STRING,
NLBER TYPE STRING,
NLPLA TYPE STRING,
NLPLA_ORIG TYPE STRING,
NLENR TYPE STRING,
DRSRC TYPE STRING,
PRSRC TYPE STRING,
REASON TYPE STRING,
PICK_ALL TYPE STRING,
KQUAN TYPE STRING,
KOMPL TYPE STRING,
TANUM TYPE STRING,
STATUS_TXT TYPE STRING,
LDEST TYPE STRING,
BATCHID TYPE STRING,
CHARG TYPE STRING,
CAT TYPE STRING,
GR_DATE TYPE STRING,
HAZMAT_IND TYPE STRING,
HZMT TYPE STRING,
VLENR_VERIF TYPE STRING,
VLPLA_VERIF TYPE STRING,
NLPLA_VERIF TYPE STRING,
HU_STATUS TYPE STRING,
HU_TYP TYPE STRING,
USAGE_IV TYPE STRING,
DIFTY TYPE STRING,
NLENR_VERIF TYPE STRING,
MATNR_VERIF TYPE STRING,
COO TYPE STRING,
BRVOL TYPE STRING,
VOLEH TYPE STRING,
BRGEW TYPE STRING,
GEWEH TYPE STRING,
CHARG_VERIF TYPE STRING,
GUID_TO TYPE STRING,
VFDAT TYPE STRING,
STOCK_DOCNO TYPE STRING,
STOCK_ITMNO TYPE STRING,
STOCK_DOCCAT TYPE STRING,
ITMID TYPE STRING,
INSPID TYPE STRING,
DGPROFL TYPE STRING,
PILFERABLE TYPE STRING,
SHELF_LIFE_DUR TYPE STRING,
HNDLCODE TYPE STRING,
ENVREL TYPE STRING,
CREA_DATE TYPE STRING,
CREA_TIME TYPE STRING,
CHANG_DATE TYPE STRING,
CHANG_TIME TYPE STRING,
CHANGED_BY TYPE STRING,
CHANGED_AT TYPE STRING,
CREATED_BY TYPE STRING,
OPUNIT TYPE STRING,
OPUNIT_1 TYPE STRING,
SELNO TYPE STRING,
SEQNO_LIST TYPE STRING,
NSOLA TYPE STRING,
NISTA TYPE STRING,
NDIFA TYPE STRING,
DOCCAT TYPE STRING,
STOCK_USAGE TYPE STRING,
OWNER_ROLE TYPE STRING,
ENTITLED_ROLE TYPE STRING,
FLGHUTO TYPE STRING,
CREATED_AT TYPE STRING,
EXCCODE TYPE STRING,
TEXT_IND TYPE STRING,
ACT_TYPE TYPE STRING,
PARTI TYPE STRING,
IDENT TYPE STRING,
TU_SR_ACT_NUM TYPE STRING,
TU_NUM TYPE STRING,
SCAC TYPE STRING,
WHO TYPE STRING,
STOCK TYPE STRING,
PAPOS TYPE STRING,
TSP_SCAC TYPE STRING,
RETURN_FCODE TYPE STRING,
CWREL TYPE STRING,
CWREL_IND TYPE STRING,
CWQUAN TYPE STRING,
CWUNIT TYPE STRING,
HUOBL TYPE STRING,
EXC_TAB TYPE STRING,
MORE TYPE STRING,
VRFHU TYPE STRING,
NRFHU TYPE STRING,
BRESTR TYPE STRING,
HU_ON_RSRC TYPE STRING,
NLPLA_OPEN_WT TYPE STRING,
TANUM_OPEN_WT TYPE STRING,
RESTA_VERIF TYPE STRING,
RESTA TYPE STRING,
LOWCHK_INV TYPE STRING,
STOCK_DOCCAT_IND TYPE STRING,
VSOLA_CHR TYPE STRING,
RFPROD TYPE STRING,
RFBATCH TYPE STRING,
RFPROD_BARC TYPE STRING,
VSOLA_BARC TYPE STRING,
CHARG_BARC TYPE STRING,
MATEAN TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SCWM/S_RF_ADHOC_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_RF_ADHOC_STR-LGNUM sy-vline
WA_/SCWM/S_RF_ADHOC_STR-SEQNO sy-vline
WA_/SCWM/S_RF_ADHOC_STR-GUID_HU sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MATID sy-vline
WA_/SCWM/S_RF_ADHOC_STR-GUID_STOCK sy-vline
WA_/SCWM/S_RF_ADHOC_STR-GUID_PARENT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MATNR sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MATNR40 sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MAKTX sy-vline
WA_/SCWM/S_RF_ADHOC_STR-OWNER sy-vline
WA_/SCWM/S_RF_ADHOC_STR-ENTITLED sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VLPLA sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VLTYP sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VLENR sy-vline
WA_/SCWM/S_RF_ADHOC_STR-HUIDENT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-SRSRC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-LETYP sy-vline
WA_/SCWM/S_RF_ADHOC_STR-AVAIL_QUAN sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MEINS sy-vline
WA_/SCWM/S_RF_ADHOC_STR-ANFME sy-vline
WA_/SCWM/S_RF_ADHOC_STR-ALTME sy-vline
WA_/SCWM/S_RF_ADHOC_STR-AUNIT_KEEP sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VSOLA sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VSOLA_ORIG sy-vline
WA_/SCWM/S_RF_ADHOC_STR-ALTME_1 sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VSOLM sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MEINS_1 sy-vline
WA_/SCWM/S_RF_ADHOC_STR-PROCTY sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLTYPG sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLTYP sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLBER sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLPLA sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLPLA_ORIG sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLENR sy-vline
WA_/SCWM/S_RF_ADHOC_STR-DRSRC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-PRSRC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-REASON sy-vline
WA_/SCWM/S_RF_ADHOC_STR-PICK_ALL sy-vline
WA_/SCWM/S_RF_ADHOC_STR-KQUAN sy-vline
WA_/SCWM/S_RF_ADHOC_STR-KOMPL sy-vline
WA_/SCWM/S_RF_ADHOC_STR-TANUM sy-vline
WA_/SCWM/S_RF_ADHOC_STR-STATUS_TXT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-LDEST sy-vline
WA_/SCWM/S_RF_ADHOC_STR-BATCHID sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CHARG sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CAT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-GR_DATE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-HAZMAT_IND sy-vline
WA_/SCWM/S_RF_ADHOC_STR-HZMT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VLENR_VERIF sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VLPLA_VERIF sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLPLA_VERIF sy-vline
WA_/SCWM/S_RF_ADHOC_STR-HU_STATUS sy-vline
WA_/SCWM/S_RF_ADHOC_STR-HU_TYP sy-vline
WA_/SCWM/S_RF_ADHOC_STR-USAGE_IV sy-vline
WA_/SCWM/S_RF_ADHOC_STR-DIFTY sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLENR_VERIF sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MATNR_VERIF sy-vline
WA_/SCWM/S_RF_ADHOC_STR-COO sy-vline
WA_/SCWM/S_RF_ADHOC_STR-BRVOL sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VOLEH sy-vline
WA_/SCWM/S_RF_ADHOC_STR-BRGEW sy-vline
WA_/SCWM/S_RF_ADHOC_STR-GEWEH sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CHARG_VERIF sy-vline
WA_/SCWM/S_RF_ADHOC_STR-GUID_TO sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VFDAT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-STOCK_DOCNO sy-vline
WA_/SCWM/S_RF_ADHOC_STR-STOCK_ITMNO sy-vline
WA_/SCWM/S_RF_ADHOC_STR-STOCK_DOCCAT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-ITMID sy-vline
WA_/SCWM/S_RF_ADHOC_STR-INSPID sy-vline
WA_/SCWM/S_RF_ADHOC_STR-DGPROFL sy-vline
WA_/SCWM/S_RF_ADHOC_STR-PILFERABLE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-SHELF_LIFE_DUR sy-vline
WA_/SCWM/S_RF_ADHOC_STR-HNDLCODE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-ENVREL sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CREA_DATE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CREA_TIME sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CHANG_DATE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CHANG_TIME sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CHANGED_BY sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CHANGED_AT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CREATED_BY sy-vline
WA_/SCWM/S_RF_ADHOC_STR-OPUNIT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-OPUNIT_1 sy-vline
WA_/SCWM/S_RF_ADHOC_STR-SELNO sy-vline
WA_/SCWM/S_RF_ADHOC_STR-SEQNO_LIST sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NSOLA sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NISTA sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NDIFA sy-vline
WA_/SCWM/S_RF_ADHOC_STR-DOCCAT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-STOCK_USAGE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-OWNER_ROLE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-ENTITLED_ROLE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-FLGHUTO sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CREATED_AT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-EXCCODE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-TEXT_IND sy-vline
WA_/SCWM/S_RF_ADHOC_STR-ACT_TYPE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-PARTI sy-vline
WA_/SCWM/S_RF_ADHOC_STR-IDENT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-TU_SR_ACT_NUM sy-vline
WA_/SCWM/S_RF_ADHOC_STR-TU_NUM sy-vline
WA_/SCWM/S_RF_ADHOC_STR-SCAC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-WHO sy-vline
WA_/SCWM/S_RF_ADHOC_STR-STOCK sy-vline
WA_/SCWM/S_RF_ADHOC_STR-PAPOS sy-vline
WA_/SCWM/S_RF_ADHOC_STR-TSP_SCAC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-RETURN_FCODE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CWREL sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CWREL_IND sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CWQUAN sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CWUNIT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-HUOBL sy-vline
WA_/SCWM/S_RF_ADHOC_STR-EXC_TAB sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MORE sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VRFHU sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NRFHU sy-vline
WA_/SCWM/S_RF_ADHOC_STR-BRESTR sy-vline
WA_/SCWM/S_RF_ADHOC_STR-HU_ON_RSRC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-NLPLA_OPEN_WT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-TANUM_OPEN_WT sy-vline
WA_/SCWM/S_RF_ADHOC_STR-RESTA_VERIF sy-vline
WA_/SCWM/S_RF_ADHOC_STR-RESTA sy-vline
WA_/SCWM/S_RF_ADHOC_STR-LOWCHK_INV sy-vline
WA_/SCWM/S_RF_ADHOC_STR-STOCK_DOCCAT_IND sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VSOLA_CHR sy-vline
WA_/SCWM/S_RF_ADHOC_STR-RFPROD sy-vline
WA_/SCWM/S_RF_ADHOC_STR-RFBATCH sy-vline
WA_/SCWM/S_RF_ADHOC_STR-RFPROD_BARC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-VSOLA_BARC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-CHARG_BARC sy-vline
WA_/SCWM/S_RF_ADHOC_STR-MATEAN sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.