I_CNSLDTNSALESORGHIERNODE

CDS View
9 Fields 1 CDS Views

Consolidation Sales Org - Hierarchy Node

I_CNSLDTNSALESORGHIERNODE is a CDS View in S/4HANA. Consolidation Sales Org - Hierarchy Node. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_CnsldtnSalesOrgHier view from COMPOSITE Combined Sales Organization Hierarchy

Fields (9)

KeyField CDS FieldsUsed in Views
KEY CnsldtnSalesOrgHierarchy AdditionalMasterDataHierarchy 1
KEY HierarchyNode HierarchyNode 1
KEY ValidityEndDate ValidityEndDate 1
HierarchyNodeLevel HierarchyNodeLevel 1
HierarchyNodeSequence HierarchyNodeSequence 1
NodeType NodeType 1
ParentNode ParentNode 1
SalesOrganization SalesOrganization 1
ValidityStartDate ValidityStartDate 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.

-- Consolidation Sales Org - Hierarchy Node
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNSALESORGHIERNODE (
    CNSLDTNSALESORGHIERARCHY,
    HIERARCHYNODE,
    VALIDITYENDDATE,
    HIERARCHYNODELEVEL,
    HIERARCHYNODESEQUENCE,
    NODETYPE,
    PARENTNODE,
    SALESORGANIZATION,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CNSLDTNSALESORGHIERARCHY, HIERARCHYNODE, VALIDITYENDDATE)
);

Learn More