FCLM_MMRD

Transparent Table Application Table
28 Fields 1 CDS Views

Cash Management and Forecast: Memo Records

FCLM_MMRD is an SAP database table in S/4HANA. Cash Management and Forecast: Memo Records. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MemoRecord_2 view from BASIC Memo Record

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY document_id fclm_mr_doc_id Memo Record
description fclm_mr_desc Description
company_code bukrs Company Code
category fclm_mr_mmrd_category Memo Record Category
planning_type dsart Memo Recd Type
planning_level fdlev Planning Level
transaction_date fclm_mr_mmrd_date Value Date
expiration_date avdat Archiving date
status fclm_mr_mmrd_status Memo Record Status
acc_id fclm_mr_acc_id Bank Account ID
amount_in_transaction_currency fis_wsl Amount in Transaction Currency
transaction_currency fis_rwcur Transaction Currency
source_rcn_bndl fclm_rcn_bndl Reconciliation Bundle
liquidity_item flqpos Liquidity Item
planning_group fdgrp Planning group
profit_center prctr Profit Center
fund bp_geber Fund
grant_nbr gm_grant_nbr Grant
business_area gsber Business Area
statistics_indicator stknz Statistics Ind.
characteristics trba_characteristics Characteristics
kukey farp_kukey Statement Short Key
esnum farp_esnum Line Item No.
channel fclm_mr_mmrd_channel Memo Record Channel
hbkid farp_hbkid House Bank
hktid fac_hktid House Bank Account
memorecordimportid fclm_mr_imprt_id Memo Record Import 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 Management and Forecast: Memo Records
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_MMRD (
    MANDT,                           -- Client [mandt]
    DOCUMENT_ID,                     -- Memo Record [fclm_mr_doc_id]
    DESCRIPTION,                     -- Description [fclm_mr_desc]
    COMPANY_CODE,                    -- Company Code [bukrs]
    CATEGORY,                        -- Memo Record Category [fclm_mr_mmrd_category]
    PLANNING_TYPE,                   -- Memo Recd Type [dsart]
    PLANNING_LEVEL,                  -- Planning Level [fdlev]
    TRANSACTION_DATE,                -- Value Date [fclm_mr_mmrd_date]
    EXPIRATION_DATE,                 -- Archiving date [avdat]
    STATUS,                          -- Memo Record Status [fclm_mr_mmrd_status]
    ACC_ID,                          -- Bank Account ID [fclm_mr_acc_id]
    AMOUNT_IN_TRANSACTION_CURRENCY,  -- Amount in Transaction Currency [fis_wsl]
    TRANSACTION_CURRENCY,            -- Transaction Currency [fis_rwcur]
    SOURCE_RCN_BNDL,                 -- Reconciliation Bundle [fclm_rcn_bndl]
    LIQUIDITY_ITEM,                  -- Liquidity Item [flqpos]
    PLANNING_GROUP,                  -- Planning group [fdgrp]
    PROFIT_CENTER,                   -- Profit Center [prctr]
    FUND,                            -- Fund [bp_geber]
    GRANT_NBR,                       -- Grant [gm_grant_nbr]
    BUSINESS_AREA,                   -- Business Area [gsber]
    STATISTICS_INDICATOR,            -- Statistics Ind. [stknz]
    CHARACTERISTICS,                 -- Characteristics [trba_characteristics]
    KUKEY,                           -- Statement Short Key [farp_kukey]
    ESNUM,                           -- Line Item No. [farp_esnum]
    CHANNEL,                         -- Memo Record Channel [fclm_mr_mmrd_channel]
    HBKID,                           -- House Bank [farp_hbkid]
    HKTID,                           -- House Bank Account [fac_hktid]
    MEMORECORDIMPORTID,              -- Memo Record Import ID [fclm_mr_imprt_id]
    PRIMARY KEY (MANDT, DOCUMENT_ID)
);

Learn More