MMSPQCNDNTERM_D

Transparent Table Application Table
81 Fields 1 CDS Views

Draft table for entity R_SRCGPROJQTNITMCMMDTYTERMTP

MMSPQCNDNTERM_D is an SAP database table in S/4HANA. Draft table for entity R_SRCGPROJQTNITMCMMDTYTERMTP. It contains 81 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SrcgProjQtnItmCmmdtyTrmDraft view_entity from BASIC SrcgProjQtn item commodity term - Draft

Fields (81)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY conditionrecord knumh Cond.Record No.
KEY conditionsequentialnumbershort kopos Sequent. No. of Cond
pricingconditionterm cpet_termno Term Number
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
originsystem cpet_formlogsys LogSys: Formula
prcgcndnfmlacommodityquantity cpet_formcommquan Comm.Qty Item
prcgcndnfmlacmmdtyquantityunit cpet_formcommuom Commodity UoM
prcgcndnfmlaevaluationdatetime cpet_eval_timestamp_cds Eval. Date and Time
cndnexchrateperddetnresultuuid cpet_perioddtout_guid PerDet.Out.GUID
prcgcndntrmconversioninputuuid cpet_termconvin_guid ConvInputGUID
prcgcndntermconversionrsltuuid cpet_termconvout_guid ConvResultGUID
pricingconditionsourcecurrency cpet_currfrom Curr:Conv. from
pricingconditiontargetcurrency cpet_currto Curr.: Conv. to
prcgcndnsourcequantityunit cpet_uomfrom UoM: Conv. from
prcgcndntargetquantityunit cpet_uomto UoM: Conv. to
pricingconditionconversionrule cpet_conversionrule Conv. Rule
prcgconditionfixedexchangerate cpet_fixexchrate Fix.Exch.Rate
cndncnvrsnrulevaldtystrtdtetme cpet_validfrom_cds Valid From
cndntrmcnvrsnvaldtystrtdtetme cpet_validfrom_cds Valid From
prcgconditionconversionplace cpet_convplace Conv. Place
prcgcndngrptrmvaldtystrtdtetme cpet_validfrom_cds Valid From
pricingconditiontermkey cpet_termid Term Key
prcgcndntrmvaldtystartdatetime cpet_validfrom_cds Valid From
prcgcndnfmlaevaluationmodule cpet_module Module
cndntrmcalctyperoutinesubmdl cpet_log_submodule Submodule
prcgcndntermcalculationtype cpet_termtype Calculation Type
pricingconditiontermrule cpet_termrule Term Rule
cndntrmrulevaldtystartdatetime cpet_validfrom_cds Valid From
prcgcndntermcalculationrule cpet_calcrule Calculation Rule
cndncalcrulevaldtystrtdatetime cpet_validfrom_cds Valid From
prcgcndntermquotationrule cpet_quotationrule Quotation Rule
cndnqtanrulevaldtystrtdatetime cpet_validfrom_cds Valid From
pricingconditiontermrate cpet_termrate_cds Term Rate
prcgconditiontermratecrcy cpet_termcurr Term Currency
prcgconditiontermrateqty cpet_termprun Term Price Unit
prcgconditiontermrateqtyunit cpet_termuom Term UoM
prcgconditiontermquotationrate cpet_pricequot_cds Price Quotation
prcgcndntrmqtanratecurrency cpet_quotcurr Qtn Currency
prcgcndntrmqtanratequantity cpet_quotprun Quotation PU
prcgcndntrmqtanrateqtyunit cpet_quotuom Quotation UoM
prcgcndntrmqtanperdstrtdtetime cpet_firsttimestamp_cds Begin of Period
prcgcndntrmqtanperdenddatetime cpet_lasttimestamp_cds End of Period
prcgcndntrmqtanperdrefdate cpet_refdate Reference Date
prcgcndntrmqtanperdbasedtetime cpet_basetimestamp_cds Calculated Base Date
cndntrmexchrateperdstrtdtetime cpet_firsttimestamp_cds Begin of Period
cndntrmexchrateperdenddatetime cpet_lasttimestamp_cds End of Period
prcgcndntrmexchrateperdrefdate cpet_refdate Reference Date
cndntrmexchrateperdbasedtetime cpet_basetimestamp_cds Calculated Base Date
prcgconditiontermsurchargerate cpet_surchargerate_cds Total Surcharge
prcgcndntrmsurchargertecrcy cpet_surchratecurr AbsSurchCurr
prcgcndntrmsurchargerteqty cpet_surchrateprun AbsSurch PU
prcgcndntrmsurchargerteqtyunit cpet_surchrateuom AbsSurchUoM
pricingconditiontermgroup cpet_termgroup Term Group
pricingconditiontermfixedrate cpet_fixtermrate_cds Fixed Rate
prcgconditiontermfixedratecrcy cpet_fixcurr Currency Fixed Rate
prcgconditiontermfixedrateqty cpet_fixprun PrcUnit Fixed Value
prcgcndntermfixedrateqtyunit cpet_fixuom UoM for Fixed Value
derivativecontrspecification tba_dcsid DCS ID
marketidentifiercode tba_mic MIC
timetomaturity tba_tenor Time to Maturity
quotationpricetype tba_pricetype Price Type
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_SRCGPROJQTNITMCMMDTYTERMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQCNDNTERM_D (
    MANDT,                           -- Client [mandt]
    CONDITIONRECORD,                 -- Cond.Record No. [knumh]
    CONDITIONSEQUENTIALNUMBERSHORT,  -- Sequent. No. of Cond [kopos]
    PRICINGCONDITIONTERM,            -- Term Number [cpet_termno]
    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]
    ORIGINSYSTEM,                    -- LogSys: Formula [cpet_formlogsys]
    PRCGCNDNFMLACOMMODITYQUANTITY,   -- Comm.Qty Item [cpet_formcommquan]
    PRCGCNDNFMLACMMDTYQUANTITYUNIT,  -- Commodity UoM [cpet_formcommuom]
    PRCGCNDNFMLAEVALUATIONDATETIME,  -- Eval. Date and Time [cpet_eval_timestamp_cds]
    CNDNEXCHRATEPERDDETNRESULTUUID,  -- PerDet.Out.GUID [cpet_perioddtout_guid]
    PRCGCNDNTRMCONVERSIONINPUTUUID,  -- ConvInputGUID [cpet_termconvin_guid]
    PRCGCNDNTERMCONVERSIONRSLTUUID,  -- ConvResultGUID [cpet_termconvout_guid]
    PRICINGCONDITIONSOURCECURRENCY,  -- Curr:Conv. from [cpet_currfrom]
    PRICINGCONDITIONTARGETCURRENCY,  -- Curr.: Conv. to [cpet_currto]
    PRCGCNDNSOURCEQUANTITYUNIT,      -- UoM: Conv. from [cpet_uomfrom]
    PRCGCNDNTARGETQUANTITYUNIT,      -- UoM: Conv. to [cpet_uomto]
    PRICINGCONDITIONCONVERSIONRULE,  -- Conv. Rule [cpet_conversionrule]
    PRCGCONDITIONFIXEDEXCHANGERATE,  -- Fix.Exch.Rate [cpet_fixexchrate]
    CNDNCNVRSNRULEVALDTYSTRTDTETME,  -- Valid From [cpet_validfrom_cds]
    CNDNTRMCNVRSNVALDTYSTRTDTETME,   -- Valid From [cpet_validfrom_cds]
    PRCGCONDITIONCONVERSIONPLACE,    -- Conv. Place [cpet_convplace]
    PRCGCNDNGRPTRMVALDTYSTRTDTETME,  -- Valid From [cpet_validfrom_cds]
    PRICINGCONDITIONTERMKEY,         -- Term Key [cpet_termid]
    PRCGCNDNTRMVALDTYSTARTDATETIME,  -- Valid From [cpet_validfrom_cds]
    PRCGCNDNFMLAEVALUATIONMODULE,    -- Module [cpet_module]
    CNDNTRMCALCTYPEROUTINESUBMDL,    -- Submodule [cpet_log_submodule]
    PRCGCNDNTERMCALCULATIONTYPE,     -- Calculation Type [cpet_termtype]
    PRICINGCONDITIONTERMRULE,        -- Term Rule [cpet_termrule]
    CNDNTRMRULEVALDTYSTARTDATETIME,  -- Valid From [cpet_validfrom_cds]
    PRCGCNDNTERMCALCULATIONRULE,     -- Calculation Rule [cpet_calcrule]
    CNDNCALCRULEVALDTYSTRTDATETIME,  -- Valid From [cpet_validfrom_cds]
    PRCGCNDNTERMQUOTATIONRULE,       -- Quotation Rule [cpet_quotationrule]
    CNDNQTANRULEVALDTYSTRTDATETIME,  -- Valid From [cpet_validfrom_cds]
    PRICINGCONDITIONTERMRATE,        -- Term Rate [cpet_termrate_cds]
    PRCGCONDITIONTERMRATECRCY,       -- Term Currency [cpet_termcurr]
    PRCGCONDITIONTERMRATEQTY,        -- Term Price Unit [cpet_termprun]
    PRCGCONDITIONTERMRATEQTYUNIT,    -- Term UoM [cpet_termuom]
    PRCGCONDITIONTERMQUOTATIONRATE,  -- Price Quotation [cpet_pricequot_cds]
    PRCGCNDNTRMQTANRATECURRENCY,     -- Qtn Currency [cpet_quotcurr]
    PRCGCNDNTRMQTANRATEQUANTITY,     -- Quotation PU [cpet_quotprun]
    PRCGCNDNTRMQTANRATEQTYUNIT,      -- Quotation UoM [cpet_quotuom]
    PRCGCNDNTRMQTANPERDSTRTDTETIME,  -- Begin of Period [cpet_firsttimestamp_cds]
    PRCGCNDNTRMQTANPERDENDDATETIME,  -- End of Period [cpet_lasttimestamp_cds]
    PRCGCNDNTRMQTANPERDREFDATE,      -- Reference Date [cpet_refdate]
    PRCGCNDNTRMQTANPERDBASEDTETIME,  -- Calculated Base Date [cpet_basetimestamp_cds]
    CNDNTRMEXCHRATEPERDSTRTDTETIME,  -- Begin of Period [cpet_firsttimestamp_cds]
    CNDNTRMEXCHRATEPERDENDDATETIME,  -- End of Period [cpet_lasttimestamp_cds]
    PRCGCNDNTRMEXCHRATEPERDREFDATE,  -- Reference Date [cpet_refdate]
    CNDNTRMEXCHRATEPERDBASEDTETIME,  -- Calculated Base Date [cpet_basetimestamp_cds]
    PRCGCONDITIONTERMSURCHARGERATE,  -- Total Surcharge [cpet_surchargerate_cds]
    PRCGCNDNTRMSURCHARGERTECRCY,     -- AbsSurchCurr [cpet_surchratecurr]
    PRCGCNDNTRMSURCHARGERTEQTY,      -- AbsSurch PU [cpet_surchrateprun]
    PRCGCNDNTRMSURCHARGERTEQTYUNIT,  -- AbsSurchUoM [cpet_surchrateuom]
    PRICINGCONDITIONTERMGROUP,       -- Term Group [cpet_termgroup]
    PRICINGCONDITIONTERMFIXEDRATE,   -- Fixed Rate [cpet_fixtermrate_cds]
    PRCGCONDITIONTERMFIXEDRATECRCY,  -- Currency Fixed Rate [cpet_fixcurr]
    PRCGCONDITIONTERMFIXEDRATEQTY,   -- PrcUnit Fixed Value [cpet_fixprun]
    PRCGCNDNTERMFIXEDRATEQTYUNIT,    -- UoM for Fixed Value [cpet_fixuom]
    DERIVATIVECONTRSPECIFICATION,    -- DCS ID [tba_dcsid]
    MARKETIDENTIFIERCODE,            -- MIC [tba_mic]
    TIMETOMATURITY,                  -- Time to Maturity [tba_tenor]
    QUOTATIONPRICETYPE,              -- Price Type [tba_pricetype]
    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