MMSPQTNDMNDDISTR

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

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

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

Learn More