I_BalShtExpsrHdgReq

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_BalShtExpsrHdgReq.
-- 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: IBSEHDGREQBASICV

CREATE VIEW I_BalShtExpsrHdgReq AS
SELECT
  bsr_id AS BalShtExpsrHdgReqID,
  tr.trade_request_id AS TreasuryTradeRequest,
  bsr.snap_id AS BalShtExpsrSnapshotID,
  cast(bsr.msgid as hdg_req_err_msg_class preserving type ) AS HedgeRequestErrorMessageClass,
  cast(bsr.msgno as hdg_req_err_msg_no preserving type ) AS HedgeRequestErrorMessageNumber,
  cast(bsr.msgv1 as hdg_req_err_msg_var1_txt preserving type ) AS HedgeReqErrMsgVariable1Text,
  cast(bsr.msgv2 as hdg_req_err_msg_var2_txt preserving type ) AS HedgeReqErrMsgVariable2Text,
  cast(bsr.msgv3 as hdg_req_err_msg_var3_txt preserving type ) AS HedgeReqErrMsgVariable3Text,
  cast(bsr.msgv4 as hdg_req_err_msg_var4_txt preserving type ) AS HedgeReqErrMsgVariable4Text,
  cast(bsr.create_user as bse_hdg_req_created_by preserving type ) AS BalShtExpsrHdgReqCreatedByUser,
  cast(bsr.create_timestamp as bse_hdg_req_created_time preserving type ) AS BalShtExpsrHdgReqCreatedDteTme,
  cast(bsr.last_change_user as bse_hdg_req_last_change_user preserving type ) AS BalShtExpsrHdgReqLastChgdUsr,
  cast(bsr.last_change_timestamp as hdg_req_last_changed_time preserving type ) AS HdgReqLastChangedDateTime,
  bsr.company_code AS CompanyCode,
  bsr.company_code_currency AS CompanyCodeCurrency,
  bsr.risk_free_currency AS RiskFreeCurrency,
  bsr.instrument_category AS BalShtExpsrHdgReqInstrCategory,
  bsr.bsr_amount AS BalShtExpsrHdgReqAmount,
  bsr.bsr_currency AS Currency,
  bsr.value_date AS BalShtExpsrHdgReqValueDate,
  bsr.description AS BalShtExpsrHdgReqDesc,
  bsr.buy_sell_indicator AS ForeignExchangeTradingActivity,
  bsr.put_call_indicator AS OptionPutCallCode,
  bsr.declined_amount AS BalShtExpsrHdgReqDeclinedAmt,
  bsr.open_amount AS BalShtExpsrHdgReqOpenAmt,
  cast(bsr.period_start as bse_hdg_req_perd_start_dte preserving type ) AS BalShtExpsrHdgReqPerdStrtDte,
  cast(bsr.period_end as bse_hdg_req_perd_end_dte preserving type ) AS BalShtExpsrHdgReqPerdEndDte,
  bsr.portfolio AS Portfolio,
  bsr.external_ref AS FinInstrExternalReference,
  bsr.assignment AS FinancialInstrumentAssignment,
  bsr.internal_ref AS FinancialInstrumentReference,
  bsr.chars AS FinancialInstrCharacteristic,
  bsr.profit_center AS ProfitCenter,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  bsr.cost_center AS CostCenter,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  cast(bsr.wbs_element as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  bsr.on_behalf_of_company AS OnBehalfOfCompany,
  bsr.country AS Country,
  bsr.segment AS Segment,
  bsr.edit_indicator AS BalShtExpsrHdgReqEditedSts
FROM fxm_bsr AS bsr
;