I_CmmdtyHdgReqFXHedgeRequest

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_CmmdtyHdgReqFXHedgeRequest.
-- 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: ICMMHDGFXHREQ

CREATE VIEW I_CmmdtyHdgReqFXHedgeRequest AS
SELECT
  FXHedgeRequest.guid AS CmmdtyHdgFXHedgeRequestUUID,
  FXHedgeRequest.hedge_request_id AS HedgeRequestIdentifier,
  FXHedgeRequest.hreq_volume AS CmmdtyHdgFXHdgRequestAmount,
  FXHedgeRequest.hreq_currency AS CmmdtyHdgFXHdgRequestCurrency,
  FXHedgeRequest.release_status AS CmmdtyHdgFXHdgRequestStatus,
  FXHedgeRequest.instrument_category AS CmmdtyHdgFXHdgReqInstrCategory,
  FXHedgeRequest.value_date AS CmmdtyHdgFXHdgRequestValueDate,
  FXHedgeRequest.request_cat AS CmmdtyHdgFXHdgRequestCategory,
  FXHedgeRequest.portfolio_req AS CmmdtyHdgFXHdgRequestPortfolio,
  FXHedgeRequest.company_code AS CmmdtyHdgFXHdgReqCompanyCode,
  FXHedgeRequest.create_user AS CmmdtyHdgFXHdgReqCreatedByUser,
  FXHedgeRequest.create_time AS CmmdtyHdgFXHdgReqCrtnDateTime,
  FXHedgeRequest.last_change_user AS CmmdtyHdgFXHdgReqLastChgdByUsr,
  FXHedgeRequest.last_change_time AS CmHdgFXHdgReqLastChgdDateTime,
  _InstrCategoryText[1:Language = $session.system_language].CmmdtyHdgFXHdgReqInstrCatText AS CmmdtyHdgFXHdgReqInstrCatText
FROM toet_hreq AS FXHedgeRequest
INNER JOIN I_CmmdtyHdgFXHdgReqCategory AS FXHedgeRequestCategory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyHdgFXHdgReqInstrCatTxt AS _InstrCategoryText ON CmmdtyHdgFXHdgReqInstrCategory = _InstrCategoryText.CmmdtyHdgFXHdgReqInstrCategory  -- association [1..*]
;