CPEC_QUOTRULE

Transparent Table Control Table (SAP+Cust)
23 Fields 9 CDS Views

CPE Quotation Rule

CPEC_QUOTRULE is an SAP database table in S/4HANA. CPE Quotation Rule. It contains 23 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
/dmbe/i_Cpe_Index view from Index
/dmbe/I_Cpe_Quot_Rule view from CPE Quotation Rule
I_CmmdtyPrcgQtanRuleDefinition view_entity from BASIC Quotation Rule
I_CmmdtyPricingQuotationRule view from BASIC CPE Quotation Rule
I_PpaytCmmdtyQtnRule view from BASIC Quotation Rule data for Prepayments
P_CmmdtyPrcFixationOptionPurg view left_outer BASIC Cmmdty Price Fixation Option Purchasing
P_CmmdtyPrcFixationOptionSales view left_outer BASIC Commodity Price Fixation Option Sales
P_PrcFixationOptionBsHndlgPurg view left_outer BASIC Cmmdt Prc Fix Option Basis Handling Purg
P_PrcFixationOptionBsHndlgSls view left_outer BASIC Cmmdt Prc Fix Option Basis Handling Sls

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY logsys LOGSYS Logical system
KEY quotationrule CPET_QUOTATIONRULE Quotation Rule
KEY validfrom CPET_VALIDFROM Valid From
quotkey CPET_QUOTKEY_ALL Quot. Key Type
dcsid TBA_DCSID DCS ID
mic TBA_MIC MIC
tenor TBA_TENOR Time to Maturity
pricetype TBA_PRICETYPE Price Type
forecast_routine CPET_QUOTFORECASTROUT QuotForecast Routine
curve_type TBA_CURVETYPE Cty Curve Type
curve_dcsid CPET_CURVE_DCSID Alternative DCSID
curve_mic CPET_CURVE_MIC Alternative MIC
dcs_selection_type CPET_KEYDATE_SELECTION_TYPE Maturity Sel. Type
timing TBA_TIMING Timing
keydate_refdate_rout CPET_KEYDATE_REFDATE_ROUT Maturity Ref.Date
keydate_selection_rout CPET_KEYDATE_SELECTION_ROUT Maturity Sel. Rt.
keydate_offset_rout CPET_KEYDATE_OFFSET_ROUT Date Offset Routine
keydate_offset_units CPET_KEYDATE_OFFSETUNITS No. Time Units
dcs_period_type TBA_PERIODTYPE Period Type
basis_type TBAC_BASIS_TYPE Basis Type
quotgroup CPET_QUOTGROUP Quotation Group
dcs_type TBA_DERIVATIVETYPE Derivative Category

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.

-- CPE Quotation Rule
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPEC_QUOTRULE (
    CLIENT,                  -- Client [MANDT]
    LOGSYS,                  -- Logical system [LOGSYS]
    QUOTATIONRULE,           -- Quotation Rule [CPET_QUOTATIONRULE]
    VALIDFROM,               -- Valid From [CPET_VALIDFROM]
    QUOTKEY,                 -- Quot. Key Type [CPET_QUOTKEY_ALL]
    DCSID,                   -- DCS ID [TBA_DCSID]
    MIC,                     -- MIC [TBA_MIC]
    TENOR,                   -- Time to Maturity [TBA_TENOR]
    PRICETYPE,               -- Price Type [TBA_PRICETYPE]
    FORECAST_ROUTINE,        -- QuotForecast Routine [CPET_QUOTFORECASTROUT]
    CURVE_TYPE,              -- Cty Curve Type [TBA_CURVETYPE]
    CURVE_DCSID,             -- Alternative DCSID [CPET_CURVE_DCSID]
    CURVE_MIC,               -- Alternative MIC [CPET_CURVE_MIC]
    DCS_SELECTION_TYPE,      -- Maturity Sel. Type [CPET_KEYDATE_SELECTION_TYPE]
    TIMING,                  -- Timing [TBA_TIMING]
    KEYDATE_REFDATE_ROUT,    -- Maturity Ref.Date [CPET_KEYDATE_REFDATE_ROUT]
    KEYDATE_SELECTION_ROUT,  -- Maturity Sel. Rt. [CPET_KEYDATE_SELECTION_ROUT]
    KEYDATE_OFFSET_ROUT,     -- Date Offset Routine [CPET_KEYDATE_OFFSET_ROUT]
    KEYDATE_OFFSET_UNITS,    -- No. Time Units [CPET_KEYDATE_OFFSETUNITS]
    DCS_PERIOD_TYPE,         -- Period Type [TBA_PERIODTYPE]
    BASIS_TYPE,              -- Basis Type [TBAC_BASIS_TYPE]
    QUOTGROUP,               -- Quotation Group [CPET_QUOTGROUP]
    DCS_TYPE,                -- Derivative Category [TBA_DERIVATIVETYPE]
    PRIMARY KEY (CLIENT, LOGSYS, QUOTATIONRULE, VALIDFROM)
);

Learn More