MMSRCGPQTNITEM_D

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_SRCGPROJQTNITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPQTNITEM_D (
    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]
    SOURCINGORIGIN,                  -- Sourcing Origin [VDM_SOURCINGORIGIN]
    SRCGPROJQUOTATIONITEMTYPE,       -- Item Type [VDM_SOURCINGPROJECTITEMTYPE]
    SRCGPROJQTNITEMCLASSIFICATION,   -- Item Classification [VDM_SRCGPROJITEMCLASSIFICATION]
    SOURCINGPROJECTITEMSTABLEUUID,   -- Stable ID [MM_SRCGPROJITEMSTABLEUUID]
    SRCGPROJQTNITEMDESCRIPTION,      -- Description [VDM_SRCGPROJQTNITEMDESC]
    SOURCINGPROJECTITEMUUID,         -- Item UUID [VDM_SOURCINGPROJECTITEMUUID]
    PLANT,                           -- Plant [EWERK]
    MATERIAL,                        -- Material [MATNR]
    PRODUCTTYPE,                     -- Product Type [VDM_SRCGPROJPRODUCTTYPE]
    MATERIALGROUP,                   -- Material Group [MATKL]
    NETPRICEAMOUNT,                  -- Net Price [VDM_SPNETPRICEAMOUNT]
    NETPRICEQUANTITY,                -- Price Unit [VDM_PRICE_UNIT]
    SRCGPROJQTNITEMTOTNETAMT,        -- Total Amount [VDM_SRCGPROJQTNITEMTOTNETAMT]
    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]
    REQUESTEDQUANTITY,               -- Requested Quantity [VDM_REQUESTED_QUANTITY]
    SRCGPROJQTNOFFEREDQUANTITY,      -- Offered Quantity [VDM_OFFERED_QUANTITY]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [VDM_REQUESTEDQUANTITYUNIT]
    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]
    ORDERPRICEUNIT,                  -- Order Price Un. [BBPRM]
    ORDERPRICEUNITTOORDERUNITNMRTR,  -- Quantity Conversion Numerator [VDM_ORDPRCUNITTOORDERUNITNMRTR]
    ORDPRICEUNITTOORDERUNITDNMNTR,   -- Quantity Conversion Denominator [VDM_ORDPRCUNTTOORDERUNTDNMNTR]
    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]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [EKORG_LL]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [MMPUR_D_SOURCE_SYS]
    SRCGPROJQTNOFFERCURRENCY,        -- Quotation Currency [VDM_SPQTNOFFERCURRENCY]
    SRCGPROJQTNITEMOFFERINGCODE,     -- Item Offering Code [VDM_SRCGPROJQTNITMOFFERINGCODE]
    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]
    HIERARCHYNODE,                   -- abap.char
    HIERARCHYPARENTNODE,             -- abap.sstr
    HIERARCHYDISTANCEFROMROOT,       -- abap.int4
    HIERARCHYDESCENDANTCOUNT,        -- abap.int4
    HIERARCHYDRILLSTATE,             -- abap.char
    HIERARCHYRANK,                   -- Hierarchy Rank [HUM_HIERARCHY_RANK]
    SUPPLIERCOSTBREAKDOWNISENABLED,  -- Cost Breakdown [VDM_SUPLRCBDTEMPLISENABLED]
    SRCGPROJITEMPRODFPRNTISREQD,     -- Request Product Footprint Data [VDM_SRCGPITEMPRODFPRNTISREQD]
    SPQTNITEMPRODFPRNTCOLLCODE,      -- Item Product Footprint Collection Code [VDM_SPQTNITEMPRODFPRNTCOLLCODE]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_SRCGPROJQITM_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SRCGPROJQTNITEMUUID)
);