Mbv_Qbewh

DDL: MBV_QBEWH SQL: MBVQBEWH Type: view
14 Fields 2 Data Sources

Compatibility view for QBEWH table

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

Data Sources (2)

SourceAliasJoin Type
V_ML_ACDOC_EX_AG_DDL ext left_outer
QBEWHJoinQBEW h from

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName MBVQBEWH view
EndUserText.label Compatibility view for QBEWH 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 (14)

KeyFieldSource TableSource FieldDescription
KEY mandt QBEWHJoinQBEW mandt Editing Client
KEY matnr QBEWHJoinQBEW matnr Vehicle Model
KEY bwkey QBEWHJoinQBEW bwkey Valuation Area
KEY bwtar QBEWHJoinQBEW bwtar Valuation Type
KEY sobkz QBEWHJoinQBEW sobkz Special Stock
KEY pspnr QBEWHJoinQBEW pspnr WBS Element
KEY lfgja QBEWHJoinQBEW lfgja Year Cur.Period
KEY lfmon QBEWHJoinQBEW lfmon Current Period
vprsv QBEWHJoinQBEW vprsv Price control
verpr QBEWHJoinQBEW verpr Moving price
stprs QBEWHJoinQBEW stprs Standard price
peinh QBEWHJoinQBEW peinh Unit of measure
bklas QBEWHJoinQBEW 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_Qbewh.
-- 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: MBVQBEWH

CREATE VIEW Mbv_Qbewh AS
SELECT
  h.mandt AS mandt,
  h.matnr AS matnr,
  h.bwkey AS bwkey,
  h.bwtar AS bwtar,
  h.sobkz AS sobkz,
  h.pspnr AS pspnr,
  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 QBEWHJoinQBEW AS h
LEFT OUTER JOIN V_ML_ACDOC_EX_AG_DDL AS ext ON /* join condition not captured in parsed metadata */
;

Learn More