pph_e_mat_ctrl_1

DDL: PPH_DDL_MAT_CTRL_1 SQL: V_PPH_MAT_CTRL_1 Type: view Package: PPH_AMDP_READ
83 Fields 1 Data Sources

View for reading master data

pph_e_mat_ctrl_1 is a CDS View that provides data about "View for reading master data" in SAP S/4HANA. It reads from 1 data source (PPH_DDL_MAT_CTRL_0) and exposes 83 fields. Part of development package PPH_AMDP_READ.

Data Sources (1)

SourceAliasJoin Type
PPH_DDL_MAT_CTRL_0 PPH_DDL_MAT_CTRL_0 from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName V_PPH_MAT_CTRL_1 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
EndUserText.label View for reading master data view

Fields (83)

KeyFieldSource TableSource FieldDescription
matnr matnr Vehicle Model
werks werks Receiving Plant
berid berid Single-Character Flag
sgt_csgr sgt_csgr Seg. Structure
sgt_covsa sgt_covsa Seg. Strategy
sgt_stat sgt_stat Seg. Status
sgt_rel sgt_rel Seg. Relevant
sgt_covs sgt_covs Segment. Strategy
sgt_statc sgt_statc Seg. Status MRP
sgt_scope sgt_scope Seg. Scope
sgt_mrpsi sgt_mrpsi Sort Stock
sgt_prcm sgt_prcm Cons. Prio.
sgt_chint sgt_chint Discr.Batch No.
berty berty MRP Area Type
matkl matkl Product Sold Group
lvorm_mara lvorm_mara DF client level
lvorm_marc lvorm_marc DF plant level
satnr satnr Cross-plant CM
mstae mstae X-Plant Status
attyp attyp Trdg Goods Cat.
meins meins Valuation Unit
disst disst Low-Level Code
kzkfg kzkfg Origin of config
kzeff kzeff Assign.eff.vals
kzkup kzkup Co-Product
cuobf cuobf Int. object no.
mprof mprof Mfr Part Profile
mfrpn mfrpn Mfr Part Number
mfrnr mfrnr Manufacturer
mmsta mmsta Primary Status
mmstd mmstd Valid From
mstde mstde Valid from
maabc maabc ABC Indicator
ekgrp ekgrp Sub. purchasing grp
apokz apokz Relevant to APO
willnolongerbemappedtoCBPPTppskz
andec andec Rounding
beskz beskz Procuremt Type
sbdkz sbdkz Indiv./ Coll.
kzaus kzaus Share of scrap
ausdt ausdt Dunning Date
mtart mtart Product Type
disgr_marc disgr_marc
miskz miskz Mixed MRP
rwpro rwpro Coverage Prof.
fhori fhori Margin Key
vrmod vrmod Consmption mode
vint1 vint1 Bwd cons. per.
vint2 vint2 Fwd cons.period
stdpd stdpd Conf. Material
cuobv cuobv Int. object no.
bearz bearz Processing Time
ruezt ruezt Setup time
tranz tranz Move Time
webaz webaz GR Proc. Time
dzeit dzeit InhseProdTime
wzeit wzeit Total RL time
qmatv qmatv Insp. Setup
cuobj cuobj Object Number
resvp resvp Adjustmt period
umlmc umlmc Stock in tfr
strgr strgr Strategy Group
periv periv FYear Variant
sauft sauft Repetitive Mfg
sfepr sfepr REM Profile
perkz perkz Period Type
disfg disfg
fevor fevor Prodn Supervisor
basmg basmg Base quantity
mfxdt mfxdt Man.firm date
altsl altsl SelectionMethod
picnum picnum GrpNo.for PIC
imatn imatn FFF class
gsaen gsaen Net Change Plng
resal resal Re-explode BOM
resdt resdt Reset ord.props
rhytd rhytd Planning date
nodisp nodisp Res./Purc. req.
num_mdps num_mdps No. of MDPS Elements
num_rto_item num_rto_item Number of BOM Items
plan_in_abap plan_in_abap Plan in Classic MRP
adspc_spc adspc_spc Spare Prt Class Code
mdach mdach Action Control

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_mat_ctrl_1.
-- 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_MAT_CTRL_1

CREATE VIEW pph_e_mat_ctrl_1 AS
SELECT
  matnr,
  werks,
  berid,
  sgt_csgr,
  sgt_covsa,
  sgt_stat,
  sgt_rel,
  sgt_covs,
  sgt_statc,
  sgt_scope,
  sgt_mrpsi,
  sgt_prcm,
  sgt_chint,
  berty,
  matkl,
  lvorm_mara,
  lvorm_marc,
  satnr,
  mstae,
  attyp,
  meins,
  disst,
  kzkfg,
  kzeff,
  kzkup,
  cuobf,
  mprof,
  mfrpn,
  mfrnr,
  mmsta,
  mmstd,
  mstde,
  maabc,
  ekgrp,
  apokz,
  andec,
  beskz,
  sbdkz,
  kzaus,
  ausdt,
  mtart,
  disgr_marc,
  miskz,
  rwpro,
  fhori,
  vrmod,
  vint1,
  vint2,
  stdpd,
  cuobv,
  bearz,
  ruezt,
  tranz,
  webaz,
  dzeit,
  wzeit,
  qmatv,
  cuobj,
  resvp,
  umlmc,
  strgr,
  periv,
  sauft,
  sfepr,
  perkz,
  disfg,
  fevor,
  basmg,
  mfxdt,
  altsl,
  picnum,
  imatn,
  gsaen,
  resal,
  resdt,
  rhytd,
  nodisp,
  num_mdps,
  num_rto_item,
  plan_in_abap,
  adspc_spc,
  mdach
FROM PPH_DDL_MAT_CTRL_0
;

Learn More