TF070

Transparent Table Customizing Table
13 Fields 4 CDS Views

Replikation von Hierarchien der Konsolidierung

TF070 is an SAP database table in S/4HANA. Replikation von Hierarchien der Konsolidierung. It contains 13 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_CnsldtnGrpHierNode view from BASIC Consolidation Group Hiearchy Node
I_CnsldtnUnitHierNode view from BASIC Consolidation Unit Hierarchy Node
I_CnsldtnUnitHierNodeEnhcd view from BASIC Consolidation Unit Hierarchy Node
P_CnsldtnGroupStructurePeriod view from BASIC validity

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hryid fc_hryid Hier. ID
KEY hryver fc_strvs Version: Structures
KEY hrytyp fc_hrytype Hier. Type
KEY nodecls fc_nodecls Node Class
KEY hrynode fc_hrynode Node
KEY parnode fc_parnode Higher-Level Node
KEY hryvalto datbi Valid To
hryvalfrom datab Valid From
nodetype fc_nodetyp Node Type
nodevalue fc_nodevalue Value
hryseqnbr fc_hryseqnbr Sequence Number
hrylevel fc_hrylevel Hierarchy Level

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.

-- Replikation von Hierarchien der Konsolidierung
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TF070 (
    MANDT,       -- Client [mandt]
    HRYID,       -- Hier. ID [fc_hryid]
    HRYVER,      -- Version: Structures [fc_strvs]
    HRYTYP,      -- Hier. Type [fc_hrytype]
    NODECLS,     -- Node Class [fc_nodecls]
    HRYNODE,     -- Node [fc_hrynode]
    PARNODE,     -- Higher-Level Node [fc_parnode]
    HRYVALTO,    -- Valid To [datbi]
    HRYVALFROM,  -- Valid From [datab]
    NODETYPE,    -- Node Type [fc_nodetyp]
    NODEVALUE,   -- Value [fc_nodevalue]
    HRYSEQNBR,   -- Sequence Number [fc_hryseqnbr]
    HRYLEVEL,    -- Hierarchy Level [fc_hrylevel]
    PRIMARY KEY (MANDT, HRYID, HRYVER, HRYTYP, NODECLS, HRYNODE, PARNODE, HRYVALTO)
);

Learn More