FCLM_MMRD

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_MemoRecord view_entity from EXTENSION Memo record - Extension
I_MemoRecord_2 view_entity from BASIC Memo Record

Fields (36)

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
date_dimension fclm_mr_mmrd_date_dim
transaction_date fclm_mr_mmrd_date Value Date
expiration_date fclm_mr_mmrd_expiration_date
expiration_datetime fclm_mr_expiration_datetime
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
amount_in_company_code_curr fis_hsl Amount in Company Code Currency
company_code_currency fis_hwaer Company Code 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 merkm Characteristics
refer refer Reference
kukey farp_kukey Statement Short Key
esnum farp_esnum Line Item No.
azdat azdat_eb Statement Date
channel fclm_mr_mmrd_channel Memo Record Channel
hbkid farp_hbkid House Bank
hktid fac_hktid House Bank Account
gl_account fis_racct G/L Account
posting_date fis_budat Posting Date
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]
    DATE_DIMENSION,                  -- fclm_mr_mmrd_date_dim
    TRANSACTION_DATE,                -- Value Date [fclm_mr_mmrd_date]
    EXPIRATION_DATE,                 -- fclm_mr_mmrd_expiration_date
    EXPIRATION_DATETIME,             -- fclm_mr_expiration_datetime
    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]
    AMOUNT_IN_COMPANY_CODE_CURR,     -- Amount in Company Code Currency [fis_hsl]
    COMPANY_CODE_CURRENCY,           -- Company Code Currency [fis_hwaer]
    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 [merkm]
    REFER,                           -- Reference [refer]
    KUKEY,                           -- Statement Short Key [farp_kukey]
    ESNUM,                           -- Line Item No. [farp_esnum]
    AZDAT,                           -- Statement Date [azdat_eb]
    CHANNEL,                         -- Memo Record Channel [fclm_mr_mmrd_channel]
    HBKID,                           -- House Bank [farp_hbkid]
    HKTID,                           -- House Bank Account [fac_hktid]
    GL_ACCOUNT,                      -- G/L Account [fis_racct]
    POSTING_DATE,                    -- Posting Date [fis_budat]
    MEMORECORDIMPORTID,              -- Memo Record Import ID [fclm_mr_imprt_id]
    PRIMARY KEY (MANDT, DOCUMENT_ID)
);

Learn More