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)
);