MMSRCGPROJQTN

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.

-- Sourcing Project Quotation Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPROJQTN (
    MANDT,                           -- Client [mandt]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    SOURCINGPROJECTQUOTATION,        -- Supplier Quotation [vdm_sourcingprojectquotation]
    SRCGPROJQUOTATIONVERSION,        -- Version [vdm_srcgprojqtnversion]
    SOURCINGPROJECTQUOTATIONTYPE,    -- Sourcing Project Quotation Type [vdm_srcgprojquotationtype]
    SOURCINGPROJECTQUOTATIONNAME,    -- Name [vdm_srcgprojquotationname]
    SRCGPROJQUOTATIONISSIMULATED,    -- Simulated [vdm_srcgprojqtnissimulated]
    BIDDER,                          -- Business Partner [vdm_bidder]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [vdm_sourcingprojectuuid]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASINGGROUP,                 -- Purch. Group [bkgrp]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [ekorg_ll]
    SRCGPROJQTNTOTNETAMT,            -- Total Amount [vdm_srcgprojqtntotnetamt]
    SRCGPROJQTNOFFERCURRENCY,        -- Quotation Currency [vdm_spqtnoffercurrency]
    SRCGPROJQTNLIFECYCLESTATUS,      -- Status [vdm_srcgprojqtnlfcycsts]
    SRCGPROJQTNSUBMSNSTS,            -- Submission Status [vdm_srcgprojqtnsubmsnsts]
    SRCGPROJQTNREVISIONSTS,          -- Revision Status [vdm_srcgprojqtnrevisionsts]
    SRCGPROJQTNACTVTNSTS,            -- Activation Status [vdm_srcgprojqtnactvtnsts]
    SRCGPROJQTNAWARDINGSTATUS,       -- Awarding Status [vdm_srcgprojqtnawardingstatus]
    LASTCHANGEDATETIME,              -- Last Changed On [vdm_lastchangedon]
    LASTCHANGEDBYUSER,               -- Changed By [vdm_lastchangedbyuserid]
    CREATEDBYUSER,                   -- Created By [vdm_createdbyuserid]
    CREATIONDATETIME,                -- Created On [vdm_srcgprojcreationdate]
    SRCGPROJATTCHSAREFORBIDDEN,      -- Forbid Attachments [vdm_srcgprojattchsareforbidden]
    SRCGPROJNOTESAREFORBIDDEN,       -- Forbid Notes [vdm_srcgprojnotesareforbidden]
    EXTERNALSOURCINGPROJECTQTNREF,   -- External Reference [vdm_externalsrcgprojqtnref]
    SOURCINGORIGIN,                  -- Sourcing Origin [vdm_sourcingorigin]
    QTNLATESTSUBMISSIONDATETIME,     -- Submission Deadline [vdm_submissiondatetime]
    LOGICALSYSTEM,                   -- Logical System [logsystem]
    ISEOPBLOCKED,                    -- Busin. Purp. Cmpltd. [eopblocked]
    SRCGPROJQTNSUITABILITY,          -- Suitability [mm_pur_spq_suitability]
    CASHDISCOUNT1DAYS,               -- Days 1 [dzbd1t]
    CASHDISCOUNT2DAYS,               -- Days 2 [dzbd2t]
    NETPAYMENTDAYS,                  -- Days Net [dzbd3t]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [dzbd1p]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [dzbd2p]
    MATERIALGROUP,                   -- Material Group [matkl]
    SOURCINGPROJECTNEGOTIATIONUUID,  -- Negotiation UUID [vdm_srcgprojngnuuid]
    PRICINGPROCEDURE,                -- Procedure [kalsm_d]
    SOURCINGAWARDINGDATE,            -- Awarded On [vdm_sourcingawardingdate]
    SOURCESRCGPROJQUOTATIONUUID,     -- UUID of Source Supplier Quotation [vdm_sourcequotationuuid]
    PRIMARY KEY (MANDT, SOURCINGPROJECTQUOTATIONUUID)
);