MMSPQTNDMNDDISTR

Transparent Table Application Table
17 Fields 2 CDS Views

Sourcing Project Quotation Demand Distribution

MMSPQTNDMNDDISTR is an SAP database table in S/4HANA. Sourcing Project Quotation Demand Distribution. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgProjQtnItmDmndDistr view_entity from EXTENSION Dmnd Distr for Item in SPQtn - Extension
R_SrcgProjQtnItmDmndDistr view from BASIC Demand Distr for Item in Srcg Proj Qtn

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY srcgprojqtndmnddistruuid VDM_SRCGPROJQTNDMNDDISTRUUID Demand Distribution UUID in Quotation
sourcingprojectquotationuuid VDM_SRCGPROJQUOTATIONUUID Supplier Quotation UUID
srcgprojqtnitemuuid VDM_SRCGPROJQTNITEMUUID Supplier Quotation Item UUID
srcgprojdmnddistributionuuid VDM_SRCGPROJDMNDDISTRUUID Demand Distribution UUID
procurementproject VDM_PROCUREMENTPROJECT Project
plant EWERK Plant
maxannualrequestedquantity VDM_MAX_REQUESTED_QUANTITY Max. Requested Quantity
srcgprojqtntotofferedquantity VDM_TOTAL_OFFERED_QUANTITY Total Offered Quantity
requestedquantityunit VDM_REQUESTEDQUANTITYUNIT Requested Quantity Unit
companycode BUKRS Company Code
purchasinggroup BKGRP Purch. Group
purchasingorganization EKORG_LL Purchasing Organization
procurementhubsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
storagelocation LGORT_D Location
procmthubplantuniqueid MMPUR_BE_PLANT_UNIQUE_ID Plant Unique ID
dummy_srcgprojqtdd_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 Quotation Demand Distribution
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQTNDMNDDISTR (
    MANDT,                           -- Client [MANDT]
    SRCGPROJQTNDMNDDISTRUUID,        -- Demand Distribution UUID in Quotation [VDM_SRCGPROJQTNDMNDDISTRUUID]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [VDM_SRCGPROJQUOTATIONUUID]
    SRCGPROJQTNITEMUUID,             -- Supplier Quotation Item UUID [VDM_SRCGPROJQTNITEMUUID]
    SRCGPROJDMNDDISTRIBUTIONUUID,    -- Demand Distribution UUID [VDM_SRCGPROJDMNDDISTRUUID]
    PROCUREMENTPROJECT,              -- Project [VDM_PROCUREMENTPROJECT]
    PLANT,                           -- Plant [EWERK]
    MAXANNUALREQUESTEDQUANTITY,      -- Max. Requested Quantity [VDM_MAX_REQUESTED_QUANTITY]
    SRCGPROJQTNTOTOFFEREDQUANTITY,   -- Total Offered Quantity [VDM_TOTAL_OFFERED_QUANTITY]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [VDM_REQUESTEDQUANTITYUNIT]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGGROUP,                 -- Purch. Group [BKGRP]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [EKORG_LL]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [MMPUR_D_SOURCE_SYS]
    STORAGELOCATION,                 -- Location [LGORT_D]
    PROCMTHUBPLANTUNIQUEID,          -- Plant Unique ID [MMPUR_BE_PLANT_UNIQUE_ID]
    DUMMY_SRCGPROJQTDD_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SRCGPROJQTNDMNDDISTRUUID)
);

Learn More