VC_INTEGRATION_VBAK
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)
| Source | Alias | Join Type |
|---|---|---|
| vbak | vbak | from |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA