I_CmmdtyHdgConstellationDeal

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_CmmdtyHdgConstellationDeal.
-- 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: ICMMHDGCONDEAL

CREATE VIEW I_CmmdtyHdgConstellationDeal AS
SELECT
  I_CmmdtyHdgCnstltnDealUnion.CmmdtyHedgeConstellationUUID AS CmmdtyHedgeConstellationUUID,
  I_CmmdtyHdgCnstltnDealUnion.CompanyCode AS CompanyCode,
  I_CmmdtyHdgCnstltnDealUnion.CmmdtyHedgeConstellationDeal AS CmmdtyHedgeConstellationDeal,
  I_CmmdtyHdgCnstltnDealUnion.CmmdtyHdgCnstltnExposureItem AS CmmdtyHdgCnstltnExposureItem,
  I_CmmdtyHdgCnstltnDealUnion.CmmdtyHdgCnstltnFrgnExchHdgReq AS CmmdtyHdgCnstltnFrgnExchHdgReq,
  I_CmmdtyHdgCnstltnDealUnion.CmmdtyHdgCnstltnValdFrmDteTime AS CmmdtyHdgCnstltnValdFrmDteTime,
  I_CmmdtyHdgCnstltnDealUnion.CmmdtyHdgConstellationExposure AS CmmdtyHdgConstellationExposure,
  I_CmmdtyHdgCnstltnDealUnion.CmmdtyHdgCnstltnExpsrVersion AS CmmdtyHdgCnstltnExpsrVersion,
  _CommodityHedgeRelatedDeal.FinTransactionCompanyCode AS FinTransactionCompanyCode,
  _CommodityHedgeRelatedDeal.FinTransactionProductCategory AS FinTransactionProductCategory,
  _CommodityHedgeRelatedDeal.FinTransactionObjectNumber AS FinTransactionObjectNumber,
  _CommodityHedgeRelatedDeal.FinTransactionProductType AS FinTransactionProductType,
  _CommodityHedgeRelatedDeal.FinTransFactoryCalendar1 AS FinTransFactoryCalendar1,
  _CommodityHedgeRelatedDeal.FinTransFactoryCalendar2 AS FinTransFactoryCalendar2,
  _CommodityHedgeRelatedDeal.FinTransContractStartDate AS FinTransContractStartDate,
  _CommodityHedgeRelatedDeal.FinTransContractStartTime AS FinTransContractStartTime,
  _CommodityHedgeRelatedDeal.FinTransactionCounterparty AS FinTransactionCounterparty,
  _CommodityHedgeRelatedDeal.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _CommodityHedgeRelatedDeal.FinancialTransactionQuantity AS FinancialTransactionQuantity,
  _CommodityHedgeRelatedDeal.FinTransactionQuantityUnit AS FinTransactionQuantityUnit,
  _CommodityHedgeRelatedDeal.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  _CommodityHedgeRelatedDeal.FinancialTransactionDCSID AS FinancialTransactionDCSID,
  _CommodityHedgeRelatedDeal.FinTransactionPricingStartDate AS FinTransactionPricingStartDate,
  _CommodityHedgeRelatedDeal.FinTransactionPricingEndDate AS FinTransactionPricingEndDate,
  _CommodityHedgeRelatedDeal.FinancialTransactionHedgeBook AS FinancialTransactionHedgeBook,
  _CommodityHedgeRelatedDeal.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  _CommodityHedgeRelatedDeal.FinTransGeneralValuationClass AS FinTransGeneralValuationClass,
  _CommodityHedgeRelatedDeal._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CommodityHedgeRelatedDeal._ProdTypeText.FinancialInstrProdTypeName AS FinTransactionProductTypeText,
  _CommodityHedgeRelatedDeal._BusinessPartner.BusinessPartnerName AS BusinessPartnerName
FROM I_CmmdtyHdgCnstltnDealUnion
;