MMSPNGNQIDDIST_D

Transparent Table Application Table
14 Fields 2 CDS Views

Draft table for entity R_SPNEGTTNQTNITEMDEMANDDISTRTP

MMSPNGNQIDDIST_D is an SAP database table in S/4HANA. Draft table for entity R_SPNEGTTNQTNITEMDEMANDDISTRTP. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SPNegttnQtanItmDmndDistrDrft view_entity from EXTENSION Dmnd Distr for SPNQtnItm - Extension
R_SPNegttnQtnItmDmndDistrDraft view_entity from BASIC Dmnd Distr for SrcPrj Negttn - Draft

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY spnegttnqtnitemdemanddistruuid vdm_spngnqtnitmdmnddistruuid Demand Distribution UUID of Item
srcgprojnegttnqtanitemuuid vdm_srcgprojngnqtnitemuuid UUID of Quotation Item in Negotiation
sourcingprojectnegotiationuuid vdm_srcgprojngnuuid Negotiation UUID
srcgprojqtndmnddistruuid vdm_srcgprojqtndmnddistruuid Demand Distribution UUID in Quotation
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
srcgprojdmnddistributionuuid vdm_srcgprojdmnddistruuid Demand Distribution UUID
sourcingprojectuuid vdm_sourcingprojectuuid Sourcing Project UUID
sourcingprojectitemuuid vdm_sourcingprojectitemuuid Item UUID
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.

-- Draft table for entity R_SPNEGTTNQTNITEMDEMANDDISTRTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPNGNQIDDIST_D (
    MANDT,                           -- Client [mandt]
    SPNEGTTNQTNITEMDEMANDDISTRUUID,  -- Demand Distribution UUID of Item [vdm_spngnqtnitmdmnddistruuid]
    SRCGPROJNEGTTNQTANITEMUUID,      -- UUID of Quotation Item in Negotiation [vdm_srcgprojngnqtnitemuuid]
    SOURCINGPROJECTNEGOTIATIONUUID,  -- Negotiation UUID [vdm_srcgprojngnuuid]
    SRCGPROJQTNDMNDDISTRUUID,        -- Demand Distribution UUID in Quotation [vdm_srcgprojqtndmnddistruuid]
    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]
    SRCGPROJDMNDDISTRIBUTIONUUID,    -- Demand Distribution UUID [vdm_srcgprojdmnddistruuid]
    SOURCINGPROJECTUUID,             -- Sourcing Project UUID [vdm_sourcingprojectuuid]
    SOURCINGPROJECTITEMUUID,         -- Item UUID [vdm_sourcingprojectitemuuid]
    SRCGPROJNEGTTNITMINCLUSIONTYPE,  -- Negotiation Item Include Type Code [vdm_srcgprojngnitemincludecode]
    PRIMARY KEY (MANDT, SPNEGTTNQTNITEMDEMANDDISTRUUID)
);

Learn More