I_CmmdtyPrcgQtanRuleDefinition

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_CmmdtyPrcgQtanRuleDefinition.
-- 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_CmmdtyPrcgQtanRuleDefinition AS
SELECT
  logsys AS OriginSystem,
  quotationrule AS PrcgCndnTermQuotationRule,
  cast( cpec_quotrule.validfrom as cpet_validfrom_cds preserving type ) AS CmmdtyPrcgValdtyStartDateTime,
  quotkey AS PricingConditionQuotationKey,
  dcsid AS DerivativeContrSpecification,
  mic AS MarketIdentifierCode,
  tenor AS TimeToMaturity,
  pricetype AS PriceQuotationType,
  curve_type AS CommodityCurveType,
  curve_dcsid AS AltvDrvtvContractSpecification,
  curve_mic AS AltvMarketIdentifierCode,
  dcs_selection_type AS MaturitySelectionType,
  timing AS CmmdtyForwardIndexTiming,
  keydate_refdate_rout AS TrmMaturitySelRefDateRoutine,
  keydate_selection_rout AS PrcgCndnTrmMaturitySelRoutine,
  keydate_offset_rout AS CndnTrmPerdDetnDteOffstRoutine,
  keydate_offset_units AS DteOffsetRoutineTimeUnitAmount,
  dcs_period_type AS DCSPeriodType,
  basis_type AS BasisType,
  quotgroup AS PricingCndnTermQuotationGroup,
  cast( dcs_type as cds_dcs_category ) AS DerivativeContractSpecCategory
FROM cpec_quotrule
;