P_CapPlngProductHierNode

DDL: P_CAPPLNGPRODUCTHIERNODE Type: view_entity COMPOSITE Package: ODATA_PP_CAP_SCHEDPRODN
11 Fields 2 Data Sources

Production Hierarchy Node for Product

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

Data Sources (2)

SourceAliasJoin Type
I_ProdUnivHierarchyNodeBasic ProductHierarchyBasic inner
I_ProdnProductHierAssgmt ProductHierAssgmt from

Annotations (9)

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
EndUserText.label Production Hierarchy Node for Product view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProductionPlant 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.
ProdUnivHierarchy I_ProdUnivHierarchyNodeBasic ProdUnivHierarchy
ProdHierarchyValidityEndDate I_ProdUnivHierarchyNodeBasic ProdHierarchyValidityEndDate
ProdHierarchyValidityStartDate I_ProdUnivHierarchyNodeBasic ProdHierarchyValidityStartDate
_MRPPlant I_ProdnProductHierAssgmt _MRPPlant
_ProductHierarchy I_ProdUnivHierarchyNodeBasic _ProductHierarchy
_Product I_ProdUnivHierarchyNodeBasic _Product

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_CapPlngProductHierNode.
-- 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_CapPlngProductHierNode AS
SELECT
  ProductHierAssgmt.MRPPlant AS ProductionPlant,
  ProductHierarchyBasic.Product AS Material,
  ProductHierAssgmt.UniversalHierVersValidFrom AS UniversalHierVersValidFrom,
  ProductHierAssgmt.UniversalHierVersValidTo AS UniversalHierVersValidTo,
  ProductHierAssgmt.ProdnProductHierarchyPurpose AS ProdnProductHierarchyPurpose,
  ProductHierarchyBasic.ProdUnivHierarchy AS ProdUnivHierarchy,
  ProductHierarchyBasic.ProdHierarchyValidityEndDate AS ProdHierarchyValidityEndDate,
  ProductHierarchyBasic.ProdHierarchyValidityStartDate AS ProdHierarchyValidityStartDate,
  ProductHierAssgmt._MRPPlant AS _MRPPlant,
  ProductHierarchyBasic._ProductHierarchy AS _ProductHierarchy,
  ProductHierarchyBasic._Product AS _Product
FROM I_ProdnProductHierAssgmt AS ProductHierAssgmt
INNER JOIN I_ProdUnivHierarchyNodeBasic AS ProductHierarchyBasic ON /* join condition not captured in parsed metadata */
;

Learn More