TTREE

Transparent Table Control Table (SAP+Cust)
21 Fields 2 CDS Views

Definition table for structures

TTREE is an SAP database table in S/4HANA. Definition table for structures. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
ris_quick_search_view view left_outer Quick Search: Ctrl.+Shift.+A
Vfs_Object_Search view union_all Search

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY id HIER_TREEG Structure ID
extension HIER_NAMES Enhancement ID
ext_key HIER_TREE External key
type HIER_TREET Structure Type
node_id HIER_GUID Unique ID
tree_id HIER_GUID Unique ID
masterlang SPRAS Language
responsibl UNAME User Name
buffermode HIER_BUFMO Buffer mode
buffervar HIER_BUFVA Buffering parameters
singlenode HIER_YESNO Flag: Yes/No
subtreeonl HIER_YESNO Flag: Yes/No
log_str HIER_LOSTR Logical Structure?
fuser HIER_FUSER CreatedBy
fdate HIER_FDATE Created on
ftime HIER_FTIME Created at
frelease SYSAPRL SAP Release
luser HIER_LUSER Last changed by
ldate HIER_LDATE Changed On
ltime HIER_LTIME Changed at
lrelease SYSAPRL SAP Release

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.

-- Definition table for structures
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TTREE (
    ID,          -- Structure ID [HIER_TREEG]
    EXTENSION,   -- Enhancement ID [HIER_NAMES]
    EXT_KEY,     -- External key [HIER_TREE]
    TYPE,        -- Structure Type [HIER_TREET]
    NODE_ID,     -- Unique ID [HIER_GUID]
    TREE_ID,     -- Unique ID [HIER_GUID]
    MASTERLANG,  -- Language [SPRAS]
    RESPONSIBL,  -- User Name [UNAME]
    BUFFERMODE,  -- Buffer mode [HIER_BUFMO]
    BUFFERVAR,   -- Buffering parameters [HIER_BUFVA]
    SINGLENODE,  -- Flag: Yes/No [HIER_YESNO]
    SUBTREEONL,  -- Flag: Yes/No [HIER_YESNO]
    LOG_STR,     -- Logical Structure? [HIER_LOSTR]
    FUSER,       -- CreatedBy [HIER_FUSER]
    FDATE,       -- Created on [HIER_FDATE]
    FTIME,       -- Created at [HIER_FTIME]
    FRELEASE,    -- SAP Release [SYSAPRL]
    LUSER,       -- Last changed by [HIER_LUSER]
    LDATE,       -- Changed On [HIER_LDATE]
    LTIME,       -- Changed at [HIER_LTIME]
    LRELEASE,    -- SAP Release [SYSAPRL]
    PRIMARY KEY (ID)
);

Learn More