P_CmmdtyFinancialTransaction

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_CmmdtyFinancialTransaction.
-- 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_CmmdtyFinancialTransaction AS
SELECT
  FinancialTransaction.CompanyCode AS CompanyCode,
  FinancialTransaction.FinancialTransaction AS FinancialTransaction,
  FinancialTransaction.CreatedByUser AS CreatedByUser,
  FinancialTransaction.FinTransCreationDate AS FinTransCreationDate,
  FinancialTransaction.FinTransCreationTime AS FinTransCreationTime,
  FinTransActivity.FinTransActyConclusionDate AS FinTransContractDate,
  FinancialTransaction.LastChangedByUser AS LastChangedByUser,
  FinancialTransaction.LastChangeDate AS LastChangeDate,
  FinancialTransaction.FinInstrumentLastChangedTime AS FinInstrumentLastChangedTime,
  FinancialTransaction.TermStartDate AS TermStartDate,
  FinancialTransaction.TermEndDate AS TermEndDate,
  FinTransActivity.FinTransActyConclusionDate AS FinTransActyConclusionDate,
  FinTransActivity.FinTransActyConclusionTime AS FinTransActyConclusionTime,
  FinTransActivity.FinTransActyConclusionTimeZone AS FinTransActyConclusionTimeZone,
  FinancialTransaction.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  FinancialTransaction.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  FinancialTransaction.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  FinancialTransaction.FinancialTransactionHedgeBook AS FinancialTransactionHedgeBook,
  FinancialTransaction.Counterparty AS Counterparty,
  FinancialTransaction.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  FinancialTransaction.FinTransHedgingClassification AS FinTransHedgingClassification,
  CommodityDeal.DerivativeContrSpecification AS DerivativeContrSpecification,
  CommodityDeal.MarketIdentifierCode AS MarketIdentifierCode,
  CommodityDeal.DeliveryDate AS FinTransFlowPaymentDate,
  CommodityDeal.CmmdtyPriceExpsrPaymentAmount AS FinTransPaymentAmount,
  CommodityDeal.PaymentCurrency AS FinTransTradedPriceCurrency,
  CommodityDeal.CalculationPeriodStartDate AS FinTransactionPricingStartDate,
  CommodityDeal.CalculationPeriodEndDate AS FinTransactionPricingEndDate,
  FinancialTransaction.TermStartDate AS FinTransTermRiskStartDate,
  CommodityDeal.CalculationPeriodEndDate AS FinTransactionTermRiskEndDate,
  abs( CommodityDeal.CommodityPriceExposureQuantity ) AS Quantity,
  CommodityDeal.CommodityPriceExposureUnit AS UnitOfMeasure,
  FinancialTransaction.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  FinancialTransaction._CompanyCode AS _CompanyCode,
  FinancialTransaction._ProductType AS _ProductType,
  FinancialTransaction._Counterparty AS _Counterparty,
  FinTransActivity._TimeZone AS _TimeZone,
  CommodityDeal._DCS AS _DCS
FROM P_CmmdtyFinVersSumQtyTrans AS CommodityDeal
INNER JOIN P_CmmdtyFinTransactionHeader AS FinancialTransaction ON /* join condition not captured in parsed metadata */
INNER JOIN I_FinTransActivity AS FinTransActivity ON /* join condition not captured in parsed metadata */
;