CPE_QTGP_ITMQUOT

Transparent Table Application Table
26 Fields 1 CDS Views

CPE Quotation Group Item Quotation

CPE_QTGP_ITMQUOT is an SAP database table in S/4HANA. CPE Quotation Group Item Quotation. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyPrcgCndnQtanGrpItmQtan view_entity from BASIC CPE Quotation Group Item Quotation

Fields (26)

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 quotgrouppos cpet_quotgrouppos Position
KEY quotation_timestamp cpet_quotation_timestamp Quotation Time Stamp
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
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
quotation_rate cpet_pricequot_df34 Price Quotation
quotation_group_rate cmm_cpe_prcqtan_qtan_grp_rate Qtan Group Currency
quotation_group_currency cmm_cpe_quotcurr_gr QtnGrpCurr
quotation_group_rate_quantity cpet_quotprun_gr PrUnit QuotGrp
quotation_group_uom cpet_quotuom_gr QuotGroup UoM
quotation_forecast_status cpet_forecast_status Forecast Status
commodity_curve_reading_date cpet_curve_reading_date Reading Date
quotation_rounded_rate vfprc_pricequot_rnd_df34 Rounded Price Quot
quotation_delivery_start_date tbac_delivery_from Delivery Start Date
quotation_delivery_end_date tbac_delivery_to Delivery End Date

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 Group Item Quotation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPE_QTGP_ITMQUOT (
    CLIENT,                         -- Client [mandt]
    DOCITEMCOND_GUID,               -- Doc. Cond. Item GUID [cpet_docitemcond_guid]
    TERMNO,                         -- Term Number [cpet_termno]
    QUOTGROUPPOS,                   -- Position [cpet_quotgrouppos]
    QUOTATION_TIMESTAMP,            -- Quotation Time Stamp [cpet_quotation_timestamp]
    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]
    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]
    QUOTATION_RATE,                 -- Price Quotation [cpet_pricequot_df34]
    QUOTATION_GROUP_RATE,           -- Qtan Group Currency [cmm_cpe_prcqtan_qtan_grp_rate]
    QUOTATION_GROUP_CURRENCY,       -- QtnGrpCurr [cmm_cpe_quotcurr_gr]
    QUOTATION_GROUP_RATE_QUANTITY,  -- PrUnit QuotGrp [cpet_quotprun_gr]
    QUOTATION_GROUP_UOM,            -- QuotGroup UoM [cpet_quotuom_gr]
    QUOTATION_FORECAST_STATUS,      -- Forecast Status [cpet_forecast_status]
    COMMODITY_CURVE_READING_DATE,   -- Reading Date [cpet_curve_reading_date]
    QUOTATION_ROUNDED_RATE,         -- Rounded Price Quot [vfprc_pricequot_rnd_df34]
    QUOTATION_DELIVERY_START_DATE,  -- Delivery Start Date [tbac_delivery_from]
    QUOTATION_DELIVERY_END_DATE,    -- Delivery End Date [tbac_delivery_to]
    PRIMARY KEY (CLIENT, DOCITEMCOND_GUID, TERMNO, QUOTGROUPPOS, QUOTATION_TIMESTAMP)
);

Learn More