FCLM_CPL_ASSGN

Transparent Table Application Table
13 Fields 1 CDS Views

Cash Pool Assignment

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashPoolAssgmtBasic view from BASIC Cash Pool Assignment

Fields (13)

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
created_by_user FCLM_CPL_CREATEDBYUSERID Created By
last_changed_by_user FCLM_CPL_LASTCHANGEDBYUSERID Changed By
creation_date_time FCLM_CPL_CREATIONDATETIME Created At
last_change_datetime FCLM_CPL_LASTCHANGEDATETIME Changed At

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]
    CREATED_BY_USER,       -- Created By [FCLM_CPL_CREATEDBYUSERID]
    LAST_CHANGED_BY_USER,  -- Changed By [FCLM_CPL_LASTCHANGEDBYUSERID]
    CREATION_DATE_TIME,    -- Created At [FCLM_CPL_CREATIONDATETIME]
    LAST_CHANGE_DATETIME,  -- Changed At [FCLM_CPL_LASTCHANGEDATETIME]
    PRIMARY KEY (MANDT, POOL_ASSGN_ID)
);

Learn More