Mbv_V_Ebew_Vbak

DDL: MBV_V_EBEW_VBAK SQL: MBVVEBEWVBAK Type: view

Compatibility view for V_EBEW_VBAK view (ML integration)

Mbv_V_Ebew_Vbak is a CDS View that provides data about "Compatibility view for V_EBEW_VBAK view (ML integration)" in SAP S/4HANA. It reads from 2 data sources (Mbv_Ebew, vbak) and exposes 17 fields.

Data Sources (2)

SourceAliasJoin Type
Mbv_Ebew Mbv_Ebew from
vbak vbak inner

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName MBVVEBEWVBAK view
EndUserText.label Compatibility view for V_EBEW_VBAK view (ML integration) view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (17)

KeyFieldSource TableSource FieldDescription
mandt Mbv_Ebew mandt Editing Client
matnr Mbv_Ebew matnr Vehicle Model
bwkey Mbv_Ebew bwkey Valuation Area
bwtar Mbv_Ebew bwtar Valuation Type
sobkz Mbv_Ebew sobkz Special Stock
vbeln Mbv_Ebew vbeln SD Sched. Agmt
posnr Mbv_Ebew posnr WBS Element
lbkum Mbv_Ebew lbkum Valuated stock
salk3 Mbv_Ebew salk3 Total Value
vprsv Mbv_Ebew vprsv Price control
verpr Mbv_Ebew verpr Moving price
stprs Mbv_Ebew stprs Standard price
peinh Mbv_Ebew peinh Unit of measure
bklas Mbv_Ebew bklas Valuation Class
salkv Mbv_Ebew salkv Value/MA price
bwtty Mbv_Ebew bwtty Valuation Cat.
kunnr vbak kunnr Stock customer

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 Mbv_V_Ebew_Vbak.
-- 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.
-- SQL view name: MBVVEBEWVBAK

CREATE VIEW Mbv_V_Ebew_Vbak AS
SELECT
  Mbv_Ebew.mandt AS mandt,
  Mbv_Ebew.matnr AS matnr,
  Mbv_Ebew.bwkey AS bwkey,
  Mbv_Ebew.bwtar AS bwtar,
  Mbv_Ebew.sobkz AS sobkz,
  Mbv_Ebew.vbeln AS vbeln,
  Mbv_Ebew.posnr AS posnr,
  Mbv_Ebew.lbkum AS lbkum,
  Mbv_Ebew.salk3 AS salk3,
  Mbv_Ebew.vprsv AS vprsv,
  Mbv_Ebew.verpr AS verpr,
  Mbv_Ebew.stprs AS stprs,
  Mbv_Ebew.peinh AS peinh,
  Mbv_Ebew.bklas AS bklas,
  Mbv_Ebew.salkv AS salkv,
  Mbv_Ebew.bwtty AS bwtty,
  vbak.kunnr AS kunnr
FROM Mbv_Ebew
INNER JOIN vbak ON /* join condition not captured in parsed metadata */
;