FCLM_CPL_FLOW_IT

Transparent Table Application Table
18 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 18 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 from BASIC Basic View for MBTs with Template Items

Fields (18)

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

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]
    PRIMARY KEY (MANDT, FLOW_ID, DETAIL_ID)
);

Learn More