MMSRCGPROJ_D

Transparent Table Application Table
65 Fields 2 CDS Views

Draft table for entity R_SOURCINGPROJECTTP

MMSRCGPROJ_D is an SAP database table in S/4HANA. Draft table for entity R_SOURCINGPROJECTTP. It contains 65 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SourcingProjectD view_entity from EXTENSION Sourcing Project - Extension
R_SourcingProjectDraft view_entity from BASIC Sourcing Project - Draft

Fields (65)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY sourcingprojectuuid vdm_sourcingprojectuuid Sourcing Project UUID
sourcingproject vdm_sourcingproject Sourcing Project
sourcingprojectversion vdm_sourcingprojectversion Sourcing Project Version
sourcingprojecttype mm_pur_srcgproj_type Sourcing Project Type
sourcingprojectname vdm_sourcingprojectname Name
srcgprojlifecyclestatus vdm_srcgprojectlfcycsts Status
srcgprojapprovalstatus vdm_srcgprojectapprvlsts Approval Status
sourcingprojectphase mm_pur_srcgproj_phase Phase
sourcingsupplierlistuuid vdm_supplierlistuuid Supplier List UUID
srcgprojrevisionsts vdm_srcgprojrevisionsts Revision Status
srcgprojactvtnsts vdm_srcgprojactvtnsts Activation Status
srcgprojpubgsts vdm_srcgprojpubgsts Publishing Status
companycode bukrs Company Code
purchasinggroup bkgrp Purch. Group
purchasingorganization ekorg_ll Purchasing Organization
materialgroup matkl Material Group
documentcurrency vdm_documentcurrency Document Currency
srcgprojtotaltargetamount vdm_srcgprojtotaltargetamount Total Target Amount
purchaserrespworkagreement vdm_purchaserresponsible Purchaser Responsible
purchaserresponsibleperson bu_partner Busn. Partner
qtnlatestsubmissiondatetime vdm_submissiondatetime Submission Deadline
lastchangedbyuser vdm_lastchangedbyuserid Changed By
createdbyuser vdm_createdbyuserid Created By
lastchangedatetime vdm_lastchangedon Last Changed On
creationdatetime vdm_srcgprojcreationdate Created On
incotermsclassification inco1 Incoterms
incotermstransferlocation inco2 Incoterms 2
incotermsversion incov Inco. Version
incotermslocation1 inco2_l Inco. Location1
incotermslocation2 inco3_l Inco. Location2
paymentterms farp_dzterm Payment Terms
cashdiscount1days dzbd1t Days 1
cashdiscount2days dzbd2t Days 2
cashdiscount1percent dzbd1p CD Percentage 1
cashdiscount2percent dzbd2p CD Percentage 2
netpaymentdays dzbd3t Days Net
srcgprojpubgdtetme vdm_srcgprojpubgdtetme Published On
srcgprojcancdtetme vdm_srcgprojcancdtetme Canceled On
srcgprojattchsareforbidden vdm_srcgprojattchsareforbidden Forbid Attachments
srcgprojnotesareforbidden vdm_srcgprojnotesareforbidden Forbid Notes
srcgprojfollowondocumentcat followondoccat Follow-On Document Category
srcgprojfollowondocumenttype followondoctype Follow-On Document Type
purcontrvaliditystartdate kdatb Validity Start
purcontrvalidityenddate kdate Validity End
exchangeratetype kurst Exch. Rate Type
sourcingorigin vdm_sourcingorigin Sourcing Origin
sourcingscenario vdm_sourcingscenario Integration Scenario
externalsourcingprojectref vdm_externalsrcgprojreference External Reference
logicalsystem logsystem Logical System
shippinginstruction evers Shipping Instr.
sourcesourcingprojectuuid vdm_sourcesourcingprojectuuid Source Sourcing Project UUID
centralpurchasecontract vdm_centralpurchasecontract Central Purchase Contract
procurementplanningbundleuuid vdm_procmtplanningbundleuuid Procurement Planning Bundle UUID
sourcingprojectversioningrsn mm_pur_srcgproj_reason Reason
srcgprojpaymenttermismanual abap_boolean Truth Value
sourcingprojectuniqueid vdm_sourcingprojectuniqueid Unique ID
srcgprojhasbeenactivated abap.char
srcgprojearliestcndnseldate vdm_srcgprojearliestcndnseldte Earliest Start Date for Conditions
srcgprojcancellationrsn mm_pur_srcgproj_cancel_reason Cancelation Reason
sourcingprojecttypeforedit mm_pur_srcgproj_type Sourcing Project Type
purchasingorganizationforedit ekorg_ll Purchasing Organization
purchasinggroupforedit bkgrp Purch. Group
companycodeforedit bukrs Company Code
materialgroupforedit matkl Material Group

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]
    DOCUMENTCURRENCY,               -- Document Currency [vdm_documentcurrency]
    SRCGPROJTOTALTARGETAMOUNT,      -- Total Target Amount [vdm_srcgprojtotaltargetamount]
    PURCHASERRESPWORKAGREEMENT,     -- Purchaser Responsible [vdm_purchaserresponsible]
    PURCHASERRESPONSIBLEPERSON,     -- Busn. Partner [bu_partner]
    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]
    SOURCINGPROJECTTYPEFOREDIT,     -- Sourcing Project Type [mm_pur_srcgproj_type]
    PURCHASINGORGANIZATIONFOREDIT,  -- Purchasing Organization [ekorg_ll]
    PURCHASINGGROUPFOREDIT,         -- Purch. Group [bkgrp]
    COMPANYCODEFOREDIT,             -- Company Code [bukrs]
    MATERIALGROUPFOREDIT,           -- Material Group [matkl]
    PRIMARY KEY (MANDT, SOURCINGPROJECTUUID)
);

Learn More