MMSPQTNDDDETS_D

Transparent Table Application Table
9 Fields 2 CDS Views

Draft table for entity R_SRCGPROJQTNITMDMNDDISTRDETTP

MMSPQTNDDDETS_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGPROJQTNITMDMNDDISTRDETTP. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgProjQtnItmDmndDistrDetD view_entity from EXTENSION Dmnd Distr Det Item in SPQtn - Extension
R_SrcPrjQtnItmDmndDistrDetDrft view_entity from BASIC DmndDistrDet for Itm in SPQtn - Draft

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY srcgprojqtndmnddistrdetsuuid vdm_spqtndmnddistrdetailsuuid Demand Distribution Details UUID
srcgprojqtndmnddistruuid vdm_srcgprojqtndmnddistruuid Demand Distribution UUID in Quotation
fiscalyear gjahr Fiscal Year
requestedquantity vdm_requested_quantity Requested Quantity
requestedquantityunit vdm_requestedquantityunit Requested Quantity Unit
srcgprojqtnofferedquantity vdm_offered_quantity Offered Quantity
sourcingprojectquotationuuid vdm_srcgprojquotationuuid Supplier Quotation UUID
spnegttnqtnitmdmnddistrdetuuid vdm_spngnqtnitmdmnddistdtluuid Demand Distribution Detail UUID

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_SRCGPROJQTNITMDMNDDISTRDETTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQTNDDDETS_D (
    MANDT,                           -- Client [mandt]
    SRCGPROJQTNDMNDDISTRDETSUUID,    -- Demand Distribution Details UUID [vdm_spqtndmnddistrdetailsuuid]
    SRCGPROJQTNDMNDDISTRUUID,        -- Demand Distribution UUID in Quotation [vdm_srcgprojqtndmnddistruuid]
    FISCALYEAR,                      -- Fiscal Year [gjahr]
    REQUESTEDQUANTITY,               -- Requested Quantity [vdm_requested_quantity]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [vdm_requestedquantityunit]
    SRCGPROJQTNOFFEREDQUANTITY,      -- Offered Quantity [vdm_offered_quantity]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    SPNEGTTNQTNITMDMNDDISTRDETUUID,  -- Demand Distribution Detail UUID [vdm_spngnqtnitmdmnddistdtluuid]
    PRIMARY KEY (MANDT, SRCGPROJQTNDMNDDISTRDETSUUID)
);

Learn More