FCLM_CPL_ASSGN

Transparent Table Application Table

Cash Pool Assignment

FCLM_CPL_ASSGN is an SAP database table in S/4HANA. Cash Pool Assignment. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashPoolAssgmtBasic view from BASIC Cash Pool Assignment

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pool_assgn_id fclm_cpl_assgn_id Cash Pool Assignment
pool_assgn_text fclm_cpl_assgn_text Account Name (Cash Pool)
pool_name fclm_cpl_name Cash Pool Name
is_head fclm_cpl_assgn_is_head_acc Assigned as Header
valid_from fclm_cpl_assgn_valid_from Valid From
valid_to fclm_cpl_assgn_valid_to Valid To
deleted_flag fclm_cpl_assgn_delflg Marked for Deletion
acc_id fclm_bam_acc_id Technical ID

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 Pool Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_CPL_ASSGN (
    MANDT,            -- Client [mandt]
    POOL_ASSGN_ID,    -- Cash Pool Assignment [fclm_cpl_assgn_id]
    POOL_ASSGN_TEXT,  -- Account Name (Cash Pool) [fclm_cpl_assgn_text]
    POOL_NAME,        -- Cash Pool Name [fclm_cpl_name]
    IS_HEAD,          -- Assigned as Header [fclm_cpl_assgn_is_head_acc]
    VALID_FROM,       -- Valid From [fclm_cpl_assgn_valid_from]
    VALID_TO,         -- Valid To [fclm_cpl_assgn_valid_to]
    DELETED_FLAG,     -- Marked for Deletion [fclm_cpl_assgn_delflg]
    ACC_ID,           -- Technical ID [fclm_bam_acc_id]
    PRIMARY KEY (MANDT, POOL_ASSGN_ID)
);