MMSRCGPNGNQITM_D

Transparent Table Application Table
25 Fields 2 CDS Views

Draft table for entity R_SRCGPROJNEGTTNQTANITEMTP

MMSRCGPNGNQITM_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGPROJNEGTTNQTANITEMTP. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SrcgProjNegttnQtanItemDraft view_entity from EXTENSION Qtn Item for SrcgProj Negttn - Extension
R_SrcgProjNegttnQtnItemDraft view_entity from BASIC Qtn Item for Srcg Proj Negttn - Draft

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY srcgprojnegttnqtanitemuuid vdm_srcgprojngnqtnitemuuid UUID of Quotation Item in Negotiation
srcgprojnegttnquotationuuid vdm_srcgprojngnqtnuuid Negotiation Quotation UUID
sourcingprojectnegotiationuuid vdm_srcgprojngnuuid Negotiation UUID
srcgprojqtnitemuuid vdm_srcgprojqtnitemuuid Supplier Quotation Item UUID
sourcingprojectquotationitem vdm_srcgprojqtnitem Item
srcgprojnegttntargetnetprcamt vdm_srcgprojngntargetamt Negotiation Target per UoM
documentcurrency vdm_documentcurrency Document Currency
sourcingprojectitemstableuuid mm_srcgprojitemstableuuid Stable ID
srcgprojnegttnitminclusiontype vdm_srcgprojngnitemincludecode Negotiation Item Include Type Code
srcgprojquotationitemtype vdm_sourcingprojectitemtype Item Type
srcgprojqtnitemclassification vdm_srcgprojitemclassification Item Classification
srcgprojquotationitemparent vdm_srcgprojqtnitemparent Item Parent
srcgprojnegttntargetquantity vdm_spngntargetquantity Negotiation Target Quantity
srcgprojnegttnmaxtargetqty vdm_spngnmaxtargetquantity Max. Negotiation Target Quantity
srcgprojnegttntotaltargetqty vdm_spngntotaltargetquantity Total Negotiation Target Quantity
requestedquantityunit vdm_requestedquantityunit Requested Quantity Unit
requestedquantity vdm_requested_quantity Requested Quantity
srcgprojqtnofferedquantity vdm_offered_quantity Offered Quantity
srcgprojqtnoffercurrency vdm_spqtnoffercurrency Quotation Currency
netpriceamount vdm_spnetpriceamount Net Price
srcgprojqtnitemtotnetamt vdm_srcgprojqtnitemtotnetamt Total Amount
exchangeratetype kurst Exch. Rate Type
srcgprojitemtargetamount vdm_srcgprojitemtargetamount Target Price
alternativeitemid vdm_alternativeitemid Alternative Item 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.

-- Draft table for entity R_SRCGPROJNEGTTNQTANITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPNGNQITM_D (
    MANDT,                           -- Client [mandt]
    SRCGPROJNEGTTNQTANITEMUUID,      -- UUID of Quotation Item in Negotiation [vdm_srcgprojngnqtnitemuuid]
    SRCGPROJNEGTTNQUOTATIONUUID,     -- Negotiation Quotation UUID [vdm_srcgprojngnqtnuuid]
    SOURCINGPROJECTNEGOTIATIONUUID,  -- Negotiation UUID [vdm_srcgprojngnuuid]
    SRCGPROJQTNITEMUUID,             -- Supplier Quotation Item UUID [vdm_srcgprojqtnitemuuid]
    SOURCINGPROJECTQUOTATIONITEM,    -- Item [vdm_srcgprojqtnitem]
    SRCGPROJNEGTTNTARGETNETPRCAMT,   -- Negotiation Target per UoM [vdm_srcgprojngntargetamt]
    DOCUMENTCURRENCY,                -- Document Currency [vdm_documentcurrency]
    SOURCINGPROJECTITEMSTABLEUUID,   -- Stable ID [mm_srcgprojitemstableuuid]
    SRCGPROJNEGTTNITMINCLUSIONTYPE,  -- Negotiation Item Include Type Code [vdm_srcgprojngnitemincludecode]
    SRCGPROJQUOTATIONITEMTYPE,       -- Item Type [vdm_sourcingprojectitemtype]
    SRCGPROJQTNITEMCLASSIFICATION,   -- Item Classification [vdm_srcgprojitemclassification]
    SRCGPROJQUOTATIONITEMPARENT,     -- Item Parent [vdm_srcgprojqtnitemparent]
    SRCGPROJNEGTTNTARGETQUANTITY,    -- Negotiation Target Quantity [vdm_spngntargetquantity]
    SRCGPROJNEGTTNMAXTARGETQTY,      -- Max. Negotiation Target Quantity [vdm_spngnmaxtargetquantity]
    SRCGPROJNEGTTNTOTALTARGETQTY,    -- Total Negotiation Target Quantity [vdm_spngntotaltargetquantity]
    REQUESTEDQUANTITYUNIT,           -- Requested Quantity Unit [vdm_requestedquantityunit]
    REQUESTEDQUANTITY,               -- Requested Quantity [vdm_requested_quantity]
    SRCGPROJQTNOFFEREDQUANTITY,      -- Offered Quantity [vdm_offered_quantity]
    SRCGPROJQTNOFFERCURRENCY,        -- Quotation Currency [vdm_spqtnoffercurrency]
    NETPRICEAMOUNT,                  -- Net Price [vdm_spnetpriceamount]
    SRCGPROJQTNITEMTOTNETAMT,        -- Total Amount [vdm_srcgprojqtnitemtotnetamt]
    EXCHANGERATETYPE,                -- Exch. Rate Type [kurst]
    SRCGPROJITEMTARGETAMOUNT,        -- Target Price [vdm_srcgprojitemtargetamount]
    ALTERNATIVEITEMID,               -- Alternative Item ID [vdm_alternativeitemid]
    PRIMARY KEY (MANDT, SRCGPROJNEGTTNQTANITEMUUID)
);

Learn More