MMSRCGPROJQTN

Transparent Table Application Table
42 Fields 2 CDS Views

Sourcing Project Quotation Header

MMSRCGPROJQTN is an SAP database table in S/4HANA. Sourcing Project Quotation Header. It contains 42 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SourcingProjectQuotation view_entity from EXTENSION Quotation for Sourcing Project - Extn
R_SourcingProjectQuotation view from BASIC Quotation for Sourcing Project

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sourcingprojectquotationuuid VDM_SRCGPROJQUOTATIONUUID Supplier Quotation UUID
sourcingprojectquotation VDM_SOURCINGPROJECTQUOTATION Supplier Quotation
srcgprojquotationversion VDM_SRCGPROJQTNVERSION Version
sourcingprojectquotationtype VDM_SRCGPROJQUOTATIONTYPE Sourcing Project Quotation Type
sourcingprojectquotationname VDM_SRCGPROJQUOTATIONNAME Name
srcgprojquotationissimulated VDM_SRCGPROJQTNISSIMULATED Simulated
bidder VDM_BIDDER Business Partner
sourcingprojectuuid VDM_SOURCINGPROJECTUUID Sourcing Project UUID
companycode BUKRS Company Code
purchasinggroup BKGRP Purch. Group
purchasingorganization EKORG_LL Purchasing Organization
srcgprojqtntotnetamt VDM_SRCGPROJQTNTOTNETAMT Total Amount
srcgprojqtnoffercurrency VDM_SPQTNOFFERCURRENCY Quotation Currency
srcgprojqtnlifecyclestatus VDM_SRCGPROJQTNLFCYCSTS Status
srcgprojqtnsubmsnsts VDM_SRCGPROJQTNSUBMSNSTS Submission Status
srcgprojqtnrevisionsts VDM_SRCGPROJQTNREVISIONSTS Revision Status
srcgprojqtnactvtnsts VDM_SRCGPROJQTNACTVTNSTS Activation Status
srcgprojqtnawardingstatus VDM_SRCGPROJQTNAWARDINGSTATUS Awarding Status
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
createdbyuser VDM_CREATEDBYUSERID Created By
creationdatetime VDM_SRCGPROJCREATIONDATE Created On
srcgprojattchsareforbidden VDM_SRCGPROJATTCHSAREFORBIDDEN Forbid Attachments
srcgprojnotesareforbidden VDM_SRCGPROJNOTESAREFORBIDDEN Forbid Notes
externalsourcingprojectqtnref VDM_EXTERNALSRCGPROJQTNREF External Reference
sourcingorigin VDM_SOURCINGORIGIN Sourcing Origin
qtnlatestsubmissiondatetime VDM_SUBMISSIONDATETIME Submission Deadline
logicalsystem LOGSYSTEM Logical System
iseopblocked EOPBLOCKED Busin. Purp. Cmpltd.
srcgprojqtnsuitability MM_PUR_SPQ_SUITABILITY Suitability
dummy_srcgprojqhdr_incl_eew_ps CFD_DUMMY Dummy
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
materialgroup MATKL Material Group
sourcingprojectnegotiationuuid VDM_SRCGPROJNGNUUID Negotiation UUID
pricingprocedure KALSM_D Procedure
sourcingawardingdate VDM_SOURCINGAWARDINGDATE Awarded On
sourcesrcgprojquotationuuid VDM_SOURCEQUOTATIONUUID UUID of Source Supplier Quotation

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPROJQTN (
    MANDT,                           -- Client [MANDT]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [VDM_SRCGPROJQUOTATIONUUID]
    SOURCINGPROJECTQUOTATION,        -- Supplier Quotation [VDM_SOURCINGPROJECTQUOTATION]
    SRCGPROJQUOTATIONVERSION,        -- Version [VDM_SRCGPROJQTNVERSION]
    SOURCINGPROJECTQUOTATIONTYPE,    -- Sourcing Project Quotation Type [VDM_SRCGPROJQUOTATIONTYPE]
    SOURCINGPROJECTQUOTATIONNAME,    -- Name [VDM_SRCGPROJQUOTATIONNAME]
    SRCGPROJQUOTATIONISSIMULATED,    -- Simulated [VDM_SRCGPROJQTNISSIMULATED]
    BIDDER,                          -- Business Partner [VDM_BIDDER]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [VDM_SOURCINGPROJECTUUID]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [EKORG_LL]
    SRCGPROJQTNTOTNETAMT,            -- Total Amount [VDM_SRCGPROJQTNTOTNETAMT]
    SRCGPROJQTNOFFERCURRENCY,        -- Quotation Currency [VDM_SPQTNOFFERCURRENCY]
    SRCGPROJQTNLIFECYCLESTATUS,      -- Status [VDM_SRCGPROJQTNLFCYCSTS]
    SRCGPROJQTNSUBMSNSTS,            -- Submission Status [VDM_SRCGPROJQTNSUBMSNSTS]
    SRCGPROJQTNREVISIONSTS,          -- Revision Status [VDM_SRCGPROJQTNREVISIONSTS]
    SRCGPROJQTNACTVTNSTS,            -- Activation Status [VDM_SRCGPROJQTNACTVTNSTS]
    SRCGPROJQTNAWARDINGSTATUS,       -- Awarding Status [VDM_SRCGPROJQTNAWARDINGSTATUS]
    LASTCHANGEDATETIME,              -- Last Changed On [VDM_LASTCHANGEDON]
    LASTCHANGEDBYUSER,               -- Changed By [VDM_LASTCHANGEDBYUSERID]
    CREATEDBYUSER,                   -- Created By [VDM_CREATEDBYUSERID]
    CREATIONDATETIME,                -- Created On [VDM_SRCGPROJCREATIONDATE]
    SRCGPROJATTCHSAREFORBIDDEN,      -- Forbid Attachments [VDM_SRCGPROJATTCHSAREFORBIDDEN]
    SRCGPROJNOTESAREFORBIDDEN,       -- Forbid Notes [VDM_SRCGPROJNOTESAREFORBIDDEN]
    EXTERNALSOURCINGPROJECTQTNREF,   -- External Reference [VDM_EXTERNALSRCGPROJQTNREF]
    SOURCINGORIGIN,                  -- Sourcing Origin [VDM_SOURCINGORIGIN]
    QTNLATESTSUBMISSIONDATETIME,     -- Submission Deadline [VDM_SUBMISSIONDATETIME]
    LOGICALSYSTEM,                   -- Logical System [LOGSYSTEM]
    ISEOPBLOCKED,                    -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    SRCGPROJQTNSUITABILITY,          -- Suitability [MM_PUR_SPQ_SUITABILITY]
    DUMMY_SRCGPROJQHDR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    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]
    MATERIALGROUP,                   -- Material Group [MATKL]
    SOURCINGPROJECTNEGOTIATIONUUID,  -- Negotiation UUID [VDM_SRCGPROJNGNUUID]
    PRICINGPROCEDURE,                -- Procedure [KALSM_D]
    SOURCINGAWARDINGDATE,            -- Awarded On [VDM_SOURCINGAWARDINGDATE]
    SOURCESRCGPROJQUOTATIONUUID,     -- UUID of Source Supplier Quotation [VDM_SOURCEQUOTATIONUUID]
    PRIMARY KEY (MANDT, SOURCINGPROJECTQUOTATIONUUID)
);

Learn More