MMSRCGPQTNITEM

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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPQTNITEM (
    MANDT,                           -- Client [mandt]
    SRCGPROJQTNITEMUUID,             -- Supplier Quotation Item UUID [vdm_srcgprojqtnitemuuid]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    SOURCINGPROJECTQUOTATIONITEM,    -- Item [vdm_srcgprojqtnitem]
    SOURCINGPROJECTQUOTATION,        -- Supplier Quotation [vdm_sourcingprojectquotation]
    SRCGPROJQUOTATIONVERSION,        -- Version [vdm_srcgprojqtnversion]
    SRCGPROJQUOTATIONITEMTYPE,       -- Item Type [vdm_sourcingprojectitemtype]
    SRCGPROJQTNITEMCLASSIFICATION,   -- Item Classification [vdm_srcgprojitemclassification]
    SOURCINGPROJECTITEMSTABLEUUID,   -- Stable ID [mm_srcgprojitemstableuuid]
    SRCGPROJQTNITEMDESCRIPTION,      -- Description [vdm_srcgprojqtnitemdesc]
    SOURCINGPROJECTITEMUUID,         -- Item UUID [vdm_sourcingprojectitemuuid]
    SRCGPROJQUOTATIONITEMPARENT,     -- Item Parent [vdm_srcgprojqtnitemparent]
    HIERARCHYNODELEVEL,              -- Hierarchy Node Level [vdm_hierarchynodelevel]
    ALTERNATIVEITEMID,               -- Alternative Item ID [vdm_alternativeitemid]
    FORMATTEDITEMID,                 -- Item Number [vdm_formatteditemid]
    HIERARCHYNODESUBTREESIZE,        -- Descendant Count [vdm_descendantcount]
    PLANT,                           -- Plant [ewerk]
    MATERIAL,                        -- Material [matnr]
    PRODUCTTYPE,                     -- Product Type [vdm_srcgprojproducttype]
    MATERIALGROUP,                   -- Material Group [matkl]
    REQUESTEDQUANTITY,               -- Requested Quantity [vdm_requested_quantity]
    SRCGPROJQTNOFFEREDQUANTITY,      -- Offered Quantity [vdm_offered_quantity]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [vdm_requestedquantityunit]
    NETPRICEAMOUNT,                  -- Net Price [vdm_spnetpriceamount]
    NETPRICEQUANTITY,                -- Price Unit [vdm_price_unit]
    SRCGPROJQTNITEMTOTNETAMT,        -- Total Amount [vdm_srcgprojqtnitemtotnetamt]
    ORDERPRICEUNIT,                  -- Order Price Un. [bbprm]
    SPQTNITEMPRICEMEASURE1AMOUNT,    -- Price Measure 1 [vdm_spqtnitmpricemeasureamnt1]
    SPQTNITEMPRICEMEASURE1QUANTITY,  -- Price Unit for Price Measure 1 [spqtnitmpricemeasure1quantity]
    SPQTNITEMPRICEMEASURE2AMOUNT,    -- Price Measure 2 [vdm_spqtnitmpricemeasureamnt2]
    SPQTNITEMPRICEMEASURE2QUANTITY,  -- Price Unit for Price Measure 2 [spqtnitmpricemeasure2quantity]
    SPQTNITEMPRICEMEASURE3AMOUNT,    -- Price Measure 3 [vdm_spqtnitmpricemeasureamnt3]
    SPQTNITEMPRICEMEASURE3QUANTITY,  -- Price Unit for Price Measure 3 [spqtnitmpricemeasure3quantity]
    REQUESTEDDELIVERYDATE,           -- Requested Delivery Date [vdm_requesteddeliverydate]
    PROPOSEDDELIVERYDATE,            -- Proposed Delivery Date [vdm_proposeddeliverydate]
    PERFORMANCEPERIODSTARTDATE,      -- Start of Performance Period [vdm_performanceperiodstartdate]
    PERFORMANCEPERIODENDDATE,        -- End of Performance Period [vdm_performanceperiodenddate]
    ORDERPRICEUNITTOORDERUNITNMRTR,  -- Quantity Conversion Numerator [vdm_ordprcunittoorderunitnmrtr]
    ORDPRICEUNITTOORDERUNITDNMNTR,   -- Quantity Conversion Denominator [vdm_ordprcunttoorderuntdnmntr]
    SRCGPROJQTNITEMOFFERINGCODE,     -- Item Offering Code [vdm_srcgprojqtnitmofferingcode]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [mmpur_d_source_sys]
    COMPANYCODE,                     -- Company Code [bukrs]
    PURCHASINGGROUP,                 -- Purch. Group [bkgrp]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [ekorg_ll]
    SRCGPROJNEGTTNQTANITEMUUID,      -- UUID of Quotation Item in Negotiation [vdm_srcgprojngnqtnitemuuid]
    SRCGPROJNEGTTNITMINCLUSIONTYPE,  -- Negotiation Item Include Type Code [vdm_srcgprojngnitemincludecode]
    PROCMTHUBPLANTUNIQUEID,          -- Plant Unique ID [mmpur_be_plant_unique_id]
    SRCGPROJQTNITEMEXCLUDINGRSN,     -- Reason [mm_pur_srcgproj_reason]
    SRCGPROJQTNITEMSUITABILITY,      -- Suitability [mm_pur_spq_suitability]
    SRCGPROJQTNITEMPRICINGORIGIN,    -- Item Pricing Origin [vdm_spqtnitempricingorigin]
    SRCGPROJITEMPRODFPRNTISREQD,     -- Request Product Footprint Data [vdm_srcgpitemprodfprntisreqd]
    SPQTNITEMPRODFPRNTCOLLCODE,      -- Item Product Footprint Collection Code [vdm_spqtnitemprodfprntcollcode]
    PRIMARY KEY (MANDT, SRCGPROJQTNITEMUUID)
);