MMSRCGPNGNQTNITM

Transparent Table Application Table
18 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 18 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 (18)

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

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]
    PRIMARY KEY (MANDT, SRCGPROJNEGTTNQTANITEMUUID)
);

Learn More