FCLM_RCN_BNDL_IT

Transparent Table Application Table
19 Fields 2 CDS Views

Cash Flow Assignments Reconciliation Bundle

FCLM_RCN_BNDL_IT is an SAP database table in S/4HANA. Cash Flow Assignments Reconciliation Bundle. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CshFlwRcnlnBndlItem view_entity from BASIC Bundle Item
I_CshFlwRcnlnBndlItmWthDeleted view_entity from BASIC Bundle Item

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY recncln_bundle fclm_rcn_bndl Reconciliation Bundle
KEY flow_id fqm_flow_id Flow ID
KEY flow_valid_from timestampl Time Stamp
recncln_strategy fclm_rcn_strategy Reconciliation Strategy
recncln_result fclm_rcn_result Reconciliation Result
acc_id fclm_bam_acc_id Technical ID
value_date valut Value date
exchange_rate_type kurst Exch. Rate Type
amount_in_bankaccount_currency fclm_amount_bnkcrcy Amount in Acct Crcy
bankaccount_currency fclm_bank_acct_currency Bank Acct Currency
amount_in_transaction_currency fclm_cp_trans_amount Transaction Amount
transaction_currency fqm_currency Currency
planning_level fdlev Planning Level
certainty_level fqm_certainty_level Certainty Level
bank_statement_short_id kukey_eb Short Key
bank_statement_item esnum_eb Memo Record No.
fidoc_line_item buzei Item
deleted_flag fclm_rcn_bndl_assgn_delflg

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.

-- Cash Flow Assignments Reconciliation Bundle
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_RCN_BNDL_IT (
    MANDT,                           -- Client [mandt]
    RECNCLN_BUNDLE,                  -- Reconciliation Bundle [fclm_rcn_bndl]
    FLOW_ID,                         -- Flow ID [fqm_flow_id]
    FLOW_VALID_FROM,                 -- Time Stamp [timestampl]
    RECNCLN_STRATEGY,                -- Reconciliation Strategy [fclm_rcn_strategy]
    RECNCLN_RESULT,                  -- Reconciliation Result [fclm_rcn_result]
    ACC_ID,                          -- Technical ID [fclm_bam_acc_id]
    VALUE_DATE,                      -- Value date [valut]
    EXCHANGE_RATE_TYPE,              -- Exch. Rate Type [kurst]
    AMOUNT_IN_BANKACCOUNT_CURRENCY,  -- Amount in Acct Crcy [fclm_amount_bnkcrcy]
    BANKACCOUNT_CURRENCY,            -- Bank Acct Currency [fclm_bank_acct_currency]
    AMOUNT_IN_TRANSACTION_CURRENCY,  -- Transaction Amount [fclm_cp_trans_amount]
    TRANSACTION_CURRENCY,            -- Currency [fqm_currency]
    PLANNING_LEVEL,                  -- Planning Level [fdlev]
    CERTAINTY_LEVEL,                 -- Certainty Level [fqm_certainty_level]
    BANK_STATEMENT_SHORT_ID,         -- Short Key [kukey_eb]
    BANK_STATEMENT_ITEM,             -- Memo Record No. [esnum_eb]
    FIDOC_LINE_ITEM,                 -- Item [buzei]
    DELETED_FLAG,                    -- fclm_rcn_bndl_assgn_delflg
    PRIMARY KEY (MANDT, RECNCLN_BUNDLE, FLOW_ID, FLOW_VALID_FROM)
);

Learn More