MMSPQTNICNDVAL_D

Transparent Table Application Table
13 Fields 1 CDS Views

Draft table for entity R_SRCGPROJQTNITMCNDNVALIDITYTP

MMSPQTNICNDVAL_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGPROJQTNITMCNDNVALIDITYTP. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SrcPrjQtnItmCndnValdtyDraft view_entity from BASIC Cndn Valdty of Itm in SrcPrjQtn - Draft

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY conditionrecord knumh Cond.Record No.
conditionvalidityenddate kodatbi Valid To
sourcingprojectquotation vdm_sourcingprojectquotation Supplier Quotation
srcgprojquotationversion vdm_srcgprojqtnversion Version
sourcingprojectquotationitem vdm_srcgprojqtnitem Item
conditionapplication kappl Application
conditiontype kscha Condition Type
conditionvaliditystartdate kodatab Valid From
conditionisdeleted loevm_ko Deletion Indic.
srcgprojqtnitemuuid vdm_srcgprojqtnitemuuid Supplier Quotation Item UUID
sourcingprojectquotationuuid vdm_srcgprojquotationuuid Supplier Quotation UUID
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.

-- Draft table for entity R_SRCGPROJQTNITMCNDNVALIDITYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQTNICNDVAL_D (
    MANDT,                         -- Client [mandt]
    CONDITIONRECORD,               -- Cond.Record No. [knumh]
    CONDITIONVALIDITYENDDATE,      -- Valid To [kodatbi]
    SOURCINGPROJECTQUOTATION,      -- Supplier Quotation [vdm_sourcingprojectquotation]
    SRCGPROJQUOTATIONVERSION,      -- Version [vdm_srcgprojqtnversion]
    SOURCINGPROJECTQUOTATIONITEM,  -- Item [vdm_srcgprojqtnitem]
    CONDITIONAPPLICATION,          -- Application [kappl]
    CONDITIONTYPE,                 -- Condition Type [kscha]
    CONDITIONVALIDITYSTARTDATE,    -- Valid From [kodatab]
    CONDITIONISDELETED,            -- Deletion Indic. [loevm_ko]
    SRCGPROJQTNITEMUUID,           -- Supplier Quotation Item UUID [vdm_srcgprojqtnitemuuid]
    SOURCINGPROJECTQUOTATIONUUID,  -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    PROCMTHUBPLANTUNIQUEID,        -- Plant Unique ID [mmpur_be_plant_unique_id]
    PRIMARY KEY (MANDT, CONDITIONRECORD)
);

Learn More