FCLM_BAM_AMD_LIM

Transparent Table Application Table

Bank Account Master Data: Overdraft Limit

FCLM_BAM_AMD_LIM is an SAP database table in S/4HANA. Bank Account Master Data: Overdraft Limit. It contains 9 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BankAccLimitTP view from TRANSACTIONAL Bank Account Limit BO active and draft
I_BankAccountOverdraftLimit view from BASIC Bank Account Overdraft Limit
I_BkAcctOvrdrftLmtWthRevision view from BASIC Bank Acct Limit with Revision
VFCLM_BAM_DDL_AMD_LIM view from

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY acc_id fclm_bam_acc_id Technical ID
KEY lim_id fclm_bam_lim_id Overdraft Limit ID
KEY revision fclm_revision Revision Number
valid_from fclm_bam_lim_valid_from Valid From
valid_to fclm_bam_lim_valid_to Valid To
amount fclm_bam_lim_amount Amount
waers waers_curc Currency
deleted_flag boole_d TRUE

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 Master Data: Overdraft Limit
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_AMD_LIM (
    MANDT,         -- Client [mandt]
    ACC_ID,        -- Technical ID [fclm_bam_acc_id]
    LIM_ID,        -- Overdraft Limit ID [fclm_bam_lim_id]
    REVISION,      -- Revision Number [fclm_revision]
    VALID_FROM,    -- Valid From [fclm_bam_lim_valid_from]
    VALID_TO,      -- Valid To [fclm_bam_lim_valid_to]
    AMOUNT,        -- Amount [fclm_bam_lim_amount]
    WAERS,         -- Currency [waers_curc]
    DELETED_FLAG,  -- TRUE [boole_d]
    PRIMARY KEY (MANDT, ACC_ID, LIM_ID, REVISION)
);