C_CmmdtyHdgDdsgntnRequestTP

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 C_CmmdtyHdgDdsgntnRequestTP.
-- 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 C_CmmdtyHdgDdsgntnRequestTP AS
SELECT
  DedesignationRequestUUID,
  DedesignationRequestIdentifier,
  CommodityHedgePlanExposureUUID,
  DedesignationRequestDate,
  DedesignationRequestCategory,
  DdsgntnReqCategoryChangeText,
  DedesignationRequestRemarkNote,
  CounterdealRequestUUID,
  DedesignationRequestLogHandle,
  DedesignationRequestStatus,
  DdsgntnReqStatusChangeReason,
  DdsgntnReqStatusCriticality,
  DdsgntnRequestCreatedByUser,
  DdsgntnRequestCreationDateTime,
  DedesignationLastChangedByUser,
  DdsgntnReqLastChangedDateTime,
  DdsgntnRequestChangeDocumentID,
  LocalLastChangeDateTime,
  CmmdtyHdgPlnExpsrCompanyCode,
  CommodityHedgePlanExposureID,
  CmmdtyHedgePlnExposureQuantity,
  CmmdtyHdgPlnExpsrQuantityUnit,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHedgePlanExposureDCSID,
  _Exposure.CmmdtyHdgPlanExposureDirection AS CmmdtyHdgPlanExposureDirection,
  CmmdtyHdgPlnExpsrHedgingArea,
  CmmdtyHedgePlanExposureVersion,
  _Exposure.CmmdtyHdgPlnExpsrPrcgStartDate AS CmmdtyHdgPlnExpsrPrcgStartDate,
  CmmdtyHdgPlnExpsrPrcgEndDate,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdText AS CmmdtyHdgPlnExpsrDelivPerdText,
  CmmdtyHdgPlnExpsrDelivPerdType,
  _Exposure.CmmdtyHdgPlnExpsrDelivPerdYear AS CmmdtyHdgPlnExpsrDelivPerdYear,
  CmmdtyHdgPlnExpsrValidFromDate,
  PhysicalCommodity,
  CmmdtyHdgBookAuthznGroup,
  CmmdtyHdgPlnExposureRemarkNote,
  _DedesignationCategory._Text.DdsgntnRequestCategoryText : localized AS DdsgntnRequestCategoryTextlocalized,
  _DedesignationRequestStatus._SystemStatusText.DedesignationRequestStatusText : localized AS DedesignationRequestStatusTextlocalized,
  _CompanyCode.CompanyCodeName AS CmmdtyHdgPlnExpsrCoCodeText,
  _CounterdealRequest.CounterdealRequestIdentifier AS CounterdealRequestIdentifier,
  _DedesignationRequestUserText.DdsgntnReqCreatedByUserText AS DdsgntnReqCreatedByUserText,
  _DedesignationRequestUserText.DdsgntnReqLastChangeByUserText AS DdsgntnReqLastChangeByUserText,
  virtual DdsgntnReqBeforeOverHedgeText : abap.char( 132 ) AS char132,
  virtual DdsgntnReqBfrOvrHdgCriticality : abap.int1 AS int1,
  _Exposure._HedgeBook._CmmdtyHdgBookText.CmmdtyHedgeBookDescription : localized AS CmmdtyHedgeBookDescriptionlocalized,
  _DrvtvContrSpec._Text.DerivativeContrSpecName : localized AS DerivativeContrSpecNamelocalized,
  _DeliveryCategory._Text.PlngDataDeliveryCategoryText : localized AS PlngDataDeliveryCategoryTextlocalized
FROM R_CmmdtyHdgDdsgntnRequestTP
LEFT OUTER JOIN C_CmmdtyHdgDdsgntnReqChgDoc AS _DdsgntnRequestChangeDoc ON DdsgntnRequestChangeDocumentID = _DdsgntnRequestChangeDoc.ChangeDocObject  -- association [0..*]
;