FCLM_BAM_HIERRT

Transparent Table Application Table

Hierarchy Node in Run Time

FCLM_BAM_HIERRT is an SAP database table in S/4HANA. Hierarchy Node in Run Time. It contains 14 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
FCLM_BAM_HIER_RTNODE view from BAM Hierarchy Runtime Version Node
I_BankAccountHierarchyNode view from BASIC Bank Account Hierarchy Node
I_BankHierarchyNode view from BASIC Bank Hierarchy Node
I_BankHierarchyNodeText view left_outer BASIC Bank Hierarchy Node Text
I_BankHierarchyNodeText view union BASIC Bank Hierarchy Node Text
P_Bankheaderquarter view from BASIC
VFCLM_BAM_DDL_HIERRTNODEATTR view from BAM Hierarchy Runtime Version Node Att

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hierid FCLM_BAM_HIERID Bank Account Group
KEY nodeid FCLM_BAM_HIERNODE Node
KEY valid_to FCLM_BAM_VALID_TO Valid To
valid_from FCLM_BAM_VALID_FROM Valid From
runtime_node BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
par_hiernode FCLM_BAM_HIERNODE Node
acc_id FCLM_BAM_ACC_ID Technical ID
childid FCLM_BAM_HIERNODE Node
nextid FCLM_BAM_HIERNODE Node
nodelevel FCLM_NODE_LEVEL Node Level
partner BU_PARTNER Busn. Partner
banks BANKS Bank Ctry/Reg.
bankl BANKK Bank Key

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.

-- Hierarchy Node in Run Time
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_HIERRT (
    MANDT,         -- Client [MANDT]
    HIERID,        -- Bank Account Group [FCLM_BAM_HIERID]
    NODEID,        -- Node [FCLM_BAM_HIERNODE]
    VALID_TO,      -- Valid To [FCLM_BAM_VALID_TO]
    VALID_FROM,    -- Valid From [FCLM_BAM_VALID_FROM]
    RUNTIME_NODE,  -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    PAR_HIERNODE,  -- Node [FCLM_BAM_HIERNODE]
    ACC_ID,        -- Technical ID [FCLM_BAM_ACC_ID]
    CHILDID,       -- Node [FCLM_BAM_HIERNODE]
    NEXTID,        -- Node [FCLM_BAM_HIERNODE]
    NODELEVEL,     -- Node Level [FCLM_NODE_LEVEL]
    PARTNER,       -- Busn. Partner [BU_PARTNER]
    BANKS,         -- Bank Ctry/Reg. [BANKS]
    BANKL,         -- Bank Key [BANKK]
    PRIMARY KEY (MANDT, HIERID, NODEID, VALID_TO)
);