CMM_NB_KEYDATE

Transparent Table Application Table
12 Fields 2 CDS Views

Maturity Key Dates

CMM_NB_KEYDATE is an SAP database table in S/4HANA. Maturity Key Dates. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_NearbyMaturityKeyDate view from BASIC Nearby Maturity Key Date
P_NearbyMaturityKeyDate view_entity from BASIC Nearby Maturity Key Date

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY dcsid TBA_DCSID DCS ID
KEY period_type TBA_PERIODTYPE Period Type
KEY dcs_selection_type CPET_ERP_DCS_PERIOD_SEL_TYPE Maturity Sel. Type
KEY keydate_selection_rout CPET_ERP_KEYDATE_SEL_ROUT Maturity Sel. Rt.
KEY timing TBA_TIMING Timing
KEY tenor TBA_TENOR Time to Maturity
KEY valid_from DATUM Date
valid_to DATUM Date
keydate TBA_KEYDATE Maturity Key Date
instrument CMM_VLOGP_INSTR Differentiator
instrument_xml CMM_GMDA_INSTRUMENT_XML Intrument (XML)

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.

-- Maturity Key Dates
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_NB_KEYDATE (
    MANDT,                   -- Client [MANDT]
    DCSID,                   -- DCS ID [TBA_DCSID]
    PERIOD_TYPE,             -- Period Type [TBA_PERIODTYPE]
    DCS_SELECTION_TYPE,      -- Maturity Sel. Type [CPET_ERP_DCS_PERIOD_SEL_TYPE]
    KEYDATE_SELECTION_ROUT,  -- Maturity Sel. Rt. [CPET_ERP_KEYDATE_SEL_ROUT]
    TIMING,                  -- Timing [TBA_TIMING]
    TENOR,                   -- Time to Maturity [TBA_TENOR]
    VALID_FROM,              -- Date [DATUM]
    VALID_TO,                -- Date [DATUM]
    KEYDATE,                 -- Maturity Key Date [TBA_KEYDATE]
    INSTRUMENT,              -- Differentiator [CMM_VLOGP_INSTR]
    INSTRUMENT_XML,          -- Intrument (XML) [CMM_GMDA_INSTRUMENT_XML]
    PRIMARY KEY (MANDT, DCSID, PERIOD_TYPE, DCS_SELECTION_TYPE, KEYDATE_SELECTION_ROUT, TIMING, TENOR, VALID_FROM)
);

Learn More