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

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

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

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SRMERP/S_SC_ITM_MODIFY ASSIGNING </SRMERP/S_SC_ITM_MODIFY>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</SRMERP/S_SC_ITM_MODIFY>-KEY = 1.
</SRMERP/S_SC_ITM_MODIFY>-PARENT_KEY = 1.
</SRMERP/S_SC_ITM_MODIFY>-ROOT_KEY = 1.
</SRMERP/S_SC_ITM_MODIFY>-OBJECT_ID = 1.
</SRMERP/S_SC_ITM_MODIFY>-ITM_NO = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SRMERP/S_SC_ITM_MODIFY-ITM_TYPE, sy-vline,
WA_/SRMERP/S_SC_ITM_MODIFY-TXZ01, sy-vline,
WA_/SRMERP/S_SC_ITM_MODIFY-MATNR, sy-vline,
WA_/SRMERP/S_SC_ITM_MODIFY-MENGE, sy-vline,
WA_/SRMERP/S_SC_ITM_MODIFY-MEINS, sy-vline,
WA_/SRMERP/S_SC_ITM_MODIFY-NETPR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SRMERP/S_SC_ITM_MODIFY 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_/SRMERP/S_SC_ITM_MODIFY 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_/SRMERP/S_SC_ITM_MODIFY INTO WA_/SRMERP/S_SC_ITM_MODIFY. *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 MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_/SRMERP/S_SC_ITM_MODIFY-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SRMERP/S_SC_ITM_MODIFY-MATNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit MATN1, internal->external for field EMATN CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_/SRMERP/S_SC_ITM_MODIFY-EMATN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SRMERP/S_SC_ITM_MODIFY-EMATN.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit EXCRT, internal->external for field WKURS CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_/SRMERP/S_SC_ITM_MODIFY-WKURS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SRMERP/S_SC_ITM_MODIFY-WKURS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ABPSP, internal->external for field PS_PSP_PNR CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_/SRMERP/S_SC_ITM_MODIFY-PS_PSP_PNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SRMERP/S_SC_ITM_MODIFY-PS_PSP_PNR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit IMKEY, internal->external for field IMKEY CALL FUNCTION 'CONVERSION_EXIT_IMKEY_OUTPUT' EXPORTING input = WA_/SRMERP/S_SC_ITM_MODIFY-IMKEY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SRMERP/S_SC_ITM_MODIFY-IMKEY.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit FMCIS, internal->external for field FIPOS CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT' EXPORTING input = WA_/SRMERP/S_SC_ITM_MODIFY-FIPOS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SRMERP/S_SC_ITM_MODIFY-FIPOS.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit NUMCV, internal->external for field VORNR CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_/SRMERP/S_SC_ITM_MODIFY-VORNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SRMERP/S_SC_ITM_MODIFY-VORNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field KBLNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SRMERP/S_SC_ITM_MODIFY-KBLNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SRMERP/S_SC_ITM_MODIFY-KBLNR.
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_/SRMERP/S_SC_ITM_MODIFY_STR,
KEY TYPE STRING,
PARENT_KEY TYPE STRING,
ROOT_KEY TYPE STRING,
OBJECT_ID TYPE STRING,
ITM_NO TYPE STRING,
ITM_TYPE TYPE STRING,
TXZ01 TYPE STRING,
MATNR TYPE STRING,
MENGE TYPE STRING,
MEINS TYPE STRING,
NETPR TYPE STRING,
PEINH TYPE STRING,
EKORG TYPE STRING,
EKGRP TYPE STRING,
LGORT TYPE STRING,
BEDNR TYPE STRING,
WAERS TYPE STRING,
MATKL TYPE STRING,
WERKS TYPE STRING,
CATALOG_ID TYPE STRING,
PLIFZ TYPE STRING,
EMATN TYPE STRING,
IDNLF TYPE STRING,
MPROF TYPE STRING,
MFRPN TYPE STRING,
MFRNR TYPE STRING,
EMNFR TYPE STRING,
BMEIN TYPE STRING,
NETWR TYPE STRING,
NETFW TYPE STRING,
WKURS TYPE STRING,
LPEIN TYPE STRING,
LFDAT TYPE STRING,
KNTTP TYPE STRING,
KZVBR TYPE STRING,
VRTKZ TYPE STRING,
TWRKZ TYPE STRING,
WEPOS TYPE STRING,
WEUNB TYPE STRING,
REPOS TYPE STRING,
SOBKZ TYPE STRING,
KZBWS TYPE STRING,
BWTAR TYPE STRING,
XOBLR TYPE STRING,
PACKNO TYPE STRING,
AUTHOR_KEY TYPE STRING,
REQUESTER_KEY TYPE STRING,
FOOBJ_TYPE TYPE STRING,
BSART TYPE STRING,
ADRNR TYPE STRING,
ADDRESS_KEY TYPE STRING,
TXT_EXISTS TYPE STRING,
DOC_EXISTS TYPE STRING,
FLIEF TYPE STRING,
SRM_CONTRACT_ID TYPE STRING,
SRM_CONTRACT_ITM TYPE STRING,
LIFNR TYPE STRING,
INFNR TYPE STRING,
VRTYP TYPE STRING,
KONNR TYPE STRING,
KTPNR TYPE STRING,
RESWK TYPE STRING,
RESLO TYPE STRING,
BANFN TYPE STRING,
BNFPO TYPE STRING,
RSNUM TYPE STRING,
RSPOS TYPE STRING,
APPROVAL_STATUS TYPE STRING,
DELIVERY_STATUS TYPE STRING,
CONSIST_STATUS TYPE STRING,
FOLLOW_ON_STATUS TYPE STRING,
CANCELATN_STATUS TYPE STRING,
ITM_LIFEC_STATUS TYPE STRING,
CREA_DATE_TIME TYPE STRING,
CREA_UNAME TYPE STRING,
LCHG_DATE_TIME TYPE STRING,
LCHG_UNAME TYPE STRING,
/SRMERP/E_SC_ITM TYPE STRING,
BUKRS TYPE STRING,
PSTYP TYPE STRING,
FABKL TYPE STRING,
MRPPP TYPE STRING,
PRREG TYPE STRING,
MNG02 TYPE STRING,
DATA_ORIGIN_MATNR TYPE STRING,
DATA_ORIGIN_MENGE TYPE STRING,
DATA_ORIGIN_MEINS TYPE STRING,
DATA_ORIGIN_MAKTX TYPE STRING,
DATA_ORIGIN_EKORG TYPE STRING,
DATA_ORIGIN_WAERS TYPE STRING,
DATA_ORIGIN_WERKS TYPE STRING,
DATA_ORIGIN_LPEIN TYPE STRING,
DATA_ORIGIN_LFDAT TYPE STRING,
DATA_ORIGIN_BUKRS TYPE STRING,
DATA_ORIGIN_FABKL TYPE STRING,
DATA_ORIGIN_KNTTP TYPE STRING,
DATA_ORIGIN_KOSTL TYPE STRING,
DATA_ORIGIN_KOKRS TYPE STRING,
SUPPLIER_NOTE TYPE STRING,
SUPPLIER_NOTE_KEY TYPE STRING,
INTERNAL_NOTE TYPE STRING,
INTERNAL_NOTE_KEY TYPE STRING,
LONG_DESCR TYPE STRING,
LONG_DESCR_KEY TYPE STRING,
THUMBNAIL_URL TYPE STRING,
THUMBNAIL_URL_KEY TYPE STRING,
PICTURE_URL TYPE STRING,
PICTURE_URL_KEY TYPE STRING,
MANUFACTURER_TXT TYPE STRING,
MAT_GROUP_TXT TYPE STRING,
PLANT_TXT TYPE STRING,
PURCH_GROUP_TXT TYPE STRING,
UOM_TXT TYPE STRING,
PARENT_NODE_KEY TYPE STRING,
ZEXKN TYPE STRING,
LOEKZ TYPE STRING,
AEDAT TYPE STRING,
SAKTO TYPE STRING,
GSBER TYPE STRING,
KOSTL TYPE STRING,
VBELN TYPE STRING,
VBELP TYPE STRING,
VETEN TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
AUFNR TYPE STRING,
ABLAD TYPE STRING,
KOKRS TYPE STRING,
KSTRG TYPE STRING,
PAOBJNR TYPE STRING,
PRCTR TYPE STRING,
PS_PSP_PNR TYPE STRING,
NPLNR TYPE STRING,
AUFPL TYPE STRING,
IMKEY TYPE STRING,
APLZL TYPE STRING,
VPTNR TYPE STRING,
FIPOS TYPE STRING,
RECID TYPE STRING,
FISTL TYPE STRING,
GEBER TYPE STRING,
GRANT_NBR TYPE STRING,
FKBER TYPE STRING,
DABRZ TYPE STRING,
AUFPL_ORD TYPE STRING,
APLZL_ORD TYPE STRING,
MWSKZ TYPE STRING,
TXJCD TYPE STRING,
LSTAR TYPE STRING,
PRZNR TYPE STRING,
VORNR TYPE STRING,
PSP_PNR TYPE STRING,
MENGE_F TYPE STRING,
BUDGET_PD TYPE STRING,
KBLNR TYPE STRING,
KBLPOS TYPE STRING,
FM_SPLIT_BATCH TYPE STRING,
FM_SPLIT_BEGRU TYPE STRING,
RECIPIENT_KEY TYPE STRING,
MIME_CODE TYPE STRING,
FILE_NAME TYPE STRING,
CONTENT TYPE STRING,
REF_SC_ITM_KEY TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SRMERP/S_SC_ITM_MODIFY_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_/SRMERP/S_SC_ITM_MODIFY_STR-KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PARENT_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ROOT_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-OBJECT_ID sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ITM_NO sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ITM_TYPE sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-TXZ01 sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MATNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MENGE sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MEINS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-NETPR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PEINH sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-EKORG sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-EKGRP sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LGORT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-BEDNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-WAERS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MATKL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-WERKS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-CATALOG_ID sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PLIFZ sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-EMATN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-IDNLF sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MPROF sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MFRPN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MFRNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-EMNFR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-BMEIN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-NETWR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-NETFW sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-WKURS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LPEIN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LFDAT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KNTTP sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KZVBR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-VRTKZ sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-TWRKZ sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-WEPOS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-WEUNB sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-REPOS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-SOBKZ sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KZBWS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-BWTAR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-XOBLR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PACKNO sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-AUTHOR_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-REQUESTER_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FOOBJ_TYPE sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-BSART sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ADRNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ADDRESS_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-TXT_EXISTS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DOC_EXISTS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FLIEF sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-SRM_CONTRACT_ID sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-SRM_CONTRACT_ITM sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LIFNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-INFNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-VRTYP sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KONNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KTPNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-RESWK sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-RESLO sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-BANFN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-BNFPO sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-RSNUM sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-RSPOS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-APPROVAL_STATUS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DELIVERY_STATUS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-CONSIST_STATUS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FOLLOW_ON_STATUS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-CANCELATN_STATUS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ITM_LIFEC_STATUS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-CREA_DATE_TIME sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-CREA_UNAME sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LCHG_DATE_TIME sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LCHG_UNAME sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-/SRMERP/E_SC_ITM sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-BUKRS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PSTYP sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FABKL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MRPPP sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PRREG sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MNG02 sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_MATNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_MENGE sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_MEINS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_MAKTX sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_EKORG sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_WAERS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_WERKS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_LPEIN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_LFDAT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_BUKRS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_FABKL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_KNTTP sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_KOSTL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DATA_ORIGIN_KOKRS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-SUPPLIER_NOTE sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-SUPPLIER_NOTE_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-INTERNAL_NOTE sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-INTERNAL_NOTE_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LONG_DESCR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LONG_DESCR_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-THUMBNAIL_URL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-THUMBNAIL_URL_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PICTURE_URL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PICTURE_URL_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MANUFACTURER_TXT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MAT_GROUP_TXT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PLANT_TXT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PURCH_GROUP_TXT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-UOM_TXT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PARENT_NODE_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ZEXKN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LOEKZ sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-AEDAT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-SAKTO sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-GSBER sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KOSTL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-VBELN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-VBELP sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-VETEN sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ANLN1 sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ANLN2 sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-AUFNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-ABLAD sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KOKRS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KSTRG sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PAOBJNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PRCTR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PS_PSP_PNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-NPLNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-AUFPL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-IMKEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-APLZL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-VPTNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FIPOS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-RECID sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FISTL sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-GEBER sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-GRANT_NBR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FKBER sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-DABRZ sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-AUFPL_ORD sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-APLZL_ORD sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MWSKZ sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-TXJCD sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-LSTAR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PRZNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-VORNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-PSP_PNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MENGE_F sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-BUDGET_PD sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KBLNR sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-KBLPOS sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FM_SPLIT_BATCH sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FM_SPLIT_BEGRU sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-RECIPIENT_KEY sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-MIME_CODE sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-FILE_NAME sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-CONTENT sy-vline
WA_/SRMERP/S_SC_ITM_MODIFY_STR-REF_SC_ITM_KEY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.