ABAP Select data from SAP table MARC into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

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

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MARC
*  INTO TABLE @DATA(IT_MARC2).
*--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_MARC INDEX 1 INTO DATA(WA_MARC2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MARC ASSIGNING <MARC>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MARC>-MANDT = 1.
<MARC>-MATNR = 1.
<MARC>-WERKS = 1.
<MARC>-PSTAT = 1.
<MARC>-LVORM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MARC-BWTTY, sy-vline,
  WA_MARC-XCHAR, sy-vline,
  WA_MARC-MMSTA, sy-vline,
  WA_MARC-MMSTD, sy-vline,
  WA_MARC-MAABC, sy-vline,
  WA_MARC-KZKRI, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MARC 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_MARC 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_MARC INTO WA_MARC.


*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_MARC-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MARC-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit GJAHR, internal->external for field LFGJA
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_MARC-LFGJA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MARC-LFGJA.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit TSTRN, internal->external for field SCM_PEG_PAST_ALERT
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_MARC-SCM_PEG_PAST_ALERT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MARC-SCM_PEG_PAST_ALERT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field SCM_PEG_FUTURE_ALERT
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_MARC-SCM_PEG_FUTURE_ALERT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MARC-SCM_PEG_FUTURE_ALERT.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit MATN1, internal->external for field /VSO/R_PAL_VEND
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_MARC-/VSO/R_PAL_VEND
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MARC-/VSO/R_PAL_VEND.
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_MARC_STR, 
MANDT TYPE STRING,
MATNR TYPE STRING,
WERKS TYPE STRING,
PSTAT TYPE STRING,
LVORM TYPE STRING,
BWTTY TYPE STRING,
XCHAR TYPE STRING,
MMSTA TYPE STRING,
MMSTD TYPE STRING,
MAABC TYPE STRING,
KZKRI TYPE STRING,
EKGRP TYPE STRING,
AUSME TYPE STRING,
DISPR TYPE STRING,
DISMM TYPE STRING,
DISPO TYPE STRING,
KZDIE TYPE STRING,
PLIFZ TYPE STRING,
WEBAZ TYPE STRING,
PERKZ TYPE STRING,
AUSSS TYPE STRING,
DISLS TYPE STRING,
BESKZ TYPE STRING,
SOBSL TYPE STRING,
MINBE TYPE STRING,
EISBE TYPE STRING,
BSTMI TYPE STRING,
BSTMA TYPE STRING,
BSTFE TYPE STRING,
BSTRF TYPE STRING,
MABST TYPE STRING,
LOSFX TYPE STRING,
SBDKZ TYPE STRING,
LAGPR TYPE STRING,
ALTSL TYPE STRING,
KZAUS TYPE STRING,
AUSDT TYPE STRING,
NFMAT TYPE STRING,
KZBED TYPE STRING,
MISKZ TYPE STRING,
FHORI TYPE STRING,
PFREI TYPE STRING,
FFREI TYPE STRING,
RGEKZ TYPE STRING,
FEVOR TYPE STRING,
BEARZ TYPE STRING,
RUEZT TYPE STRING,
TRANZ TYPE STRING,
BASMG TYPE STRING,
DZEIT TYPE STRING,
MAXLZ TYPE STRING,
LZEIH TYPE STRING,
KZPRO TYPE STRING,
GPMKZ TYPE STRING,
UEETO TYPE STRING,
UEETK TYPE STRING,
UNETO TYPE STRING,
WZEIT TYPE STRING,
ATPKZ TYPE STRING,
VZUSL TYPE STRING,
HERBL TYPE STRING,
INSMK TYPE STRING,
SPROZ TYPE STRING,
QUAZT TYPE STRING,
SSQSS TYPE STRING,
MPDAU TYPE STRING,
KZPPV TYPE STRING,
KZDKZ TYPE STRING,
WSTGH TYPE STRING,
PRFRQ TYPE STRING,
NKMPR TYPE STRING,
UMLMC TYPE STRING,
LADGR TYPE STRING,
XCHPF TYPE STRING,
USEQU TYPE STRING,
LGRAD TYPE STRING,
AUFTL TYPE STRING,
PLVAR TYPE STRING,
OTYPE TYPE STRING,
OBJID TYPE STRING,
MTVFP TYPE STRING,
PERIV TYPE STRING,
KZKFK TYPE STRING,
VRVEZ TYPE STRING,
VBAMG TYPE STRING,
VBEAZ TYPE STRING,
LIZYK TYPE STRING,
BWSCL TYPE STRING,
KAUTB TYPE STRING,
KORDB TYPE STRING,
STAWN TYPE STRING,
HERKL TYPE STRING,
HERKR TYPE STRING,
EXPME TYPE STRING,
MTVER TYPE STRING,
PRCTR TYPE STRING,
TRAME TYPE STRING,
MRPPP TYPE STRING,
SAUFT TYPE STRING,
FXHOR TYPE STRING,
VRMOD TYPE STRING,
VINT1 TYPE STRING,
VINT2 TYPE STRING,
VERKZ TYPE STRING,
STLAL TYPE STRING,
STLAN TYPE STRING,
PLNNR TYPE STRING,
APLAL TYPE STRING,
LOSGR TYPE STRING,
SOBSK TYPE STRING,
FRTME TYPE STRING,
LGPRO TYPE STRING,
DISGR TYPE STRING,
KAUSF TYPE STRING,
QZGTP TYPE STRING,
QMATV TYPE STRING,
TAKZT TYPE STRING,
RWPRO TYPE STRING,
COPAM TYPE STRING,
ABCIN TYPE STRING,
AWSLS TYPE STRING,
SERNP TYPE STRING,
CUOBJ TYPE STRING,
STDPD TYPE STRING,
SFEPR TYPE STRING,
XMCNG TYPE STRING,
QSSYS TYPE STRING,
LFRHY TYPE STRING,
RDPRF TYPE STRING,
VRBMT TYPE STRING,
VRBWK TYPE STRING,
VRBDT TYPE STRING,
VRBFK TYPE STRING,
AUTRU TYPE STRING,
PREFE TYPE STRING,
PRENC TYPE STRING,
PRENO TYPE STRING,
PREND TYPE STRING,
PRENE TYPE STRING,
PRENG TYPE STRING,
ITARK TYPE STRING,
SERVG TYPE STRING,
KZKUP TYPE STRING,
STRGR TYPE STRING,
CUOBV TYPE STRING,
LGFSB TYPE STRING,
SCHGT TYPE STRING,
CCFIX TYPE STRING,
EPRIO TYPE STRING,
QMATA TYPE STRING,
RESVP TYPE STRING,
PLNTY TYPE STRING,
UOMGR TYPE STRING,
UMRSL TYPE STRING,
ABFAC TYPE STRING,
SFCPF TYPE STRING,
SHFLG TYPE STRING,
SHZET TYPE STRING,
MDACH TYPE STRING,
KZECH TYPE STRING,
MEGRU TYPE STRING,
MFRGR TYPE STRING,
SFTY_STK_METH TYPE STRING,
PROFIL TYPE STRING,
VKUMC TYPE STRING,
VKTRW TYPE STRING,
KZAGL TYPE STRING,
FVIDK TYPE STRING,
FXPRU TYPE STRING,
LOGGR TYPE STRING,
FPRFM TYPE STRING,
GLGMG TYPE STRING,
VKGLG TYPE STRING,
INDUS TYPE STRING,
MOWNR TYPE STRING,
MOGRU TYPE STRING,
CASNR TYPE STRING,
GPNUM TYPE STRING,
STEUC TYPE STRING,
FABKZ TYPE STRING,
MATGR TYPE STRING,
VSPVB TYPE STRING,
DPLFS TYPE STRING,
DPLPU TYPE STRING,
DPLHO TYPE STRING,
MINLS TYPE STRING,
MAXLS TYPE STRING,
FIXLS TYPE STRING,
LTINC TYPE STRING,
COMPL TYPE STRING,
CONVT TYPE STRING,
SHPRO TYPE STRING,
AHDIS TYPE STRING,
DIBER TYPE STRING,
KZPSP TYPE STRING,
OCMPF TYPE STRING,
APOKZ TYPE STRING,
MCRUE TYPE STRING,
LFMON TYPE STRING,
LFGJA TYPE STRING,
EISLO TYPE STRING,
NCOST TYPE STRING,
ROTATION_DATE TYPE STRING,
UCHKZ TYPE STRING,
UCMAT TYPE STRING,
EXCISE_TAX_RLVNCE TYPE STRING,
BWESB TYPE STRING,
SGT_COVS TYPE STRING,
SGT_STATC TYPE STRING,
SGT_SCOPE TYPE STRING,
SGT_MRPSI TYPE STRING,
SGT_PRCM TYPE STRING,
SGT_CHINT TYPE STRING,
SGT_STK_PRT TYPE STRING,
SGT_DEFSC TYPE STRING,
SGT_MRP_ATP_STATUS TYPE STRING,
SGT_MMSTD TYPE STRING,
FSH_MG_ARUN_REQ TYPE STRING,
FSH_SEAIM TYPE STRING,
FSH_VAR_GROUP TYPE STRING,
FSH_KZECH TYPE STRING,
FSH_CALENDAR_GROUP TYPE STRING,
ARUN_FIX_BATCH TYPE STRING,
PPSKZ TYPE STRING,
CONS_PROCG TYPE STRING,
GI_PR_TIME TYPE STRING,
MULTIPLE_EKGRP TYPE STRING,
REF_SCHEMA TYPE STRING,
MIN_TROC TYPE STRING,
MAX_TROC TYPE STRING,
TARGET_STOCK TYPE STRING,
NF_FLAG TYPE STRING,
/CWM/UMLMC TYPE STRING,
/CWM/TRAME TYPE STRING,
/CWM/BWESB TYPE STRING,
SCM_MATLOCID_GUID16 TYPE STRING,
SCM_MATLOCID_GUID22 TYPE STRING,
SCM_GRPRT TYPE STRING,
SCM_GIPRT TYPE STRING,
SCM_SCOST TYPE STRING,
SCM_RELDT TYPE STRING,
SCM_RRP_TYPE TYPE STRING,
SCM_HEUR_ID TYPE STRING,
SCM_PACKAGE_ID TYPE STRING,
SCM_SSPEN TYPE STRING,
SCM_GET_ALERTS TYPE STRING,
SCM_RES_NET_NAME TYPE STRING,
SCM_CONHAP TYPE STRING,
SCM_HUNIT TYPE STRING,
SCM_CONHAP_OUT TYPE STRING,
SCM_HUNIT_OUT TYPE STRING,
SCM_SHELF_LIFE_LOC TYPE STRING,
SCM_SHELF_LIFE_DUR TYPE STRING,
SCM_MATURITY_DUR TYPE STRING,
SCM_SHLF_LFE_REQ_MIN TYPE STRING,
SCM_SHLF_LFE_REQ_MAX TYPE STRING,
SCM_LSUOM TYPE STRING,
SCM_REORD_DUR TYPE STRING,
SCM_TARGET_DUR TYPE STRING,
SCM_TSTRID TYPE STRING,
SCM_STRA1 TYPE STRING,
SCM_PEG_PAST_ALERT TYPE STRING,
SCM_PEG_FUTURE_ALERT TYPE STRING,
SCM_PEG_STRATEGY TYPE STRING,
SCM_PEG_WO_ALERT_FST TYPE STRING,
SCM_FIXPEG_PROD_SET TYPE STRING,
SCM_WHATBOM TYPE STRING,
SCM_RRP_SEL_GROUP TYPE STRING,
SCM_INTSRC_PROF TYPE STRING,
SCM_PRIO TYPE STRING,
SCM_MIN_PASS_AMOUNT TYPE STRING,
SCM_PROFID TYPE STRING,
SCM_GES_MNG_USE TYPE STRING,
SCM_GES_BST_USE TYPE STRING,
ESPPFLG TYPE STRING,
SCM_THRUPUT_TIME TYPE STRING,
SCM_TPOP TYPE STRING,
SCM_SAFTY_V TYPE STRING,
SCM_PPSAFTYSTK TYPE STRING,
SCM_PPSAFTYSTK_V TYPE STRING,
SCM_REPSAFTY TYPE STRING,
SCM_REPSAFTY_V TYPE STRING,
SCM_REORD_V TYPE STRING,
SCM_MAXSTOCK_V TYPE STRING,
SCM_SCOST_PRCNT TYPE STRING,
SCM_PROC_COST TYPE STRING,
SCM_NDCOSTWE TYPE STRING,
SCM_NDCOSTWA TYPE STRING,
SCM_CONINP TYPE STRING,
CONF_GMSYNC TYPE STRING,
SCM_IUNIT TYPE STRING,
SCM_SFT_LOCK TYPE STRING,
DUMMY_PLNT_INCL_EEW_PS TYPE STRING,
/SAPMP/TOLPRPL TYPE STRING,
/SAPMP/TOLPRMI TYPE STRING,
/STTPEC/SERVALID TYPE STRING,
/VSO/R_PKGRP TYPE STRING,
/VSO/R_LANE_NUM TYPE STRING,
/VSO/R_PAL_VEND TYPE STRING,
/VSO/R_FORK_DIR TYPE STRING,
IUID_RELEVANT TYPE STRING,
IUID_TYPE TYPE STRING,
UID_IEA TYPE STRING,
DPCBT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MARC_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_MARC_STR-MANDT sy-vline 
WA_MARC_STR-MATNR sy-vline 
WA_MARC_STR-WERKS sy-vline 
WA_MARC_STR-PSTAT sy-vline 
WA_MARC_STR-LVORM sy-vline 
WA_MARC_STR-BWTTY sy-vline 
WA_MARC_STR-XCHAR sy-vline 
WA_MARC_STR-MMSTA sy-vline 
WA_MARC_STR-MMSTD sy-vline 
WA_MARC_STR-MAABC sy-vline 
WA_MARC_STR-KZKRI sy-vline 
WA_MARC_STR-EKGRP sy-vline 
WA_MARC_STR-AUSME sy-vline 
WA_MARC_STR-DISPR sy-vline 
WA_MARC_STR-DISMM sy-vline 
WA_MARC_STR-DISPO sy-vline 
WA_MARC_STR-KZDIE sy-vline 
WA_MARC_STR-PLIFZ sy-vline 
WA_MARC_STR-WEBAZ sy-vline 
WA_MARC_STR-PERKZ sy-vline 
WA_MARC_STR-AUSSS sy-vline 
WA_MARC_STR-DISLS sy-vline 
WA_MARC_STR-BESKZ sy-vline 
WA_MARC_STR-SOBSL sy-vline 
WA_MARC_STR-MINBE sy-vline 
WA_MARC_STR-EISBE sy-vline 
WA_MARC_STR-BSTMI sy-vline 
WA_MARC_STR-BSTMA sy-vline 
WA_MARC_STR-BSTFE sy-vline 
WA_MARC_STR-BSTRF sy-vline 
WA_MARC_STR-MABST sy-vline 
WA_MARC_STR-LOSFX sy-vline 
WA_MARC_STR-SBDKZ sy-vline 
WA_MARC_STR-LAGPR sy-vline 
WA_MARC_STR-ALTSL sy-vline 
WA_MARC_STR-KZAUS sy-vline 
WA_MARC_STR-AUSDT sy-vline 
WA_MARC_STR-NFMAT sy-vline 
WA_MARC_STR-KZBED sy-vline 
WA_MARC_STR-MISKZ sy-vline 
WA_MARC_STR-FHORI sy-vline 
WA_MARC_STR-PFREI sy-vline 
WA_MARC_STR-FFREI sy-vline 
WA_MARC_STR-RGEKZ sy-vline 
WA_MARC_STR-FEVOR sy-vline 
WA_MARC_STR-BEARZ sy-vline 
WA_MARC_STR-RUEZT sy-vline 
WA_MARC_STR-TRANZ sy-vline 
WA_MARC_STR-BASMG sy-vline 
WA_MARC_STR-DZEIT sy-vline 
WA_MARC_STR-MAXLZ sy-vline 
WA_MARC_STR-LZEIH sy-vline 
WA_MARC_STR-KZPRO sy-vline 
WA_MARC_STR-GPMKZ sy-vline 
WA_MARC_STR-UEETO sy-vline 
WA_MARC_STR-UEETK sy-vline 
WA_MARC_STR-UNETO sy-vline 
WA_MARC_STR-WZEIT sy-vline 
WA_MARC_STR-ATPKZ sy-vline 
WA_MARC_STR-VZUSL sy-vline 
WA_MARC_STR-HERBL sy-vline 
WA_MARC_STR-INSMK sy-vline 
WA_MARC_STR-SPROZ sy-vline 
WA_MARC_STR-QUAZT sy-vline 
WA_MARC_STR-SSQSS sy-vline 
WA_MARC_STR-MPDAU sy-vline 
WA_MARC_STR-KZPPV sy-vline 
WA_MARC_STR-KZDKZ sy-vline 
WA_MARC_STR-WSTGH sy-vline 
WA_MARC_STR-PRFRQ sy-vline 
WA_MARC_STR-NKMPR sy-vline 
WA_MARC_STR-UMLMC sy-vline 
WA_MARC_STR-LADGR sy-vline 
WA_MARC_STR-XCHPF sy-vline 
WA_MARC_STR-USEQU sy-vline 
WA_MARC_STR-LGRAD sy-vline 
WA_MARC_STR-AUFTL sy-vline 
WA_MARC_STR-PLVAR sy-vline 
WA_MARC_STR-OTYPE sy-vline 
WA_MARC_STR-OBJID sy-vline 
WA_MARC_STR-MTVFP sy-vline 
WA_MARC_STR-PERIV sy-vline 
WA_MARC_STR-KZKFK sy-vline 
WA_MARC_STR-VRVEZ sy-vline 
WA_MARC_STR-VBAMG sy-vline 
WA_MARC_STR-VBEAZ sy-vline 
WA_MARC_STR-LIZYK sy-vline 
WA_MARC_STR-BWSCL sy-vline 
WA_MARC_STR-KAUTB sy-vline 
WA_MARC_STR-KORDB sy-vline 
WA_MARC_STR-STAWN sy-vline 
WA_MARC_STR-HERKL sy-vline 
WA_MARC_STR-HERKR sy-vline 
WA_MARC_STR-EXPME sy-vline 
WA_MARC_STR-MTVER sy-vline 
WA_MARC_STR-PRCTR sy-vline 
WA_MARC_STR-TRAME sy-vline 
WA_MARC_STR-MRPPP sy-vline 
WA_MARC_STR-SAUFT sy-vline 
WA_MARC_STR-FXHOR sy-vline 
WA_MARC_STR-VRMOD sy-vline 
WA_MARC_STR-VINT1 sy-vline 
WA_MARC_STR-VINT2 sy-vline 
WA_MARC_STR-VERKZ sy-vline 
WA_MARC_STR-STLAL sy-vline 
WA_MARC_STR-STLAN sy-vline 
WA_MARC_STR-PLNNR sy-vline 
WA_MARC_STR-APLAL sy-vline 
WA_MARC_STR-LOSGR sy-vline 
WA_MARC_STR-SOBSK sy-vline 
WA_MARC_STR-FRTME sy-vline 
WA_MARC_STR-LGPRO sy-vline 
WA_MARC_STR-DISGR sy-vline 
WA_MARC_STR-KAUSF sy-vline 
WA_MARC_STR-QZGTP sy-vline 
WA_MARC_STR-QMATV sy-vline 
WA_MARC_STR-TAKZT sy-vline 
WA_MARC_STR-RWPRO sy-vline 
WA_MARC_STR-COPAM sy-vline 
WA_MARC_STR-ABCIN sy-vline 
WA_MARC_STR-AWSLS sy-vline 
WA_MARC_STR-SERNP sy-vline 
WA_MARC_STR-CUOBJ sy-vline 
WA_MARC_STR-STDPD sy-vline 
WA_MARC_STR-SFEPR sy-vline 
WA_MARC_STR-XMCNG sy-vline 
WA_MARC_STR-QSSYS sy-vline 
WA_MARC_STR-LFRHY sy-vline 
WA_MARC_STR-RDPRF sy-vline 
WA_MARC_STR-VRBMT sy-vline 
WA_MARC_STR-VRBWK sy-vline 
WA_MARC_STR-VRBDT sy-vline 
WA_MARC_STR-VRBFK sy-vline 
WA_MARC_STR-AUTRU sy-vline 
WA_MARC_STR-PREFE sy-vline 
WA_MARC_STR-PRENC sy-vline 
WA_MARC_STR-PRENO sy-vline 
WA_MARC_STR-PREND sy-vline 
WA_MARC_STR-PRENE sy-vline 
WA_MARC_STR-PRENG sy-vline 
WA_MARC_STR-ITARK sy-vline 
WA_MARC_STR-SERVG sy-vline 
WA_MARC_STR-KZKUP sy-vline 
WA_MARC_STR-STRGR sy-vline 
WA_MARC_STR-CUOBV sy-vline 
WA_MARC_STR-LGFSB sy-vline 
WA_MARC_STR-SCHGT sy-vline 
WA_MARC_STR-CCFIX sy-vline 
WA_MARC_STR-EPRIO sy-vline 
WA_MARC_STR-QMATA sy-vline 
WA_MARC_STR-RESVP sy-vline 
WA_MARC_STR-PLNTY sy-vline 
WA_MARC_STR-UOMGR sy-vline 
WA_MARC_STR-UMRSL sy-vline 
WA_MARC_STR-ABFAC sy-vline 
WA_MARC_STR-SFCPF sy-vline 
WA_MARC_STR-SHFLG sy-vline 
WA_MARC_STR-SHZET sy-vline 
WA_MARC_STR-MDACH sy-vline 
WA_MARC_STR-KZECH sy-vline 
WA_MARC_STR-MEGRU sy-vline 
WA_MARC_STR-MFRGR sy-vline 
WA_MARC_STR-SFTY_STK_METH sy-vline 
WA_MARC_STR-PROFIL sy-vline 
WA_MARC_STR-VKUMC sy-vline 
WA_MARC_STR-VKTRW sy-vline 
WA_MARC_STR-KZAGL sy-vline 
WA_MARC_STR-FVIDK sy-vline 
WA_MARC_STR-FXPRU sy-vline 
WA_MARC_STR-LOGGR sy-vline 
WA_MARC_STR-FPRFM sy-vline 
WA_MARC_STR-GLGMG sy-vline 
WA_MARC_STR-VKGLG sy-vline 
WA_MARC_STR-INDUS sy-vline 
WA_MARC_STR-MOWNR sy-vline 
WA_MARC_STR-MOGRU sy-vline 
WA_MARC_STR-CASNR sy-vline 
WA_MARC_STR-GPNUM sy-vline 
WA_MARC_STR-STEUC sy-vline 
WA_MARC_STR-FABKZ sy-vline 
WA_MARC_STR-MATGR sy-vline 
WA_MARC_STR-VSPVB sy-vline 
WA_MARC_STR-DPLFS sy-vline 
WA_MARC_STR-DPLPU sy-vline 
WA_MARC_STR-DPLHO sy-vline 
WA_MARC_STR-MINLS sy-vline 
WA_MARC_STR-MAXLS sy-vline 
WA_MARC_STR-FIXLS sy-vline 
WA_MARC_STR-LTINC sy-vline 
WA_MARC_STR-COMPL sy-vline 
WA_MARC_STR-CONVT sy-vline 
WA_MARC_STR-SHPRO sy-vline 
WA_MARC_STR-AHDIS sy-vline 
WA_MARC_STR-DIBER sy-vline 
WA_MARC_STR-KZPSP sy-vline 
WA_MARC_STR-OCMPF sy-vline 
WA_MARC_STR-APOKZ sy-vline 
WA_MARC_STR-MCRUE sy-vline 
WA_MARC_STR-LFMON sy-vline 
WA_MARC_STR-LFGJA sy-vline 
WA_MARC_STR-EISLO sy-vline 
WA_MARC_STR-NCOST sy-vline 
WA_MARC_STR-ROTATION_DATE sy-vline 
WA_MARC_STR-UCHKZ sy-vline 
WA_MARC_STR-UCMAT sy-vline 
WA_MARC_STR-EXCISE_TAX_RLVNCE sy-vline 
WA_MARC_STR-BWESB sy-vline 
WA_MARC_STR-SGT_COVS sy-vline 
WA_MARC_STR-SGT_STATC sy-vline 
WA_MARC_STR-SGT_SCOPE sy-vline 
WA_MARC_STR-SGT_MRPSI sy-vline 
WA_MARC_STR-SGT_PRCM sy-vline 
WA_MARC_STR-SGT_CHINT sy-vline 
WA_MARC_STR-SGT_STK_PRT sy-vline 
WA_MARC_STR-SGT_DEFSC sy-vline 
WA_MARC_STR-SGT_MRP_ATP_STATUS sy-vline 
WA_MARC_STR-SGT_MMSTD sy-vline 
WA_MARC_STR-FSH_MG_ARUN_REQ sy-vline 
WA_MARC_STR-FSH_SEAIM sy-vline 
WA_MARC_STR-FSH_VAR_GROUP sy-vline 
WA_MARC_STR-FSH_KZECH sy-vline 
WA_MARC_STR-FSH_CALENDAR_GROUP sy-vline 
WA_MARC_STR-ARUN_FIX_BATCH sy-vline 
WA_MARC_STR-PPSKZ sy-vline 
WA_MARC_STR-CONS_PROCG sy-vline 
WA_MARC_STR-GI_PR_TIME sy-vline 
WA_MARC_STR-MULTIPLE_EKGRP sy-vline 
WA_MARC_STR-REF_SCHEMA sy-vline 
WA_MARC_STR-MIN_TROC sy-vline 
WA_MARC_STR-MAX_TROC sy-vline 
WA_MARC_STR-TARGET_STOCK sy-vline 
WA_MARC_STR-NF_FLAG sy-vline 
WA_MARC_STR-/CWM/UMLMC sy-vline 
WA_MARC_STR-/CWM/TRAME sy-vline 
WA_MARC_STR-/CWM/BWESB sy-vline 
WA_MARC_STR-SCM_MATLOCID_GUID16 sy-vline 
WA_MARC_STR-SCM_MATLOCID_GUID22 sy-vline 
WA_MARC_STR-SCM_GRPRT sy-vline 
WA_MARC_STR-SCM_GIPRT sy-vline 
WA_MARC_STR-SCM_SCOST sy-vline 
WA_MARC_STR-SCM_RELDT sy-vline 
WA_MARC_STR-SCM_RRP_TYPE sy-vline 
WA_MARC_STR-SCM_HEUR_ID sy-vline 
WA_MARC_STR-SCM_PACKAGE_ID sy-vline 
WA_MARC_STR-SCM_SSPEN sy-vline 
WA_MARC_STR-SCM_GET_ALERTS sy-vline 
WA_MARC_STR-SCM_RES_NET_NAME sy-vline 
WA_MARC_STR-SCM_CONHAP sy-vline 
WA_MARC_STR-SCM_HUNIT sy-vline 
WA_MARC_STR-SCM_CONHAP_OUT sy-vline 
WA_MARC_STR-SCM_HUNIT_OUT sy-vline 
WA_MARC_STR-SCM_SHELF_LIFE_LOC sy-vline 
WA_MARC_STR-SCM_SHELF_LIFE_DUR sy-vline 
WA_MARC_STR-SCM_MATURITY_DUR sy-vline 
WA_MARC_STR-SCM_SHLF_LFE_REQ_MIN sy-vline 
WA_MARC_STR-SCM_SHLF_LFE_REQ_MAX sy-vline 
WA_MARC_STR-SCM_LSUOM sy-vline 
WA_MARC_STR-SCM_REORD_DUR sy-vline 
WA_MARC_STR-SCM_TARGET_DUR sy-vline 
WA_MARC_STR-SCM_TSTRID sy-vline 
WA_MARC_STR-SCM_STRA1 sy-vline 
WA_MARC_STR-SCM_PEG_PAST_ALERT sy-vline 
WA_MARC_STR-SCM_PEG_FUTURE_ALERT sy-vline 
WA_MARC_STR-SCM_PEG_STRATEGY sy-vline 
WA_MARC_STR-SCM_PEG_WO_ALERT_FST sy-vline 
WA_MARC_STR-SCM_FIXPEG_PROD_SET sy-vline 
WA_MARC_STR-SCM_WHATBOM sy-vline 
WA_MARC_STR-SCM_RRP_SEL_GROUP sy-vline 
WA_MARC_STR-SCM_INTSRC_PROF sy-vline 
WA_MARC_STR-SCM_PRIO sy-vline 
WA_MARC_STR-SCM_MIN_PASS_AMOUNT sy-vline 
WA_MARC_STR-SCM_PROFID sy-vline 
WA_MARC_STR-SCM_GES_MNG_USE sy-vline 
WA_MARC_STR-SCM_GES_BST_USE sy-vline 
WA_MARC_STR-ESPPFLG sy-vline 
WA_MARC_STR-SCM_THRUPUT_TIME sy-vline 
WA_MARC_STR-SCM_TPOP sy-vline 
WA_MARC_STR-SCM_SAFTY_V sy-vline 
WA_MARC_STR-SCM_PPSAFTYSTK sy-vline 
WA_MARC_STR-SCM_PPSAFTYSTK_V sy-vline 
WA_MARC_STR-SCM_REPSAFTY sy-vline 
WA_MARC_STR-SCM_REPSAFTY_V sy-vline 
WA_MARC_STR-SCM_REORD_V sy-vline 
WA_MARC_STR-SCM_MAXSTOCK_V sy-vline 
WA_MARC_STR-SCM_SCOST_PRCNT sy-vline 
WA_MARC_STR-SCM_PROC_COST sy-vline 
WA_MARC_STR-SCM_NDCOSTWE sy-vline 
WA_MARC_STR-SCM_NDCOSTWA sy-vline 
WA_MARC_STR-SCM_CONINP sy-vline 
WA_MARC_STR-CONF_GMSYNC sy-vline 
WA_MARC_STR-SCM_IUNIT sy-vline 
WA_MARC_STR-SCM_SFT_LOCK sy-vline 
WA_MARC_STR-DUMMY_PLNT_INCL_EEW_PS sy-vline 
WA_MARC_STR-/SAPMP/TOLPRPL sy-vline 
WA_MARC_STR-/SAPMP/TOLPRMI sy-vline 
WA_MARC_STR-/STTPEC/SERVALID sy-vline 
WA_MARC_STR-/VSO/R_PKGRP sy-vline 
WA_MARC_STR-/VSO/R_LANE_NUM sy-vline 
WA_MARC_STR-/VSO/R_PAL_VEND sy-vline 
WA_MARC_STR-/VSO/R_FORK_DIR sy-vline 
WA_MARC_STR-IUID_RELEVANT sy-vline 
WA_MARC_STR-IUID_TYPE sy-vline 
WA_MARC_STR-UID_IEA sy-vline 
WA_MARC_STR-DPCBT sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.