I_CmmdtyHdgRclassfctnReqCmpst

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_CmmdtyHdgRclassfctnReqCmpst.
-- 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: ICMMHRCLSRQCOMP

CREATE VIEW I_CmmdtyHdgRclassfctnReqCmpst AS
SELECT
  ReclassificationRequestUUID,
  RclassfctnRequestIdentifier,
  CommodityHedgePlanExposureUUID,
  ReclassificationRequestDate,
  RclassfctnRequestCategory,
  RclassfctnRequestRemarkNote,
  RclassfctnRequestLogHandle,
  ReclassificationRequestStatus,
  RclassfctnReqStsChangeReason,
  RclassfctnRequestCreatedByUser,
  RclassfctnReqCreationDateTime,
  RclassfctnReqLastChangedByUser,
  RclassfctnReqLastChgdDateTime,
  LocalLastChangeDateTime,
  bintohex( ReclassificationRequestUUID ) AS RclassfctnReqChangeDocumentID,
  _Exposure.CmmdtyHdgPlnExpsrCompanyCode AS CmmdtyHdgPlnExpsrCompanyCode,
  _Exposure.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  _Exposure.CmmdtyHedgePlnExposureQuantity AS CmmdtyHedgePlnExposureQuantity,
  _Exposure.CmmdtyHdgPlnExpsrQuantityUnit AS CmmdtyHdgPlnExpsrQuantityUnit,
  _Exposure.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  _Exposure.CmmdtyHedgePlanExposureDCSID AS CmmdtyHedgePlanExposureDCSID,
  _Exposure.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  _Exposure.CmmdtyHdgPlnExpsrHedgingArea AS CmmdtyHdgPlnExpsrHedgingArea,
  _Exposure.CmmdtyHdgPlnExpsrPrcgStartDate AS CmmdtyHdgPlnExpsrPrcgStartDate,
  _Exposure.CmmdtyHdgPlnExpsrPrcgEndDate AS CmmdtyHdgPlnExpsrPrcgEndDate,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdText AS CmmdtyHdgPlnExpsrDelivPerdText,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdType AS CmmdtyHdgPlnExpsrDelivPerdType,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear,
  _Exposure.CmmdtyHdgPlnExpsrValidFromDate AS CmmdtyHdgPlnExpsrValidFromDate,
  _Exposure._CompanyCode AS _CompanyCode,
  _Exposure.PhysicalCommodity AS PhysicalCommodity,
  _Exposure._HedgeBook.CmmdtyHdgBookAuthznGroup AS CmmdtyHdgBookAuthznGroup,
  _Exposure.CmmdtyHdgPlnExposureRemarkNote AS CmmdtyHdgPlnExposureRemarkNote,
  _Exposure.CmmdtyHedgePlanExposureVersion AS CmmdtyHedgePlanExposureVersion
FROM I_CmmdtyHdgRclassfctnRequest AS RclassfctnReq
LEFT OUTER JOIN I_CommodityHedgePlanExposure AS _Exposure ON CommodityHedgePlanExposureUUID = _Exposure.CommodityHedgePlanExposureUUID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgRclassfctnReqCat AS _RclassfctnReqCategory ON RclassfctnRequestCategory = _RclassfctnReqCategory.RclassfctnRequestCategory  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgRclassfctnReqStatus AS _RclassfctnReqStatus ON ReclassificationRequestStatus = _RclassfctnReqStatus.ReclassificationRequestStatus  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgRclassfctnReqUsrTxt AS _RclassfctnReqUserText ON ReclassificationRequestUUID = _RclassfctnReqUserText.ReclassificationRequestUUID AND _RclassfctnReqUserText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_DerivativeContrSpec AS _DrvtvContrSpec ON cmmdtyhedgeplanexposuredcsid = _DrvtvContrSpec.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgPlngDtaDelivCat AS _DeliveryCategory ON cmmdtyhdgplnexpsrdelivperdtype = _DeliveryCategory.PlanningDataDeliveryCategory  -- association [0..1]
;