PPH_DDL_MDPB_B

DDL: PPH_DDL_MDPB_B SQL: V_PPH_MDPB_B Type: view

PPH_DDL_MDPB_B is a CDS View in SAP S/4HANA. It reads from 1 data source (PPH_E_MDPB) and exposes 36 fields.

Data Sources (1)

SourceAliasJoin Type
PPH_E_MDPB m from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName V_PPH_MDPB_B 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 (36)

KeyFieldSource TableSource FieldDescription
matnr matnr Vehicle Model
werks werks Receiving Plant
dat00 dat00 Planned dates
sort1 sort1 Sort string 1
sort2 sort2 Sort string 2
delkz delkz MRP Elmnt Ind.
vrfkz vrfkz Availability
plumi plumi Plus/minus
mng01 mng01 Rec./reqd qty
mng03 mng03 Shortage Quantity
dat01 dat01 Finish date
perkz perkz Period Type
baart baart P.O./Order type
delnr delnr Order No.(OLTP)
zuvkz zuvkz Consumption
vervp vervp CInd.
versb versb Version
sernr sernr Serial Number
techs techs Tech st from
verid verid Version ID
knttp knttp AcctAssgnCat:CC
kzvbr kzvbr Consumption
sobkz sobkz Special Stock
kdauf kdauf SD Document
kdpos kdpos Sales Ord. Item
pspel pspel WBS Element
cuobj cuobj Object Number
vrpla vrpla W/o final assy
pbdnr pbdnr Requirements Plan
kzbws kzbws Valuation
sgt_rcat sgt_rcat Req. Segment
mdpb_plnkz mdpb_plnkz
mdpb_oplkz mdpb_oplkz
knttp_db knttp_db
kzvbr_db kzvbr_db
kzbws_db kzbws_db

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_DDL_MDPB_B.
-- 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_MDPB_B

CREATE VIEW PPH_DDL_MDPB_B AS
SELECT
  matnr,
  werks,
  dat00,
  sort1,
  sort2,
  delkz,
  vrfkz,
  plumi,
  mng01,
  mng03,
  dat01,
  perkz,
  baart,
  delnr,
  zuvkz,
  vervp,
  versb,
  sernr,
  techs,
  verid,
  knttp,
  kzvbr,
  sobkz,
  kdauf,
  kdpos,
  pspel,
  cuobj,
  vrpla,
  pbdnr,
  kzbws,
  sgt_rcat,
  mdpb_plnkz,
  mdpb_oplkz,
  knttp_db,
  kzvbr_db,
  kzbws_db
FROM PPH_E_MDPB AS m
;