GHO_HIER_DET

Transparent Table Application Table
13 Fields 2 CDS Views

Forecast Hierarchy Details

GHO_HIER_DET is an SAP database table in S/4HANA. Forecast Hierarchy Details. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_GhoCusHierDet_Db view from BASIC Custom Hierarchy Details
P_GhoCusHierDet_TL view from BASIC

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY node_id GHO_HIER_NODE_ID Object Node ID
hierarchy_name GHO_HIERARCHY_NAME Hierarchy Name
parent_id GHO_HIR_PARENT_ID Parent ID
node_name GHO_HIR_NODE_NAME Node Name
eff_date_from GHO_HIR_DET_EFF_DATE_FROM Eff. Start Date
eff_date_to GHO_HIR_DET_EFF_DATE_TO Eff End Date
node_value GHO_HIR_NODE_VALUE Node Value
node_ref GHO_NODE_REF Node Ref
created_by GHO_CREATED_BY Record Created By
created_tst GHO_DE_CREATED_ON Created On
changed_by GHO_CHANGED_BY Changed By
changed_tst GHO_DE_CHANGED_ON Changed On

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.

-- Forecast Hierarchy Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GHO_HIER_DET (
    MANDT,           -- Client [MANDT]
    NODE_ID,         -- Object Node ID [GHO_HIER_NODE_ID]
    HIERARCHY_NAME,  -- Hierarchy Name [GHO_HIERARCHY_NAME]
    PARENT_ID,       -- Parent ID [GHO_HIR_PARENT_ID]
    NODE_NAME,       -- Node Name [GHO_HIR_NODE_NAME]
    EFF_DATE_FROM,   -- Eff. Start Date [GHO_HIR_DET_EFF_DATE_FROM]
    EFF_DATE_TO,     -- Eff End Date [GHO_HIR_DET_EFF_DATE_TO]
    NODE_VALUE,      -- Node Value [GHO_HIR_NODE_VALUE]
    NODE_REF,        -- Node Ref [GHO_NODE_REF]
    CREATED_BY,      -- Record Created By [GHO_CREATED_BY]
    CREATED_TST,     -- Created On [GHO_DE_CREATED_ON]
    CHANGED_BY,      -- Changed By [GHO_CHANGED_BY]
    CHANGED_TST,     -- Changed On [GHO_DE_CHANGED_ON]
    PRIMARY KEY (MANDT, NODE_ID)
);

Learn More