VC_INTEGRATION_VBAP

@AbapCatalog.sqlViewName: 'VCIVBAP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking 
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@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 VBAP'
define view VC_INTEGRATION_VBAP
  as select from vbap
{
      //vbap

  key vbeln as VBELN,
  key posnr as POSNR,
      matnr as MATNR,
      matwa as MATWA,
      pmatn as PMATN,
      charg as CHARG,
      matkl as MATKL,
      arktx as ARKTX,
      pstyv as PSTYV,
      posar as POSAR,
      process_code as PROCESS_CODE,
      lfrel as LFREL,
      fkrel as FKREL,
      uepos as UEPOS,
      grpos as GRPOS,
      abgru as ABGRU,
      prodh as PRODH,
      prodh_univ_sales_parnt_nodid as PRODH_UNIV_SALES_PARNT_NODID,
      prodh_univ_sales_det_origin as PRODH_UNIV_SALES_DET_ORIGIN,
      prodh_univ_batdet_parnt_nodid as PRODH_UNIV_BATDET_PARNT_NODID,
      prodh_univ_batdet_det_origin as PRODH_UNIV_BATDET_DET_ORIGIN,
      zwert as ZWERT,
      zmeng as ZMENG,
      zieme as ZIEME,
      umziz as UMZIZ,
      umzin as UMZIN,
      meins as MEINS,
      smeng as SMENG,
      ablfz as ABLFZ,
      abdat as ABDAT,
      absfz as ABSFZ,
      posex as POSEX,
      kdmat as KDMAT,
      kbver as KBVER,
      kever as KEVER,
      vkgru as VKGRU,
      vkaus as VKAUS,
      grkor as GRKOR,
      fmeng as FMENG,
      uebtk as UEBTK,
      uebto as UEBTO,
      untto as UNTTO,
      faksp as FAKSP,
      atpkz as ATPKZ,
      rkfkf as RKFKF,
      spart as SPART,
      gsber as GSBER,
      netwr as NETWR,
      waerk as WAERK,
      antlf as ANTLF,
      kztlf as KZTLF,
      chspl as CHSPL,
      kwmeng as KWMENG,
      lsmeng as LSMENG,
      kbmeng as KBMENG,
      klmeng as KLMENG,
      vrkme as VRKME,
      umvkz as UMVKZ,
      umvkn as UMVKN,
      brgew as BRGEW,
      ntgew as NTGEW,
      gewei as GEWEI,
      volum as VOLUM,
      voleh as VOLEH,
      vbelv as VBELV,
      posnv as POSNV,
      vgbel as VGBEL,
      vgpos as VGPOS,
      voref as VOREF,
      upflu as UPFLU,
      erlre as ERLRE,
      lprio as LPRIO,
      werks as WERKS,
      lgort as LGORT,
      vstel as VSTEL,
      route as ROUTE,
      stkey as STKEY,
      stdat as STDAT,
      stlnr as STLNR,
      stpos as STPOS,
      awahr as AWAHR,
      erdat as ERDAT,
      // ernam,

      erzet as ERZET,
      taxm1 as TAXM1,
      taxm2 as TAXM2,
      taxm3 as TAXM3,
      taxm4 as TAXM4,
      taxm5 as TAXM5,
      taxm6 as TAXM6,
      taxm7 as TAXM7,
      taxm8 as TAXM8,
      taxm9 as TAXM9,
      vbeaf as VBEAF,
      vbeav as VBEAV,
      vgref as VGREF,
      netpr as NETPR,
      kpein as KPEIN,
      kmein as KMEIN,
      shkzg as SHKZG,
      sktof as SKTOF,
      mtvfp as MTVFP,
      sumbd as SUMBD,
      kondm as KONDM,
      ktgrm as KTGRM,
      bonus as BONUS,
      provg as PROVG,
      eannr as EANNR,
      prsok as PRSOK,
      bwtar as BWTAR,
      bwtex as BWTEX,
      xchpf as XCHPF,
      xchar as XCHAR,
      lfmng as LFMNG,
      stafo as STAFO,
      wavwr as WAVWR,
      kzwi1 as KZWI1,
      kzwi2 as KZWI2,
      kzwi3 as KZWI3,
      kzwi4 as KZWI4,
      kzwi5 as KZWI5,
      kzwi6 as KZWI6,
      stcur as STCUR,
      aedat as AEDAT,
      ean11 as EAN11,
      fixmg as FIXMG,
      prctr as PRCTR,
      mvgr1 as MVGR1,
      mvgr2 as MVGR2,
      mvgr3 as MVGR3,
      mvgr4 as MVGR4,
      mvgr5 as MVGR5,
      kmpmg as KMPMG,
      sugrd as SUGRD,
      sobkz as SOBKZ,
      vpzuo as VPZUO,
      paobjnr as PAOBJNR,
      ps_psp_pnr as PS_PSP_PNR,
      aufnr as AUFNR,
      vpmat as VPMAT,
      vpwrk as VPWRK,
      prbme as PRBME,
      umref as UMREF,
      knttp as KNTTP,
      kzvbr as KZVBR,
      sernr as SERNR,
      objnr as OBJNR,
      abgrs as ABGRS,
      bedae as BEDAE,
      cmpre as CMPRE,
      cmtfg as CMTFG,
      cmpnt as CMPNT,
      cmkua as CMKUA,
      cuobj as CUOBJ,
      cuobj_ch as CUOBJ_CH,
      cepok as CEPOK,
      koupd as KOUPD,
      serail as SERAIL,
      anzsn as ANZSN,
      nachl as NACHL,
      magrv as MAGRV,
      mprok as MPROK,
      vgtyp as VGTYP,
      prosa as PROSA,
      uepvw as UEPVW,
      kalnr as KALNR,
      klvar as KLVAR,
      sposn as SPOSN,
      kowrr as KOWRR,
      stadat as STADAT,
      exart as EXART,
      prefe as PREFE,
      knumh as KNUMH,
      clint as CLINT,
      chmvs as CHMVS,
      stlty as STLTY,
      stlkn as STLKN,
      stpoz as STPOZ,
      stman as STMAN,
      zschl_k as ZSCHL_K,
      kalsm_k as KALSM_K,
      kalvar as KALVAR,
      kosch as KOSCH,
      upmat as UPMAT,
      ukonm as UKONM,
      mfrgr as MFRGR,
      plavo as PLAVO,
      kannr as KANNR,
      cmpre_flt as CMPRE_FLT,
      abfor as ABFOR,
      abges as ABGES,
      j_1bcfop as J_1BCFOP,
      j_1btaxlw1 as J_1BTAXLW1,
      j_1btaxlw2 as J_1BTAXLW2,
      j_1btxsdc as J_1BTXSDC,
      wktnr as WKTNR,
      wktps as WKTPS,
      skopf as SKOPF,
      kzbws as KZBWS,
      wgru1 as WGRU1,
      wgru2 as WGRU2,
      knuma_pi as KNUMA_PI,
      knuma_ag as KNUMA_AG,
      kzfme as KZFME,
      lstanr as LSTANR,
      techs as TECHS,
      mwsbp as MWSBP,
      berid as BERID,
      pctrf as PCTRF,
      logsys_ext as LOGSYS_EXT,
      j_1btaxlw3 as J_1BTAXLW3,
      j_1btaxlw4 as J_1BTAXLW4,
      j_1btaxlw5 as J_1BTAXLW5,
      stockloc as STOCKLOC,
      sloctype as SLOCTYPE,
      msr_ret_reason as MSR_RET_REASON,
      msr_refund_code as MSR_REFUND_CODE,
      msr_approv_block as MSR_APPROV_BLOCK,
      nrab_knumh as NRAB_KNUMH,
      trmrisk_relevant as TRMRISK_RELEVANT,
      sgt_rcat as SGT_RCAT,
      vbkd_posnr as VBKD_POSNR,
      veda_posnr as VEDA_POSNR,
      handoverloc as HANDOVERLOC,
      ext_ref_item_id as EXT_REF_ITEM_ID,
      handoverdate as HANDOVERDATE,
      handovertime as HANDOVERTIME,
      tc_aut_det as TC_AUT_DET,
      manual_tc_reason as MANUAL_TC_REASON,
      fiscal_incentive as FISCAL_INCENTIVE,
      tax_subject_st as TAX_SUBJECT_ST,
      fiscal_incentive_id as FISCAL_INCENTIVE_ID,
      spcsto as SPCSTO,
      revacc_refid as REVACC_REFID,
      revacc_reftype as REVACC_REFTYPE,
      _dataaging as _DATAAGING,
      absta as ABSTA,
      besta as BESTA,
      cmppi as CMPPI,
      cmppj as CMPPJ,
      costa as COSTA,
      dcsta as DCSTA,
      fksaa as FKSAA,
      fssta as FSSTA,
      gbsta as GBSTA,
      lfgsa as LFGSA,
      lfsta as LFSTA,
      lssta as LSSTA,
      manek as MANEK,
      rfgsa as RFGSA,
      rfsta as RFSTA,
      uvall as UVALL,
      uvfak as UVFAK,
      uvprs as UVPRS,
      uvvlk as UVVLK,
      uvp01 as UVP01,
      uvp02 as UVP02,
      uvp03 as UVP03,
      uvp04 as UVP04,
      uvp05 as UVP05,
      wbsta as WBSTA,
      emcst as EMCST,
      slcst as SLCST,
      total_lccst as TOTAL_LCCST,
      pcsta as PCSTA,
      dgsta as DGSTA,
      sdssta as SDSSTA,
      dp_clear_sta_itm as DP_CLEAR_STA_ITM,
      cmtd_deliv_date as CMTD_DELIV_DATE,
      cmtd_deliv_creadate as CMTD_DELIV_CREADATE,
      cmtd_deliv_qty_su as CMTD_DELIV_QTY_SU,
      reqqty_bu as REQQTY_BU,
      handle as HANDLE,
      pbs_state as PBS_STATE,
      ifrs15_relevance as IFRS15_RELEVANCE,
      ifrs15_total_ssp as IFRS15_TOTAL_SSP,
      revfp as REVFP,
      capped_net_amount as CAPPED_NET_AMOUNT,
      capped_net_amount_alert_thld as CAPPED_NET_AMOUNT_ALERT_THLD,
      cats_overtime_category as CATS_OVERTIME_CATEGORY,
      session_creation_date as SESSION_CREATION_DATE,
      session_creation_time as SESSION_CREATION_TIME,
      original_plant as ORIGINAL_PLANT,
      atp_abc_substitution_status as ATP_ABC_SUBSTITUTION_STATUS,
      dummy_slsdocitem_incl_eew_ps as DUMMY_SLSDOCITEM_INCL_EEW_PS,
      po_quan as PO_QUAN,
      po_unit as PO_UNIT,
      mill_se_gposn as MILL_SE_GPOSN,
      mill_batch_sel_f as MILL_BATCH_SEL_F,
      service_doc_type as SERVICE_DOC_TYPE,
      service_doc_id as SERVICE_DOC_ID,
      service_doc_item_id as SERVICE_DOC_ITEM_ID,
      cpd_updat as CPD_UPDAT,
      zapcgki as ZAPCGKI,
      apcgk_extendi as APCGK_EXTENDI,
      zabdati as ZABDATI,
      aufpl_olc as AUFPL_OLC,
      aplzl_olc as APLZL_OLC,
      ad01profnr as AD01PROFNR,
      admoi as ADMOI,
      adicc as ADICC,
      adpri as ADPRI,
      addns as ADDNS,
      adacn as ADACN,
      labsg as LABSG,
      fabsg as FABSG,
      pr_l_l as PR_L_L,
      pr_f_f as PR_F_F,
      pr_f_l as PR_F_L,
      ferc_ind as FERC_IND,
      fsh_season_year as FSH_SEASON_YEAR,
      fsh_season as FSH_SEASON,
      fsh_collection as FSH_COLLECTION,
      fsh_theme as FSH_THEME,
      fsh_crsd as FSH_CRSD,
      fsh_searef as FSH_SEAREF,
      fsh_candate as FSH_CANDATE,
      fsh_psm_pfm_split as FSH_PSM_PFM_SPLIT,
      fsh_vas_rel as FSH_VAS_REL,
      fsh_vas_prnt_id as FSH_VAS_PRNT_ID,
      fsh_transaction as FSH_TRANSACTION,
      fsh_item_group as FSH_ITEM_GROUP,
      fsh_item as FSH_ITEM,
      fsh_vasref as FSH_VASREF,
      fsh_grid_cond_rec as FSH_GRID_COND_REC,
      fsh_pqr_uepos as FSH_PQR_UEPOS,
      rfm_scc_indicator as RFM_SCC_INDICATOR,
      iuid_relevant as IUID_RELEVANT,
      equnr as EQUNR,
      eqart as EQART,
      j_3glvart as J_3GLVART,
      j_3gdatvo as J_3GDATVO,
      j_3gdatbi as J_3GDATBI,
      j_3gbelnri as J_3GBELNRI,
      j_3gposnri as J_3GPOSNRI,
      prs_objnr as PRS_OBJNR,
      prs_sd_spsnr as PRS_SD_SPSNR,
      prs_work_period as PRS_WORK_PERIOD,
      rfm_psst_rule as RFM_PSST_RULE,
      rfm_psst_group as RFM_PSST_GROUP,
      pargb as PARGB,
      aufpl_oaa as AUFPL_OAA,
      aplzl_oaa as APLZL_OAA,
      // vlcendcu,

      wrf_charstc1 as WRF_CHARSTC1,
      wrf_charstc2 as WRF_CHARSTC2,
      wrf_charstc3 as WRF_CHARSTC3,
      arsnum as ARSNUM,
      arspos as ARSPOS,
      wtysc_clmitem as WTYSC_CLMITEM
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VBAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/