Mbv_Mbew_Base

DDL: MBV_MBEW_BASE SQL: MBVMBEWBASE Type: view Package: MBV_DB
108 Fields 1 Data Sources

Base view for compatibility view of MBEW

Mbv_Mbew_Base is a CDS View that provides data about "Base view for compatibility view of MBEW" in SAP S/4HANA. It reads from 1 data source (mbew) and exposes 108 fields with key fields mandt, matnr, bwkey, bwtar. Part of development package MBV_DB.

Data Sources (1)

SourceAliasJoin Type
mbew m from

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName MBVMBEWBASE view
EndUserText.label Base view for compatibility view of MBEW view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

Fields (108)

KeyFieldSource TableSource FieldDescription
KEY mandt mbew mandt Editing Client
KEY matnr mbew matnr Vehicle Model
KEY bwkey mbew bwkey Valuation Area
KEY bwtar mbew bwtar Valuation Type
kaln1 kaln1 ProdCostEst.No.
lbkum u vmsl Val. quantity
salk3 u hsl Local Crcy Amt
lvorm lvorm Stock del. flag
vprsv mbew vprsv Price control
verpr verpr Moving price
stprs mbew stprs Standard price
peinh mbew peinh Unit of measure
bklas bklas Valuation Class
salkv matprice salkv Value/MA price
vmkum vmkum Total stock PP
vmsal vmsal Total value PP
vmvpr vmvpr Price ctrl PP
vmver vmver MovAvgPrice PP
vmstp vmstp Std price PP
vmpei vmpei Price unit PP
vmbkl vmbkl Val. class PP
vmsav vmsav Value prev.per.
vjkum vjkum Total stock PY
vjsal vjsal Total value PY
vjvpr vjvpr Price ctrl PY
vjver vjver MovAvgPrice PY
vjstp vjstp Std price PY
vjpei vjpei Price unit PY
vjbkl vjbkl Val. class PY
vjsav vjsav Value prev.year
lfgja lfgja Year Cur.Period
lfmon lfmon Current Period
bwtty bwtty Valuation Cat.
stprv stprv Previous Price
laepr laepr Last Price Chg.
zkprs zkprs Future Price
zkdat zkdat Valid from
timestamp timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
bwprs bwprs Tax price 1
bwprh bwprh Comm. price 1
vjbws vjbws Tax price 3
vjbwh vjbwh Coml price 3
vvjsl vvjsl Valued at
vvjlb vvjlb Total stock YBL
vvmlb vvmlb Total stock PBL
vvsal vvsal Valued at
zplpr zplpr Fut. Plnd Price
zplp1 zplp1 Planned price 1
zplp2 zplp2 Planned price 2
zplp3 zplp3 Planned price 3
zpld1 zpld1 Plnd pr. date 1
zpld2 zpld2 Plnd pr. date 2
zpld3 zpld3 Plnd pr. date 3
pperz pperz Fut. c/e period
pperl pperl Current c/e pd
pperv pperv Prev. c/e per.
kalkz kalkz Fut. cost est.
kalkl kalkl CurrentCostEst.
kalkv kalkv PreviousCostEst
kalsc kalsc Overhead key
xlifo xlifo LIFO/FIFO-Rel.
mypol mypol LIFO Pool
bwph1 bwph1 Commercial pr.2
bwps1 bwps1 Tax price 2
abwkz abwkz Devaluation Ind
pstat pstat Processing Status
kalnr mbew kalnr ProdCostEst.No.
bwva1 bwva1 Valuation Var.
bwva2 bwva2 Valuatn Variant
bwva3 bwva3 Valuation Var.
vers1 vers1 Late Completion
vers2 vers2 EarlyCompletion
vers3 vers3 Costing Version
hrkft hrkft Origin group order
kosgr kosgr Overhead Group
pprdz pprdz Posting Period
pprdl pprdl Current Period
pprdv pprdv Previous Period
pdatz pdatz Fut. FYyear
pdatl pdatl Curr. Fiscal Yr
pdatv pdatv Valid From
ekalr ekalr Cost Est. w/QS
vplpr vplpr Prev. Plnd Prc.
mlmaa mlmaa ML Act.
mlast mlast Price Determ.
lplpr lplpr Curr.Plnd Price
vksal u hvkwrt Value SP LCrcy
hkmat hkmat Material origin
sperw sperw Phys. Inv. Blk
kziwl kziwl Ph.inv. VO mat.
wlinl wlinl Last Count Date
abciw abciw CC Phys. Inv.
bwspa bwspa Val. Margin
lplpx lplpx Fix. Cur. Plnd Prc.
vplpx vplpx Fixed Prev. PlndPrc.
fplpx fplpx Fut. PlanPrice, Fxd
lbwst lbwst Curr. Valn Strat.
vbwst vbwst Prev. Valn Strat.
fbwst fbwst Fut. Valn Strat.
eklas eklas VC: Sal.Ord.Stk
qklas qklas Project stk VC
mtuse mtuse Material Usage
mtorg mtorg Material Origin
ownpr ownpr Prod. in-house
xbewm xbewm Valuated UoM
bwpei bwpei Price Unit
mbrue mbrue MBEWH rec. already exists for per. before last of MBEW per.
oklas oklas VC: Vendor

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_Mbew_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: MBVMBEWBASE

CREATE VIEW Mbv_Mbew_Base AS
SELECT
  m.mandt AS mandt,
  m.matnr AS matnr,
  m.bwkey AS bwkey,
  m.bwtar AS bwtar,
  kaln1,
  u.vmsl AS lbkum,
  u.hsl AS salk3,
  lvorm,
  m.vprsv AS vprsv,
  verpr,
  m.stprs AS stprs,
  m.peinh AS peinh,
  bklas,
  matprice.salkv AS salkv,
  vmkum,
  vmsal,
  vmvpr,
  vmver,
  vmstp,
  vmpei,
  vmbkl,
  vmsav,
  vjkum,
  vjsal,
  vjvpr,
  vjver,
  vjstp,
  vjpei,
  vjbkl,
  vjsav,
  lfgja,
  lfmon,
  bwtty,
  stprv,
  laepr,
  zkprs,
  zkdat,
  timestamp,
  bwprs,
  bwprh,
  vjbws,
  vjbwh,
  vvjsl,
  vvjlb,
  vvmlb,
  vvsal,
  zplpr,
  zplp1,
  zplp2,
  zplp3,
  zpld1,
  zpld2,
  zpld3,
  pperz,
  pperl,
  pperv,
  kalkz,
  kalkl,
  kalkv,
  kalsc,
  xlifo,
  mypol,
  bwph1,
  bwps1,
  abwkz,
  pstat,
  m.kalnr AS kalnr,
  bwva1,
  bwva2,
  bwva3,
  vers1,
  vers2,
  vers3,
  hrkft,
  kosgr,
  pprdz,
  pprdl,
  pprdv,
  pdatz,
  pdatl,
  pdatv,
  ekalr,
  vplpr,
  mlmaa,
  mlast,
  lplpr,
  u.hvkwrt AS vksal,
  hkmat,
  sperw,
  kziwl,
  wlinl,
  abciw,
  bwspa,
  lplpx,
  vplpx,
  fplpx,
  lbwst,
  vbwst,
  fbwst,
  eklas,
  qklas,
  mtuse,
  mtorg,
  ownpr,
  xbewm,
  bwpei,
  mbrue,
  oklas
FROM mbew AS m
;

Learn More