PPH_PICSupersessionGroup

DDL: PPH_PICSUPERSESSIONGROUP Type: view_entity Package: PPH_AMDP_READ
11 Fields 2 Data Sources 2 Associations

Supersession Materials with NetChange

PPH_PICSupersessionGroup is a CDS View that provides data about "Supersession Materials with NetChange" in SAP S/4HANA. It reads from 2 data sources (Pph_MatlocForPlanFileEntry, picps) and exposes 11 fields with key fields Matnr, Werks, Berid. It has 2 associations to related views. Part of development package PPH_AMDP_READ.

Data Sources (2)

SourceAliasJoin Type
Pph_MatlocForPlanFileEntry dbvm from
picps picps inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] PPH_PICSupersessionGroup _LeadingMaterial _LeadingMaterial.pickey = $projection.pickey and _LeadingMaterial.Werks = $projection.Werks and _LeadingMaterial.Berid = $projection.Berid and _LeadingMaterial.seqnr = '0001'
[1..*] Pph_MatlocForPlanFileEntry _SusGroup _SusGroup.picnum = $projection.picnum and _SusGroup.werks = $projection.Werks and _SusGroup.berid = $projection.Berid

Annotations (6)

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

Fields (11)

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
pickey Pph_MatlocForPlanFileEntry pickey PIC key
picnum
gsaen
picpos picps picpos Item no.
seqnr picps seqnr Tank ID
counter picps counter Version
_LeadingMaterial _LeadingMaterial
_SusGroup _SusGroup

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_PICSupersessionGroup.
-- 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_PICSupersessionGroup AS
SELECT
  dbvm.matnr AS Matnr,
  dbvm.werks AS Werks,
  dbvm.berid AS Berid,
  dbvm.pickey AS pickey,
  picps.picpos AS picpos,
  picps.seqnr AS seqnr,
  picps.counter AS counter
FROM Pph_MatlocForPlanFileEntry AS dbvm
INNER JOIN picps ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PPH_PICSupersessionGroup AS _LeadingMaterial ON _LeadingMaterial.pickey = pickey AND _LeadingMaterial.Werks = Werks AND _LeadingMaterial.Berid = Berid AND _LeadingMaterial.seqnr = '0001'  -- association [1..1]
LEFT OUTER JOIN Pph_MatlocForPlanFileEntry AS _SusGroup ON _SusGroup.picnum = picnum AND _SusGroup.werks = Werks AND _SusGroup.berid = Berid  -- association [1..*]
;

Learn More