VC_INTEGRATION_VBAK

DDL: VC_INTEGRATION_VBAK SQL: VCIVBAK Type: view Package: IPS_DATA_REPLICATION

Extraction for VBAK

VC_INTEGRATION_VBAK is a CDS View that provides data about "Extraction for VBAK" in SAP S/4HANA. It reads from 1 data source (vbak) and exposes 195 fields with key field VBELN. Part of development package IPS_DATA_REPLICATION.

Data Sources (1)

SourceAliasJoin Type
vbak vbak from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName VCIVBAK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
EndUserText.label Extraction for VBAK view

Fields (195)

KeyFieldSource TableSource FieldDescription
KEY VBELN vbeln
ERDAT erdat
ERZET erzet
ANGDT angdt
BNDDT bnddt
AUDAT audat
VBTYP vbtyp
TRVOG trvog
AUART auart
AUGRU augru
GWLDT gwldt
SUBMI submi
LIFSK lifsk
FAKSK faksk
NETWR netwr
WAERK waerk
VKORG vkorg
VTWEG vtweg
SPART spart
VKGRP vkgrp
VKBUR vkbur
GSBER gsber
GSKST gskst
GUEBG guebg
GUEEN gueen
KNUMV knumv
VDATU vdatu
VPRGR vprgr
AUTLF autlf
VBKLA vbkla
VBKLT vbklt
KALSM kalsm
VSBED vsbed
FKARA fkara
AWAHR awahr
KTEXT ktext
BSTNK bstnk
BSARK bsark
BSTDK bstdk
BSTZD bstzd
IHREZ ihrez
MAHZA mahza
MAHDT mahdt
KUNNR kunnr
KOSTL kostl
STAFO stafo
STWAE stwae
AEDAT aedat
KVGR1 kvgr1
KVGR2 kvgr2
KVGR3 kvgr3
KVGR4 kvgr4
KVGR5 kvgr5
KNUMA knuma
KOKRS kokrs
PS_PSP_PNR ps_psp_pnr
KURST kurst
KKBER kkber
GRUPP grupp
SBGRP sbgrp
CTLPC ctlpc
CMWAE cmwae
CMFRE cmfre
CMNUP cmnup
CMNGV cmngv
AMTBL amtbl
HITYP_PR hityp_pr
ABRVW abrvw
ABDIS abdis
VGBEL vgbel
OBJNR objnr
BUKRS_VF bukrs_vf
TAXK1 taxk1
TAXK2 taxk2
TAXK3 taxk3
TAXK4 taxk4
TAXK5 taxk5
TAXK6 taxk6
TAXK7 taxk7
TAXK8 taxk8
TAXK9 taxk9
XBLNR xblnr
ZUONR zuonr
VGTYP vgtyp
KALSM_CH kalsm_ch
AGRZR agrzr
AUFNR aufnr
QMNUM qmnum
VBELN_GRP vbeln_grp
SCHEME_GRP scheme_grp
ABRUF_PART abruf_part
ABHOD abhod
ABHOV abhov
ABHOB abhob
RPLNR rplnr
VZEIT vzeit
STCEG_L stceg_l
LANDTX landtx
XEGDR xegdr
ENQUEUE_GRP enqueue_grp
DAT_FZAU dat_fzau
FMBDAT fmbdat
VSNMR_V vsnmr_v
HANDLE handle
PROLI proli
CONT_DG cont_dg
CRM_GUID crm_guid
UPD_TMSTMP upd_tmstmp
MSR_ID msr_id
TM_CTRL_KEY tm_ctrl_key
OIPBL oipbl
HANDOVERLOC handoverloc
EXT_BUS_SYST_ID ext_bus_syst_id
EXT_REF_DOC_ID ext_ref_doc_id
EXT_REV_TMSTMP ext_rev_tmstmp
APM_APPROVAL_STATUS apm_approval_status
APM_APPROVAL_REASON apm_approval_reason
APM_REJECTION_REASON apm_rejection_reason
_DATAAGING _dataaging
ABSTK abstk
BESTK bestk
CMPSC cmpsc
CMPSD cmpsd
CMPSI cmpsi
CMPSJ cmpsj
CMPSK cmpsk
CMPS_CM cmps_cm
CMPS_TE cmps_te
CMGST cmgst
COSTA costa
DCSTK dcstk
FKSAK fksak
FMSTK fmstk
FSSTK fsstk
GBSTK gbstk
LFGSK lfgsk
LFSTK lfstk
LSSTK lsstk
MANEK manek
RFGSK rfgsk
RFSTK rfstk
SPSTG spstg
TRSTA trsta
UVALL uvall
UVALS uvals
UVFAK uvfak
UVFAS uvfas
UVPRS uvprs
UVVLK uvvlk
UVVLS uvvls
UVK01 uvk01
UVK02 uvk02
UVK03 uvk03
UVK04 uvk04
UVK05 uvk05
UVS01 uvs01
UVS02 uvs02
UVS03 uvs03
UVS04 uvs04
UVS05 uvs05
WBSTK wbstk
TOTAL_EMCST total_emcst
TOTAL_SLCST total_slcst
TOTAL_LCCST total_lccst
TOTAL_PCSTA total_pcsta
TOTAL_DGSTA total_dgsta
TOTAL_SDSSTA total_sdssta
DP_CLEAR_STA_HDR dp_clear_sta_hdr
ZAPCGKH zapcgkh
APCGK_EXTENDH apcgk_extendh
ZABDATH zabdath
AD01FAREG ad01fareg
AD01BASDOC ad01basdoc
LASTVCHR lastvchr
PSM_BUDAT psm_budat
FSH_KVGR6 fsh_kvgr6
FSH_KVGR7 fsh_kvgr7
FSH_KVGR8 fsh_kvgr8
FSH_KVGR9 fsh_kvgr9
FSH_KVGR10 fsh_kvgr10
FSH_REREG fsh_rereg
FSH_CQ_CHECK fsh_cq_check
FSH_VRSN_STATUS fsh_vrsn_status
FSH_TRANSACTION fsh_transaction
FSH_VAS_CG fsh_vas_cg
FSH_CANDATE fsh_candate
FSH_SS fsh_ss
FSH_OS_STG_CHANGE fsh_os_stg_change
J_3GKBAUL j_3gkbaul
MILL_APPL_ID mill_appl_id
LOGSYSB logsysb
KALCD kalcd
MULTI multi
SPPAYM sppaym
WTYSC_CLM_HDR wtysc_clm_hdr
@AbapCatalog.sqlViewName: 'VCIVBAK'
@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 VBAK'
define view VC_INTEGRATION_VBAK
  as select from vbak
{ //vbak

  key vbeln as VBELN,
      erdat as ERDAT,
      erzet as ERZET,
      // ernam,

      angdt as ANGDT,
      bnddt as BNDDT,
      audat as AUDAT,
      vbtyp as VBTYP,
      trvog as TRVOG,
      auart as AUART,
      augru as AUGRU,
      gwldt as GWLDT,
      submi as SUBMI,
      lifsk as LIFSK,
      faksk as FAKSK,
      netwr as NETWR,
      waerk as WAERK,
      vkorg as VKORG,
      vtweg as VTWEG,
      spart as SPART,
      vkgrp as VKGRP,
      vkbur as VKBUR,
      gsber as GSBER,
      gskst as GSKST,
      guebg as GUEBG,
      gueen as GUEEN,
      knumv as KNUMV,
      vdatu as VDATU,
      vprgr as VPRGR,
      autlf as AUTLF,
      vbkla as VBKLA,
      vbklt as VBKLT,
      kalsm as KALSM,
      vsbed as VSBED,
      fkara as FKARA,
      awahr as AWAHR,
      ktext as KTEXT,
      bstnk as BSTNK,
      bsark as BSARK,
      bstdk as BSTDK,
      bstzd as BSTZD,
      ihrez as IHREZ,
      // bname,

      // telf1,

      mahza as MAHZA,
      mahdt as MAHDT,
      kunnr as KUNNR,
      kostl as KOSTL,
      stafo as STAFO,
      stwae as STWAE,
      aedat as AEDAT,
      kvgr1 as KVGR1,
      kvgr2 as KVGR2,
      kvgr3 as KVGR3,
      kvgr4 as KVGR4,
      kvgr5 as KVGR5,
      knuma as KNUMA,
      kokrs as KOKRS,
      ps_psp_pnr as PS_PSP_PNR,
      kurst as KURST,
      kkber as KKBER,
      // knkli,

      grupp as GRUPP,
      sbgrp as SBGRP,
      ctlpc as CTLPC,
      cmwae as CMWAE,
      cmfre as CMFRE,
      cmnup as CMNUP,
      cmngv as CMNGV,
      amtbl as AMTBL,
      hityp_pr as HITYP_PR,
      abrvw as ABRVW,
      abdis as ABDIS,
      vgbel as VGBEL,
      objnr as OBJNR,
      bukrs_vf as BUKRS_VF,
      taxk1 as TAXK1,
      taxk2 as TAXK2,
      taxk3 as TAXK3,
      taxk4 as TAXK4,
      taxk5 as TAXK5,
      taxk6 as TAXK6,
      taxk7 as TAXK7,
      taxk8 as TAXK8,
      taxk9 as TAXK9,
      xblnr as XBLNR,
      zuonr as ZUONR,
      vgtyp as VGTYP,
      kalsm_ch as KALSM_CH,
      agrzr as AGRZR,
      aufnr as AUFNR,
      qmnum as QMNUM,
      vbeln_grp as VBELN_GRP,
      scheme_grp as SCHEME_GRP,
      abruf_part as ABRUF_PART,
      abhod as ABHOD,
      abhov as ABHOV,
      abhob as ABHOB,
      rplnr as RPLNR,
      vzeit as VZEIT,
      stceg_l as STCEG_L,
      landtx as LANDTX,
      xegdr as XEGDR,
      enqueue_grp as ENQUEUE_GRP,
      dat_fzau as DAT_FZAU,
      fmbdat as FMBDAT,
      vsnmr_v as VSNMR_V,
      handle as HANDLE,
      proli as PROLI,
      cont_dg as CONT_DG,
      crm_guid as CRM_GUID,
      upd_tmstmp as UPD_TMSTMP,
      msr_id as MSR_ID,
      tm_ctrl_key as TM_CTRL_KEY,
      oipbl as OIPBL,
      // last_changed_by_user,

      handoverloc as HANDOVERLOC,
      ext_bus_syst_id as EXT_BUS_SYST_ID,
      ext_ref_doc_id as EXT_REF_DOC_ID,
      ext_rev_tmstmp as EXT_REV_TMSTMP,
      apm_approval_status as APM_APPROVAL_STATUS,
      apm_approval_reason as APM_APPROVAL_REASON,
      apm_rejection_reason as APM_REJECTION_REASON,
      _dataaging as _DATAAGING,
      abstk as ABSTK,
      bestk as BESTK,
      cmpsc as CMPSC,
      cmpsd as CMPSD,
      cmpsi as CMPSI,
      cmpsj as CMPSJ,
      cmpsk as CMPSK,
      cmps_cm as CMPS_CM,
      cmps_te as CMPS_TE,
      cmgst as CMGST,
      costa as COSTA,
      dcstk as DCSTK,
      fksak as FKSAK,
      fmstk as FMSTK,
      fsstk as FSSTK,
      gbstk as GBSTK,
      lfgsk as LFGSK,
      lfstk as LFSTK,
      lsstk as LSSTK,
      manek as MANEK,
      rfgsk as RFGSK,
      rfstk as RFSTK,
      spstg as SPSTG,
      trsta as TRSTA,
      uvall as UVALL,
      uvals as UVALS,
      uvfak as UVFAK,
      uvfas as UVFAS,
      uvprs as UVPRS,
      uvvlk as UVVLK,
      uvvls as UVVLS,
      uvk01 as UVK01,
      uvk02 as UVK02,
      uvk03 as UVK03,
      uvk04 as UVK04,
      uvk05 as UVK05,
      uvs01 as UVS01,
      uvs02 as UVS02,
      uvs03 as UVS03,
      uvs04 as UVS04,
      uvs05 as UVS05,
      wbstk as WBSTK,
      total_emcst as TOTAL_EMCST,
      total_slcst as TOTAL_SLCST,
      total_lccst as TOTAL_LCCST,
      total_pcsta as TOTAL_PCSTA,
      total_dgsta as TOTAL_DGSTA,
      total_sdssta as TOTAL_SDSSTA,
      dp_clear_sta_hdr as DP_CLEAR_STA_HDR,
      // dummy_salesdoc_incl_eew_ps,

      zapcgkh as ZAPCGKH,
      apcgk_extendh as APCGK_EXTENDH,
      zabdath as ZABDATH,
      ad01fareg as AD01FAREG,
      ad01basdoc as AD01BASDOC,
      lastvchr as LASTVCHR,
      psm_budat as PSM_BUDAT,
      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_rereg as FSH_REREG,
      fsh_cq_check as FSH_CQ_CHECK,
      fsh_vrsn_status as FSH_VRSN_STATUS,
      fsh_transaction as FSH_TRANSACTION,
      fsh_vas_cg as FSH_VAS_CG,
      fsh_candate as FSH_CANDATE,
      fsh_ss as FSH_SS,
      fsh_os_stg_change as FSH_OS_STG_CHANGE,
      j_3gkbaul as J_3GKBAUL,
      mill_appl_id as MILL_APPL_ID,
      logsysb as LOGSYSB,
      kalcd as KALCD,
      multi as MULTI,
      sppaym as SPPAYM,
      wtysc_clm_hdr as WTYSC_CLM_HDR
}