VC_INTEGRATION_KNVV

@AbapCatalog.sqlViewName: 'VCIKNVV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: ['CVP_XBLCK_V']
@ObjectModel.usageType.sizeCategory: #L
@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 KNVV'
define view VC_INTEGRATION_KNVV
  as select from knvv
{
      //knvv

  key kunnr as KUNNR,
  key vkorg as VKORG,
  key vtweg as VTWEG,
  key spart as SPART,
      // ernam,

      erdat as ERDAT,
      begru as BEGRU,
      loevm as LOEVM,
      versg as VERSG,
      aufsd as AUFSD,
      kalks as KALKS,
      kdgrp as KDGRP,
      bzirk as BZIRK,
      konda as KONDA,
      pltyp as PLTYP,
      awahr as AWAHR,
      inco1 as INCO1,
      inco2 as INCO2,
      lifsd as LIFSD,
      autlf as AUTLF,
      antlf as ANTLF,
      kztlf as KZTLF,
      kzazu as KZAZU,
      chspl as CHSPL,
      lprio as LPRIO,
      eikto as EIKTO,
      vsbed as VSBED,
      faksd as FAKSD,
      mrnkz as MRNKZ,
      perfk as PERFK,
      perrl as PERRL,
      kvakz as KVAKZ,
      kvawt as KVAWT,
      waers as WAERS,
      klabc as KLABC,
      ktgrd as KTGRD,
      zterm as ZTERM,
      vwerk as VWERK,
      vkgrp as VKGRP,
      vkbur as VKBUR,
      vsort as VSORT,
      kvgr1 as KVGR1,
      kvgr2 as KVGR2,
      kvgr3 as KVGR3,
      kvgr4 as KVGR4,
      kvgr5 as KVGR5,
      bokre as BOKRE,
      boidt as BOIDT,
      kurst as KURST,
      prfre as PRFRE,
      prat1 as PRAT1,
      prat2 as PRAT2,
      prat3 as PRAT3,
      prat4 as PRAT4,
      prat5 as PRAT5,
      prat6 as PRAT6,
      prat7 as PRAT7,
      prat8 as PRAT8,
      prat9 as PRAT9,
      prata as PRATA,
      kabss as KABSS,
      kkber as KKBER,
      cassd as CASSD,
      rdoff as RDOFF,
      agrel as AGREL,
      megru as MEGRU,
      uebto as UEBTO,
      untto as UNTTO,
      uebtk as UEBTK,
      pvksm as PVKSM,
      podkz as PODKZ,
      podtg as PODTG,
      blind as BLIND,
      carrier_notif as CARRIER_NOTIF,
      cvp_xblck_v as CVP_XBLCK_V,
      incov as INCOV,
      inco2_l as INCO2_L,
      inco3_l as INCO3_L,
      knvv_eew_contact as KNVV_EEW_CONTACT,
      status_obj_guid as STATUS_OBJ_GUID,
      billplan_proc as BILLPLAN_PROC,
      /bev1/emlgpfand as /BEV1/EMLGPFAND,
      /bev1/emlgforts as /BEV1/EMLGFORTS,
      j_1nboesl as J_1NBOESL,
      fsh_kvgr6 as FSH_KVGR6,
      fsh_kvgr7 as FSH_KVGR7,
      fsh_kvgr8 as FSH_KVGR8,
      fsh_kvgr9 as FSH_KVGR9,
      fsh_kvgr10 as FSH_KVGR10,
      fsh_grreg as FSH_GRREG,
      fsh_resgy as FSH_RESGY,
      fsh_sc_cid as FSH_SC_CID,
      fsh_vas_detc as FSH_VAS_DETC,
      fsh_vas_cg as FSH_VAS_CG,
      fsh_grsgy as FSH_GRSGY,
      fsh_ss as FSH_SS,
      fsh_frate as FSH_FRATE,
      fsh_frate_agg_level as FSH_FRATE_AGG_LEVEL,
      // fsh_msocdc,

      fsh_msopid as FSH_MSOPID,
      rfm_psst_rule as RFM_PSST_RULE,
      rfm_psst_exclude as RFM_PSST_EXCLUDE
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNVV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/