MMSPQCNDNFML_D

Transparent Table Application Table
37 Fields 1 CDS Views

Draft table for entity R_SRCGPROJQTNCMMDTYFORMULATP

MMSPQCNDNFML_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGPROJQTNCMMDTYFORMULATP. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SPQtnItemCommodityFmlaDraft view_entity from BASIC SrcPrj Qtn item commodity fmla - Draft

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY conditionrecord knumh Cond.Record No.
KEY conditionsequentialnumbershort kopos Sequent. No. of Cond
docitemcommoditypricinguuid cpet_docitem_guid Doc. Item GUID
conditiontype cpet_cond_type Condition Type
pricingconditionformulakey cpet_formid Formula Key
prcgconditionformulainputuuid cpet_forminput_guid Doc. Form. GUID
prcgcndnfmlaamtindoccurrency cpet_formval_doccurr_cds Form. Doc. Crcy
prcgcndnformulaamountcurrency cpet_doccurr Doc. Currency
pricingconditionformularate cpet_formrate_cds Formula Rate
prcgcndnformularatecurrency cpet_formcurr Formula Currency
prcgcndnformularatequantity cpet_formprun Formula Price Unit
prcgcndnformularateqtyunit cpet_formuom Formula UoM
prcgcndnfmlacommodityquantity cpet_formcommquan Comm.Qty Item
prcgcndnfmlacmmdtyquantityunit cpet_formcommuom Commodity UoM
prcgcndnfmlaevaluationdatetime cpet_eval_timestamp_cds Eval. Date and Time
prcgcndnfmlacombinationroutine cpet_combrout Combination Routine
prcgcndnfmlaevaluationmodule cpet_module Module
prcgcndnfmlacombnroutinesubmdl cpet_log_submodule Submodule
originsystem cpet_formlogsys LogSys: Formula
prcgcndnfmlavaldtystrtdatetime cpet_validfrom_cds Valid From
conditionvalidityenddate kodatbi Valid To
conditionvaliditystartdate kodatab Valid From
sourcingprojectquotation vdm_sourcingprojectquotation Supplier Quotation
sourcingprojectquotationitem vdm_srcgprojqtnitem Item
srcgprojquotationversion vdm_srcgprojqtnversion Version
srcgprojqtnitemuuid vdm_srcgprojqtnitemuuid Supplier Quotation Item UUID
sourcingprojectquotationuuid vdm_srcgprojquotationuuid Supplier Quotation UUID
procmthubplantuniqueid mmpur_be_plant_unique_id Plant Unique ID
currency konwa Cond. Currency
conditionratevalue kbetr_kond Amount
conditionratevalueunit konwa Cond. Currency
conditioncalculationtypeshort krech Calculat.Type
conditionquantity kpein Pricing Unit
conditionquantityunit kmein Unit of Measure
conditionapplication kappl Application
conditionisdeleted loevm_ko Deletion Indic.

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_SRCGPROJQTNCMMDTYFORMULATP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQCNDNFML_D (
    MANDT,                           -- Client [mandt]
    CONDITIONRECORD,                 -- Cond.Record No. [knumh]
    CONDITIONSEQUENTIALNUMBERSHORT,  -- Sequent. No. of Cond [kopos]
    DOCITEMCOMMODITYPRICINGUUID,     -- Doc. Item GUID [cpet_docitem_guid]
    CONDITIONTYPE,                   -- Condition Type [cpet_cond_type]
    PRICINGCONDITIONFORMULAKEY,      -- Formula Key [cpet_formid]
    PRCGCONDITIONFORMULAINPUTUUID,   -- Doc. Form. GUID [cpet_forminput_guid]
    PRCGCNDNFMLAAMTINDOCCURRENCY,    -- Form. Doc. Crcy [cpet_formval_doccurr_cds]
    PRCGCNDNFORMULAAMOUNTCURRENCY,   -- Doc. Currency [cpet_doccurr]
    PRICINGCONDITIONFORMULARATE,     -- Formula Rate [cpet_formrate_cds]
    PRCGCNDNFORMULARATECURRENCY,     -- Formula Currency [cpet_formcurr]
    PRCGCNDNFORMULARATEQUANTITY,     -- Formula Price Unit [cpet_formprun]
    PRCGCNDNFORMULARATEQTYUNIT,      -- Formula UoM [cpet_formuom]
    PRCGCNDNFMLACOMMODITYQUANTITY,   -- Comm.Qty Item [cpet_formcommquan]
    PRCGCNDNFMLACMMDTYQUANTITYUNIT,  -- Commodity UoM [cpet_formcommuom]
    PRCGCNDNFMLAEVALUATIONDATETIME,  -- Eval. Date and Time [cpet_eval_timestamp_cds]
    PRCGCNDNFMLACOMBINATIONROUTINE,  -- Combination Routine [cpet_combrout]
    PRCGCNDNFMLAEVALUATIONMODULE,    -- Module [cpet_module]
    PRCGCNDNFMLACOMBNROUTINESUBMDL,  -- Submodule [cpet_log_submodule]
    ORIGINSYSTEM,                    -- LogSys: Formula [cpet_formlogsys]
    PRCGCNDNFMLAVALDTYSTRTDATETIME,  -- Valid From [cpet_validfrom_cds]
    CONDITIONVALIDITYENDDATE,        -- Valid To [kodatbi]
    CONDITIONVALIDITYSTARTDATE,      -- Valid From [kodatab]
    SOURCINGPROJECTQUOTATION,        -- Supplier Quotation [vdm_sourcingprojectquotation]
    SOURCINGPROJECTQUOTATIONITEM,    -- Item [vdm_srcgprojqtnitem]
    SRCGPROJQUOTATIONVERSION,        -- Version [vdm_srcgprojqtnversion]
    SRCGPROJQTNITEMUUID,             -- Supplier Quotation Item UUID [vdm_srcgprojqtnitemuuid]
    SOURCINGPROJECTQUOTATIONUUID,    -- Supplier Quotation UUID [vdm_srcgprojquotationuuid]
    PROCMTHUBPLANTUNIQUEID,          -- Plant Unique ID [mmpur_be_plant_unique_id]
    CURRENCY,                        -- Cond. Currency [konwa]
    CONDITIONRATEVALUE,              -- Amount [kbetr_kond]
    CONDITIONRATEVALUEUNIT,          -- Cond. Currency [konwa]
    CONDITIONCALCULATIONTYPESHORT,   -- Calculat.Type [krech]
    CONDITIONQUANTITY,               -- Pricing Unit [kpein]
    CONDITIONQUANTITYUNIT,           -- Unit of Measure [kmein]
    CONDITIONAPPLICATION,            -- Application [kappl]
    CONDITIONISDELETED,              -- Deletion Indic. [loevm_ko]
    PRIMARY KEY (MANDT, CONDITIONRECORD, CONDITIONSEQUENTIALNUMBERSHORT)
);

Learn More