ABAP Select data from SAP table VCIMARC 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 VCIMARC 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 VCIMARC. 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 VCIMARC 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_VCIMARC TYPE STANDARD TABLE OF VCIMARC,
      WA_VCIMARC TYPE VCIMARC,
      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: <VCIMARC> TYPE VCIMARC.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VCIMARC
*  INTO TABLE @DATA(IT_VCIMARC2).
*--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_VCIMARC INDEX 1 INTO DATA(WA_VCIMARC2).


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

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

ENDLOOP.

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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