MMSRCGPNGNQTNITM

Transparent Table Application Table
19 Fields 2 CDS Views

Sourcing Projection Negotiation Quotation Item

MMSRCGPNGNQTNITM is an SAP database table in S/4HANA. Sourcing Projection Negotiation Quotation Item. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgProjNegttnQuotationItem view_entity from EXTENSION Qtn Item for Srcg Proj Negttn - Extn
R_SrcgProjNegttnQuotationItem view from BASIC Quotation Item for Srcg Proj Negotiation

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY srcgprojnegttnqtanitemuuid VDM_SRCGPROJNGNQTNITEMUUID UUID of Quotation Item in Negotiation
srcgprojnegttnquotationuuid VDM_SRCGPROJNGNQTNUUID Negotiation Quotation UUID
sourcingprojectnegotiationuuid VDM_SRCGPROJNGNUUID Negotiation UUID
srcgprojqtnitemuuid VDM_SRCGPROJQTNITEMUUID Supplier Quotation Item UUID
sourcingprojectquotationitem VDM_SRCGPROJQTNITEM Item
srcgprojnegttntargetnetprcamt VDM_SRCGPROJNGNTARGETAMT Negotiation Target per UoM
documentcurrency VDM_DOCUMENTCURRENCY Document Currency
sourcingprojectitemstableuuid MM_SRCGPROJITEMSTABLEUUID Stable ID
srcgprojnegttnitminclusiontype VDM_SRCGPROJNGNITEMINCLUDECODE Negotiation Item Include Type Code
srcgprojquotationitemtype VDM_SOURCINGPROJECTITEMTYPE Item Type
srcgprojqtnitemclassification VDM_SRCGPROJITEMCLASSIFICATION Item Classification
srcgprojquotationitemparent VDM_SRCGPROJQTNITEMPARENT Item Parent
srcgprojnegttntargetquantity VDM_SPNGNTARGETQUANTITY Negotiation Target Quantity
requestedquantityunit VDM_REQUESTEDQUANTITYUNIT Requested Quantity Unit
srcgprojnegttnmaxtargetqty VDM_SPNGNMAXTARGETQUANTITY Max. Negotiation Target Quantity
srcgprojnegttntotaltargetqty VDM_SPNGNTOTALTARGETQUANTITY Total Negotiation Target Quantity
alternativeitemid VDM_ALTERNATIVEITEMID Alternative Item ID
dummy_spngnqitm_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.

-- Sourcing Projection Negotiation Quotation Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPNGNQTNITM (
    MANDT,                           -- Client [MANDT]
    SRCGPROJNEGTTNQTANITEMUUID,      -- UUID of Quotation Item in Negotiation [VDM_SRCGPROJNGNQTNITEMUUID]
    SRCGPROJNEGTTNQUOTATIONUUID,     -- Negotiation Quotation UUID [VDM_SRCGPROJNGNQTNUUID]
    SOURCINGPROJECTNEGOTIATIONUUID,  -- Negotiation UUID [VDM_SRCGPROJNGNUUID]
    SRCGPROJQTNITEMUUID,             -- Supplier Quotation Item UUID [VDM_SRCGPROJQTNITEMUUID]
    SOURCINGPROJECTQUOTATIONITEM,    -- Item [VDM_SRCGPROJQTNITEM]
    SRCGPROJNEGTTNTARGETNETPRCAMT,   -- Negotiation Target per UoM [VDM_SRCGPROJNGNTARGETAMT]
    DOCUMENTCURRENCY,                -- Document Currency [VDM_DOCUMENTCURRENCY]
    SOURCINGPROJECTITEMSTABLEUUID,   -- Stable ID [MM_SRCGPROJITEMSTABLEUUID]
    SRCGPROJNEGTTNITMINCLUSIONTYPE,  -- Negotiation Item Include Type Code [VDM_SRCGPROJNGNITEMINCLUDECODE]
    SRCGPROJQUOTATIONITEMTYPE,       -- Item Type [VDM_SOURCINGPROJECTITEMTYPE]
    SRCGPROJQTNITEMCLASSIFICATION,   -- Item Classification [VDM_SRCGPROJITEMCLASSIFICATION]
    SRCGPROJQUOTATIONITEMPARENT,     -- Item Parent [VDM_SRCGPROJQTNITEMPARENT]
    SRCGPROJNEGTTNTARGETQUANTITY,    -- Negotiation Target Quantity [VDM_SPNGNTARGETQUANTITY]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [VDM_REQUESTEDQUANTITYUNIT]
    SRCGPROJNEGTTNMAXTARGETQTY,      -- Max. Negotiation Target Quantity [VDM_SPNGNMAXTARGETQUANTITY]
    SRCGPROJNEGTTNTOTALTARGETQTY,    -- Total Negotiation Target Quantity [VDM_SPNGNTOTALTARGETQUANTITY]
    ALTERNATIVEITEMID,               -- Alternative Item ID [VDM_ALTERNATIVEITEMID]
    DUMMY_SPNGNQITM_INCL_EEW_PS,     -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SRCGPROJNEGTTNQTANITEMUUID)
);

Learn More