MMSRCGPROJ

Transparent Table Application Table
59 Fields 3 CDS Views

Sourcing Project Header

MMSRCGPROJ is an SAP database table in S/4HANA. Sourcing Project Header. It contains 59 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_SourcingProject view_entity from EXTENSION Sourcing Project - Extension
P_SRCGPROJ_HDR view_entity from SDM SRCGPROJ Header
R_SourcingProject view from BASIC Sourcing Project

Fields (59)

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
sourcingprojectphase MM_PUR_SRCGPROJ_PHASE Phase
srcgprojpubgsts VDM_SRCGPROJPUBGSTS Publishing Status
srcgprojactvtnsts VDM_SRCGPROJACTVTNSTS Activation Status
srcgprojrevisionsts VDM_SRCGPROJREVISIONSTS Revision 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
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
createdbyuser VDM_CREATEDBYUSERID Created By
creationdatetime VDM_SRCGPROJCREATIONDATE Created On
purchaserrespworkagreement VDM_PURCHASERRESPONSIBLE Purchaser Responsible
qtnlatestsubmissiondatetime VDM_QTNLATESTSUBMISDATETIME Submission Deadline
incotermsclassification INCO1 Incoterms
incotermstransferlocation INCO2 Incoterms 2
paymentterms FARP_DZTERM Payment Terms
cashdiscount1days FARP_DZBD1T Cash Discount Days 1
cashdiscount2days FARP_DZBD2T Cash Discount Days 2
netpaymentdays FARP_DZBD3T Days Net
cashdiscount1percent DZBD1P_FARP Disc. Percent 1
cashdiscount2percent DZBD2P_FARP Disc. Percent 2
incotermsversion INCOV Inco. Version
incotermslocation1 INCO2_L Inco. Location1
incotermslocation2 INCO3_L Inco. Location2
srcgprojpubgdtetme VDM_SRCGPROJPUBGDTETME Published On
srcgprojcancdtetme VDM_SRCGPROJCANCDTETME Canceled On
srcgprojattchsareforbidden VDM_SRCGPROJATTCHSAREFORBIDDEN Forbid Attachments
srcgprojnotesareforbidden VDM_SRCGPROJNOTESAREFORBIDDEN Forbid Notes
sourcingsupplierlistuuid VDM_SUPPLIERLISTUUID Supplier List UUID
sourcingorigin VDM_SOURCINGORIGIN Sourcing Origin
sourcingscenario VDM_SOURCINGSCENARIO Integration Scenario
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
externalsourcingprojectref VDM_EXTERNALSRCGPROJREFERENCE External Reference
logicalsystem LOGSYSTEM Logical System
sourcingprojectversioningrsn MM_PUR_SRCGPROJ_REASON Reason
dummy_srcgprojhdr_incl_eew_ps CFD_DUMMY Dummy
srcgprojapprovalstatus VDM_SRCGPROJECTAPPRVLSTS Approval Status
shippinginstruction EVERS Shipping Instr.
sourcesourcingprojectuuid VDM_SOURCESOURCINGPROJECTUUID Source Sourcing Project UUID
centralpurchasecontract VDM_CENTRALPURCHASECONTRACT Central Purchase Contract
procurementplanningbundleuuid VDM_PROCMTPLANNINGBUNDLEUUID Procurement Planning Bundle UUID
srcgprojpaymenttermismanual ABAP_BOOLEAN Truth Value
srcgprojhaspaymenttermkey ABAP_BOOLEAN Truth Value
srcgprojearliestcndnseldate VDM_SRCGPROJEARLIESTCNDNSELDTE Earliest Start Date for Conditions
srcgprojcancellationrsn MM_PUR_SRCGPROJ_CANCEL_REASON Cancelation Reason

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPROJ (
    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]
    SOURCINGPROJECTPHASE,           -- Phase [MM_PUR_SRCGPROJ_PHASE]
    SRCGPROJPUBGSTS,                -- Publishing Status [VDM_SRCGPROJPUBGSTS]
    SRCGPROJACTVTNSTS,              -- Activation Status [VDM_SRCGPROJACTVTNSTS]
    SRCGPROJREVISIONSTS,            -- Revision Status [VDM_SRCGPROJREVISIONSTS]
    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]
    LASTCHANGEDATETIME,             -- Last Changed On [VDM_LASTCHANGEDON]
    LASTCHANGEDBYUSER,              -- Changed By [VDM_LASTCHANGEDBYUSERID]
    CREATEDBYUSER,                  -- Created By [VDM_CREATEDBYUSERID]
    CREATIONDATETIME,               -- Created On [VDM_SRCGPROJCREATIONDATE]
    PURCHASERRESPWORKAGREEMENT,     -- Purchaser Responsible [VDM_PURCHASERRESPONSIBLE]
    QTNLATESTSUBMISSIONDATETIME,    -- Submission Deadline [VDM_QTNLATESTSUBMISDATETIME]
    INCOTERMSCLASSIFICATION,        -- Incoterms [INCO1]
    INCOTERMSTRANSFERLOCATION,      -- Incoterms 2 [INCO2]
    PAYMENTTERMS,                   -- Payment Terms [FARP_DZTERM]
    CASHDISCOUNT1DAYS,              -- Cash Discount Days 1 [FARP_DZBD1T]
    CASHDISCOUNT2DAYS,              -- Cash Discount Days 2 [FARP_DZBD2T]
    NETPAYMENTDAYS,                 -- Days Net [FARP_DZBD3T]
    CASHDISCOUNT1PERCENT,           -- Disc. Percent 1 [DZBD1P_FARP]
    CASHDISCOUNT2PERCENT,           -- Disc. Percent 2 [DZBD2P_FARP]
    INCOTERMSVERSION,               -- Inco. Version [INCOV]
    INCOTERMSLOCATION1,             -- Inco. Location1 [INCO2_L]
    INCOTERMSLOCATION2,             -- Inco. Location2 [INCO3_L]
    SRCGPROJPUBGDTETME,             -- Published On [VDM_SRCGPROJPUBGDTETME]
    SRCGPROJCANCDTETME,             -- Canceled On [VDM_SRCGPROJCANCDTETME]
    SRCGPROJATTCHSAREFORBIDDEN,     -- Forbid Attachments [VDM_SRCGPROJATTCHSAREFORBIDDEN]
    SRCGPROJNOTESAREFORBIDDEN,      -- Forbid Notes [VDM_SRCGPROJNOTESAREFORBIDDEN]
    SOURCINGSUPPLIERLISTUUID,       -- Supplier List UUID [VDM_SUPPLIERLISTUUID]
    SOURCINGORIGIN,                 -- Sourcing Origin [VDM_SOURCINGORIGIN]
    SOURCINGSCENARIO,               -- Integration Scenario [VDM_SOURCINGSCENARIO]
    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]
    EXTERNALSOURCINGPROJECTREF,     -- External Reference [VDM_EXTERNALSRCGPROJREFERENCE]
    LOGICALSYSTEM,                  -- Logical System [LOGSYSTEM]
    SOURCINGPROJECTVERSIONINGRSN,   -- Reason [MM_PUR_SRCGPROJ_REASON]
    DUMMY_SRCGPROJHDR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    SRCGPROJAPPROVALSTATUS,         -- Approval Status [VDM_SRCGPROJECTAPPRVLSTS]
    SHIPPINGINSTRUCTION,            -- Shipping Instr. [EVERS]
    SOURCESOURCINGPROJECTUUID,      -- Source Sourcing Project UUID [VDM_SOURCESOURCINGPROJECTUUID]
    CENTRALPURCHASECONTRACT,        -- Central Purchase Contract [VDM_CENTRALPURCHASECONTRACT]
    PROCUREMENTPLANNINGBUNDLEUUID,  -- Procurement Planning Bundle UUID [VDM_PROCMTPLANNINGBUNDLEUUID]
    SRCGPROJPAYMENTTERMISMANUAL,    -- Truth Value [ABAP_BOOLEAN]
    SRCGPROJHASPAYMENTTERMKEY,      -- Truth Value [ABAP_BOOLEAN]
    SRCGPROJEARLIESTCNDNSELDATE,    -- Earliest Start Date for Conditions [VDM_SRCGPROJEARLIESTCNDNSELDTE]
    SRCGPROJCANCELLATIONRSN,        -- Cancelation Reason [MM_PUR_SRCGPROJ_CANCEL_REASON]
    PRIMARY KEY (MANDT, SOURCINGPROJECTUUID)
);

Learn More