MMSPQCEXRATE_D

Transparent Table Application Table
38 Fields 1 CDS Views

Draft table for entity R_SPQtnItmCmmdtyExchangeRatTP

MMSPQCEXRATE_D is an SAP database table in S/4HANA. Draft table for entity R_SPQtnItmCmmdtyExchangeRatTP. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SPQtnItmCmmdtyExchRateDraft view_entity from BASIC Srcg Proj Qtn Cmmdty ExchRate - Draft

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY conditionrecord knumh Cond.Record No.
KEY conditionsequentialnumbershort kopos Sequent. No. of Cond
KEY pricingconditionterm cpet_termno Term Number
KEY prcgcndntrmexchratedatetime cpet_exchangerate_timestamp Exch Rate Time Stamp
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
conditionvalidityenddate kodatbi Valid To
conditionvaliditystartdate kodatab Valid From
procmthubplantuniqueid mmpur_be_plant_unique_id Plant Unique ID
conditiontype kscha Condition Type
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.
docitemcommoditypricinguuid guid GUID
cndnexchrateperddetnresultuuid cpet_perioddtout_guid PerDet.Out.GUID
prcgconditionexchangeratetype kurst_curr Exch. Rate Type
pricingconditionsourcecurrency cpet_currfrom Curr:Conv. from
pricingconditiontargetcurrency cpet_currto Curr.: Conv. to
numberofsourcecurrencyunits ffact_curr Ratio (from)
numberoftargetcurrencyunits tfact_curr Ratio (to)
cndntrmexchratesubstndatetime cpet_substitution_timestamp Subst Time Stamp
cndntrmexchrateisnontradingday cpet_exchrate_closed_market Non-Trading Day
prcgcndntrmexchrateismissing cpet_exchrate_missing ExchangeRate Missing
cndntrmexchrateissubstituted cpet_exchrate_substituted Substitute Exr
prcgcndntrmexchrateisignored cpet_exchrate_ignored Exchg. Rate Ignored
prcgcndntrmexchratefcststatus cpet_forecast_status Forecast Status
pricingconditionexchangerate cpet_usedexchrate Conv.:Ex.Rate
prcgconditionswapexchangerate cmm_swap_rate Swap Exchange Rate
prcgconditionspotexchangerate cmm_spot_rate Spot Exchange Rate

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_SPQtnItmCmmdtyExchangeRatTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSPQCEXRATE_D (
    MANDT,                           -- Client [mandt]
    CONDITIONRECORD,                 -- Cond.Record No. [knumh]
    CONDITIONSEQUENTIALNUMBERSHORT,  -- Sequent. No. of Cond [kopos]
    PRICINGCONDITIONTERM,            -- Term Number [cpet_termno]
    PRCGCNDNTRMEXCHRATEDATETIME,     -- Exch Rate Time Stamp [cpet_exchangerate_timestamp]
    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]
    CONDITIONVALIDITYENDDATE,        -- Valid To [kodatbi]
    CONDITIONVALIDITYSTARTDATE,      -- Valid From [kodatab]
    PROCMTHUBPLANTUNIQUEID,          -- Plant Unique ID [mmpur_be_plant_unique_id]
    CONDITIONTYPE,                   -- Condition Type [kscha]
    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]
    DOCITEMCOMMODITYPRICINGUUID,     -- GUID [guid]
    CNDNEXCHRATEPERDDETNRESULTUUID,  -- PerDet.Out.GUID [cpet_perioddtout_guid]
    PRCGCONDITIONEXCHANGERATETYPE,   -- Exch. Rate Type [kurst_curr]
    PRICINGCONDITIONSOURCECURRENCY,  -- Curr:Conv. from [cpet_currfrom]
    PRICINGCONDITIONTARGETCURRENCY,  -- Curr.: Conv. to [cpet_currto]
    NUMBEROFSOURCECURRENCYUNITS,     -- Ratio (from) [ffact_curr]
    NUMBEROFTARGETCURRENCYUNITS,     -- Ratio (to) [tfact_curr]
    CNDNTRMEXCHRATESUBSTNDATETIME,   -- Subst Time Stamp [cpet_substitution_timestamp]
    CNDNTRMEXCHRATEISNONTRADINGDAY,  -- Non-Trading Day [cpet_exchrate_closed_market]
    PRCGCNDNTRMEXCHRATEISMISSING,    -- ExchangeRate Missing [cpet_exchrate_missing]
    CNDNTRMEXCHRATEISSUBSTITUTED,    -- Substitute Exr [cpet_exchrate_substituted]
    PRCGCNDNTRMEXCHRATEISIGNORED,    -- Exchg. Rate Ignored [cpet_exchrate_ignored]
    PRCGCNDNTRMEXCHRATEFCSTSTATUS,   -- Forecast Status [cpet_forecast_status]
    PRICINGCONDITIONEXCHANGERATE,    -- Conv.:Ex.Rate [cpet_usedexchrate]
    PRCGCONDITIONSWAPEXCHANGERATE,   -- Swap Exchange Rate [cmm_swap_rate]
    PRCGCONDITIONSPOTEXCHANGERATE,   -- Spot Exchange Rate [cmm_spot_rate]
    PRIMARY KEY (MANDT, CONDITIONRECORD, CONDITIONSEQUENTIALNUMBERSHORT, PRICINGCONDITIONTERM, PRCGCNDNTRMEXCHRATEDATETIME)
);

Learn More