I_CmmdtyPricingTermInputData

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_CmmdtyPricingTermInputData.
-- 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.
-- SQL view name: ITERMINPUTDATA

CREATE VIEW I_CmmdtyPricingTermInputData AS
SELECT
  terminput_guid AS PricingConditionTermInputUUID,
  termtype AS PrcgCndnTermCalculationType,
  termrule AS PricingConditionTermRule,
  terminput_rates.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
  terminput_rates.PrcgConditionTermFixedRateQty AS PrcgConditionTermFixedRateQty,
  terminput_rates.PrcgCndnTermFixedRateQtyUnit AS PrcgCndnTermFixedRateQtyUnit,
  dcsid AS DerivativeContrSpecification,
  mic AS MarketIdentifierCode,
  tenor AS TimeToMaturity,
  pricetype AS QuotationPriceType,
  quotationrule AS PrcgCndnTermQuotationRule,
  keydate AS MaturityKeyDate,
  calcrule AS PrcgCndnTermCalculationRule,
  terminput_rates.PricingConditionTermFixedRate AS PricingConditionTermFixedRate
FROM cped_terminput AS terminput
INNER JOIN P_CmmdtyPricingTermInputData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyPricingQuotationRule AS _CmmdtyPricingQuotationRule ON PrcgCndnTermQuotationRule = _CmmdtyPricingQuotationRule.PrcgCndnTermQuotationRule  -- association [0..*]
LEFT OUTER JOIN I_CommodityPricingRoutine AS _PrcgCndnTermCalculationType ON _PrcgCndnTermCalculationType.OriginSystem = ' ' AND _PrcgCndnTermCalculationType.PricingConditionModule = 'FE' AND _PrcgCndnTermCalculationType.PricingConditionSubModule = '05' AND _PrcgCndnTermCalculationType.PricingConditionRoutine = PrcgCndnTermCalculationType  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyPricingTermRule AS _PricingConditionTermRule ON PricingConditionTermRule = _PricingConditionTermRule.PricingConditionTermRule  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _PrcgCndnTermFixedRateCrcy ON PrcgConditionTermFixedRateCrcy = _PrcgCndnTermFixedRateCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PrcgCndnTermFixedRateQtyUnit ON PrcgCndnTermFixedRateQtyUnit = _PrcgCndnTermFixedRateQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContrSpec AS _DerivativeContrSpecification ON DerivativeContrSpecification = _DerivativeContrSpecification.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MarketIdentifierCode ON MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode  -- association [0..1]
LEFT OUTER JOIN I_TimeToMaturity AS _TimeToMaturity ON TimeToMaturity = _TimeToMaturity.TimeToMaturity  -- association [0..1]
LEFT OUTER JOIN I_PriceQuotationType AS _QuotationPriceType ON QuotationPriceType = _QuotationPriceType.PriceQuotationType  -- association [0..1]
;