FCLM_CRL

Transparent Table Application Table
4 Fields 7 CDS Views

Line item table for cash reconciliation

FCLM_CRL is an SAP database table in S/4HANA. Line item table for cash reconciliation. It contains 4 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_CshRecnclnGroupItemBasic view from BASIC Cash Reconciliation Group Line Item
P_ACTUALFLOW_PAST90DAYS view_entity left_outer COMPOSITE Actual Flows for Past 90 Days
P_CASHPOSITION_TODAY view_entity left_outer COMPOSITE Cash Position Today
P_FORECASTFLOW_90DAYS view_entity left_outer COMPOSITE Liquidity Forecast Flows in 90 Days
P_RECNCLN_ACCID view inner BASIC ACC ID of reconciliation ID
P_RecnclnRsltComprn view left_outer BASIC Compare reconciliation results
P_RECONCILIATION_STATUS view from BASIC P_RECONCILIATION_STATUS

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reconciliation_id fclm_reconciliation_id Reconciliation Key
KEY flow_id fqm_flow_id Flow ID
valid_from timestampl Time Stamp

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 table for cash reconciliation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_CRL (
    MANDT,              -- Client [mandt]
    RECONCILIATION_ID,  -- Reconciliation Key [fclm_reconciliation_id]
    FLOW_ID,            -- Flow ID [fqm_flow_id]
    VALID_FROM,         -- Time Stamp [timestampl]
    PRIMARY KEY (MANDT, RECONCILIATION_ID, FLOW_ID)
);

Learn More