V_VBUK_S4

DDL: V_VBUK_S4 Type: view

Vbuk Cds View

V_VBUK_S4 is a CDS View that provides data about "Vbuk Cds View" in SAP S/4HANA. It reads from 3 data sources (likp, vbak, vbrk) and exposes 248 fields with key field vbeln.

Data Sources (3)

SourceAliasJoin Type
likp likp union_all
vbak vbak from
vbrk vbrk union_all

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName V_VBUK_CDS view
AbapCatalog.preserveKey true view
EndUserText.label Vbuk Cds View view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (248)

KeyFieldSource TableSource FieldDescription
KEY vbeln vbeln SD Sched. Agmt
rfstk rfstk Reference Sts
rfgsk rfgsk Ovrl Ref. Sts
bestk bestk Deliv. Conf.Sts
lfstk lfstk Delivery Status
lfgsk lfgsk Ovrl Deliv. Sts
wbstk Goods Mvmnt Sts
fkstk Del.Rel.BillgSt
fksak fksak Ord.Rel.BillgSt
buchk Posting Status
abstk abstk Rejection Sts
gbstk gbstk Overall Status
kostk Picking Status
kostk_wh Picking Status
lvstk WM Activity Sts
uvals uvals All Items
uvvls uvvls Deliv–All Itms
uvfas uvfas Billg–All Items
uvall uvall Overall Header
uvvlk uvvlk Delivery – Item
uvfak uvfak Billing Doc.
uvprs uvprs Pricing – Item
vbtyp vbtyp TSW Det.Doc typ
vbobj
aedat
fkivk Intco Bllg Sts
relik Inv.List Status
uvk01 uvk01 Hdr reserves 1
uvk02 uvk02 Hdr reserves 2
uvk03 uvk03 Hdr reserves 3
uvk04 uvk04 Hdr reserves 4
uvk05 uvk05 Hdr reserves 5
uvs01 uvs01 Total reserves1
uvs02 uvs02 TotalReserves2
uvs03 uvs03 Total reserves3
uvs04 uvs04 Total reserves4
uvs05 uvs05 Total reserves5
pkstk Packing Status
cmpsa
cmpsb
cmpsc cmpsc Value
cmpsd cmpsd TermsOfPayment
cmpse
cmpsf
cmpsg
cmpsh
cmpsi cmpsi Financial Doc.
cmpsj cmpsj ExptCreditInsur
cmpsk cmpsk Payment Card
cmpsl
cmps0
cmps1
cmps2
cmgst cmgst OverallCredStat
trsta trsta Transp.Plng Sts
koquk Confirmation
costa costa Purg Conf. Sts
saprl
uvpas Packing – Items
uvpis Picking/Ptwy – Items
uvwas GdsMvt–All Itms
uvpak Packing – Item
uvpik Picking/Putaway–Item
uvwak GoodsMvt–Header
uvgek
cmpsm
dcstk
vestk HU in Stock
vlstk StatDecntrlWhse
rrsta
block
fsstk fsstk Billg Block Sts
lsstk lsstk OvrlDelivBlkSts
spstg spstg Ovrl Block Sts
pdstk POD Status
fmstk fmstk Status Funds Mgmt
manek manek Manual Completion
spe_tmpid Temp
hdall Hold
hdals PHold
cmps_cm cmps_cm SAP Cred. Mgmt
cmps_te cmps_te CrMa TE Status
vbtyp_ext
rfstk Reference Sts
rfgsk Ovrl Ref. Sts
bestk bestk Deliv. Conf.Sts
lfstk Delivery Status
lfgsk Ovrl Deliv. Sts
wbstk wbstk Goods Mvmnt Sts
fkstk fkstk Del.Rel.BillgSt
fksak Ord.Rel.BillgSt
buchk Posting Status
abstk Rejection Sts
gbstk gbstk Overall Status
kostk kostk Picking Status
kostk_wh kostk_wh Picking Status
lvstk lvstk WM Activity Sts
uvals uvals All Items
uvvls uvvls Deliv–All Itms
uvfas uvfas Billg–All Items
uvall uvall Overall Header
uvvlk uvvlk Delivery – Item
uvfak uvfak Billing Doc.
uvprs Pricing – Item
vbtyp vbtyp TSW Det.Doc typ
vbobj
aedat
fkivk fkivk Intco Bllg Sts
relik Inv.List Status
uvk01 uvk01 Hdr reserves 1
uvk02 uvk02 Hdr reserves 2
uvk03 uvk03 Hdr reserves 3
uvk04 uvk04 Hdr reserves 4
uvk05 uvk05 Hdr reserves 5
uvs01 uvs01 Total reserves1
uvs02 uvs02 TotalReserves2
uvs03 uvs03 Total reserves3
uvs04 uvs04 Total reserves4
uvs05 uvs05 Total reserves5
pkstk pkstk Packing Status
cmpsa
cmpsb
cmpsc cmpsc Value
cmpsd cmpsd TermsOfPayment
cmpse
cmpsf
cmpsg
cmpsh
cmpsi cmpsi Financial Doc.
cmpsj cmpsj ExptCreditInsur
cmpsk cmpsk Payment Card
cmpsl
cmps0
cmps1
cmps2
cmgst cmgst OverallCredStat
trsta trsta Transp.Plng Sts
koquk koquk Confirmation
costa Purg Conf. Sts
saprl
uvpas uvpas Packing – Items
uvpis uvpis Picking/Ptwy – Items
uvwas uvwas GdsMvt–All Itms
uvpak uvpak Packing – Item
uvpik uvpik Picking/Putaway–Item
uvwak uvwak GoodsMvt–Header
uvgek
cmpsm
dcstk
vestk vestk HU in Stock
vlstk vlstk StatDecntrlWhse
rrsta
block
fsstk Billg Block Sts
lsstk OvrlDelivBlkSts
spstg spstg Ovrl Block Sts
pdstk pdstk POD Status
fmstk Status Funds Mgmt
manek Manual Completion
spe_tmpid spe_tmpid Temp
hdall hdall Hold
hdals hdals PHold
cmps_cm cmps_cm SAP Cred. Mgmt
cmps_te cmps_te CrMa TE Status
vbtyp_ext
rfstk Reference Sts
rfgsk Ovrl Ref. Sts
bestk Deliv. Conf.Sts
lfstk Delivery Status
lfgsk Ovrl Deliv. Sts
wbstk Goods Mvmnt Sts
fkstk Del.Rel.BillgSt
fksak Ord.Rel.BillgSt
buchk buchk Posting Status
abstk Rejection Sts
gbstk gbstk Overall Status
kostk Picking Status
kostk_wh Picking Status
lvstk WM Activity Sts
uvals uvals All Items
uvvls Deliv–All Itms
uvfas Billg–All Items
uvall Overall Header
uvvlk Delivery – Item
uvfak Billing Doc.
uvprs uvprs Pricing – Item
vbtyp vbtyp TSW Det.Doc typ
vbobj
aedat
fkivk Intco Bllg Sts
relik relik Inv.List Status
uvk01 Hdr reserves 1
uvk02 Hdr reserves 2
uvk03 Hdr reserves 3
uvk04 Hdr reserves 4
uvk05 Hdr reserves 5
uvs01 Total reserves1
uvs02 TotalReserves2
uvs03 Total reserves3
uvs04 Total reserves4
uvs05 Total reserves5
pkstk Packing Status
cmpsa
cmpsb
cmpsc Value
cmpsd TermsOfPayment
cmpse
cmpsf
cmpsg
cmpsh
cmpsi Financial Doc.
cmpsj ExptCreditInsur
cmpsk Payment Card
cmpsl
cmps0
cmps1
cmps2
cmgst OverallCredStat
trsta Transp.Plng Sts
koquk Confirmation
costa Purg Conf. Sts
saprl
uvpas Packing – Items
uvpis Picking/Ptwy – Items
uvwas GdsMvt–All Itms
uvpak Packing – Item
uvpik Picking/Putaway–Item
uvwak GoodsMvt–Header
uvgek
cmpsm
dcstk
vestk HU in Stock
vlstk StatDecntrlWhse
rrsta
block
fsstk Billg Block Sts
lsstk OvrlDelivBlkSts
spstg Ovrl Block Sts
pdstk POD Status
fmstk Status Funds Mgmt
manek Manual Completion
spe_tmpid Temp
hdall Hold
hdals PHold
cmps_cm SAP Cred. Mgmt
cmps_te CrMa TE Status
vbtyp_ext
/sapmp/lbask

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view V_VBUK_S4.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW V_VBUK_S4 AS
SELECT
  vbeln,
  rfstk,
  rfgsk,
  bestk,
  lfstk,
  lfgsk,
  '' AS wbstk,
  '' AS fkstk,
  fksak,
  '' AS buchk,
  abstk,
  gbstk,
  '' AS kostk,
  '' AS kostk_wh,
  '' AS lvstk,
  uvals,
  uvvls,
  uvfas,
  uvall,
  uvvlk,
  uvfak,
  uvprs,
  vbtyp,
  'A' AS vbobj,
  cast ( '' as abap.dats(8)) AS aedat,
  '' AS fkivk,
  '' AS relik,
  uvk01,
  uvk02,
  uvk03,
  uvk04,
  uvk05,
  uvs01,
  uvs02,
  uvs03,
  uvs04,
  uvs05,
  '' AS pkstk,
  '' AS cmpsa,
  '' AS cmpsb,
  cmpsc,
  cmpsd,
  '' AS cmpse,
  '' AS cmpsf,
  '' AS cmpsg,
  '' AS cmpsh,
  cmpsi,
  cmpsj,
  cmpsk,
  '' AS cmpsl,
  '' AS cmps0,
  '' AS cmps1,
  '' AS cmps2,
  cmgst,
  trsta,
  '' AS koquk,
  costa,
  '' AS saprl,
  '' AS uvpas,
  '' AS uvpis,
  '' AS uvwas,
  '' AS uvpak,
  '' AS uvpik,
  '' AS uvwak,
  '' AS uvgek,
  '' AS cmpsm,
  '' AS dcstk,
  '' AS vestk,
  '' AS vlstk,
  '' AS rrsta,
  '' AS block,
  fsstk,
  lsstk,
  spstg,
  '' AS pdstk,
  fmstk,
  manek,
  '' AS spe_tmpid,
  '' AS hdall,
  '' AS hdals,
  cmps_cm,
  cmps_te,
  '' AS vbtyp_ext,
  '' AS /sapmp/lbask
FROM vbak
-- UNION ALL with additional select branch(es): likp, vbrk
;