I_CmmdtyPrcgCndnTermQuotation

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CmmdtyPrcgCndnTermQuotation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CmmdtyPrcgCndnTermQuotation AS
SELECT
  docitemcond_guid AS DocItmCmmdtyPrcgCndnUUID,
  termno AS PricingConditionTerm,
  quotation_timestamp AS PrcgCndnTermQuotationDateTime,
  quotation AS PrcgConditionTermQuotationRate,
  quotation_currency AS PrcgCndnTrmQtanRateCurrency,
  quotation_priceunit AS PrcgCndnTrmQtanRateQuantity,
  quotation_unitofmeasure AS PrcgCndnTrmQtanRateQtyUnit,
  quotation_status AS PrcgCndnTermQuotationStatus,
  quotation_in_termcurr AS PrcgCndnTrmQtanInTrmCrcyRate,
  termcurr AS ConditionTermRateCurrency,
  termprun AS ConditionTermRateQuantity,
  termuom AS ConditionTermRateQuantityUnit,
  exchangerate AS PricingConditionExchangeRate,
  keydate AS MaturityKeyDate,
  substitution_timestamp AS PrcgCndnTrmQtanSubstnDateTime,
  closed_market AS PrcgCndnTrmQtanIsNonTradingDay,
  missing AS PrcgCndnTermQuotationIsMissing,
  substituted AS PrcgCndnTrmQtanIsSubstituted,
  ignored AS PrcgCndnTrmQuotationIsIgnored,
  perioddetermination_uuid AS CndnTrmQtanPerdDetnResultUUID,
  docitem_guid AS DocItemCommodityPricingUUID,
  cond_type AS ConditionType,
  curve_reading_date AS CommodityCurveReadingDate,
  rounded_quotation AS PrcgCndnTermQtanRoundedRate,
  delivery_from AS PrcgCndnTrmQtanDelivStartDate,
  delivery_to AS PrcgCndnTrmQtanDeliveryEndDate,
  quotgrouppos AS CmmdtyPrcgCndnQtanGroupItem
FROM cpe_quotation
;