Mbv_Macku

DDL: MBV_MACKU SQL: MBVMACKU Type: view
38 Fields 2 Data Sources

Compatibility view for MACKU view (ML integration)

Mbv_Macku is a CDS View that provides data about "Compatibility view for MACKU view (ML integration)" in SAP S/4HANA. It reads from 2 data sources (mara, Mbv_Mbew) and exposes 38 fields.

Data Sources (2)

SourceAliasJoin Type
mara mara from
Mbv_Mbew Mbv_Mbew inner

Annotations (9)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName MBVMACKU view
EndUserText.label Compatibility view for MACKU 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 (38)

KeyFieldSource TableSource FieldDescription
mandt mara mandt Editing Client
matnr mara matnr Vehicle Model
bwkey Mbv_Mbew bwkey Valuation Area
bwtar Mbv_Mbew bwtar Valuation Type
mtart mara mtart Product Type
matkl mara matkl Product Sold Group
kzkfg mara kzkfg Origin of config
vprsv Mbv_Mbew vprsv Price control
verpr Mbv_Mbew verpr Moving price
stprs Mbv_Mbew stprs Standard price
peinh Mbv_Mbew peinh Unit of measure
bklas Mbv_Mbew bklas Valuation Class
bwtty Mbv_Mbew bwtty Valuation Cat.
zkprs Mbv_Mbew zkprs Future Price
zkdat Mbv_Mbew zkdat Valid from
bwprs Mbv_Mbew bwprs Tax price 1
bwprh Mbv_Mbew bwprh Comm. price 1
bwps1 Mbv_Mbew bwps1 Tax price 2
bwph1 Mbv_Mbew bwph1 Commercial pr.2
vjbws Mbv_Mbew vjbws Tax price 3
vjbwh Mbv_Mbew vjbwh Coml price 3
zplp1 Mbv_Mbew zplp1 Planned price 1
zplp2 Mbv_Mbew zplp2 Planned price 2
zplp3 Mbv_Mbew zplp3 Planned price 3
zpld1 Mbv_Mbew zpld1 Plnd pr. date 1
zpld2 Mbv_Mbew zpld2 Plnd pr. date 2
zpld3 Mbv_Mbew zpld3 Plnd pr. date 3
kalnr Mbv_Mbew kalnr ProdCostEst.No.
kaln1 Mbv_Mbew kaln1 ProdCostEst.No.
vmstp Mbv_Mbew vmstp Std price PP
vmpei Mbv_Mbew vmpei Price unit PP
hrkft Mbv_Mbew hrkft Origin group order
ekalr Mbv_Mbew ekalr Cost Est. w/QS
zplpr Mbv_Mbew zplpr Fut. Plnd Price
hkmat Mbv_Mbew hkmat Material origin
bwpei Mbv_Mbew bwpei Price Unit
cwmxcwmat mara /cwm/xcwmat
cwmvalum mara /cwm/valum

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_Macku.
-- 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: MBVMACKU

CREATE VIEW Mbv_Macku AS
SELECT
  mara.mandt AS mandt,
  mara.matnr AS matnr,
  Mbv_Mbew.bwkey AS bwkey,
  Mbv_Mbew.bwtar AS bwtar,
  mara.mtart AS mtart,
  mara.matkl AS matkl,
  mara.kzkfg AS kzkfg,
  Mbv_Mbew.vprsv AS vprsv,
  Mbv_Mbew.verpr AS verpr,
  Mbv_Mbew.stprs AS stprs,
  Mbv_Mbew.peinh AS peinh,
  Mbv_Mbew.bklas AS bklas,
  Mbv_Mbew.bwtty AS bwtty,
  Mbv_Mbew.zkprs AS zkprs,
  Mbv_Mbew.zkdat AS zkdat,
  Mbv_Mbew.bwprs AS bwprs,
  Mbv_Mbew.bwprh AS bwprh,
  Mbv_Mbew.bwps1 AS bwps1,
  Mbv_Mbew.bwph1 AS bwph1,
  Mbv_Mbew.vjbws AS vjbws,
  Mbv_Mbew.vjbwh AS vjbwh,
  Mbv_Mbew.zplp1 AS zplp1,
  Mbv_Mbew.zplp2 AS zplp2,
  Mbv_Mbew.zplp3 AS zplp3,
  Mbv_Mbew.zpld1 AS zpld1,
  Mbv_Mbew.zpld2 AS zpld2,
  Mbv_Mbew.zpld3 AS zpld3,
  Mbv_Mbew.kalnr AS kalnr,
  Mbv_Mbew.kaln1 AS kaln1,
  Mbv_Mbew.vmstp AS vmstp,
  Mbv_Mbew.vmpei AS vmpei,
  Mbv_Mbew.hrkft AS hrkft,
  Mbv_Mbew.ekalr AS ekalr,
  Mbv_Mbew.zplpr AS zplpr,
  Mbv_Mbew.hkmat AS hkmat,
  Mbv_Mbew.bwpei AS bwpei,
  mara./cwm/xcwmat AS cwmxcwmat,
  mara./cwm/valum AS cwmvalum
FROM mara
INNER JOIN Mbv_Mbew ON /* join condition not captured in parsed metadata */
;

Learn More