CPE_QUOTATION

Transparent Table Application Table
29 Fields 1 CDS Views

CPE Quotation

CPE_QUOTATION is an SAP database table in S/4HANA. CPE Quotation. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyPrcgCndnTermQuotation view_entity from BASIC CPE Condition Quotation

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY docitemcond_guid cpet_docitemcond_guid Doc. Cond. Item GUID
KEY termno cpet_termno Term Number
KEY quotation_timestamp cpet_quotation_timestamp Quotation Time Stamp
quotation cpet_pricequot_df34 Price Quotation
quotation_currency cpet_quotcurr Qtn Currency
quotation_priceunit cpet_quotprun Quotation PU
quotation_unitofmeasure cpet_quotuom Quotation UoM
quotation_status cmm_quotation_status Quotation Status
quotation_in_termcurr cmm_quotation_in_termcurr_df34 Price Quota Conv
termcurr cpet_termcurr Term Currency
termprun cpet_termprun Term Price Unit
termuom cpet_termuom Term UoM
exchangerate cpet_usedexchrate Conv.:Ex.Rate
keydate tba_keydate Maturity Key Date
substitution_timestamp cpet_substitution_timestamp Subst Time Stamp
closed_market cpet_quotation_closed_market Non-Trading Day
missing cpet_quotation_missing Quotation Missing
substituted cpet_quotation_substituted Substitute Qtn
ignored cpet_quotation_ignored Quotation Ignored
forecast_status cpet_forecast_status Forecast Status
perioddetermination_uuid cpet_perioddtout_guid PerDet.Out.GUID
docitem_guid cpet_docitem_guid Doc. Item GUID
cond_type cpet_cond_type Condition Type
curve_reading_date cpet_curve_reading_date Reading Date
rounded_quotation vfprc_pricequot_rnd_df34 Rounded Price Quot
delivery_from tbac_delivery_from Delivery Start Date
delivery_to tbac_delivery_to Delivery End Date
quotgrouppos cpet_quotgrouppos Position

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPE_QUOTATION (
    CLIENT,                    -- Client [mandt]
    DOCITEMCOND_GUID,          -- Doc. Cond. Item GUID [cpet_docitemcond_guid]
    TERMNO,                    -- Term Number [cpet_termno]
    QUOTATION_TIMESTAMP,       -- Quotation Time Stamp [cpet_quotation_timestamp]
    QUOTATION,                 -- Price Quotation [cpet_pricequot_df34]
    QUOTATION_CURRENCY,        -- Qtn Currency [cpet_quotcurr]
    QUOTATION_PRICEUNIT,       -- Quotation PU [cpet_quotprun]
    QUOTATION_UNITOFMEASURE,   -- Quotation UoM [cpet_quotuom]
    QUOTATION_STATUS,          -- Quotation Status [cmm_quotation_status]
    QUOTATION_IN_TERMCURR,     -- Price Quota Conv [cmm_quotation_in_termcurr_df34]
    TERMCURR,                  -- Term Currency [cpet_termcurr]
    TERMPRUN,                  -- Term Price Unit [cpet_termprun]
    TERMUOM,                   -- Term UoM [cpet_termuom]
    EXCHANGERATE,              -- Conv.:Ex.Rate [cpet_usedexchrate]
    KEYDATE,                   -- Maturity Key Date [tba_keydate]
    SUBSTITUTION_TIMESTAMP,    -- Subst Time Stamp [cpet_substitution_timestamp]
    CLOSED_MARKET,             -- Non-Trading Day [cpet_quotation_closed_market]
    MISSING,                   -- Quotation Missing [cpet_quotation_missing]
    SUBSTITUTED,               -- Substitute Qtn [cpet_quotation_substituted]
    IGNORED,                   -- Quotation Ignored [cpet_quotation_ignored]
    FORECAST_STATUS,           -- Forecast Status [cpet_forecast_status]
    PERIODDETERMINATION_UUID,  -- PerDet.Out.GUID [cpet_perioddtout_guid]
    DOCITEM_GUID,              -- Doc. Item GUID [cpet_docitem_guid]
    COND_TYPE,                 -- Condition Type [cpet_cond_type]
    CURVE_READING_DATE,        -- Reading Date [cpet_curve_reading_date]
    ROUNDED_QUOTATION,         -- Rounded Price Quot [vfprc_pricequot_rnd_df34]
    DELIVERY_FROM,             -- Delivery Start Date [tbac_delivery_from]
    DELIVERY_TO,               -- Delivery End Date [tbac_delivery_to]
    QUOTGROUPPOS,              -- Position [cpet_quotgrouppos]
    PRIMARY KEY (CLIENT, DOCITEMCOND_GUID, TERMNO, QUOTATION_TIMESTAMP)
);

Learn More