FLEXHIER_DIR

Transparent Table Application Table
8 Fields 5 CDS Views

Flexible Hierarchy Directory

FLEXHIER_DIR is an SAP database table in S/4HANA. Flexible Hierarchy Directory. It contains 8 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
fac_cds_fh view inner Flexible Hierarchy
fac_cds_fh_node view inner Flexible Hierarchy Node
FAC_CDS_UH_REUSE_FH_NODE_CC view inner Flexible Cost Center Hierarchy Node
FAC_CDS_UH_REUSE_FH_NODE_COCD view inner Flexible Company Code Hierarchy Node
FAC_CDS_UH_REUSE_FH_NODE_PC view inner Flexible Profit Center Hierarchy Node

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hryid hryid Hierarchy ID
KEY hryver hryversn Version
KEY hryvalto datbi Valid To
fhsequence fhsequence_raw Field Sequence
fhfilter fhfilter_raw Filter
fhcrtntime fhcrtntime Created On
fhcrtnuser fhcrtnuser Created By

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.

-- Flexible Hierarchy Directory
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLEXHIER_DIR (
    MANDT,       -- Client [mandt]
    HRYID,       -- Hierarchy ID [hryid]
    HRYVER,      -- Version [hryversn]
    HRYVALTO,    -- Valid To [datbi]
    FHSEQUENCE,  -- Field Sequence [fhsequence_raw]
    FHFILTER,    -- Filter [fhfilter_raw]
    FHCRTNTIME,  -- Created On [fhcrtntime]
    FHCRTNUSER,  -- Created By [fhcrtnuser]
    PRIMARY KEY (MANDT, HRYID, HRYVER, HRYVALTO)
);

Learn More