MMSPITEMNOTE_D

Transparent Table Application Table
15 Fields 1 CDS Views

Draft table for entity R_SOURCINGPROJECTITEMNOTETP

MMSPITEMNOTE_D is an SAP database table in S/4HANA. Draft table for entity R_SOURCINGPROJECTITEMNOTETP. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SrcgProjItemNoteDraft view_entity from BASIC Note for Item in Srcg Proj - Draft

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY notebasicuuid nte_id Note ID
sourcingprojectitemuuid abap.raw
notebasicobjectnodetype sbo_node_type SAP Obj Node Type
notebasictype nte_ntyname Name
notebasiclanguage nte_langu Lang.
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
sourcingprojectuuid vdm_sourcingprojectuuid Sourcing Project UUID
srcprjitemnotetypeisinternal 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_SOURCINGPROJECTITEMNOTETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPITEMNOTE_D (
    MANDT,                         -- Client [mandt]
    NOTEBASICUUID,                 -- Note ID [nte_id]
    SOURCINGPROJECTITEMUUID,       -- abap.raw
    NOTEBASICOBJECTNODETYPE,       -- SAP Obj Node Type [sbo_node_type]
    NOTEBASICTYPE,                 -- Name [nte_ntyname]
    NOTEBASICLANGUAGE,             -- Lang. [nte_langu]
    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]
    SOURCINGPROJECTUUID,           -- Sourcing Project UUID [vdm_sourcingprojectuuid]
    SRCPRJITEMNOTETYPEISINTERNAL,  -- Internal Note [mm_pur_sp_notetype_is_internal]
    PRIMARY KEY (MANDT, NOTEBASICUUID)
);

Learn More