MMSRCGPROJ_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_SOURCINGPROJECTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPROJ_D (
    MANDT,                          -- Client [mandt]
    SOURCINGPROJECTUUID,            -- Sourcing Project UUID [vdm_sourcingprojectuuid]
    SOURCINGPROJECT,                -- Sourcing Project [vdm_sourcingproject]
    SOURCINGPROJECTVERSION,         -- Sourcing Project Version [vdm_sourcingprojectversion]
    SOURCINGPROJECTTYPE,            -- Sourcing Project Type [mm_pur_srcgproj_type]
    SOURCINGPROJECTNAME,            -- Name [vdm_sourcingprojectname]
    SRCGPROJLIFECYCLESTATUS,        -- Status [vdm_srcgprojectlfcycsts]
    SRCGPROJAPPROVALSTATUS,         -- Approval Status [vdm_srcgprojectapprvlsts]
    SOURCINGPROJECTPHASE,           -- Phase [mm_pur_srcgproj_phase]
    SOURCINGSUPPLIERLISTUUID,       -- Supplier List UUID [vdm_supplierlistuuid]
    SRCGPROJREVISIONSTS,            -- Revision Status [vdm_srcgprojrevisionsts]
    SRCGPROJACTVTNSTS,              -- Activation Status [vdm_srcgprojactvtnsts]
    SRCGPROJPUBGSTS,                -- Publishing Status [vdm_srcgprojpubgsts]
    COMPANYCODE,                    -- Company Code [bukrs]
    PURCHASINGGROUP,                -- Purch. Group [bkgrp]
    PURCHASINGORGANIZATION,         -- Purchasing Organization [ekorg_ll]
    MATERIALGROUP,                  -- Material Group [matkl]
    PURCHASINGCATEGORY,             -- Purchasing Category [/srmsmc/purchasing_category_id]
    DOCUMENTCURRENCY,               -- Document Currency [vdm_documentcurrency]
    SRCGPROJTOTALTARGETAMOUNT,      -- Total Target Amount [vdm_srcgprojtotaltargetamount]
    PURCHASERRESPWORKAGREEMENT,     -- Purchaser Responsible [vdm_purchaserresponsible]
    QTNLATESTSUBMISSIONDATETIME,    -- Submission Deadline [vdm_submissiondatetime]
    LASTCHANGEDBYUSER,              -- Changed By [vdm_lastchangedbyuserid]
    CREATEDBYUSER,                  -- Created By [vdm_createdbyuserid]
    LASTCHANGEDATETIME,             -- Last Changed On [vdm_lastchangedon]
    CREATIONDATETIME,               -- Created On [vdm_srcgprojcreationdate]
    INCOTERMSCLASSIFICATION,        -- Incoterms [inco1]
    INCOTERMSTRANSFERLOCATION,      -- Incoterms 2 [inco2]
    INCOTERMSVERSION,               -- Inco. Version [incov]
    INCOTERMSLOCATION1,             -- Inco. Location1 [inco2_l]
    INCOTERMSLOCATION2,             -- Inco. Location2 [inco3_l]
    PAYMENTTERMS,                   -- Payment Terms [farp_dzterm]
    CASHDISCOUNT1DAYS,              -- Days 1 [dzbd1t]
    CASHDISCOUNT2DAYS,              -- Days 2 [dzbd2t]
    CASHDISCOUNT1PERCENT,           -- CD Percentage 1 [dzbd1p]
    CASHDISCOUNT2PERCENT,           -- CD Percentage 2 [dzbd2p]
    NETPAYMENTDAYS,                 -- Days Net [dzbd3t]
    SRCGPROJPUBGDTETME,             -- Published On [vdm_srcgprojpubgdtetme]
    SRCGPROJCANCDTETME,             -- Canceled On [vdm_srcgprojcancdtetme]
    SRCGPROJATTCHSAREFORBIDDEN,     -- Forbid Attachments [vdm_srcgprojattchsareforbidden]
    SRCGPROJNOTESAREFORBIDDEN,      -- Forbid Notes [vdm_srcgprojnotesareforbidden]
    SRCGPROJFOLLOWONDOCUMENTCAT,    -- Follow-On Document Category [followondoccat]
    SRCGPROJFOLLOWONDOCUMENTTYPE,   -- Follow-On Document Type [followondoctype]
    PURCONTRVALIDITYSTARTDATE,      -- Validity Start [kdatb]
    PURCONTRVALIDITYENDDATE,        -- Validity End [kdate]
    EXCHANGERATETYPE,               -- Exch. Rate Type [kurst]
    SOURCINGORIGIN,                 -- Sourcing Origin [vdm_sourcingorigin]
    SOURCINGSCENARIO,               -- Integration Scenario [vdm_sourcingscenario]
    EXTERNALSOURCINGPROJECTREF,     -- External Reference [vdm_externalsrcgprojreference]
    LOGICALSYSTEM,                  -- Logical System [logsystem]
    SHIPPINGINSTRUCTION,            -- Shipping Instr. [evers]
    SOURCESOURCINGPROJECTUUID,      -- Source Sourcing Project UUID [vdm_sourcesourcingprojectuuid]
    CENTRALPURCHASECONTRACT,        -- Central Purchase Contract [vdm_centralpurchasecontract]
    PROCUREMENTPLANNINGBUNDLEUUID,  -- Procurement Planning Bundle UUID [vdm_procmtplanningbundleuuid]
    SOURCINGPROJECTVERSIONINGRSN,   -- Reason [mm_pur_srcgproj_reason]
    SRCGPROJPAYMENTTERMISMANUAL,    -- Truth Value [abap_boolean]
    SOURCINGPROJECTUNIQUEID,        -- Unique ID [vdm_sourcingprojectuniqueid]
    SRCGPROJHASBEENACTIVATED,       -- abap.char
    SRCGPROJEARLIESTCNDNSELDATE,    -- Earliest Start Date for Conditions [vdm_srcgprojearliestcndnseldte]
    SRCGPROJCANCELLATIONRSN,        -- Cancelation Reason [mm_pur_srcgproj_cancel_reason]
    SRCGPROJTYPEISNOTAUTHORIZED,    -- SP Type No Authorization indicator [vdm_srcprjtypeisnotauthorized]
    PURGORGISNOTAUTHORIZED,         -- Purch. Org. No Authorization indicator [vdm_purgorgisnotauthorized]
    PURGGROUPISNOTAUTHORIZED,       -- Purch. Group No Authorization indicator [vdm_purggroupisnotauthorized]
    COMPANYCODEISNOTAUTHORIZED,     -- Company Code No Authorization indicator [vdm_companycodeisnotauthorized]
    MATERIALGROUPISNOTAUTHORIZED,   -- Mat. Group No Authorization indicator [vdm_matlgroupisnotauthorized]
    SOURCINGPROJECTTYPEFOREDIT,     -- Sourcing Project Type [vdm_sourcingprojecttypeforedit]
    PURCHASINGORGANIZATIONFOREDIT,  -- Purchasing Organization [vdm_purchorganizationforedit]
    PURCHASINGGROUPFOREDIT,         -- Purchasing Group [vdm_purchasinggroupforedit]
    COMPANYCODEFOREDIT,             -- Company Code [vdm_companycodeforedit]
    MATERIALGROUPFOREDIT,           -- Material Group [vdm_materialgroupforedit]
    PRIMARY KEY (MANDT, SOURCINGPROJECTUUID)
);