FCLM_CRH

Transparent Table Application Table
7 Fields 6 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. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_CshRecnclnGroupBasic view from BASIC Cash Reconciliation Group
P_ACTUALFLOW_PAST90DAYS view left_outer COMPOSITE Actual Flows for Past 90 Days
P_CASHPOSITION_TODAY view left_outer COMPOSITE Cash Position Today
P_FORECASTFLOW_90DAYS view left_outer COMPOSITE Liquidity Forecast Flows in 90 Days
P_RecnclnRsltComprn view inner BASIC
P_RECONCILIATION_STATUS view inner BASIC

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