VC_INTEGRATION_KNA1

@AbapCatalog.sqlViewName: 'VCIKNA1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: ['CVP_XBLCK']
@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 KNA1'
define view VC_INTEGRATION_KNA1
  as select from kna1
{
      //KNA1

  key kunnr as KUNNR,
      land1 as LAND1,
      // name1,

      // name2,

      // ort01,

      // pstlz,

      regio as REGIO,
      sortl as SORTL,
      // stras,

      // telf1,

      // telfx,

      xcpdk as XCPDK,
      // adrnr,

      // mcod1 as MCOD1,

      // mcod2 as MCOD2,

      // mcod3 as MCOD3,

      anred as ANRED,
      aufsd as AUFSD,
      bahne as BAHNE,
      bahns as BAHNS,
      bbbnr as BBBNR,
      bbsnr as BBSNR,
      begru as BEGRU,
      brsch as BRSCH,
      bubkz as BUBKZ,
      datlt as DATLT,
      erdat as ERDAT,
      // ernam,

      exabl as EXABL,
      faksd as FAKSD,
      // fiskn,

      knazk as KNAZK,
      // knrza,

      konzs as KONZS,
      ktokd as KTOKD,
      kukla as KUKLA,
      // lifnr,

      lifsd as LIFSD,
      locco as LOCCO,
      loevm as LOEVM,
      // name3 as NAME3,

      // name4 as NAME4,

      niels as NIELS,
      // ort02,

      // pfach,

      // pstl2,

      counc as COUNC,
      cityc as CITYC,
      rpmkr as RPMKR,
      sperr as SPERR,
      spras as SPRAS,
      // stcd1,

      // stcd2,

      stkza as STKZA,
      stkzu as STKZU,
      telbx as TELBX,
      telf2 as TELF2,
      teltx as TELTX,
      telx1 as TELX1,
      lzone as LZONE,
      xzemp as XZEMP,
      vbund as VBUND,
      // stceg,

      dear1 as DEAR1,
      dear2 as DEAR2,
      dear3 as DEAR3,
      dear4 as DEAR4,
      dear5 as DEAR5,
      gform as GFORM,
      bran1 as BRAN1,
      bran2 as BRAN2,
      bran3 as BRAN3,
      bran4 as BRAN4,
      bran5 as BRAN5,
      ekont as EKONT,
      umsat as UMSAT,
      umjah as UMJAH,
      uwaer as UWAER,
      jmzah as JMZAH,
      jmjah as JMJAH,
      katr1 as KATR1,
      katr2 as KATR2,
      katr3 as KATR3,
      katr4 as KATR4,
      katr5 as KATR5,
      katr6 as KATR6,
      katr7 as KATR7,
      katr8 as KATR8,
      katr9 as KATR9,
      katr10 as KATR10,
      stkzn as STKZN,
      umsa1 as UMSA1,
      // txjcd as TXJCD,

      periv as PERIV,
      abrvw as ABRVW,
      inspbydebi as INSPBYDEBI,
      inspatdebi as INSPATDEBI,
      ktocd as KTOCD,
      pfort as PFORT,
      werks as WERKS,
      dtams as DTAMS,
      dtaws as DTAWS,
      duefl as DUEFL,
      hzuor as HZUOR,
      sperz as SPERZ,
      etikg as ETIKG,
      civve as CIVVE,
      milve as MILVE,
      kdkg1 as KDKG1,
      kdkg2 as KDKG2,
      kdkg3 as KDKG3,
      kdkg4 as KDKG4,
      kdkg5 as KDKG5,
      xknza as XKNZA,
      fityp as FITYP,
      stcdt as STCDT,
      stcd3 as STCD3,
      stcd4 as STCD4,
      stcd5 as STCD5,
      xicms as XICMS,
      xxipi as XXIPI,
      xsubt as XSUBT,
      cfopc as CFOPC,
      txlw1 as TXLW1,
      txlw2 as TXLW2,
      ccc01 as CCC01,
      ccc02 as CCC02,
      ccc03 as CCC03,
      ccc04 as CCC04,
      bonded_area_confirm as BONDED_AREA_CONFIRM,
      donate_mark as DONATE_MARK,
      cassd as CASSD,
      // knurl as KNURL,

      // j_1kfrepre,

      j_1kftbus as J_1KFTBUS,
      j_1kftind as J_1KFTIND,
      confs as CONFS,
      updat as UPDAT,
      uptim as UPTIM,
      nodel as NODEL,
      dear6 as DEAR6,
      cvp_xblck as CVP_XBLCK,
      suframa as SUFRAMA,
      rg as RG,
      exp as EXP,
      uf as UF,
      rgdate as RGDATE,
      ric as RIC,
      rne as RNE,
      rnedate as RNEDATE,
      cnae as CNAE,
      legalnat as LEGALNAT,
      crtn as CRTN,
      icmstaxpay as ICMSTAXPAY,
      indtyp as INDTYP,
      tdt as TDT,
      comsize as COMSIZE,
      decregpc as DECREGPC,
      kna1_eew_cust as KNA1_EEW_CUST,
      rule_exclusion as RULE_EXCLUSION,
      /vso/r_palhgt as /VSO/R_PALHGT,
      /vso/r_pal_ul as /VSO/R_PAL_UL,
      /vso/r_pk_mat as /VSO/R_PK_MAT,
      /vso/r_matpal as /VSO/R_MATPAL,
      /vso/r_i_no_lyr as /VSO/R_I_NO_LYR,
      /vso/r_one_mat as /VSO/R_ONE_MAT,
      /vso/r_one_sort as /VSO/R_ONE_SORT,
      /vso/r_uld_side as /VSO/R_ULD_SIDE,
      /vso/r_load_pref as /VSO/R_LOAD_PREF,
      /vso/r_dpoint as /VSO/R_DPOINT,
      j_1iexcd as J_1IEXCD,
      j_1iexrn as J_1IEXRN,
      j_1iexrg as J_1IEXRG,
      j_1iexdi as J_1IEXDI,
      j_1iexco as J_1IEXCO,
      j_1icstno as J_1ICSTNO,
      j_1ilstno as J_1ILSTNO,
      j_1ipanno as J_1IPANNO,
      j_1iexcicu as J_1IEXCICU,
      aedat as AEDAT,
      usnam as USNAM,
      j_1isern as J_1ISERN,
      j_1ipanref as J_1IPANREF,
      j_3getyp as J_3GETYP,
      j_3greftyp as J_3GREFTYP,
      pspnr as PSPNR,
      coaufnr as COAUFNR,
      // j_3gagext,

      // j_3gagint,

      // j_3gagdumi,

      // j_3gagstdi,

      lgort as LGORT,
      kokrs as KOKRS,
      kostl as KOSTL,
      j_3gabglg as J_3GABGLG,
      j_3gabgvg as J_3GABGVG,
      j_3gabrart as J_3GABRART,
      j_3gstdmon as J_3GSTDMON,
      j_3gstdtag as J_3GSTDTAG,
      j_3gtagmon as J_3GTAGMON,
      j_3gzugtag as J_3GZUGTAG,
      j_3gmaschb as J_3GMASCHB,
      j_3gmeinsa as J_3GMEINSA,
      j_3gkeinsa as J_3GKEINSA,
      j_3gblsper as J_3GBLSPER,
      j_3gkleivo as J_3GKLEIVO,
      j_3gcalid as J_3GCALID,
      j_3gvmonat as J_3GVMONAT,
      j_3gabrken as J_3GABRKEN,
      j_3glabrech as J_3GLABRECH,
      j_3gaabrech as J_3GAABRECH,
      j_3gzutvhlg as J_3GZUTVHLG,
      j_3gnegmen as J_3GNEGMEN,
      j_3gfristlo as J_3GFRISTLO,
      j_3geminbe as J_3GEMINBE,
      j_3gfmgue as J_3GFMGUE,
      j_3gzuschue as J_3GZUSCHUE,
      j_3gschprs as J_3GSCHPRS,
      j_3ginvsta as J_3GINVSTA,
      /sapcem/dber as /SAPCEM/DBER,
      /sapcem/kvmeq as /SAPCEM/KVMEQ
}