FCLM_CPL_FLOW_IT

Transparent Table Application Table
20 Fields 2 CDS Views

Line item for cash pooling

FCLM_CPL_FLOW_IT is an SAP database table in S/4HANA. Line item for cash pooling. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CshConcnLineItem view from BASIC Line Item for Cash Concentration
I_MakeBkTransfWthTmplItm view_entity from BASIC Basic View for MBTs with Template Items

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY flow_id fclm_csh_concn_id Csh Concn ID
KEY detail_id sysuuid_x UUID
currency waers Currency
pool_name fclm_cpl_name Cash Pool Name
from_bankaccountid fclm_bam_acc_id Technical ID
to_bankaccountid fclm_bam_acc_id Technical ID
payment_method hbzw2 Payment Method
reference_key prq_keyno Key Number
closing_bal fqm_amount Amount
transfer_amt fqm_amount Amount
target_bal fqm_amount Amount
after_bal fqm_amount Amount
state fclm_cpl_state Concn Status
log_handle balloghndl Handle
run_id laufi Identification
value_date valut Value date
cashmemorecordid idenr ID number
pay_flag fclm_cash_concn_payflg
channel fclm_cash_concn_channel

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.

-- Line item for cash pooling
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_CPL_FLOW_IT (
    MANDT,               -- Client [mandt]
    FLOW_ID,             -- Csh Concn ID [fclm_csh_concn_id]
    DETAIL_ID,           -- UUID [sysuuid_x]
    CURRENCY,            -- Currency [waers]
    POOL_NAME,           -- Cash Pool Name [fclm_cpl_name]
    FROM_BANKACCOUNTID,  -- Technical ID [fclm_bam_acc_id]
    TO_BANKACCOUNTID,    -- Technical ID [fclm_bam_acc_id]
    PAYMENT_METHOD,      -- Payment Method [hbzw2]
    REFERENCE_KEY,       -- Key Number [prq_keyno]
    CLOSING_BAL,         -- Amount [fqm_amount]
    TRANSFER_AMT,        -- Amount [fqm_amount]
    TARGET_BAL,          -- Amount [fqm_amount]
    AFTER_BAL,           -- Amount [fqm_amount]
    STATE,               -- Concn Status [fclm_cpl_state]
    LOG_HANDLE,          -- Handle [balloghndl]
    RUN_ID,              -- Identification [laufi]
    VALUE_DATE,          -- Value date [valut]
    CASHMEMORECORDID,    -- ID number [idenr]
    PAY_FLAG,            -- fclm_cash_concn_payflg
    CHANNEL,             -- fclm_cash_concn_channel
    PRIMARY KEY (MANDT, FLOW_ID, DETAIL_ID)
);

Learn More