MMSPNGNQIDDIST

Transparent Table Application Table
12 Fields 2 CDS Views

Sourcing Project Negotiation Qtn Item Demand Distribution

MMSPNGNQIDDIST is an SAP database table in S/4HANA. Sourcing Project Negotiation Qtn Item Demand Distribution. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SPNegttnQtnItemDemandDistr view_entity from EXTENSION Dmnd Distr for SPNQtnItm - Extension
R_SPNegttnQtnItemDemandDistr view from BASIC Demand Distr for Srcg Project Negttn

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY spnegttnqtnitemdemanddistruuid VDM_SPNGNQTNITMDMNDDISTRUUID Demand Distribution UUID of Item
srcgprojnegttnqtanitemuuid VDM_SRCGPROJNGNQTNITEMUUID UUID of Quotation Item in Negotiation
srcgprojqtndmnddistruuid VDM_SRCGPROJQTNDMNDDISTRUUID Demand Distribution UUID in Quotation
sourcingprojectnegotiationuuid VDM_SRCGPROJNGNUUID Negotiation UUID
plant EWERK Plant
maxannualrequestedquantity VDM_MAX_REQUESTED_QUANTITY Max. Requested Quantity
srcgprojnegttnmaxtargetqty VDM_SPNGNMAXTARGETQUANTITY Max. Negotiation Target Quantity
srcgprojnegttntotaltargetqty VDM_SPNGNTOTALTARGETQUANTITY Total Negotiation Target Quantity
requestedquantityunit VDM_REQUESTEDQUANTITYUNIT Requested Quantity Unit
srcgprojnegttnitminclusiontype VDM_SRCGPROJNGNITEMINCLUDECODE Negotiation Item Include Type Code
dummy_spngnqidmdt_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 Project Negotiation Qtn Item Demand Distribution
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPNGNQIDDIST (
    CLIENT,                          -- Client [MANDT]
    SPNEGTTNQTNITEMDEMANDDISTRUUID,  -- Demand Distribution UUID of Item [VDM_SPNGNQTNITMDMNDDISTRUUID]
    SRCGPROJNEGTTNQTANITEMUUID,      -- UUID of Quotation Item in Negotiation [VDM_SRCGPROJNGNQTNITEMUUID]
    SRCGPROJQTNDMNDDISTRUUID,        -- Demand Distribution UUID in Quotation [VDM_SRCGPROJQTNDMNDDISTRUUID]
    SOURCINGPROJECTNEGOTIATIONUUID,  -- Negotiation UUID [VDM_SRCGPROJNGNUUID]
    PLANT,                           -- Plant [EWERK]
    MAXANNUALREQUESTEDQUANTITY,      -- Max. Requested Quantity [VDM_MAX_REQUESTED_QUANTITY]
    SRCGPROJNEGTTNMAXTARGETQTY,      -- Max. Negotiation Target Quantity [VDM_SPNGNMAXTARGETQUANTITY]
    SRCGPROJNEGTTNTOTALTARGETQTY,    -- Total Negotiation Target Quantity [VDM_SPNGNTOTALTARGETQUANTITY]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [VDM_REQUESTEDQUANTITYUNIT]
    SRCGPROJNEGTTNITMINCLUSIONTYPE,  -- Negotiation Item Include Type Code [VDM_SRCGPROJNGNITEMINCLUDECODE]
    DUMMY_SPNGNQIDMDT_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, SPNEGTTNQTNITEMDEMANDDISTRUUID)
);

Learn More