_HIERARCHYTEXT

5 Fields

_HIERARCHYTEXT is an SAP database table in S/4HANA. It contains 5 fields.

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Language Language 22
KEY UniversalHierHierarchyID AdditionalMasterDataHierarchy,ConsolidationSupplierHierarchy 2
KEY ValidityEndDate ValidityEndDate 22
UniversalHierarchyText AdditionalMasterDataHierText,CnsldtnCostCenterHierarchyText,CnsldtnCustomerHierarchyText,CnsldtnFinTransTypeHierText,CnsldtnFSItemHierarchyText,CnsldtnMaterialHierarchyText,CnsldtnProfitCenterHierText,CnsldtnSupplierHierarchyText,ConsolidationGLAccountHierText,ConsolidationRptgItemHierText,ConsolidationSegmentHierText,ConsolidationUnitHierarchyText,FunctionalAreaHierarchyName,ProfitCenterHierarchyName 20
ValidityStartDate ValidityStartDate 22

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _HIERARCHYTEXT (
    LANGUAGE,
    UNIVERSALHIERHIERARCHYID,
    VALIDITYENDDATE,
    UNIVERSALHIERARCHYTEXT,
    VALIDITYSTARTDATE,
    PRIMARY KEY (LANGUAGE, UNIVERSALHIERHIERARCHYID, VALIDITYENDDATE)
);

Learn More