I_CntrlPurContrExchRateUnion

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_CntrlPurContrExchRateUnion.
-- 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_CntrlPurContrExchRateUnion AS
SELECT
  new.CentralPurchaseContract AS CentralPurchaseContract,
  new.CentralPurchaseContractItem AS CentralPurchaseContractItem,
  new.ConditionRecord AS ConditionRecord,
  new.ConditionValidityEndDate AS ConditionValidityEndDate,
  new.ConditionSequentialNumber AS ConditionSequentialNumber,
  new.PricingConditionTerm AS PricingConditionTerm,
  new.PrcgCndnTrmExchRateDateTime AS PrcgCndnTrmExchRateDateTime,
  new.CndnTrmQtanPerdDetnResultUUID AS CndnExchRatePerdDetnResultUUID,
  new.PrcgConditionExchangeRateType AS PrcgConditionExchangeRateType,
  new.PricingConditionSourceCurrency AS PricingConditionSourceCurrency,
  new.PricingConditionTargetCurrency AS PricingConditionTargetCurrency,
  new.PricingConditionExchangeRate AS PricingConditionExchangeRate,
  new.NumberOfSourceCurrencyUnits AS NumberOfSourceCurrencyUnits,
  new.NumberOfTargetCurrencyUnits AS NumberOfTargetCurrencyUnits,
  new.CndnTrmExchRateSubstnDateTime AS CndnTrmExchRateSubstnDateTime,
  new.CndnTrmExchRateIsNonTradingDay AS CndnTrmExchRateIsNonTradingDay,
  new.PrcgCndnTrmExchRateIsMissing AS PrcgCndnTrmExchRateIsMissing,
  new.CndnTrmExchRateIsSubstituted AS CndnTrmExchRateIsSubstituted,
  new.PrcgCndnTrmExchRateIsIgnored AS PrcgCndnTrmExchRateIsIgnored,
  new.PrcgCndnTrmExchRateFcstStatus AS PrcgCndnTrmExchRateFcstStatus,
  new.PrcgConditionSwapExchangeRate AS PrcgConditionSwapExchangeRate,
  new.PrcgConditionSpotExchangeRate AS PrcgConditionSpotExchangeRate,
  new.ConditionType AS ConditionType,
  new._ExchRateSourceCurrency AS _ExchRateSourceCurrency,
  old._ExchRateTargetCurrency AS _ExchRateTargetCurrency
FROM I_CntrlPurContrExchangeRateNew AS new
INNER JOIN I_CmmdtyPricingMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_CntrlPurContrCmmdtyExchRate
;