I_PURHUBCOMMODITYTERMQUOTATION

CDS View
19 Fields 1 CDS Views

Purchase Commodity Term Quotation

I_PURHUBCOMMODITYTERMQUOTATION is a CDS View in S/4HANA. Purchase Commodity Term Quotation. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurHubSmrtCmmdtyTrmQtanUnion view_entity union_all COMPOSITE Union Layer Purchase Hub Quotation

Fields (19)

KeyField CDS FieldsUsed in Views
KEY ConditionSequentialNumberShort ConditionSequentialNumberShort 1
KEY PrcgCndnTermQuotationDateTime PrcgCndnTermQuotationDateTime 1
KEY PricingConditionTerm PricingConditionTerm 1
_PrcgCndnTrmQtanRateQtyUnit _PrcgCndnTrmQtanRateQtyUnit 1
_QuotationCurrency _QuotationCurrency 1
CndnTrmQtanPerdDetnResultUUID CndnTrmQtanPerdDetnResultUUID 1
ConditionType ConditionType 1
MaturityKeyDate MaturityKeyDate 1
PrcgCndnTermQuotationIsMissing PrcgCndnTermQuotationIsMissing 1
PrcgCndnTrmQtanForecastStatus PrcgCndnTrmQtanForecastStatus 1
PrcgCndnTrmQtanIsNonTradingDay PrcgCndnTrmQtanIsNonTradingDay 1
PrcgCndnTrmQtanIsSubstituted PrcgCndnTrmQtanIsSubstituted 1
PrcgCndnTrmQtanRateCurrency PrcgCndnTrmQtanRateCurrency 1
PrcgCndnTrmQtanRateQtyUnit PrcgCndnTrmQtanRateQtyUnit 1
PrcgCndnTrmQtanRateQuantity PrcgCndnTrmQtanRateQuantity 1
PrcgCndnTrmQtanSubstnDateTime PrcgCndnTrmQtanSubstnDateTime 1
PrcgCndnTrmQuotationIsIgnored PrcgCndnTrmQuotationIsIgnored 1
PrcgConditionTermQuotationRate PrcgConditionTermQuotationRate 1
PricingConditionExchangeRate PricingConditionExchangeRate 1

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.

-- Purchase Commodity Term Quotation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURHUBCOMMODITYTERMQUOTATION (
    CONDITIONSEQUENTIALNUMBERSHORT,
    PRCGCNDNTERMQUOTATIONDATETIME,
    PRICINGCONDITIONTERM,
    _PRCGCNDNTRMQTANRATEQTYUNIT,
    _QUOTATIONCURRENCY,
    CNDNTRMQTANPERDDETNRESULTUUID,
    CONDITIONTYPE,
    MATURITYKEYDATE,
    PRCGCNDNTERMQUOTATIONISMISSING,
    PRCGCNDNTRMQTANFORECASTSTATUS,
    PRCGCNDNTRMQTANISNONTRADINGDAY,
    PRCGCNDNTRMQTANISSUBSTITUTED,
    PRCGCNDNTRMQTANRATECURRENCY,
    PRCGCNDNTRMQTANRATEQTYUNIT,
    PRCGCNDNTRMQTANRATEQUANTITY,
    PRCGCNDNTRMQTANSUBSTNDATETIME,
    PRCGCNDNTRMQUOTATIONISIGNORED,
    PRCGCONDITIONTERMQUOTATIONRATE,
    PRICINGCONDITIONEXCHANGERATE,
    PRIMARY KEY (CONDITIONSEQUENTIALNUMBERSHORT, PRCGCNDNTERMQUOTATIONDATETIME, PRICINGCONDITIONTERM)
);

Learn More