MMSPNGNQIDDDET

Transparent Table Application Table
12 Fields 2 CDS Views

Sourcing Project Negotiation Qtn Item Demand Distr Detail

MMSPNGNQIDDDET is an SAP database table in S/4HANA. Sourcing Project Negotiation Qtn Item Demand Distr Detail. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SPNegttnQtnItmDmndDistrDet view_entity from EXTENSION NgnQtnItmDmndDistrDet for SP - Extension
R_SPNegttnQtnItmDmndDistrDet view from BASIC Dmnd Distr Details for Srcg Proj Negttn

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY spnegttnqtnitmdmnddistrdetuuid vdm_spngnqtnitmdmnddistdtluuid Demand Distribution Detail UUID
spnegttnqtnitemdemanddistruuid vdm_spngnqtnitmdmnddistruuid Demand Distribution UUID of Item
srcgprojqtndmnddistrdetsuuid vdm_spqtndmnddistrdetailsuuid Demand Distribution Details UUID
srcgprojqtndmnddistruuid vdm_srcgprojqtndmnddistruuid Demand Distribution UUID in Quotation
sourcingprojectnegotiationuuid vdm_srcgprojngnuuid Negotiation UUID
fiscalyear fis_gjahr_no_conv Fiscal Year
srcgprojnegttntargetquantity vdm_spngntargetquantity Negotiation Target Quantity
requestedquantity vdm_requested_quantity Requested Quantity
srcgprojqtnofferedquantity vdm_offered_quantity Offered 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 Distr Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPNGNQIDDDET (
    CLIENT,                          -- Client [mandt]
    SPNEGTTNQTNITMDMNDDISTRDETUUID,  -- Demand Distribution Detail UUID [vdm_spngnqtnitmdmnddistdtluuid]
    SPNEGTTNQTNITEMDEMANDDISTRUUID,  -- Demand Distribution UUID of Item [vdm_spngnqtnitmdmnddistruuid]
    SRCGPROJQTNDMNDDISTRDETSUUID,    -- Demand Distribution Details UUID [vdm_spqtndmnddistrdetailsuuid]
    SRCGPROJQTNDMNDDISTRUUID,        -- Demand Distribution UUID in Quotation [vdm_srcgprojqtndmnddistruuid]
    SOURCINGPROJECTNEGOTIATIONUUID,  -- Negotiation UUID [vdm_srcgprojngnuuid]
    FISCALYEAR,                      -- Fiscal Year [fis_gjahr_no_conv]
    SRCGPROJNEGTTNTARGETQUANTITY,    -- Negotiation Target Quantity [vdm_spngntargetquantity]
    REQUESTEDQUANTITY,               -- Requested Quantity [vdm_requested_quantity]
    SRCGPROJQTNOFFEREDQUANTITY,      -- Offered Quantity [vdm_offered_quantity]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [vdm_requestedquantityunit]
    SRCGPROJNEGTTNITMINCLUSIONTYPE,  -- Negotiation Item Include Type Code [vdm_srcgprojngnitemincludecode]
    PRIMARY KEY (CLIENT, SPNEGTTNQTNITMDMNDDISTRDETUUID)
);

Learn More