FCLM_BRM_COND
Bank Condition
FCLM_BRM_COND is an SAP database table in S/4HANA. Bank Condition. It contains 42 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCLM_BRM_BANK_FEE_CONDITION | view | from | Bank Fee Condition List | |
| I_BankConditionTP | view | from | TRANSACTIONAL | Bank Condition |
| I_BankFeeCondition | view | from | BASIC | Bank Fee Condition |
| R_BankFeeConditionTP | view_entity | from | TRANSACTIONAL | Bank fee condition |
Fields (42)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | condarea | BKK_CONDAR | Condition Area | |||
| KEY | cond | BKK_CON | Condition | |||
| KEY | validfrom | FCLM_BRM_FROM_DATE | From Date | |||
| chargemethod | FCLM_BRM_CHARGE_METHOD2 | Charge Method | ||||
| condcatg | BKK_CONCAT | Condit.Category | ||||
| conddif | BKK_CONDIF | 1st Diff. Type | ||||
| conddif_v1 | BKK_CONVAL | Diff.value | ||||
| conddif_2 | BKK_COND_2 | 2nd Diff. Type | ||||
| conddif_v2 | BKK_CONVAL | Diff.value | ||||
| curr | WAERS | Currency | ||||
| intmet | BKK_INTMET | Int.calc.method | ||||
| stgmeth | VVSTGMETH | Daily Method | ||||
| stgbasis | VVSTGBASIS | Base Days Meth. | ||||
| calctyp | BKK_CALCTY | Level Interval | ||||
| flgfromto | BKK_FROMTO | To amount | ||||
| flgadddebi | BKK_ADDDEB | Addit. Deb.Int. | ||||
| condtime | BKK_CONTIM | Period | ||||
| condtime_u | BKK_CONTUN | Time Unit | ||||
| timepropcalc | BKK_TIMEPROCALC | Pro Rate Calc. | ||||
| freecount | BKK_FREECT | Free Items | ||||
| exemptlim | BKK_EXLIM | Allowance | ||||
| flglocked | BKK_FLGLOC | Block Indicator | ||||
| sortf | BKK_SORTF | Sort string | ||||
| usedtill | BKK_USED | Used till | ||||
| xsurcharge | BKK_SURCHG | Markup Condit. | ||||
| sround | TFM_SROUND | Rounding Cat. | ||||
| prunit | TFMPRUNIT | Rounding unit | ||||
| adintmet | BKK_ADINTMET | PenaltyCalcMeth | ||||
| xzerolim | BKK_XZEROLIM | Zero Is Min/Max | ||||
| 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 | ||||
| x_duedate | BKK_DTE_FLG_COND_SFP_DUEDATE | SFP on Due Date | ||||
| x_vd_duedate | BKK_DTE_FLG_COND_VD_DUEDATE | VDt on Due Date | ||||
| 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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BRM_COND (
MANDT, -- Client [MANDT]
CONDAREA, -- Condition Area [BKK_CONDAR]
COND, -- Condition [BKK_CON]
VALIDFROM, -- From Date [FCLM_BRM_FROM_DATE]
CHARGEMETHOD, -- Charge Method [FCLM_BRM_CHARGE_METHOD2]
CONDCATG, -- Condit.Category [BKK_CONCAT]
CONDDIF, -- 1st Diff. Type [BKK_CONDIF]
CONDDIF_V1, -- Diff.value [BKK_CONVAL]
CONDDIF_2, -- 2nd Diff. Type [BKK_COND_2]
CONDDIF_V2, -- Diff.value [BKK_CONVAL]
CURR, -- Currency [WAERS]
INTMET, -- Int.calc.method [BKK_INTMET]
STGMETH, -- Daily Method [VVSTGMETH]
STGBASIS, -- Base Days Meth. [VVSTGBASIS]
CALCTYP, -- Level Interval [BKK_CALCTY]
FLGFROMTO, -- To amount [BKK_FROMTO]
FLGADDDEBI, -- Addit. Deb.Int. [BKK_ADDDEB]
CONDTIME, -- Period [BKK_CONTIM]
CONDTIME_U, -- Time Unit [BKK_CONTUN]
TIMEPROPCALC, -- Pro Rate Calc. [BKK_TIMEPROCALC]
FREECOUNT, -- Free Items [BKK_FREECT]
EXEMPTLIM, -- Allowance [BKK_EXLIM]
FLGLOCKED, -- Block Indicator [BKK_FLGLOC]
SORTF, -- Sort string [BKK_SORTF]
USEDTILL, -- Used till [BKK_USED]
XSURCHARGE, -- Markup Condit. [BKK_SURCHG]
SROUND, -- Rounding Cat. [TFM_SROUND]
PRUNIT, -- Rounding unit [TFMPRUNIT]
ADINTMET, -- PenaltyCalcMeth [BKK_ADINTMET]
XZEROLIM, -- Zero Is Min/Max [BKK_XZEROLIM]
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]
X_DUEDATE, -- SFP on Due Date [BKK_DTE_FLG_COND_SFP_DUEDATE]
X_VD_DUEDATE, -- VDt on Due Date [BKK_DTE_FLG_COND_VD_DUEDATE]
LAST_CHANGE_DATETIME, -- Last Changed At [FCLM_BRM_LASTCHANGEDATETIME]
PRIMARY KEY (MANDT, CONDAREA, COND, VALIDFROM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA