I_CmmdtyHdgCnstltnExtTrade

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_CmmdtyHdgCnstltnExtTrade.
-- 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: ICMMDTYCNSTLEDL
-- Parameters: P_CompanyCode : bukrs, P_ContractStartDate : datum, P_ContractEndDate : datum

CREATE VIEW I_CmmdtyHdgCnstltnExtTrade AS
SELECT
  hdgconstellation.CmmdtyHdgConstellationExposure AS CmmdtyHdgConstellationExposure,
  hdgconstellation.CmmdtyHdgCnstltnExpsrVersion AS CmmdtyHdgCnstltnExpsrVersion,
  hdgconstellation.CmmdtyHedgeConstellationUUID AS CmmdtyHedgeConstellationUUID,
  transaction.FinTransactionCompanyCode AS FinTransactionCompanyCode,
  transaction.FinTransactionDealIdentifier AS FinTransactionDealIdentifier,
  hsorder.CmmdtyHdgSpecificationID AS CmmdtyHdgSpecificationID,
  hsorder.CmmdtyHdgSpecQuotaOrderID AS CmmdtyHdgSpecQuotaOrderID,
  hsorder.CmmdtyHdgSpecLimitAmount AS CmmdtyHdgSpecLimitAmount,
  hsorder.CmmdtyHdgSpecAmountCurrency AS CmmdtyHdgSpecAmountCurrency,
  transaction.FinTransactionProductCategory AS FinTransactionProductCategory,
  transaction.FinTransactionProductType AS FinTransactionProductType,
  transaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  transaction.ContractStartDate AS ContractStartDate,
  transaction.ContractEndDate AS ContractEndDate,
  transactionflow.Quantity AS Quantity,
  transactionflow.FinTransFlowPaytAmt AS FinTransFlowPaytAmt,
  transactionflow.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  transactionflow.UnitOfMeasure AS UnitOfMeasure,
  transactionflow.FinTransTradedPriceCrcyUnit AS FinTransTradedPriceCrcyUnit,
  transactionflow.FinancialTransactionDCSID AS FinancialTransactionDCSID,
  transactionflow.FinTransPositionCrcyCnvrsnRate AS FinTransPositionCrcyCnvrsnRate,
  cast (transactionflow.FinTransacTradedPriceAmount as tb_hwbetr ) AS FinTransacTradedPriceAmount,
  cast (transactionflow.FinTransTradedPriceCrcyUnit as tb_wzbetr ) AS TradingContractCurrency
FROM I_CmmdtyHdgConstellationDetail AS hdgconstellation
INNER JOIN I_CommodityHedgeTransaction AS transaction ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHedgeTransactionFlow AS transactionflow ON /* join condition not captured in parsed metadata */
INNER JOIN I_CmmdtyHdgSpecQuotaOrder AS hsorder ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS companycode ON /* join condition not captured in parsed metadata */
;