FCLM_MMRD_D

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.

-- Draft table for entity R_MEMORECORDTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_MMRD_D (
    MANDT,                           -- Client [mandt]
    MEMORECORD,                      -- Memo Record [fclm_mr_doc_id]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    MEMORECORDDESCRIPTION,           -- Text [fdsgt]
    COMPANYCODE,                     -- Company Code [bukrs]
    MEMORECORDCATEGORY,              -- Memo Record Category [fclm_mr_mmrd_category]
    MEMORECORDTYPE,                  -- Memo Recd Type [dsart]
    MEMORECORDTYPEFORCREATE,         -- Memo Recd Type [dsart]
    PLANNINGLEVEL,                   -- Planning Level [fdlev]
    TRANSACTIONDATE,                 -- Value Date [fclm_mr_mmrd_date]
    EXPIRATIONDATE,                  -- Archiving date [avdat]
    MEMORECORDEXPIRATIONDATETIME,    -- fclm_mr_expiration_datetime
    MEMORECORDSTATUS_2,              -- Memo Record Status [fclm_mr_mmrd_status]
    MEMORECORDSTATUS,                -- Memo Record Status [fclm_mr_mmrd_status]
    BANKACCOUNTINTERNALID,           -- Bank Account ID [fclm_mr_acc_id]
    MEMORECORDBALANCEDATEDIMENSION,  -- fclm_mr_mmrd_date_dim
    AMOUNTINTRANSACTIONCURRENCY,     -- Amount in Transaction Currency [fis_wsl]
    TRANSACTIONCURRENCY,             -- Transaction Currency [fis_rwcur]
    AMOUNTINCOMPANYCODECURRENCY,     -- Amount in Company Code Currency [fis_hsl]
    COMPANYCODECURRENCY,             -- Company Code Currency [fis_hwaer]
    CASHFLOWRECONCILIATIONBUNDLE,    -- Reconciliation Bundle [fclm_rcn_bndl]
    CASHPLANNINGGROUP,               -- Planning group [fdgrp]
    LIQUIDITYITEM,                   -- Liquidity Item [flqpos]
    BANKSTATEMENTSHORTID,            -- Statement Short Key [farp_kukey]
    BANKSTATEMENTITEM,               -- Line Item No. [farp_esnum]
    BANKSTATEMENT,                   -- Bank Statement No. [aznum_lg_eb]
    PROFITCENTER,                    -- Profit Center [prctr]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    FINANCIALMANAGEMENTAREA,         -- FM Area [fikrs]
    FUND,                            -- Fund [bp_geber]
    GRANTID,                         -- Grant [gm_grant_nbr]
    BUSINESSAREA,                    -- Business Area [gsber]
    MEMORECORDSTATISTICSINDICATOR,   -- Statistics Ind. [stknz]
    FINANCIALINSTRCHARACTERISTIC,    -- Characteristics [merkm]
    MEMORECORDCHARACTERISTIC,        -- Characteristics [merkm]
    MEMORECORDINTERNALREFERENCE,     -- Reference [refer]
    BANKSTATEMENTDATE,               -- Statement Date [azdat_eb]
    COMPANYCODENAME,                 -- Company Name [butxt]
    PROFITCENTERVALIDITYENDDATE,     -- Valid To [datbi]
    CREATIONDATE,                    -- Entry Date [hzdat]
    LASTCHANGEDATE,                  -- Changed On [aendt]
    MEMORECORDSTATUSCRITICALITY,     -- INT1 [int1]
    MEMORECDEXPRTNCRITLTY,           -- INT1 [int1]
    MEMORECORDCHANNEL,               -- Memo Record Channel [fclm_mr_mmrd_channel]
    HOUSEBANK,                       -- House Bank [farp_hbkid]
    HOUSEBANKACCOUNT,                -- House Bank Account [fac_hktid]
    MEMORECORDIMPORT,                -- Memo Record Import ID [fclm_mr_imprt_id]
    GLACCOUNT,                       -- G/L Account [fis_racct]
    POSTINGDATE,                     -- Posting Date [fis_budat]
    MEMORECDOFFSTGBKACCTINTERNALID,  -- fclm_mr_mmrd_offset_acc_id
    MEMORECDOFFSETTINGCOMPANYCODE,   -- fclm_mr_mmrd_offset_cocd
    MEMORECDOFFSTGCOCODENAME,        -- fclm_mr_mmrd_offset_cocd_name
    OFFSETTINGMEMORECORD,            -- fclm_mr_mmrd_offset_doc_id
    MEMORECORDOFFSETTINGHOUSEBANK,   -- fclm_mr_mmrd_offset_hbkid
    MEMORECDOFFSTGHOUSEBANKACCOUNT,  -- fclm_mr_mmrd_offset_hktid
    MEMORECDOFFSTGTRANSACTIONDATE,   -- fclm_mr_mmrd_offset_date
    MEMORECORDPAIRINGREASON,         -- fclm_mr_mmrd_pairing_reason
    MEMORECORDISLEADINGDOCUMENT,     -- fclm_mr_mmrd_is_leading_doc
    BANKACCOUNTNUMBER,               -- Account Number [fclm_bam_acc_num]
    LASTCHANGEDATETIME,              -- Changed On [abp_lastchange_tstmpl]
    CREATEDBYUSER,                   -- Created By [abp_creation_user]
    CREATIONDATETIME,                -- Created On [abp_creation_tstmpl]
    LASTCHANGEBYUSER,                -- Changed By [abp_lastchange_user]
    LOCALLASTCHANGEDATETIME,         -- Changed On [abp_locinst_lastchange_tstmpl]
    MEMORECORDTYPEISRQDFORAPPROVE,   -- fclm_mr_mmrd_release
    PRIMARY KEY (MANDT, MEMORECORD, DRAFTUUID)
);