_HIERARCHYTEXT

8 Fields

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

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 1
KEY CnsldtnSubitemCategory CnsldtnSubitemCategory 1
KEY CnsldtnUniversalHierarchy ConsolidationUnitHierarchy 1
KEY Language Language 38
KEY ValidityEndDate ValidityEndDate 33
_Language _Language 11
UniversalHierarchyText AdditionalMasterDataHierText,CnsldtnCostCenterHierarchyText,CnsldtnFinTransTypeHierText,CnsldtnFSItemHierarchyText,CnsldtnMaterialHierarchyText,CnsldtnProfitCenterHierText,ConsolidationGroupHierText,ConsolidationRptgItemHierText,ConsolidationSegmentHierText,ConsolidationUnitHierarchyText,FunctionalAreaHierarchyName 17
ValidityStartDate ValidityStartDate 33

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 (
    CHARTOFACCOUNTS,
    CNSLDTNSUBITEMCATEGORY,
    CNSLDTNUNIVERSALHIERARCHY,
    LANGUAGE,
    VALIDITYENDDATE,
    _LANGUAGE,
    UNIVERSALHIERARCHYTEXT,
    VALIDITYSTARTDATE,
    PRIMARY KEY (CHARTOFACCOUNTS, CNSLDTNSUBITEMCATEGORY, CNSLDTNUNIVERSALHIERARCHY, LANGUAGE, VALIDITYENDDATE)
);

Learn More