VC_INTEGRATION_MARA

@AbapCatalog.sqlViewName: 'VCIMARA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #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 MARA'
define view VC_INTEGRATION_MARA
  as select from mara
{
      //mara

  key matnr as MATNR,
      ersda as ERSDA,
      created_at_time as CREATED_AT_TIME,
      // ernam,

      laeda as LAEDA,
      //aenam,

      vpsta as VPSTA,
      pstat as PSTAT,
      lvorm as LVORM,
      mtart as MTART,
      mbrsh as MBRSH,
      matkl as MATKL,
      bismt as BISMT,
      meins as MEINS,
      bstme as BSTME,
      zeinr as ZEINR,
      zeiar as ZEIAR,
      zeivr as ZEIVR,
      zeifo as ZEIFO,
      aeszn as AESZN,
      blatt as BLATT,
      blanz as BLANZ,
      ferth as FERTH,
      formt as FORMT,
      groes as GROES,
      wrkst as WRKST,
      normt as NORMT,
      labor as LABOR,
      ekwsl as EKWSL,
      brgew as BRGEW,
      ntgew as NTGEW,
      gewei as GEWEI,
      volum as VOLUM,
      voleh as VOLEH,
      behvo as BEHVO,
      raube as RAUBE,
      tempb as TEMPB,
      disst as DISST,
      tragr as TRAGR,
      stoff as STOFF,
      spart as SPART,
      // kunnr,

      eannr as EANNR,
      wesch as WESCH,
      bwvor as BWVOR,
      bwscl as BWSCL,
      saiso as SAISO,
      etiar as ETIAR,
      etifo as ETIFO,
      entar as ENTAR,
      ean11 as EAN11,
      numtp as NUMTP,
      laeng as LAENG,
      breit as BREIT,
      hoehe as HOEHE,
      meabm as MEABM,
      prdha as PRDHA,
      aeklk as AEKLK,
      cadkz as CADKZ,
      qmpur as QMPUR,
      ergew as ERGEW,
      ergei as ERGEI,
      ervol as ERVOL,
      ervoe as ERVOE,
      gewto as GEWTO,
      volto as VOLTO,
      vabme as VABME,
      kzrev as KZREV,
      kzkfg as KZKFG,
      xchpf as XCHPF,
      vhart as VHART,
      fuelg as FUELG,
      stfak as STFAK,
      magrv as MAGRV,
      begru as BEGRU,
      datab as DATAB,
      liqdt as LIQDT,
      saisj as SAISJ,
      plgtp as PLGTP,
      mlgut as MLGUT,
      extwg as EXTWG,
      satnr as SATNR,
      attyp as ATTYP,
      kzkup as KZKUP,
      kznfm as KZNFM,
      pmata as PMATA,
      mstae as MSTAE,
      mstav as MSTAV,
      mstde as MSTDE,
      mstdv as MSTDV,
      taklv as TAKLV,
      rbnrm as RBNRM,
      mhdrz as MHDRZ,
      mhdhb as MHDHB,
      mhdlp as MHDLP,
      inhme as INHME,
      inhal as INHAL,
      vpreh as VPREH,
      etiag as ETIAG,
      inhbr as INHBR,
      cmeth as CMETH,
      cuobf as CUOBF,
      kzumw as KZUMW,
      kosch as KOSCH,
      sprof as SPROF,
      nrfhg as NRFHG,
      mfrpn as MFRPN,
      // mfrnr,

      bmatn as BMATN,
      mprof as MPROF,
      kzwsm as KZWSM,
      saity as SAITY,
      profl as PROFL,
      ihivi as IHIVI,
      iloos as ILOOS,
      serlv as SERLV,
      kzgvh as KZGVH,
      xgchp as XGCHP,
      kzeff as KZEFF,
      compl as COMPL,
      iprkz as IPRKZ,
      rdmhd as RDMHD,
      przus as PRZUS,
      mtpos_mara as MTPOS_MARA,
      bflme as BFLME,
      matfi as MATFI,
      cmrel as CMREL,
      bbtyp as BBTYP,
      sled_bbd as SLED_BBD,
      gtin_variant as GTIN_VARIANT,
      gennr as GENNR,
      rmatp as RMATP,
      gds_relevant as GDS_RELEVANT,
      weora as WEORA, 
      hutyp_dflt as HUTYP_DFLT,
      pilferable as PILFERABLE,
      whstc as WHSTC,
      whmatgr as WHMATGR,
      hndlcode as HNDLCODE,
      hazmat as HAZMAT,
      hutyp as HUTYP,
      tare_var as TARE_VAR,
      maxc as MAXC,
      maxc_tol as MAXC_TOL,
      maxl as MAXL,
      maxb as MAXB,
      maxh as MAXH,
      maxdim_uom as MAXDIM_UOM,
      herkl as HERKL,
      mfrgr as MFRGR,
      qqtime as QQTIME,
      qqtimeuom as QQTIMEUOM,
      qgrp as QGRP,
      serial as SERIAL,
      ps_smartform as PS_SMARTFORM,
      logunit as LOGUNIT,
      cwqrel as CWQREL,
      cwqproc as CWQPROC,
      cwqtolgr as CWQTOLGR,
      adprof as ADPROF,
      ipmipproduct as IPMIPPRODUCT,
      allow_pmat_igno as ALLOW_PMAT_IGNO,
      medium as MEDIUM,
      commodity as COMMODITY,
      animal_origin as ANIMAL_ORIGIN,
      textile_comp_ind as TEXTILE_COMP_IND,
      last_changed_time as LAST_CHANGED_TIME,
      matnr_external as MATNR_EXTERNAL,
      chml_cmplnc_rlvnce_ind as CHML_CMPLNC_RLVNCE_IND,
      logistical_mat_category as LOGISTICAL_MAT_CATEGORY,
      sales_material as SALES_MATERIAL,
      identification_tag_type as IDENTIFICATION_TAG_TYPE,
      sgt_csgr as SGT_CSGR,
      sgt_covsa as SGT_COVSA,
      sgt_stat as SGT_STAT,
      sgt_scope as SGT_SCOPE,
      sgt_rel as SGT_REL,
      anp as ANP,
      psm_code as PSM_CODE,
      fsh_mg_at1 as FSH_MG_AT1,
      fsh_mg_at2 as FSH_MG_AT2,
      fsh_mg_at3 as FSH_MG_AT3,
      fsh_sealv as FSH_SEALV,
      fsh_seaim as FSH_SEAIM,
      fsh_sc_mid as FSH_SC_MID,
      dummy_prd_incl_eew_ps as DUMMY_PRD_INCL_EEW_PS,
      scm_matid_guid16 as SCM_MATID_GUID16,
      scm_matid_guid22 as SCM_MATID_GUID22,
      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_puom as SCM_PUOM,
      rmatp_pb as RMATP_PB,
      prod_shape as PROD_SHAPE,
      mo_profile_id as MO_PROFILE_ID,
      overhang_tresh as OVERHANG_TRESH,
      bridge_tresh as BRIDGE_TRESH,
      bridge_max_slope as BRIDGE_MAX_SLOPE,
      height_nonflat as HEIGHT_NONFLAT,
      height_nonflat_uom as HEIGHT_NONFLAT_UOM,
      scm_kitcomp as SCM_KITCOMP,
      scm_prod_paoopt as SCM_PROD_PAOOPT,
      scm_bod_deplvl as SCM_BOD_DEPLVL,
      scm_restrict_invbal as SCM_RESTRICT_INVBAL,
      scm_drp_gl_stock as SCM_DRP_GL_STOCK,
      scm_excl_expedite as SCM_EXCL_EXPEDITE,
      /cwm/xcwmat as /CWM/XCWMAT,
      /cwm/valum as /CWM/VALUM,
      /cwm/tolgr as /CWM/TOLGR,
      /cwm/tara as /CWM/TARA,
      /cwm/tarum as /CWM/TARUM,
      /bev1/luleinh as /BEV1/LULEINH,
      /bev1/luldegrp as /BEV1/LULDEGRP,
      /bev1/nestruccat as /BEV1/NESTRUCCAT,
      /dsd/sl_toltyp as /DSD/SL_TOLTYP,
      /dsd/sv_cnt_grp as /DSD/SV_CNT_GRP,
      /sapmp/kadu as /SAPMP/KADU,
      /sapmp/abmein as /SAPMP/ABMEIN,
      /sapmp/kadp as /SAPMP/KADP,
      /sapmp/brad as /SAPMP/BRAD,
      /sapmp/spbi as /SAPMP/SPBI,
      /sapmp/trad as /SAPMP/TRAD,
      /sapmp/kedu as /SAPMP/KEDU,
      /sapmp/sptr as /SAPMP/SPTR,
      /sapmp/fbdk as /SAPMP/FBDK,
      /sapmp/fbhk as /SAPMP/FBHK,
      /sapmp/rili as /SAPMP/RILI,
      /sapmp/fbak as /SAPMP/FBAK,
      /sapmp/aho as /SAPMP/AHO,
      /sapmp/mifrr as /SAPMP/MIFRR,
      /vso/r_tilt_ind as /VSO/R_TILT_IND,
      /vso/r_stack_ind as /VSO/R_STACK_IND,
      /vso/r_bot_ind as /VSO/R_BOT_IND,
      /vso/r_top_ind as /VSO/R_TOP_IND,
      /vso/r_stack_no as /VSO/R_STACK_NO,
      /vso/r_pal_ind as /VSO/R_PAL_IND,
      /vso/r_pal_ovr_d as /VSO/R_PAL_OVR_D,
      /vso/r_pal_ovr_w as /VSO/R_PAL_OVR_W,
      /vso/r_pal_b_ht as /VSO/R_PAL_B_HT,
      /vso/r_pal_min_h as /VSO/R_PAL_MIN_H,
      /vso/r_tol_b_ht as /VSO/R_TOL_B_HT,
      /vso/r_no_p_gvh as /VSO/R_NO_P_GVH,
      /vso/r_quan_unit as /VSO/R_QUAN_UNIT,
      /vso/r_kzgvh_ind as /VSO/R_KZGVH_IND,
      packcode as PACKCODE,
      dg_pack_status as DG_PACK_STATUS,
      srv_dura as SRV_DURA,
      srv_dura_uom as SRV_DURA_UOM,
      srv_serwi as SRV_SERWI,
      srv_escal as SRV_ESCAL,
      som_cycle as SOM_CYCLE,
      som_cycle_rule as SOM_CYCLE_RULE,
      som_tc_schema as SOM_TC_SCHEMA,
      mcond as MCOND,
      retdelc as RETDELC,
      loglev_reto as LOGLEV_RETO,
      nsnid as NSNID,
      ovlpn as OVLPN,
      adspc_spc as ADSPC_SPC,
      varid as VARID,
      msbookpartno as MSBOOKPARTNO,
      dpcbt as DPCBT,
      xgrdt as XGRDT,
      imatn as IMATN,
      picnum as PICNUM,
      bstat as BSTAT,
      color_atinn as COLOR_ATINN,
      size1_atinn as SIZE1_ATINN,
      size2_atinn as SIZE2_ATINN,
      color as COLOR,
      size1 as SIZE1,
      size2 as SIZE2,
      free_char as FREE_CHAR,
      care_code as CARE_CODE, 
      brand_id as BRAND_ID,
      fiber_code1 as FIBER_CODE1,
      fiber_part1 as FIBER_PART1,
      fiber_code2 as FIBER_CODE2,
      fiber_part2 as FIBER_PART2,
      fiber_code3 as FIBER_CODE3,
      fiber_part3 as FIBER_PART3,
      fiber_code4 as FIBER_CODE4,
      fiber_part4 as FIBER_PART4,
      fiber_code5 as FIBER_CODE5,
      fiber_part5 as FIBER_PART5,
      fashgrd as FASHGRD
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/