MMSRCGPROJQTN_D

Transparent Table Application Table
55 Fields 2 CDS Views

Draft table for entity R_SOURCINGPROJECTQUOTATIONTP

MMSRCGPROJQTN_D is an SAP database table in S/4HANA. Draft table for entity R_SOURCINGPROJECTQUOTATIONTP. It contains 55 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SourcingProjectQuotationD view_entity from EXTENSION Quotation for Sourcing Project - Extn
R_SrcgProjQtnDraft view_entity from BASIC Quotation for Sourcing Project - Draft

Fields (55)

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_BUSINESSPARTNER Business Partner
companycode BUKRS Company Code
purchasinggroup BKGRP Purch. Group
purchasingorganization EKORG_LL Purchasing Organization
srcgprojqtnoffercurrency VDM_SPQTNOFFERCURRENCY Quotation Currency
srcgprojqtntotnetamt VDM_SRCGPROJQTNTOTNETAMT Total Amount
srcgprojqtnlifecyclestatus VDM_SRCGPROJQTNLFCYCSTS Status
srcgprojqtnrevisionsts VDM_SRCGPROJQTNREVISIONSTS Revision Status
srcgprojqtnactvtnsts VDM_SRCGPROJQTNACTVTNSTS Activation Status
srcgprojqtnsubmsnsts VDM_SRCGPROJQTNSUBMSNSTS Submission Status
srcgprojqtnawardingstatus VDM_SRCGPROJQTNAWARDINGSTATUS Awarding Status
sourcingprojectuuid VDM_SOURCINGPROJECTUUID Sourcing Project UUID
sourcingprojectnegotiationuuid VDM_SRCGPROJNGNUUID Negotiation UUID
pricingprocedure KALSM_D Procedure
lastchangedbyuser VDM_LASTCHANGEDBYUSERID Changed By
createdbyuser VDM_CREATEDBYUSERID Created By
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
creationdatetime VDM_SRCGPROJCREATIONDATE Created On
srcgprojattchsareforbidden VDM_SRCGPROJATTCHSAREFORBIDDEN Forbid Attachments
srcgprojnotesareforbidden VDM_SRCGPROJNOTESAREFORBIDDEN Forbid Notes
sourcingorigin VDM_SOURCINGORIGIN Sourcing Origin
externalsourcingprojectqtnref VDM_EXTERNALSRCGPROJQTNREF External Reference
qtnlatestsubmissiondatetime VDM_SUBMISSIONDATETIME Submission Deadline
logicalsystem LOGSYSTEM Logical System
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
cashdiscount1days DZBD1T Days 1
cashdiscount2days DZBD2T Days 2
cashdiscount1percent DZBD1P CD Percentage 1
cashdiscount2percent DZBD2P CD Percentage 2
netpaymentdays DZBD3T Days Net
materialgroup MATKL Material Group
sourcingawardingdate VDM_SOURCINGAWARDINGDATE Awarded On
srcgprojqtnsuitability MM_PUR_SPQ_SUITABILITY Suitability
sourcingprojectnegotiationtype VDM_SRCGPROJNGNTYPE Negotiation Type
lglcntntmlinkdobj VDM_SOURCINGPROJECTUNIQUEID Unique ID
sourcesrcgprojquotationuuid VDM_SOURCEQUOTATIONUUID UUID of Source Supplier Quotation
srcgprojqtntypeisnotauthorized VDM_SPQTNTYPEISNOTAUTHORIZED SPQtn Type No Authorization indicator
purgorgisnotauthorized VDM_PURGORGISNOTAUTHORIZED Purch. Org. No Authorization indicator
purggroupisnotauthorized VDM_PURGGROUPISNOTAUTHORIZED Purch. Group No Authorization indicator
companycodeisnotauthorized VDM_COMPANYCODEISNOTAUTHORIZED Company Code No Authorization indicator
materialgroupisnotauthorized VDM_MATLGROUPISNOTAUTHORIZED Mat. Group No Authorization indicator
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_srcgprojqhdr_incl_eew_ps CFD_DUMMY Dummy

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_SOURCINGPROJECTQUOTATIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPROJQTN_D (
    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_BUSINESSPARTNER]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [EKORG_LL]
    SRCGPROJQTNOFFERCURRENCY,        -- Quotation Currency [VDM_SPQTNOFFERCURRENCY]
    SRCGPROJQTNTOTNETAMT,            -- Total Amount [VDM_SRCGPROJQTNTOTNETAMT]
    SRCGPROJQTNLIFECYCLESTATUS,      -- Status [VDM_SRCGPROJQTNLFCYCSTS]
    SRCGPROJQTNREVISIONSTS,          -- Revision Status [VDM_SRCGPROJQTNREVISIONSTS]
    SRCGPROJQTNACTVTNSTS,            -- Activation Status [VDM_SRCGPROJQTNACTVTNSTS]
    SRCGPROJQTNSUBMSNSTS,            -- Submission Status [VDM_SRCGPROJQTNSUBMSNSTS]
    SRCGPROJQTNAWARDINGSTATUS,       -- Awarding Status [VDM_SRCGPROJQTNAWARDINGSTATUS]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [VDM_SOURCINGPROJECTUUID]
    SOURCINGPROJECTNEGOTIATIONUUID,  -- Negotiation UUID [VDM_SRCGPROJNGNUUID]
    PRICINGPROCEDURE,                -- Procedure [KALSM_D]
    LASTCHANGEDBYUSER,               -- Changed By [VDM_LASTCHANGEDBYUSERID]
    CREATEDBYUSER,                   -- Created By [VDM_CREATEDBYUSERID]
    LASTCHANGEDATETIME,              -- Last Changed On [VDM_LASTCHANGEDON]
    CREATIONDATETIME,                -- Created On [VDM_SRCGPROJCREATIONDATE]
    SRCGPROJATTCHSAREFORBIDDEN,      -- Forbid Attachments [VDM_SRCGPROJATTCHSAREFORBIDDEN]
    SRCGPROJNOTESAREFORBIDDEN,       -- Forbid Notes [VDM_SRCGPROJNOTESAREFORBIDDEN]
    SOURCINGORIGIN,                  -- Sourcing Origin [VDM_SOURCINGORIGIN]
    EXTERNALSOURCINGPROJECTQTNREF,   -- External Reference [VDM_EXTERNALSRCGPROJQTNREF]
    QTNLATESTSUBMISSIONDATETIME,     -- Submission Deadline [VDM_SUBMISSIONDATETIME]
    LOGICALSYSTEM,                   -- Logical System [LOGSYSTEM]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    CASHDISCOUNT1DAYS,               -- Days 1 [DZBD1T]
    CASHDISCOUNT2DAYS,               -- Days 2 [DZBD2T]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [DZBD1P]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [DZBD2P]
    NETPAYMENTDAYS,                  -- Days Net [DZBD3T]
    MATERIALGROUP,                   -- Material Group [MATKL]
    SOURCINGAWARDINGDATE,            -- Awarded On [VDM_SOURCINGAWARDINGDATE]
    SRCGPROJQTNSUITABILITY,          -- Suitability [MM_PUR_SPQ_SUITABILITY]
    SOURCINGPROJECTNEGOTIATIONTYPE,  -- Negotiation Type [VDM_SRCGPROJNGNTYPE]
    LGLCNTNTMLINKDOBJ,               -- Unique ID [VDM_SOURCINGPROJECTUNIQUEID]
    SOURCESRCGPROJQUOTATIONUUID,     -- UUID of Source Supplier Quotation [VDM_SOURCEQUOTATIONUUID]
    SRCGPROJQTNTYPEISNOTAUTHORIZED,  -- SPQtn Type No Authorization indicator [VDM_SPQTNTYPEISNOTAUTHORIZED]
    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]
    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_SRCGPROJQHDR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SOURCINGPROJECTQUOTATIONUUID)
);

Learn More