MMSTOHEADER_D

Transparent Table Application Table
33 Fields 2 CDS Views

Draft table for entity R_STOCKTRANSPORTORDERTP

MMSTOHEADER_D is an SAP database table in S/4HANA. Draft table for entity R_STOCKTRANSPORTORDERTP. It contains 33 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_StockTransportOrderDraft view_entity from EXTENSION Stock Transport Order - Extension
R_StockTransportOrderDraft view_entity from BASIC Stock Transport Order - Draft

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY stocktransportorder vdm_stocktransportorder STO Number
KEY draftuuid sdraft_uuid Draft Document ID
stocktransportordertype esart Document Type
createdbyuser mmpur_ernam Created By
creationdate mmpur_erdat Created On
stocktransportorderdate ebdat Document Date
lastchangedatetime changedatetime Last Changed
language spras Language
purchasingdocumentdeletioncode eloek Del. Indicator
releaseisnotcompleted frgrl Subj.to Release
companycode bukrs Company Code
purchasingorganization ekorg Purchasing Org.
purchasinggroup bkgrp Purch. Group
supplier lifnr Supplier
supplierrespsalespersonname everk Salesperson
supplierphonenumber telfnr0 Supplier Phone
supplyingplant reswk Supplying Plant
documentcurrency waers Currency
incotermsclassification inco1 Incoterms
incotermstransferlocation inco2 Incoterms 2
incotermsversion incov Inco. Version
incotermslocation1 inco2_l Inco. Location1
incotermslocation2 inco3_l Inco. Location2
isintrastatreportingrelevant intra_rel Intrastat rel.
isintrastatreportingexcluded intra_excl exclude Intra
vatregistrationcountry stceg_l CtryRgnSlsTxNo.
customer kunnr Customer
manualsupplieraddressid ad_addrnum Address Number
customeraddressid adrnr Address
plantaddressid adrnr Address
supplieraddressid adrnr Address
purchasingdocumentprocesscode mmpur_process_indicator Process Indicator

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_STOCKTRANSPORTORDERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSTOHEADER_D (
    MANDT,                           -- Client [mandt]
    STOCKTRANSPORTORDER,             -- STO Number [vdm_stocktransportorder]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    STOCKTRANSPORTORDERTYPE,         -- Document Type [esart]
    CREATEDBYUSER,                   -- Created By [mmpur_ernam]
    CREATIONDATE,                    -- Created On [mmpur_erdat]
    STOCKTRANSPORTORDERDATE,         -- Document Date [ebdat]
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    LANGUAGE,                        -- Language [spras]
    PURCHASINGDOCUMENTDELETIONCODE,  -- Del. Indicator [eloek]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [frgrl]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    PURCHASINGGROUP,                 -- Purch. Group [bkgrp]
    SUPPLIER,                        -- Supplier [lifnr]
    SUPPLIERRESPSALESPERSONNAME,     -- Salesperson [everk]
    SUPPLIERPHONENUMBER,             -- Supplier Phone [telfnr0]
    SUPPLYINGPLANT,                  -- Supplying Plant [reswk]
    DOCUMENTCURRENCY,                -- Currency [waers]
    INCOTERMSCLASSIFICATION,         -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,       -- Incoterms 2 [inco2]
    INCOTERMSVERSION,                -- Inco. Version [incov]
    INCOTERMSLOCATION1,              -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,              -- Inco. Location2 [inco3_l]
    ISINTRASTATREPORTINGRELEVANT,    -- Intrastat rel. [intra_rel]
    ISINTRASTATREPORTINGEXCLUDED,    -- exclude Intra [intra_excl]
    VATREGISTRATIONCOUNTRY,          -- CtryRgnSlsTxNo. [stceg_l]
    CUSTOMER,                        -- Customer [kunnr]
    MANUALSUPPLIERADDRESSID,         -- Address Number [ad_addrnum]
    CUSTOMERADDRESSID,               -- Address [adrnr]
    PLANTADDRESSID,                  -- Address [adrnr]
    SUPPLIERADDRESSID,               -- Address [adrnr]
    PURCHASINGDOCUMENTPROCESSCODE,   -- Process Indicator [mmpur_process_indicator]
    PRIMARY KEY (MANDT, STOCKTRANSPORTORDER, DRAFTUUID)
);

Learn More