C_CmmdtyHdgMigrationRequestTP

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_CmmdtyHdgMigrationRequestTP.
-- 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_CmmdtyHdgMigrationRequestTP AS
SELECT
  MigrationRequestUUID,
  MigrationRequestIdentifier,
  CommodityHedgePlanExposureUUID,
  MigrationRequestDate,
  MigrationRequestRemarkNote,
  MigrationRequestStatus,
  MigrtnReqStatusChangeReason,
  MigrationRequestPortfolio,
  MigrtnReqHedgingClassification,
  MigrationRequestLogHandle,
  MigrtnReqIsApplLogAvailable,
  MigrationRequestCreatedByUser,
  MigrtnRequestCreationDateTime,
  MigrtnRequestLastChangedByUser,
  MigrtnReqLastChangedDateTime,
  MigrtnRequestStatusCriticality,
  MigrtnRequestChangeDocumentID,
  LocalLastChangeDateTime,
  CmmdtyHdgPlnExpsrCompanyCode,
  virtual CmmdtyHdgPlnExpsrCoCodeText : butxt AS virtualCmmdtyHdgPlnExpsrCoCodeTextbutxt,
  CommodityHedgePlanExposureID,
  CmmdtyHdgPlanExposureHedgeBook,
  CmmdtyHedgePlanExposureDCSID,
  virtual CmmdtyHdgPlnExpsrPrcgStartDate : abap.dats AS dats,
  CmmdtyHdgPlnExpsrDelivPerdText,
  virtual PhysicalCommodity : tba_stoeffchen AS virtualPhysicalCommoditytba_stoeffchen,
  CmmdtyHdgBookAuthznGroup,
  virtual MigrtnReqAfterOverHedgeText : abap.char( 132 ) AS char132,
  virtual MigrtnReqAftOvrHdgCriticality : abap.int1 AS int1,
  CmmdtyHdgSpecificationID,
  MigrtnHdgSpecificationIsHidden,
  _CmmdtyHdgMigrtnReqStatus._MigrtnReqStatusText.MigrationRequestStatusText : localized AS MigrationRequestStatusTextlocalized,
  _MigrtnReqUserText.MigrtnRequestCreatedByUserText AS MigrtnRequestCreatedByUserText,
  _MigrtnReqUserText.MigrtnReqLastChgdByUserText AS MigrtnReqLastChgdByUserText,
  _DeliveryCategory._Text.PlngDataDeliveryCategoryText : localized AS PlngDataDeliveryCategoryTextlocalized,
  _DrvtvContrSpec._Text.DerivativeContrSpecName : localized AS DerivativeContrSpecNamelocalized,
  _TreasuryPortfolio._TreasuryPortfolioText.PortfolioName : localized AS PortfolioNamelocalized,
  _TreasuryHedgingClassfctn._Text.HedgingClassificationName : localized AS HedgingClassificationNamelocalized,
  _CmmdtyHdgPlngDataDirection._Text.PlanningDataDirectionText : localized AS PlanningDataDirectionTextlocalized,
  _Exposure._HedgeBook._CmmdtyHdgBookText.CmmdtyHedgeBookDescription : localized AS CmmdtyHedgeBookDescriptionlocalized
FROM R_CmmdtyHdgMigrationRequestTP
LEFT OUTER JOIN C_CmmdtyHdgMigrtnReqChgDoc AS _MigrationReqChgDoc ON MigrtnRequestChangeDocumentID = _MigrationReqChgDoc.ChangeDocObject  -- association [0..*]
;