V_VBUK_S4
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.
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- CDS View Annotations — A Complete Guide
- 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 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA