R_CmmdtyHedgeBookCmpltDetailTP

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 R_CmmdtyHedgeBookCmpltDetailTP.
-- 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 R_CmmdtyHedgeBookCmpltDetailTP AS
SELECT
  CmmdtyHdgBook.CommodityHedgeBookIdentifier AS CommodityHedgeBookIdentifier,
  CmmdtyHdgBook.DerivativeContrSpecification AS DerivativeContrSpecification,
  _DCSText.DerivativeContrSpecName AS DerivativeContrSpecName,
  CmmdtyHdgBook.CommodityHedgePricingPeriod AS CommodityHedgePricingPeriod,
  CmmdtyHdgBook.CmmdtyHedgeShiftDeliveryPeriod AS CmmdtyHedgeShiftDeliveryPeriod,
  CmmdtyDelPeriod.CommodityHedgeDeliveryPeriod AS CommodityHedgeDeliveryPeriod,
  CmmdtyDelPeriod.CmmdtyHedgeDeliveryPeriodText AS CmmdtyHedgeDeliveryPeriodText,
  CmmdtyHdgBook.CmmdtyHdgBookAuthznGroup AS CmmdtyHdgBookAuthznGroup,
  _Text.CmmdtyHdgBookAuthznGroupText AS CmmdtyHdgBookAuthznGroupText,
  CmmdtyHdgBook.CmmdtyHedgeBookCreatedByUser AS CmmdtyHedgeBookCreatedByUser,
  CmmdtyHdgBook.CmmdtyHdgBookCreationDateTime AS CmmdtyHdgBookCreationDateTime,
  CmmdtyHdgBook.CmmdtyHedgeBookChangedByUser AS CmmdtyHedgeBookChangedByUser,
  CmmdtyHdgBook.CmmdtyHdgBookChangedAtDateTime AS CmmdtyHdgBookChangedAtDateTime,
  CmmdtyHdgBook.CmmdtyHdgBookIsDeprecatedFlag AS CmmdtyHdgBookIsDeprecatedFlag,
  CmmdtyHdgBook.FinTransProdCatIsCommoditySwap AS FinTransProdCatIsCommoditySwap,
  CmmdtyHdgBook.FinTransProdCatIsCmmdtyForward AS FinTransProdCatIsCmmdtyForward,
  CmmdtyHdgBook.FinTransProdCatIsCmmdtyOption AS FinTransProdCatIsCmmdtyOption,
  CmmdtyHdgBook.FinTransProdCatIsListedOption AS FinTransProdCatIsListedOption,
  CmmdtyHdgBook.FinTransProdCategoryIsFuture AS FinTransProdCategoryIsFuture,
  case CmmdtyDelPeriod.CommodityHedgeDeliveryPeriod when '12' then concat( cast(CmmdtyHdgBook.CommodityHedgePricingPeriod as abap.char(3)), concat('-', concat(cast(CmmdtyShiftDelPeriod.CmmdtyHdgShftDelivPeriodText as abap.char(10)), concat('-', cast(CmmdtyDelPeriod.CommodityHedgeDeliveryPeriod as abap.char(3)) )))) else concat( cast(CmmdtyHdgBook.CommodityHedgePricingPeriod as abap.char(3)), concat('-', concat(cast(CmmdtyShiftDelPeriod.CmmdtyHdgShftDelivPeriodText as abap.char(10)), concat('-', cast(substring(CmmdtyDelPeriod.CommodityHedgeDeliveryPeriod,2,1) as abap.char(3)) )))) end as CmmdtyHdgBookClusterPeriodName AS char3endasCmmdtyHdgBookClusterPeriodName,
  CmmdtyHdgBook._CmmdtyHdgBookText[1:Language = $session.system_language].CmmdtyHedgeBookDescription AS CmmdtyHedgeBookDescription
FROM I_CmmdtyHdgBookCompleteDetail AS CmmdtyHdgBook
INNER JOIN P_CmmdtyHdgBookDelPeriod AS CmmdtyDelPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN P_CmmdtyHdgBookShiftDelPeriod AS CmmdtyShiftDelPeriod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DerivativeContractSpecText AS _DCSText ON DerivativeContrSpecification = _DCSText.DerivativeContrSpecification AND _DCSText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CmmdtyHedgeBookCreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON CmmdtyHedgeBookChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CommodityHedgeFormerMemberT AS _CommodityHedgeFormerMemberT ON _CommodityHedgeFormerMemberT.CommodityHedgeFormerMember = 'X' AND _CommodityHedgeFormerMemberT.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyHdgBookAuthznGroupText AS _Text ON CmmdtyHdgBookAuthznGroup = _Text.CmmdtyHdgBookAuthznGroup AND _Text.Language = $session.system_language  -- association [0..*]
;