FCLM_BAM_HIER

Transparent Table Application Table
18 Fields 6 CDS Views

Bank Account Hierarchy

FCLM_BAM_HIER is an SAP database table in S/4HANA. Bank Account Hierarchy. It contains 18 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
FCLM_BAH_ACCOUNTNODE_VH view left_outer Bank Account Group Node Value Help
FCLM_BAH_UH_BANKACCGROUP view from Bank Account Group Value Help
I_BankAccountHierarchy view from BASIC Bank Account Hierarchy
I_BankHierarchy view from BASIC Bank Hierarchy
P_Bankheaderquarter view left_outer BASIC Bank Head Quarter
VFCLM_BAM_DDL_HIERARCHY view from BAM Hierarchy

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hierid fclm_bam_hierid Bank Account Group
KEY valid_to fclm_bam_valid_to Valid To
hiertype fclm_bam_hiertype Hierarchy Type
self_structed_field fieldname Field Name
self_structed_parfield fieldname Field Name
valid_from fclm_bam_valid_from Valid From
public_hier boolean Boolean Variable (X = True, - = False, Space = Unknown)
dynamic_hier boolean Boolean Variable (X = True, - = False, Space = Unknown)
child_subset boolean Boolean Variable (X = True, - = False, Space = Unknown)
par_hierid fclm_bam_hierid Bank Account Group
par_hiernodeid fclm_bam_hiernode Node
created_by fclm_bam_created_by Created By
created_on fclm_bam_created_on Created On
created_at fclm_bam_created_at Created At
changed_by fclm_bam_changed_by Changed By
changed_on fclm_bam_changed_on Changed On
changed_at fclm_bam_changed_at Changed At

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.

-- Bank Account Hierarchy
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_HIER (
    MANDT,                   -- Client [mandt]
    HIERID,                  -- Bank Account Group [fclm_bam_hierid]
    VALID_TO,                -- Valid To [fclm_bam_valid_to]
    HIERTYPE,                -- Hierarchy Type [fclm_bam_hiertype]
    SELF_STRUCTED_FIELD,     -- Field Name [fieldname]
    SELF_STRUCTED_PARFIELD,  -- Field Name [fieldname]
    VALID_FROM,              -- Valid From [fclm_bam_valid_from]
    PUBLIC_HIER,             -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    DYNAMIC_HIER,            -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    CHILD_SUBSET,            -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    PAR_HIERID,              -- Bank Account Group [fclm_bam_hierid]
    PAR_HIERNODEID,          -- Node [fclm_bam_hiernode]
    CREATED_BY,              -- Created By [fclm_bam_created_by]
    CREATED_ON,              -- Created On [fclm_bam_created_on]
    CREATED_AT,              -- Created At [fclm_bam_created_at]
    CHANGED_BY,              -- Changed By [fclm_bam_changed_by]
    CHANGED_ON,              -- Changed On [fclm_bam_changed_on]
    CHANGED_AT,              -- Changed At [fclm_bam_changed_at]
    PRIMARY KEY (MANDT, HIERID, VALID_TO)
);

Learn More