Mbv_Ebewh

DDL: MBV_EBEWH SQL: MBVEBEWH Type: view
15 Fields 2 Data Sources

Compatibility view for EBEWH table

Mbv_Ebewh is a CDS View that provides data about "Compatibility view for EBEWH table" in SAP S/4HANA. It reads from 2 data sources (V_ML_ACDOC_EX_AG_DDL, EBEWHJoinEBEW) and exposes 15 fields with key fields mandt, matnr, bwkey, bwtar, sobkz.

Data Sources (2)

SourceAliasJoin Type
V_ML_ACDOC_EX_AG_DDL ext left_outer
EBEWHJoinEBEW h from

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName MBVEBEWH view
EndUserText.label Compatibility view for EBEWH table view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY mandt EBEWHJoinEBEW mandt Editing Client
KEY matnr EBEWHJoinEBEW matnr Vehicle Model
KEY bwkey EBEWHJoinEBEW bwkey Valuation Area
KEY bwtar EBEWHJoinEBEW bwtar Valuation Type
KEY sobkz EBEWHJoinEBEW sobkz Special Stock
KEY vbeln EBEWHJoinEBEW vbeln SD Sched. Agmt
KEY posnr EBEWHJoinEBEW posnr WBS Element
KEY lfgja EBEWHJoinEBEW lfgja Year Cur.Period
KEY lfmon EBEWHJoinEBEW lfmon Current Period
vprsv EBEWHJoinEBEW vprsv Price control
verpr EBEWHJoinEBEW verpr Moving price
stprs EBEWHJoinEBEW stprs Standard price
peinh EBEWHJoinEBEW peinh Unit of measure
bklas EBEWHJoinEBEW bklas Valuation Class
salkv

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_Ebewh.
-- 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: MBVEBEWH

CREATE VIEW Mbv_Ebewh AS
SELECT
  h.mandt AS mandt,
  h.matnr AS matnr,
  h.bwkey AS bwkey,
  h.bwtar AS bwtar,
  h.sobkz AS sobkz,
  h.vbeln AS vbeln,
  h.posnr AS posnr,
  h.lfgja AS lfgja,
  h.lfmon AS lfmon,
  h.vprsv AS vprsv,
  h.verpr AS verpr,
  h.stprs AS stprs,
  h.peinh AS peinh,
  h.bklas AS bklas,
  cast(matprice.salkv as salkv) AS salkv
FROM EBEWHJoinEBEW AS h
LEFT OUTER JOIN V_ML_ACDOC_EX_AG_DDL AS ext ON /* join condition not captured in parsed metadata */
;

Learn More