MMSPQNOTE_D

Transparent Table Application Table
14 Fields 1 CDS Views

Draft table for entity R_SRCGPROJQTNNOTETP

MMSPQNOTE_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGPROJQTNNOTETP. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SrcgProjQtnNoteDraft view_entity from BASIC Note for SrcgProjQtn - Draft

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY notebasicuuid nte_id Note ID
sourcingprojectquotationuuid vdm_srcgprojquotationuuid Supplier Quotation UUID
notebasiclanguage nte_langu Lang.
notebasicobjectnodetype sbo_node_type SAP Obj Node Type
notebasictype nte_ntyname Name
notebasictitle nte_title Title
notebasicmimetype nte_mimetype MIME Type
notebasiccreatedbyuser nte_creator Created By
notebasiccreationdatetime nte_created Created At
notebasicchangedbyuser nte_changer Last Changed By
notebasicchangedatetime nte_changed Last Changed at
notebasiccontent nte_cont Content of note
srcgprojqtnnotetypeisinternal mm_pur_sp_notetype_is_internal Internal Note

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_SRCGPROJQTNNOTETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQNOTE_D (
    MANDT,                          -- Client [mandt]
    NOTEBASICUUID,                  -- Note ID [nte_id]
    SOURCINGPROJECTQUOTATIONUUID,   -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    NOTEBASICLANGUAGE,              -- Lang. [nte_langu]
    NOTEBASICOBJECTNODETYPE,        -- SAP Obj Node Type [sbo_node_type]
    NOTEBASICTYPE,                  -- Name [nte_ntyname]
    NOTEBASICTITLE,                 -- Title [nte_title]
    NOTEBASICMIMETYPE,              -- MIME Type [nte_mimetype]
    NOTEBASICCREATEDBYUSER,         -- Created By [nte_creator]
    NOTEBASICCREATIONDATETIME,      -- Created At [nte_created]
    NOTEBASICCHANGEDBYUSER,         -- Last Changed By [nte_changer]
    NOTEBASICCHANGEDATETIME,        -- Last Changed at [nte_changed]
    NOTEBASICCONTENT,               -- Content of note [nte_cont]
    SRCGPROJQTNNOTETYPEISINTERNAL,  -- Internal Note [mm_pur_sp_notetype_is_internal]
    PRIMARY KEY (MANDT, NOTEBASICUUID)
);

Learn More