MMSPNGNQIDDIST

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

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

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]
    PRIMARY KEY (CLIENT, SPNEGTTNQTNITEMDEMANDDISTRUUID)
);

Learn More