FCLM_CRH

Transparent Table Application Table
7 Fields 5 CDS Views

Head table for cash reconciliation

FCLM_CRH is an SAP database table in S/4HANA. Head table for cash reconciliation. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CshRecnclnGroupBasic view from BASIC Cash Reconciliation Group
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_RecnclnRsltComprn view inner BASIC Compare reconciliation results

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reconciliation_id fclm_reconciliation_id Reconciliation Key
KEY valid_from timestampl Time Stamp
valid_to timestampl Time Stamp
reconciliation_status fclm_reconciliation_status Status
comments sgtxt Text
reconciliation_type fclm_recncln_type Reconciliation Type

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.

-- Head 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_CRH (
    MANDT,                  -- Client [mandt]
    RECONCILIATION_ID,      -- Reconciliation Key [fclm_reconciliation_id]
    VALID_FROM,             -- Time Stamp [timestampl]
    VALID_TO,               -- Time Stamp [timestampl]
    RECONCILIATION_STATUS,  -- Status [fclm_reconciliation_status]
    COMMENTS,               -- Text [sgtxt]
    RECONCILIATION_TYPE,    -- Reconciliation Type [fclm_recncln_type]
    PRIMARY KEY (MANDT, RECONCILIATION_ID, VALID_FROM)
);

Learn More