I_ArticleHierNodeToProduct

DDL: I_ARTICLEHIERNODETOPRODUCT SQL: IARTHIERNODEPROD Type: view BASIC Package: RFM_ASSORTMENT_VDM
11 Fields 1 Data Sources 1 Associations

Main Assignment of Product to Product Hierarchy Node

I_ArticleHierNodeToProduct is a Basic CDS View that provides data about "Main Assignment of Product to Product Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_ProductHierAssign) and exposes 11 fields with key field Product. It has 1 association to related views. Part of development package RFM_ASSORTMENT_VDM.

Data Sources (1)

SourceAliasJoin Type
I_ProductHierAssign I_ProductHierAssign from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CategoryStrucText _NodeText $projection.HierarchyID = _NodeText.HierarchyID and $projection.RetailArticleHierarchyNode = _NodeText.HierarchyNode

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IARTHIERNODEPROD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Main Assignment of Product to Product Hierarchy Node view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
HierarchyID HierarchyID Hierarchy ID
RetailArticleHierarchyNode HierarchyNode Node
ArticleHierAssgmtValdtyStrtDte ArticleHierAssgmtValdtyStrtDte Validity Start Date
ArticleHierAssgmtValdtyEndDate ArticleHierAssgmtValdtyEndDate Validity End Date
IsArticleHierMainAssignment IsArticleHierMainAssignment Main Assignment
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
_ActiveArticleHierarchy _ActiveArticleHierarchy
_ArticleHierDescText _ArticleHierDescText
_NodeText _NodeText

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 I_ArticleHierNodeToProduct.
-- 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: IARTHIERNODEPROD

CREATE VIEW I_ArticleHierNodeToProduct AS
SELECT
  Product,
  HierarchyID,
  HierarchyNode AS RetailArticleHierarchyNode,
  ArticleHierAssgmtValdtyStrtDte,
  ArticleHierAssgmtValdtyEndDate,
  IsArticleHierMainAssignment,
  SalesOrganization,
  DistributionChannel
FROM I_ProductHierAssign
LEFT OUTER JOIN I_CategoryStrucText AS _NodeText ON HierarchyID = _NodeText.HierarchyID AND RetailArticleHierarchyNode = _NodeText.HierarchyNode  -- association [0..*]
;

Learn More