I_PRODUNIVHIERARCHYNODEBASIC

CDS View
12 Fields 7 CDS Views

Product Hierarchy Node

I_PRODUNIVHIERARCHYNODEBASIC is a CDS View in S/4HANA. Product Hierarchy Node. It contains 12 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_ProdUnivHierarchyNode view from CONSUMPTION API Product Hierarchy Node
I_ProdUnivHierarchyNode view from COMPOSITE Product Hierarchy Node View
I_ProdUnivHierNodesByHierID view from COMPOSITE Product Hierarchy Node by Hier ID
I_ProdUnivHierProdsByHierNode view from COMPOSITE Product Hierarchy - Product View
P_CapPlngProductHierNode view inner COMPOSITE Production Hierarchy Node for Product
P_ProdnProductHierarcyNode view_entity inner COMPOSITE
P_ProdnProductHierNode view inner COMPOSITE

Fields (12)

KeyField CDS FieldsUsed in Views
KEY HierarchyNode HierarchyNode,ProductHierarchyNode 3
KEY ProdHierarchyValidityEndDate ProdHierarchyValidityEndDate 4
KEY Product Material,Product 2
KEY ProdUnivHierarchy ProductHierarchy,ProdUnivHierarchy 4
_Product _Product 3
_ProductHierarchy _ProductHierarchy 3
HierarchyNodeLevel HierarchyNodeLevel 1
HierarchyNodeSequence SequenceNumber 2
NodeType NodeType 2
ParentNode ParentNode,ProductHierarchyParentNode 3
ProdHierarchyValidityStartDate ProdHierarchyValidityStartDate 4
ProdUnivHierarchyNode ProdUnivHierarchyNode 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Product Hierarchy Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUNIVHIERARCHYNODEBASIC (
    HIERARCHYNODE,
    PRODHIERARCHYVALIDITYENDDATE,
    PRODUCT,
    PRODUNIVHIERARCHY,
    _PRODUCT,
    _PRODUCTHIERARCHY,
    HIERARCHYNODELEVEL,
    HIERARCHYNODESEQUENCE,
    NODETYPE,
    PARENTNODE,
    PRODHIERARCHYVALIDITYSTARTDATE,
    PRODUNIVHIERARCHYNODE,
    PRIMARY KEY (HIERARCHYNODE, PRODHIERARCHYVALIDITYENDDATE, PRODUCT, PRODUNIVHIERARCHY)
);

Learn More