DMTDCITMSNRDRAFT

Transparent Table Application Table
8 Fields 1 CDS Views

Draft table for entity R_MATERIALDOCITEMSERIALNOTP

DMTDCITMSNRDRAFT is an SAP database table in S/4HANA. Draft table for entity R_MATERIALDOCITEMSERIALNOTP. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_MatlDocItmSerialNumberDraft view_entity from BASIC View for Matdoc Item Sernos table-draft

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY serialnumber gernr Serial Number
KEY materialdocument mblnr Material Doc.
KEY materialdocumentitem nsdm_mblpo Material Document Item
KEY materialdocumentyear nsdm_mjahr Material Document Year
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
materialdocumentdraftuuid 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_MATERIALDOCITEMSERIALNOTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMTDCITMSNRDRAFT (
    MANDT,                      -- Client [mandt]
    SERIALNUMBER,               -- Serial Number [gernr]
    MATERIALDOCUMENT,           -- Material Doc. [mblnr]
    MATERIALDOCUMENTITEM,       -- Material Document Item [nsdm_mblpo]
    MATERIALDOCUMENTYEAR,       -- Material Document Year [nsdm_mjahr]
    DRAFTUUID,                  -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,            -- Draft Document ID [sdraft_uuid]
    MATERIALDOCUMENTDRAFTUUID,  -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, SERIALNUMBER, MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR, DRAFTUUID)
);

Learn More