FCLM_RCN_BNDL_IT

Transparent Table Application Table
23 Fields 1 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 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CshFlwRcnlnBndlItem view from BASIC Bundle Item

Fields (23)

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
origin_system LOGSYS Logical system
origin_application FQM_ORIGIN_APPLICATION Source Application
origin_document_id FQM_ORIGIN_DOC_ID Source Doc. ID
origin_transaction_id FQM_ORIGIN_TRANS_ID Source Trans. ID
origin_trans_qualifier FQM_ORIGIN_TRANS_QUALIFIER Trans. Qualifier
origin_flow_id FQM_ORIGIN_FLOW_ID Source Flow ID
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.

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]
    ORIGIN_SYSTEM,                   -- Logical system [LOGSYS]
    ORIGIN_APPLICATION,              -- Source Application [FQM_ORIGIN_APPLICATION]
    ORIGIN_DOCUMENT_ID,              -- Source Doc. ID [FQM_ORIGIN_DOC_ID]
    ORIGIN_TRANSACTION_ID,           -- Source Trans. ID [FQM_ORIGIN_TRANS_ID]
    ORIGIN_TRANS_QUALIFIER,          -- Trans. Qualifier [FQM_ORIGIN_TRANS_QUALIFIER]
    ORIGIN_FLOW_ID,                  -- Source Flow ID [FQM_ORIGIN_FLOW_ID]
    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]
    PRIMARY KEY (MANDT, RECNCLN_BUNDLE, FLOW_ID, FLOW_VALID_FROM)
);

Learn More