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 Quotation in Quotation Group Item

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