FCLM_BRM_COND_I

Transparent Table Application Table
41 Fields 3 CDS Views

Bank Condition Item

FCLM_BRM_COND_I is an SAP database table in S/4HANA. Bank Condition Item. It contains 41 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BankConditionItemTP view from TRANSACTIONAL Bank Condition Items
I_BankFeeConditionItem view from BASIC Bank Fee Condition Item
R_BankFeeConditionItemTP view_entity from TRANSACTIONAL Bank fee condition item

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandant MANDT Client
KEY condarea BKK_CONDAR Condition Area
KEY cond BKK_CON Condition
KEY validfrom FCLM_BRM_FROM_DATE From Date
KEY condlevel BKK_LEVEL Levels
amountlim BKK_AMTLIM Amount Limit
ind_amount BKK_INDAMT Amt.from Acct.
countfrom BKK_CFROM Number from
validto FCLM_BRM_TO_DATE To Date
ultimo BKK_ULTIMO Month-end
pkond BKK_PKOND Percentage rate
szsref BKK_SZSREF Interest ref
markup BKK_MARKUP Markup/markdown
lowlimit BKK_LOWLIM Min. Int. Rate
uplimit BKK_UPLIM Max. int. rate
amount BKK_AMOUNT Amount
lowamount BKK_LWAMNT Min. amount
upamount BKK_UPAMNT Maximum amount
devider BKK_DEVIDE Divisor
curr WAERS Currency
numbdays BKK_NODAYS Number of days
flglock BKK_FLGLOC Block Indicator
toldays_p BKK_TOLD_P Tol.Dy.Val.Max.
toldays_m BKK_TOLD_M Tol.Dy.Val.Min
xcalendar BKK_XCAL Shift to Work. Day
xexpint BKK_XEXPINT Exponential
ammrhyzv BKK_AMMRHYZV Int.sttlm.freq
new_amount FCLM_BANK_FEE_AMOUNT Bank Fee Amount
amountlim_avg BKK_AMTLIM_AVG Average Amt Lim
amountlim_combo BKK_AMTLIM_COMBO Comb. Amt Limit
amountlim_c_avg BKK_AMTLIM_C_AVG CombAvAmt Limit
cruser BKK_CRUSER Created by
crdate BKK_CRDATE Created on
crtime BKK_CRTIME Created at
chguser BKK_CHUSER Changed by
chgdate BKK_CHDATE Changed on
chgtime BKK_CHTIME Changed at
reluser BKK_RLUSER Release by
reldate BKK_RLDATE Release on
reltime BKK_RLTIME Release at
last_change_datetime FCLM_BRM_LASTCHANGEDATETIME Last 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 Condition Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BRM_COND_I (
    MANDANT,               -- Client [MANDT]
    CONDAREA,              -- Condition Area [BKK_CONDAR]
    COND,                  -- Condition [BKK_CON]
    VALIDFROM,             -- From Date [FCLM_BRM_FROM_DATE]
    CONDLEVEL,             -- Levels [BKK_LEVEL]
    AMOUNTLIM,             -- Amount Limit [BKK_AMTLIM]
    IND_AMOUNT,            -- Amt.from Acct. [BKK_INDAMT]
    COUNTFROM,             -- Number from [BKK_CFROM]
    VALIDTO,               -- To Date [FCLM_BRM_TO_DATE]
    ULTIMO,                -- Month-end [BKK_ULTIMO]
    PKOND,                 -- Percentage rate [BKK_PKOND]
    SZSREF,                -- Interest ref [BKK_SZSREF]
    MARKUP,                -- Markup/markdown [BKK_MARKUP]
    LOWLIMIT,              -- Min. Int. Rate [BKK_LOWLIM]
    UPLIMIT,               -- Max. int. rate [BKK_UPLIM]
    AMOUNT,                -- Amount [BKK_AMOUNT]
    LOWAMOUNT,             -- Min. amount [BKK_LWAMNT]
    UPAMOUNT,              -- Maximum amount [BKK_UPAMNT]
    DEVIDER,               -- Divisor [BKK_DEVIDE]
    CURR,                  -- Currency [WAERS]
    NUMBDAYS,              -- Number of days [BKK_NODAYS]
    FLGLOCK,               -- Block Indicator [BKK_FLGLOC]
    TOLDAYS_P,             -- Tol.Dy.Val.Max. [BKK_TOLD_P]
    TOLDAYS_M,             -- Tol.Dy.Val.Min [BKK_TOLD_M]
    XCALENDAR,             -- Shift to Work. Day [BKK_XCAL]
    XEXPINT,               -- Exponential [BKK_XEXPINT]
    AMMRHYZV,              -- Int.sttlm.freq [BKK_AMMRHYZV]
    NEW_AMOUNT,            -- Bank Fee Amount [FCLM_BANK_FEE_AMOUNT]
    AMOUNTLIM_AVG,         -- Average Amt Lim [BKK_AMTLIM_AVG]
    AMOUNTLIM_COMBO,       -- Comb. Amt Limit [BKK_AMTLIM_COMBO]
    AMOUNTLIM_C_AVG,       -- CombAvAmt Limit [BKK_AMTLIM_C_AVG]
    CRUSER,                -- Created by [BKK_CRUSER]
    CRDATE,                -- Created on [BKK_CRDATE]
    CRTIME,                -- Created at [BKK_CRTIME]
    CHGUSER,               -- Changed by [BKK_CHUSER]
    CHGDATE,               -- Changed on [BKK_CHDATE]
    CHGTIME,               -- Changed at [BKK_CHTIME]
    RELUSER,               -- Release by [BKK_RLUSER]
    RELDATE,               -- Release on [BKK_RLDATE]
    RELTIME,               -- Release at [BKK_RLTIME]
    LAST_CHANGE_DATETIME,  -- Last Changed At [FCLM_BRM_LASTCHANGEDATETIME]
    PRIMARY KEY (MANDANT, CONDAREA, COND, VALIDFROM, CONDLEVEL)
);

Learn More