pph_e_Mdbs_2

DDL: PPH_DDL_MDBS_2 SQL: V_PPH_MDBS_2 Type: view

pph_e_Mdbs_2 is a CDS View in SAP S/4HANA. It reads from 1 data source (pph_e_Mdbs_1) and exposes 76 fields.

Data Sources (1)

SourceAliasJoin Type
pph_e_Mdbs_1 pph_e_Mdbs_1 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_PPH_MDBS_2 view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (76)

KeyFieldSource TableSource FieldDescription
matnr matnr Vehicle Model
werks werks Receiving Plant
sgt_scat sgt_scat Stock Segment
sgt_rcat sgt_rcat Req. Segment
umrez umrez Numerator
umren umren Denominator
webaz webaz GR Proc. Time
fix01 fix01 Fixed Lot Size
fix02 fix02 Fixed explosion
bstyp bstyp Source doc.cat.
eglkz eglkz Final Delivery
pstyp pstyp Item Category
retpo retpo Returns Item
ebeln ebeln Source PurchDoc
ebelp ebelp Item pur. doc.
lgort lgort Sublocation
delnr delnr Order No.(OLTP)
delps delps Order Item
revlv revlv Revision Level
arsnr arsnr Settle.reser.No
arsps arsps Settle.item no.
knttp knttp AcctAssgnCat:CC
kzvbr kzvbr Consumption
sobkz sobkz Special Stock
kzbws kzbws Valuation
reslo reslo Iss. Stor. Loc.
prio_urg prio_urg Reqmt Urgency
prio_req prio_req Reqmt Priority
statu statu Vehicle Status
wepos wepos Goods Receipt
insmk insmk Stock Type
etfz2 etfz2 Trade-Off Zone
mdbs_itcons mdbs_itcons
mdbs_statu mdbs_statu
mdbs_wepos mdbs_wepos
mdbs_emlif mdbs_emlif
mdbs_lblkz mdbs_lblkz
mdbs_insmk mdbs_insmk
mdbs_bstme mdbs_bstme
mng01 mng01 Rec./reqd qty
mng02 mng02 Scrap
auftm auftm
etmen etmen
glmng glmng Qty Delivered
etenr etenr Schedule Line
uzeit uzeit Time
dat01 dat01 Finish date
bedat bedat Start date
delet delet Scheduling
rsnum rsnum Reservation
sernr sernr Serial Number
verid verid Version ID
qunum qunum Quota arr.
qupos qupos Quota arr. item
mdbs_no_disp mdbs_no_disp
wrk02 wrk02 Plant
lifnr lifnr Vendor no.
beskz beskz Procuremt Type
sort1 sort1 Sort string 1
sort2 sort2 Sort string 2
delkz delkz MRP Elmnt Ind.
plumi plumi Plus/minus
sobes sobes Spec. procuremt
charg charg Chargeable Proc.
dbskz dbskz Direct procure.
mdbs_loekz mdbs_loekz
mdbs_aktnr mdbs_aktnr
fls_rsto fls_rsto Enh. Store Ret.
mdbs_ameng mdbs_ameng
mdbs_fixmg mdbs_fixmg
mdbs_eglkz mdbs_eglkz
mdbs_kzfix mdbs_kzfix
mdbs_etfz1 mdbs_etfz1
mdbs_etfz2 mdbs_etfz2
mdbs_etdrk mdbs_etdrk
calculateBASISMNG

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 pph_e_Mdbs_2.
-- 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: V_PPH_MDBS_2

CREATE VIEW pph_e_Mdbs_2 AS
SELECT
  matnr,
  werks,
  sgt_scat,
  sgt_rcat,
  umrez,
  umren,
  webaz,
  fix01,
  fix02,
  bstyp,
  eglkz,
  pstyp,
  retpo,
  ebeln,
  ebelp,
  lgort,
  delnr,
  delps,
  revlv,
  arsnr,
  arsps,
  knttp,
  kzvbr,
  sobkz,
  kzbws,
  reslo,
  prio_urg,
  prio_req,
  statu,
  wepos,
  insmk,
  etfz2,
  mdbs_itcons,
  mdbs_statu,
  mdbs_wepos,
  mdbs_emlif,
  mdbs_lblkz,
  mdbs_insmk,
  mdbs_bstme,
  mng01,
  mng02,
  auftm,
  etmen,
  glmng,
  etenr,
  uzeit,
  dat01,
  bedat,
  delet,
  rsnum,
  sernr,
  verid,
  qunum,
  qupos,
  mdbs_no_disp,
  wrk02,
  lifnr,
  beskz,
  sort1,
  sort2,
  delkz,
  plumi,
  sobes,
  charg,
  dbskz,
  mdbs_loekz,
  mdbs_aktnr,
  fls_rsto,
  mdbs_ameng,
  mdbs_fixmg,
  mdbs_eglkz,
  mdbs_kzfix,
  mdbs_etfz1,
  mdbs_etfz2,
  mdbs_etdrk
FROM pph_e_Mdbs_1
;