I_HedgingRelationship

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_HedgingRelationship.
-- 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: IHEDGINGREL

CREATE VIEW I_HedgingRelationship AS
SELECT
  cast(hrel.os_guid as ftr_gen_hrel_uuid preserving type) AS HedgingRelationshipUUID,
  hrel.hrel_number AS HedgingRelationship,
  cast(hrel.fiscal_year as ftr_gen_hrel_fiscal_year preserving type) AS HedgingRelationshipFiscalYear,
  cast(hrel.description as tpm_hrel_descr preserving type) AS HedgingRelationshipName,
  cast(hrel.tr_acc_code as bukrs preserving type) AS CompanyCode,
  cast(hrel.valuation_area as tpm_val_area preserving type) AS TreasuryValuationArea,
  cast(hrel.hrel_status as ftr_gen_hrel_status preserving type) AS HedgingRelationshipStatus,
  cast(hrel.hrel_profile as ftr_gen_hdgg_profile preserving type) AS HedgingProfile,
  cast(hrel.hrel_risk_curr as ftr_gen_hrel_risk_currency preserving type) AS TrsyHedgingRelshpRiskCurrency,
  cast(hrel.hres_calc_rule as ftr_gen_cost_hres_calc_rule preserving type) AS TrsyCostHdggRsrvCalcRule,
  hrel.hrel_hedging_area AS HedgingArea,
  hrel.hrel_snapshot_id AS FinNetOpenExposureSnapshot,
  hrel.hrel_split_id AS TrsyHdggRelshpDsgntnSplitID,
  cast(hrel.hrel_bal_sheet_rec_date as ftr_gen_hrel_bal_sht_recgn_dte preserving type) AS TrsyHdggRelshpBalShtRecgnDate,
  cast(hrel.hrel_reclass_st_date as ftr_gen_hrel_altv_reclass_date preserving type) AS TrsyAltvReclassificationDate
FROM thxt_hrel AS hrel
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON HedgingRelationshipFiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationArea AS _TreasuryValuationArea ON TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea  -- association [0..1]
;