FCLM_MMRD

Transparent Table Application Table
35 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 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MemoRecord_2 view from BASIC Memo Record

Fields (35)

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
created_on HZDAT Entry Date
changed_on AENDT Changed On
created_by ABP_CREATION_USER Created By
changed_by ABP_LASTCHANGE_USER Changed By
created_at ABP_CREATION_TSTMPL Created On
changed_at ABP_LASTCHANGE_TSTMPL Changed On
local_changed_at ABP_LOCINST_LASTCHANGE_TSTMPL Changed On

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]
    CREATED_ON,                      -- Entry Date [HZDAT]
    CHANGED_ON,                      -- Changed On [AENDT]
    CREATED_BY,                      -- Created By [ABP_CREATION_USER]
    CHANGED_BY,                      -- Changed By [ABP_LASTCHANGE_USER]
    CREATED_AT,                      -- Created On [ABP_CREATION_TSTMPL]
    CHANGED_AT,                      -- Changed On [ABP_LASTCHANGE_TSTMPL]
    LOCAL_CHANGED_AT,                -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    PRIMARY KEY (MANDT, DOCUMENT_ID)
);

Learn More