Mbv_Mbewh_Base

DDL: MBV_MBEWH_BASE SQL: MBVMBEWHBASE Type: view
13 Fields 2 Data Sources

Base V. for compatibility view of MBEWH

Mbv_Mbewh_Base is a CDS View that provides data about "Base V. for compatibility view of MBEWH" in SAP S/4HANA. It reads from 2 data sources (V_ML_ACDOC_EX_AG_DDL, mbewh) and exposes 13 fields with key fields mandt, matnr, bwkey, bwtar, lfgja.

Data Sources (2)

SourceAliasJoin Type
V_ML_ACDOC_EX_AG_DDL ext left_outer
mbewh mbewh from

Annotations (8)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName MBVMBEWHBASE view
EndUserText.label Base V. for compatibility view of MBEWH view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #P view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY mandt mbewh mandt Editing Client
KEY matnr mbewh matnr Vehicle Model
KEY bwkey mbewh bwkey Valuation Area
KEY bwtar mbewh bwtar Valuation Type
KEY lfgja mbewh lfgja Year Cur.Period
KEY lfmon mbewh lfmon Current Period
vprsv mbewh vprsv Price control
verpr mbewh verpr Moving price
stprs mbewh stprs Standard price
peinh mbewh peinh Unit of measure
bklas mbewh bklas Valuation Class
bwtty mbew bwtty Valuation Cat.
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_Mbewh_Base.
-- 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: MBVMBEWHBASE

CREATE VIEW Mbv_Mbewh_Base AS
SELECT
  mbewh.mandt AS mandt,
  mbewh.matnr AS matnr,
  mbewh.bwkey AS bwkey,
  mbewh.bwtar AS bwtar,
  mbewh.lfgja AS lfgja,
  mbewh.lfmon AS lfmon,
  mbewh.vprsv AS vprsv,
  mbewh.verpr AS verpr,
  mbewh.stprs AS stprs,
  mbewh.peinh AS peinh,
  mbewh.bklas AS bklas,
  mbew.bwtty AS bwtty,
  coalesce(matprice.salkv, 0) AS salkv
FROM mbewh
LEFT OUTER JOIN V_ML_ACDOC_EX_AG_DDL AS ext ON /* join condition not captured in parsed metadata */
;

Learn More