I_CntrlPurContrCmmdtyTermNew

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_CntrlPurContrCmmdtyTermNew.
-- 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_CntrlPurContrCmmdtyTermNew AS
SELECT
  CmmdtyPrcgCndnRecdMapping.ConditionRecord AS ConditionRecord,
  CmmdtyPrcgCndnRecdMapping.ConditionSequentialNumber AS ConditionSequentialNumber,
  PurCtrCondItem.PurchaseContract AS CentralPurchaseContract,
  PurCtrCondItem.PurchaseContractItem AS CentralPurchaseContractItem,
  PurCtrCondItem.ConditionValidityEndDate AS ConditionValidityEndDate,
  term.PricingConditionTerm AS PricingConditionTerm,
  formula.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  formula.ConditionType AS ConditionType,
  formula.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  formula.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  cast ('' as cpet_formlogsys) AS OriginSystem,
  formula.PrcgCndnFmlaCommodityQuantity AS PrcgCndnFmlaCommodityQuantity,
  formula.PrcgCndnFmlaCmmdtyQuantityUnit AS PrcgCndnFmlaCmmdtyQuantityUnit,
  formula.PrcgCndnFmlaEvaluationDateTime AS PrcgCndnFmlaEvaluationDateTime,
  term.DocItmCmmdtyPrcgCndnUUID AS DocItmCmmdtyPrcgCndnUUID,
  termconv.PricingConditionSourceCurrency AS PricingConditionSourceCurrency,
  termconv.PricingConditionTargetCurrency AS PricingConditionTargetCurrency,
  termconv.PrcgCndnSourceQuantityUnit AS PrcgCndnSourceQuantityUnit,
  termconv.PrcgCndnTargetQuantityUnit AS PrcgCndnTargetQuantityUnit,
  termconv.PricingConditionConversionRule AS PricingConditionConversionRule,
  termconv.PrcgConditionFixedExchangeRate AS PrcgConditionFixedExchangeRate,
  cast ('' as cpet_validfrom_cds) AS CndnCnvrsnRuleValdtyStrtDteTme,
  cast ('' as cpet_validfrom_cds) AS CndnTrmCnvrsnValdtyStrtDteTme,
  termconv.PrcgConditionConversionPlace AS PrcgConditionConversionPlace,
  cast ('' as cpet_validfrom_cds) AS PrcgCndnGrpTrmValdtyStrtDteTme,
  term.PricingConditionTermKey AS PricingConditionTermKey,
  cast ('' as cpet_validfrom_cds) AS PrcgCndnTrmValdtyStartDateTime,
  cast ('FE' as cpet_module preserving type ) AS PrcgCndnFmlaEvaluationModule,
  cast ('05' as cpet_log_submodule) AS CndnTrmCalcTypeRoutineSubMdl,
  term.PrcgCndnTermCalculationType AS PrcgCndnTermCalculationType,
  term.PricingConditionTermRule AS PricingConditionTermRule,
  cast ('' as cpet_validfrom_cds) AS CndnTrmRuleValdtyStartDateTime,
  term.PrcgCndnTermCalculationRule AS PrcgCndnTermCalculationRule,
  cast ('' as cpet_validfrom_cds) AS CndnCalcRuleValdtyStrtDateTime,
  term.PrcgCndnTermQuotationRule AS PrcgCndnTermQuotationRule,
  cast ('' as cpet_validfrom_cds) AS CndnQtanRuleValdtyStrtDateTime,
  term.ConditionTermRate AS PricingConditionTermRate,
  term.ConditionTermRateCurrency AS PrcgConditionTermRateCrcy,
  term.ConditionTermRateQuantity AS PrcgConditionTermRateQty,
  term.ConditionTermRateQuantityUnit AS PrcgConditionTermRateQtyUnit,
  term.PrcgConditionTermQuotationRate AS PrcgConditionTermQuotationRate,
  term.PrcgCndnTrmQtanRateCurrency AS PrcgCndnTrmQtanRateCurrency,
  term.PrcgCndnTrmQtanRateQuantity AS PrcgCndnTrmQtanRateQuantity,
  term.PrcgCndnTrmQtanRateQtyUnit AS PrcgCndnTrmQtanRateQtyUnit,
  cast (term.CndnTrmQtnPerdDetnStartDteTime as cpet_firsttimestamp_cds preserving type ) AS PrcgCndnTrmQtanPerdStrtDteTime,
  cast (term.CndnTrmQtnPerdDetnEndDateTime as cpet_lasttimestamp_cds preserving type ) AS PrcgCndnTrmQtanPerdEndDateTime,
  term.TrmQtnPerdDetnCalcdRefDate AS PrcgCndnTrmQtanPerdRefDate,
  cast (term.TrmQtnPerdDetnCalcdBaseDteTme as cpet_basetimestamp_cds preserving type ) AS PrcgCndnTrmQtanPerdBaseDteTime,
  cast (term.CndnTrmCrcyPerdDetnStartDteTme as cpet_firsttimestamp_cds preserving type ) AS CndnTrmExchRatePerdStrtDteTime,
  cast (term.CndnTrmCrcyPerdDetnEndDateTime as cpet_lasttimestamp_cds preserving type ) AS CndnTrmExchRatePerdEndDateTime,
  term.TrmCrcyPerdDetnCalcdRefDate AS PrcgCndnTrmExchRatePerdRefDate,
  cast (term.TrmCrcyPerdDetnCalcdBaseDteTme as cpet_basetimestamp_cds preserving type ) AS CndnTrmExchRatePerdBaseDteTime,
  term.PrcgConditionTermSurchargeRate AS PrcgConditionTermSurchargeRate,
  term.PrcgCndnTrmSurchargeRteCrcy AS PrcgCndnTrmSurchargeRteCrcy,
  term.PrcgCndnTrmSurchargeRteQty AS PrcgCndnTrmSurchargeRteQty,
  term.PrcgCndnTrmSurchargeRteQtyUnit AS PrcgCndnTrmSurchargeRteQtyUnit,
  term.PricingConditionTermGroup AS PricingConditionTermGroup,
  term.PricingConditionTermFixedRate AS PricingConditionTermFixedRate,
  term.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
  term.PrcgConditionTermFixedRateQty AS PrcgConditionTermFixedRateQty,
  term.PrcgCndnTermFixedRateQtyUnit AS PrcgCndnTermFixedRateQtyUnit,
  term.DerivativeContrSpecification AS DerivativeContrSpecification,
  term.MarketIdentifierCode AS MarketIdentifierCode,
  term.TimeToMaturity AS TimeToMaturity,
  term.PriceQuotationType AS QuotationPriceType
FROM I_CmmdtyPrcgConditionFormula AS formula
INNER JOIN I_CmmdtyPrcgCndnRecdMapping AS CmmdtyPrcgCndnRecdMapping ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurCtrCondItem AS PurCtrCondItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CommodityPricingTermText AS _CommodityPricingTermText ON _CommodityPricingTermText.OriginSystem = OriginSystem AND _CommodityPricingTermText.PricingConditionTermKey = PricingConditionTermKey AND _CommodityPricingTermText.ConditionType = ConditionType  -- association [1..*]
LEFT OUTER JOIN I_CmmdtyPrcgQuotationRuleText AS _CmmdtyPrcgQuotationRuleText ON _CmmdtyPrcgQuotationRuleText.OriginSystem = OriginSystem AND _CmmdtyPrcgQuotationRuleText.PrcgCndnTermQuotationRule = PrcgCndnTermQuotationRule  -- association [1..*]
LEFT OUTER JOIN I_CmmdtyPricingTermRuleText AS _CmmdtyPricingTermRuleText ON _CmmdtyPricingTermRuleText.OriginSystem = OriginSystem AND _CmmdtyPricingTermRuleText.PricingConditionTermRule = PricingConditionTermRule  -- association [1..*]
LEFT OUTER JOIN I_CmmdtyPrcgCalcRuleText AS _CmmdtyPrcgCalcRuleText ON _CmmdtyPrcgCalcRuleText.OriginSystem = OriginSystem AND _CmmdtyPrcgCalcRuleText.PrcgCndnTermCalculationRule = PrcgCndnTermCalculationRule  -- association [1..*]
LEFT OUTER JOIN I_CommodityPricingRoutineText AS _CmmdtyPrcgTermCalcTypeText ON _CmmdtyPrcgTermCalcTypeText.OriginSystem = OriginSystem AND _CmmdtyPrcgTermCalcTypeText.PricingConditionModule = PrcgCndnFmlaEvaluationModule AND _CmmdtyPrcgTermCalcTypeText.PricingConditionSubModule = CndnTrmCalcTypeRoutineSubMdl AND _CmmdtyPrcgTermCalcTypeText.PricingConditionRoutine = PrcgCndnTermCalculationType  -- association [1..*]
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _PrcgConditionSourceCurrency ON PricingConditionSourceCurrency = _PrcgConditionSourceCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PrcgConditionTargetCurrency ON PricingConditionTargetCurrency = _PrcgConditionTargetCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnSourceQuantityUnit ON PrcgCndnSourceQuantityUnit = _PrcgCndnSourceQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnTargetQuantityUnit ON PrcgCndnTargetQuantityUnit = _PrcgCndnTargetQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnFmlaCmmdtyQtyUnit ON PrcgCndnFmlaCmmdtyQuantityUnit = _PrcgCndnFmlaCmmdtyQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _OriginSystem ON OriginSystem = _OriginSystem.LogicalSystem  -- association [0..1]
;