MMSTOITMNOTE_D

Transparent Table Application Table
10 Fields 1 CDS Views

Draft table for entity R_STOITEMNOTETP

MMSTOITMNOTE_D is an SAP database table in S/4HANA. Draft table for entity R_STOITEMNOTETP. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_STOItemNoteDraft view_entity from BASIC Item Note for STO - Draft

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stocktransportorder vdm_stocktransportorder STO Number
KEY stocktransportorderitem vdm_stocktransportorderitem STO Item
KEY textobjecttype tdid Text ID
KEY language spras Language
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
plainlongtext esh_e_sr_longtext Long Text
stoitemuniqueid purchasingdocumentitemuniqueid Document Item
stktransptorddraftuuid sdraft_uuid Draft Document ID

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_STOITEMNOTETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSTOITMNOTE_D (
    MANDT,                    -- Client [mandt]
    STOCKTRANSPORTORDER,      -- STO Number [vdm_stocktransportorder]
    STOCKTRANSPORTORDERITEM,  -- STO Item [vdm_stocktransportorderitem]
    TEXTOBJECTTYPE,           -- Text ID [tdid]
    LANGUAGE,                 -- Language [spras]
    DRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,          -- Draft Document ID [sdraft_uuid]
    PLAINLONGTEXT,            -- Long Text [esh_e_sr_longtext]
    STOITEMUNIQUEID,          -- Document Item [purchasingdocumentitemuniqueid]
    STKTRANSPTORDDRAFTUUID,   -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, STOCKTRANSPORTORDER, STOCKTRANSPORTORDERITEM, TEXTOBJECTTYPE, LANGUAGE, DRAFTUUID)
);

Learn More