VC_INTEGRATION_MARC

@AbapCatalog.sqlViewName: 'VCIMARC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@Analytics.dataExtraction: {
        enabled: true,  // Unfortunately only views with a prefix 'I_' and 'C_' are allowed to be released for C1 contract

        delta.changeDataCapture.automatic: true
}

@EndUserText.label: 'Extraction for MARC'
define view VC_INTEGRATION_MARC
  as select from marc
{
      //marc

  key matnr as MATNR,
  key werks as WERKS,
      pstat as PSTAT,
      lvorm as LVORM,
      bwtty as BWTTY,
      xchar as XCHAR,
      mmsta as MMSTA,
      mmstd as MMSTD,
      maabc as MAABC,
      kzkri as KZKRI,
      ekgrp as EKGRP,
      ausme as AUSME,
      dispr as DISPR,
      dismm as DISMM,
      dispo as DISPO,
      kzdie as KZDIE,
      plifz as PLIFZ,
      webaz as WEBAZ,
      perkz as PERKZ,
      ausss as AUSSS,
      disls as DISLS,
      beskz as BESKZ,
      sobsl as SOBSL,
      minbe as MINBE,
      eisbe as EISBE,
      bstmi as BSTMI,
      bstma as BSTMA,
      bstfe as BSTFE,
      bstrf as BSTRF,
      mabst as MABST,
      losfx as LOSFX,
      sbdkz as SBDKZ,
      lagpr as LAGPR,
      altsl as ALTSL,
      kzaus as KZAUS,
      ausdt as AUSDT,
      nfmat as NFMAT,
      kzbed as KZBED,
      miskz as MISKZ,
      fhori as FHORI,
      pfrei as PFREI,
      ffrei as FFREI,
      rgekz as RGEKZ,
      fevor as FEVOR,
      bearz as BEARZ,
      ruezt as RUEZT,
      tranz as TRANZ,
      basmg as BASMG,
      dzeit as DZEIT,
      maxlz as MAXLZ,
      lzeih as LZEIH,
      kzpro as KZPRO,
      gpmkz as GPMKZ,
      ueeto as UEETO,
      ueetk as UEETK,
      uneto as UNETO,
      wzeit as WZEIT,
      atpkz as ATPKZ,
      vzusl as VZUSL,
      herbl as HERBL,
      insmk as INSMK,
      sproz as SPROZ,
      quazt as QUAZT,
      ssqss as SSQSS,
      mpdau as MPDAU,
      kzppv as KZPPV,
      kzdkz as KZDKZ,
      wstgh as WSTGH,
      prfrq as PRFRQ,
      nkmpr as NKMPR,
      ladgr as LADGR,
      xchpf as XCHPF,
      usequ as USEQU,
      lgrad as LGRAD,
      auftl as AUFTL,
      plvar as PLVAR,
      otype as OTYPE,
      objid as OBJID,
      mtvfp as MTVFP,
      periv as PERIV,
      kzkfk as KZKFK,
      vrvez as VRVEZ,
      vbamg as VBAMG,
      vbeaz as VBEAZ,
      lizyk as LIZYK,
      bwscl as BWSCL,
      kautb as KAUTB,
      kordb as KORDB,
      stawn as STAWN,
      herkl as HERKL,
      herkr as HERKR,
      expme as EXPME,
      mtver as MTVER,
      prctr as PRCTR,
      mrppp as MRPPP,
      sauft as SAUFT,
      fxhor as FXHOR,
      vrmod as VRMOD,
      vint1 as VINT1,
      vint2 as VINT2,
      verkz as VERKZ,
      stlal as STLAL,
      stlan as STLAN,
      plnnr as PLNNR,
      aplal as APLAL,
      losgr as LOSGR,
      sobsk as SOBSK,
      frtme as FRTME,
      lgpro as LGPRO,
      disgr as DISGR,
      kausf as KAUSF,
      qzgtp as QZGTP,
      qmatv as QMATV,
      takzt as TAKZT,
      rwpro as RWPRO,
      copam as COPAM,
      abcin as ABCIN,
      awsls as AWSLS,
      sernp as SERNP,
      cuobj as CUOBJ,
      stdpd as STDPD,
      sfepr as SFEPR,
      xmcng as XMCNG,
      qssys as QSSYS,
      lfrhy as LFRHY,
      rdprf as RDPRF,
      vrbmt as VRBMT,
      vrbwk as VRBWK,
      vrbdt as VRBDT,
      vrbfk as VRBFK,
      autru as AUTRU,
      prefe as PREFE,
      prenc as PRENC,
      preno as PRENO,
      prend as PREND,
      prene as PRENE,
      preng as PRENG,
      itark as ITARK,
      servg as SERVG,
      kzkup as KZKUP,
      strgr as STRGR,
      cuobv as CUOBV,
      lgfsb as LGFSB,
      schgt as SCHGT,
      ccfix as CCFIX,
      eprio as EPRIO,
      qmata as QMATA,
      resvp as RESVP,
      plnty as PLNTY,
      uomgr as UOMGR,
      umrsl as UMRSL,
      abfac as ABFAC,
      sfcpf as SFCPF,
      shflg as SHFLG,
      shzet as SHZET,
      mdach as MDACH,
      kzech as KZECH,
      megru as MEGRU,
      mfrgr as MFRGR,
      profil as PROFIL,
      kzagl as KZAGL,
      fvidk as FVIDK,
      fxpru as FXPRU,
      loggr as LOGGR,
      fprfm as FPRFM,
      indus as INDUS,
      mownr as MOWNR,
      mogru as MOGRU,
      casnr as CASNR,
      gpnum as GPNUM,
      steuc as STEUC,
      fabkz as FABKZ,
      matgr as MATGR,
      vspvb as VSPVB,
      dplfs as DPLFS,
      dplpu as DPLPU,
      dplho as DPLHO,
      minls as MINLS,
      maxls as MAXLS,
      fixls as FIXLS,
      ltinc as LTINC,
      compl as COMPL,
      convt as CONVT,
      shpro as SHPRO,
      ahdis as AHDIS,
      diber as DIBER,
      kzpsp as KZPSP,
      ocmpf as OCMPF,
      apokz as APOKZ,
      mcrue as MCRUE,
      lfmon as LFMON, 
      lfgja as LFGJA,
      eislo as EISLO,
      ncost as NCOST,
      rotation_date as ROTATION_DATE,
      uchkz as UCHKZ,
      ucmat as UCMAT,
      excise_tax_rlvnce as EXCISE_TAX_RLVNCE, 
      sgt_covs as SGT_COVS,
      sgt_statc as SGT_STATC,
      sgt_scope as SGT_SCOPE,
      sgt_mrpsi as SGT_MRPSI,
      sgt_prcm as SGT_PRCM,
      sgt_chint as SGT_CHINT,
      sgt_stk_prt as SGT_STK_PRT,
      sgt_defsc as SGT_DEFSC,
      sgt_mrp_atp_status as SGT_MRP_ATP_STATUS,
      sgt_mmstd as SGT_MMSTD,
      fsh_mg_arun_req as FSH_MG_ARUN_REQ,
      fsh_seaim as FSH_SEAIM,
      fsh_var_group as FSH_VAR_GROUP,
      fsh_kzech as FSH_KZECH,
      fsh_calendar_group as FSH_CALENDAR_GROUP,
      arun_fix_batch as ARUN_FIX_BATCH,
      ppskz as PPSKZ,
      cons_procg as CONS_PROCG,
      gi_pr_time as GI_PR_TIME,
      multiple_ekgrp as MULTIPLE_EKGRP,
      ref_schema as REF_SCHEMA,
      min_troc as MIN_TROC,
      max_troc as MAX_TROC,
      target_stock as TARGET_STOCK,
      nf_flag as NF_FLAG,
      /cwm/umlmc as /CWM/UMLMC,
      /cwm/trame as /CWM/TRAME,
      /cwm/bwesb as /CWM/BWESB,
      scm_matlocid_guid16 as SCM_MATLOCID_GUID16,
      scm_matlocid_guid22 as SCM_MATLOCID_GUID22,
      scm_grprt as SCM_GRPRT,
      scm_giprt as SCM_GIPRT,
      scm_scost as SCM_SCOST,
      scm_reldt as SCM_RELDT,
      scm_rrp_type as SCM_RRP_TYPE,
      scm_heur_id as SCM_HEUR_ID,
      scm_package_id as SCM_PACKAGE_ID,
      scm_sspen as SCM_SSPEN,
      scm_get_alerts as SCM_GET_ALERTS,
      scm_res_net_name as SCM_RES_NET_NAME,
      scm_conhap as SCM_CONHAP,
      scm_hunit as SCM_HUNIT,
      scm_conhap_out as SCM_CONHAP_OUT,
      scm_hunit_out as SCM_HUNIT_OUT, 
      scm_shelf_life_loc as SCM_SHELF_LIFE_LOC,
      scm_shelf_life_dur as SCM_SHELF_LIFE_DUR,
      scm_maturity_dur as SCM_MATURITY_DUR,
      scm_shlf_lfe_req_min as SCM_SHLF_LFE_REQ_MIN,
      scm_shlf_lfe_req_max as SCM_SHLF_LFE_REQ_MAX,
      scm_lsuom as SCM_LSUOM,
      scm_reord_dur as SCM_REORD_DUR,
      scm_target_dur as SCM_TARGET_DUR,
      scm_tstrid as SCM_TSTRID,
      scm_stra1 as SCM_STRA1,
      scm_peg_past_alert as SCM_PEG_PAST_ALERT,
      scm_peg_future_alert as SCM_PEG_FUTURE_ALERT,
      scm_peg_strategy as SCM_PEG_STRATEGY,
      scm_peg_wo_alert_fst  as SCM_PEG_WO_ALERT_FST,
      scm_fixpeg_prod_set  as SCM_FIXPEG_PROD_SET,
      scm_whatbom as SCM_WHATBOM,
      scm_rrp_sel_group as SCM_RRP_SEL_GROUP,
      scm_intsrc_prof as SCM_INTSRC_PROF,
      scm_prio as SCM_PRIO,
      scm_min_pass_amount as SCM_MIN_PASS_AMOUNT,
      scm_profid as SCM_PROFID,
      scm_ges_mng_use as SCM_GES_MNG_USE,
      scm_ges_bst_use as SCM_GES_BST_USE,
      esppflg as ESPPFLG,
      scm_thruput_time as SCM_THRUPUT_TIME,
      scm_tpop as SCM_TPOP,
      scm_safty_v as SCM_SAFTY_V,
      scm_ppsaftystk as SCM_PPSAFTYSTK,
      scm_ppsaftystk_v as SCM_PPSAFTYSTK_V,
      scm_repsafty as SCM_REPSAFTY,
      scm_repsafty_v as SCM_REPSAFTY_V,
      scm_reord_v as SCM_REORD_V,
      scm_maxstock_v as SCM_MAXSTOCK_V,
      scm_scost_prcnt as SCM_SCOST_PRCNT,
      scm_proc_cost as SCM_PROC_COST,
      scm_ndcostwe as SCM_NDCOSTWE,
      scm_ndcostwa as SCM_NDCOSTWA,
      /sapmp/tolprpl as /SAPMP/TOLPRPL,
      /sapmp/tolprmi as /SAPMP/TOLPRMI,
      /vso/r_pkgrp as /VSO/R_PKGRP,
      /vso/r_lane_num as /VSO/R_LANE_NUM,
      /vso/r_pal_vend as /VSO/R_PAL_VEND,
      /vso/r_fork_dir as /VSO/R_FORK_DIR,
      iuid_relevant as IUID_RELEVANT,
      iuid_type as IUID_TYPE,
      uid_iea as UID_IEA,
      dpcbt as DPCBT
}