P_ProdnProductHierNode

DDL: P_PRODNPRODUCTHIERNODE Type: view_entity COMPOSITE Package: ODATA_PP_MRP
13 Fields 2 Data Sources

Product Hierarchy and Hierarchy Node for Production

P_ProdnProductHierNode is a Composite CDS View that provides data about "Product Hierarchy and Hierarchy Node for Production" in SAP S/4HANA. It reads from 2 data sources (I_ProdUnivHierarchyNodeBasic, I_ProdnProductHierAssgmt) and exposes 13 fields with key fields MRPPlant, Material, UniversalHierVersValidFrom, UniversalHierVersValidTo, ProdnProductHierarchyPurpose. Part of development package ODATA_PP_MRP.

Data Sources (2)

SourceAliasJoin Type
I_ProdUnivHierarchyNodeBasic ProductHierarchyBasic inner
I_ProdnProductHierAssgmt ProductHierAssgmt from

Annotations (8)

NameValueLevelField
Search.searchable false view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MRPPlant I_ProdnProductHierAssgmt MRPPlant Plant
KEY Material I_ProdUnivHierarchyNodeBasic Product Product Sold
KEY UniversalHierVersValidFrom I_ProdnProductHierAssgmt UniversalHierVersValidFrom Valid From
KEY UniversalHierVersValidTo I_ProdnProductHierAssgmt UniversalHierVersValidTo Valid To
KEY ProdnProductHierarchyPurpose I_ProdnProductHierAssgmt ProdnProductHierarchyPurpose Purpose of ProdHier.
ProductionProductHierarchy I_ProdnProductHierAssgmt ProductionProductHierarchy Prod.hierarchy
ParentNode250endasHierarchyNode
ProdHierarchyValidityEndDate I_ProdUnivHierarchyNodeBasic ProdHierarchyValidityEndDate
ProdHierarchyValidityStartDate I_ProdUnivHierarchyNodeBasic ProdHierarchyValidityStartDate
_MRPPlant I_ProdnProductHierAssgmt _MRPPlant
_Product I_ProdUnivHierarchyNodeBasic _Product
_ProdnProductHierarchyPurpose I_ProdnProductHierAssgmt _ProdnProductHierarchyPurpose
_ProductHierarchyVH I_ProdnProductHierAssgmt _ProductHierarchyVH

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 P_ProdnProductHierNode.
-- 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 P_ProdnProductHierNode AS
SELECT
  ProductHierAssgmt.MRPPlant AS MRPPlant,
  ProductHierarchyBasic.Product AS Material,
  ProductHierAssgmt.UniversalHierVersValidFrom AS UniversalHierVersValidFrom,
  ProductHierAssgmt.UniversalHierVersValidTo AS UniversalHierVersValidTo,
  ProductHierAssgmt.ProdnProductHierarchyPurpose AS ProdnProductHierarchyPurpose,
  ProductHierAssgmt.ProductionProductHierarchy AS ProductionProductHierarchy,
  case when ProductHierarchyBasic.HierarchyNodeLevel = '000001' then '' else SUBSTRING(ProductHierarchyBasic.ParentNode, 2, 50) end as HierarchyNode AS ParentNode250endasHierarchyNode,
  ProductHierarchyBasic.ProdHierarchyValidityEndDate AS ProdHierarchyValidityEndDate,
  ProductHierarchyBasic.ProdHierarchyValidityStartDate AS ProdHierarchyValidityStartDate,
  ProductHierAssgmt._MRPPlant AS _MRPPlant,
  ProductHierarchyBasic._Product AS _Product,
  ProductHierAssgmt._ProdnProductHierarchyPurpose AS _ProdnProductHierarchyPurpose,
  ProductHierAssgmt._ProductHierarchyVH AS _ProductHierarchyVH
FROM I_ProdnProductHierAssgmt AS ProductHierAssgmt
INNER JOIN I_ProdUnivHierarchyNodeBasic AS ProductHierarchyBasic ON /* join condition not captured in parsed metadata */
;

Learn More