PPH_PICMpnSet

DDL: PPH_PICMPNSET Type: view_entity Package: PPH_AMDP_READ
13 Fields 2 Data Sources 3 Associations

PIC MPN Sets with NetChange

PPH_PICMpnSet is a CDS View that provides data about "PIC MPN Sets with NetChange" in SAP S/4HANA. It reads from 2 data sources (Pph_MatlocForPlanFileEntry, PPH_PICPsRl) and exposes 13 fields with key fields Matnr, Werks, Berid, mrpgr. It has 3 associations to related views. Part of development package PPH_AMDP_READ.

Data Sources (2)

SourceAliasJoin Type
Pph_MatlocForPlanFileEntry dbvm from
PPH_PICPsRl picpsrl inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] PPH_PICMpnSet _LeadingMaterial _LeadingMaterial.pickey = $projection.pickey and _LeadingMaterial.Werks = $projection.Werks and _LeadingMaterial.Berid = $projection.Berid and _LeadingMaterial.mrpgr = $projection.mrpgr and _LeadingMaterial.Matnr = $projection.lmatn
[1..*] PPH_PICMpnSet _MPNGroup _MPNGroup.imatn = $projection.imatn and _MPNGroup.Werks = $projection.Werks --include all MRP sets from plant independent of BERID even if GSAEN is set only on one MRP set
[1..1] Pph_MatlocForPlanFileEntry _Entry _Entry.matnr = $projection.Matnr and _Entry.werks = $projection.Werks and _Entry.berid = $projection.Berid

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PIC MPN Sets with NetChange view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Matnr Pph_MatlocForPlanFileEntry matnr Vehicle Model
KEY Werks Pph_MatlocForPlanFileEntry werks Receiving Plant
KEY Berid Pph_MatlocForPlanFileEntry berid Single-Character Flag
KEY mrpgr PPH_PICPsRl mrpgr MPN-MRP Set
pickey Pph_MatlocForPlanFileEntry pickey PIC key
imatn
gsaen
picpos PPH_PICPsRl picpos Item no.
seqnr PPH_PICPsRl seqnr Tank ID
lmatn PPH_PICPsRl lmatn Leading part
_LeadingMaterial _LeadingMaterial
_MPNGroup _MPNGroup
_Entry _Entry

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_PICMpnSet.
-- 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.

CREATE VIEW PPH_PICMpnSet AS
SELECT
  dbvm.matnr AS Matnr,
  dbvm.werks AS Werks,
  dbvm.berid AS Berid,
  picpsrl.mrpgr AS mrpgr,
  dbvm.pickey AS pickey,
  picpsrl.picpos AS picpos,
  picpsrl.seqnr AS seqnr,
  picpsrl.lmatn AS lmatn
FROM Pph_MatlocForPlanFileEntry AS dbvm
INNER JOIN PPH_PICPsRl AS picpsrl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PPH_PICMpnSet AS _LeadingMaterial ON _LeadingMaterial.pickey = pickey AND _LeadingMaterial.Werks = Werks AND _LeadingMaterial.Berid = Berid AND _LeadingMaterial.mrpgr = mrpgr AND _LeadingMaterial.Matnr = lmatn  -- association [1..1]
LEFT OUTER JOIN PPH_PICMpnSet AS _MPNGroup ON _MPNGroup.imatn = imatn AND _MPNGroup.Werks = Werks  -- association [1..*]
LEFT OUTER JOIN Pph_MatlocForPlanFileEntry AS _Entry ON _Entry.matnr = Matnr AND _Entry.werks = Werks AND _Entry.berid = Berid  -- association [1..1]
;

Learn More