T037

Transparent Table Customizing Table
10 Fields 5 CDS Views

Memo Record Types

T037 is an SAP database table in S/4HANA. Memo Record Types. It contains 10 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_MemoRecordType view_entity from BASIC Memo Record Type
V_FDES_PLT view from FDES Planning Type Derivation
V_FDES_PT view from FDES Planning Type
V_PLT_COUNT view from Count of Planning Type
V_PLT_SINGLE view inner Planning Type Single Mapping

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY dsart dsart Memo Recd Type
ebene fdlev Planning Level
archk aklas Archiving cat.
xauvf xauvf Auto Expiration
numkr numkr Number Range
auswa fau64 Field Selection (Length 64)
mmrd_cat fclm_mr_mmrd_category Memo Record Category
enable_release fclm_mr_mmrd_release
auto_expiration fclm_mr_auto_expiration

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.

-- Memo Record Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T037 (
    MANDT,            -- Client [mandt]
    DSART,            -- Memo Recd Type [dsart]
    EBENE,            -- Planning Level [fdlev]
    ARCHK,            -- Archiving cat. [aklas]
    XAUVF,            -- Auto Expiration [xauvf]
    NUMKR,            -- Number Range [numkr]
    AUSWA,            -- Field Selection (Length 64) [fau64]
    MMRD_CAT,         -- Memo Record Category [fclm_mr_mmrd_category]
    ENABLE_RELEASE,   -- fclm_mr_mmrd_release
    AUTO_EXPIRATION,  -- fclm_mr_auto_expiration
    PRIMARY KEY (MANDT, DSART)
);

Learn More