P_CmmdtyHdgFinTransUntCnvrsn

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 P_CmmdtyHdgFinTransUntCnvrsn.
-- 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 P_CmmdtyHdgFinTransUntCnvrsn AS
SELECT
  FTRDeal.CompanyCode AS CompanyCode,
  FTRDeal.FinancialTransaction AS FinancialTransaction,
  FTRDeal.CreatedByUser AS CreatedByUser,
  FTRDeal.LastChangedByUser AS LastChangedByUser,
  FTRDeal.LastChangeDate AS LastChangeDate,
  FTRDeal.FinInstrumentLastChangedTime AS FinInstrumentLastChangedTime,
  FTRDeal.FinTransCreationDate AS FinTransCreationDate,
  FTRDeal.FinTransCreationTime AS FinTransCreationTime,
  FTRDeal.FinTransContractDate AS FinTransContractDate,
  FTRDeal.TermStartDate AS TermStartDate,
  FTRDeal.TermEndDate AS TermEndDate,
  FTRDeal.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  FTRDeal.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  FTRDeal.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  FTRDeal.FinTransTermRiskStartDate AS FinTransTermRiskStartDate,
  FTRDeal.FinTransactionTermRiskEndDate AS FinTransactionTermRiskEndDate,
  FTRDeal.FinTransActyConclusionDate AS FinTransActyConclusionDate,
  FTRDeal.FinTransActyConclusionTime AS FinTransActyConclusionTime,
  FTRDeal.FinTransActyConclusionTimeZone AS FinTransActyConclusionTimeZone,
  FTRDeal.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  FTRDeal.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  FTRDeal.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  FTRDeal.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  FTRDeal.Counterparty AS Counterparty,
  FTRDeal.FinancialTransactionHedgeBook AS FinancialTransactionHedgeBook,
  FTRDeal.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  FTRDeal.FinTransHedgingClassification AS FinTransHedgingClassification,
  FTRDeal.DerivativeContrSpecification AS DerivativeContrSpecification,
  FTRDeal.MarketIdentifierCode AS MarketIdentifierCode,
  FTRDeal.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  FTRDeal.FinancialTransactionDirection AS FinancialTransactionDirection,
  FTRDeal.FinTransacTradedPriceAmount AS FinTransacTradedPriceAmount,
  FTRDeal.FinTransTradedPriceCurrency AS FinTransTradedPriceCurrency,
  FinTransPaymentAmount,
  FTRDeal.Quantity AS Quantity,
  FTRDeal.UnitOfMeasure AS UnitOfMeasure,
  cast ( case when FTRDeal.UnitOfMeasure = _DCSAttr.DerivativeContrSpecification then cast( FTRDeal.Quantity as abap.fltp ) else cast( unit_conversion( quantity => FTRDeal.Quantity, source_unit => FTRDeal.UnitOfMeasure, target_unit => _DCSAttr.UnitOfMeasure, error_handling => 'SET_TO_NULL' ) as abap.fltp ) end as abap.fltp ) as CmmdtyDealQtyInDCSUoM AS fltpasCmmdtyDealQtyInDCSUoM,
  _DCSAttr.UnitOfMeasure AS DCSUnitOfMeasure,
  FTRDeal._CompanyCode AS _CompanyCode,
  FTRDeal._DCS AS _DCS,
  FTRDeal._ProductType AS _ProductType,
  FTRDeal._Counterparty AS _Counterparty,
  FTRDeal._TimeZone AS _TimeZone
FROM P_CmmdtyFinancialTransaction AS FTRDeal
INNER JOIN I_CmmdtyDrvtvContrSpecLtstVers AS _DCSValdFrom ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHdgDrvtvContrSpecUoM AS _DCSAttr ON /* join condition not captured in parsed metadata */
;