P_CmmdtyFinTransactFlowUnion

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_CmmdtyFinTransactFlowUnion.
-- 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_CmmdtyFinTransactFlowUnion AS
SELECT
  fha.CompanyCode AS CompanyCode,
  fha.FinancialTransaction AS FinancialTransaction,
  fhapo.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  fhapo.FinTransFlowNumber AS FinTransFlowNumber,
  fha.CmmdtyHdgSpecificationID AS CmmdtyHdgSpecificationID,
  fha.CmmdtyHdgSpecQuotaOrderID AS CmmdtyHdgSpecQuotaOrderID,
  fha.FinTransHedgingClassification AS FinTransHedgingClassification,
  fha.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  fhapo.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  fhapo_unfixed.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  fhapo_unfixed.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  fhapo.FinTransacTradedPriceAmount AS FinTransacTradedPriceAmount,
  fhapo.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  fhapo.FinancialTransactionDirection AS FinancialTransactionDirection,
  fhapo.DerivativeContrSpecification AS DerivativeContrSpecification,
  fhapo_unfixed.MarketIdentifierCode AS MarketIdentifierCode,
  fhapo.Quantity AS Quantity,
  fhapo.UnitOfMeasure AS UnitOfMeasure,
  fhapo.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  fhapo.FinancialTransactionAmount AS FinancialTransactionAmount,
  fhapo.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  fhapo.FinTransFlowIntrstRateFixDate AS FinTransFlowIntrstRateFixDate,
  fhapo.FinTransPositionCrcyCnvrsnRate AS FinTransPositionCrcyCnvrsnRate
FROM I_CmmdtyFinTransactionFlow AS fhapo
INNER JOIN I_CmmdtyFinTransFlowUnfixed AS fhapo_unfixed ON /* join condition not captured in parsed metadata */
INNER JOIN P_CmmdtyFinTransactionHeader AS fha ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DerivativeContrSpec AS _DCS ON _DCS.DerivativeContrSpecification = DerivativeContrSpecification  -- association [0..1]
-- UNION ALL with additional select branch(es): I_CmmdtyFinTransactionFlow, I_CmmdtyFinTransFlowUnfixed
;