I_TreasuryTradeRequest

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_TreasuryTradeRequest.
-- 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: ITRSYTRDREQ

CREATE VIEW I_TreasuryTradeRequest AS
SELECT
  guid AS TreasuryTradeRequestUUID,
  trade_request_id AS TreasuryTradeRequest,
  instrument_group AS TrsyTrdReqInstrumentGroup,
  request_status AS TreasuryTradeRequestStatus,
  request_category AS TreasuryTradeRequestCategory,
  company_code AS CompanyCode,
  instrument_category AS TrsyTrdReqInstrumentCategory,
  hedging_area AS HedgingArea,
  hedge_request_id AS HedgeRequestIdentifier,
  cancel_reason AS TrsyTradeReqCancellationReason,
  note AS TreasuryTradeRequestNote,
  flag_document AS TrsyTrdReqIsDocumentAvailable,
  request_description AS TrsyTradeRequestDescription,
  create_user AS TreasuryTradeRequestCreatedBy,
  create_time AS TreasuryTradeRequestCreatedAt,
  last_change_user AS TrsyTradeRequestLastChangedBy,
  last_change_time AS TrsyTradeRequestLastChangedAt,
  object_cat AS TrsyTrdReqRefObjectCategory,
  object_reference AS TrsyTrdReqRefObjectIdentifier,
  node_cat AS TrsyTradeRequestNodeCategory,
  node_reference AS TrsyTradeRequestNodeReference,
  portfolio AS FinancialTransactionPortfolio,
  hedging_class AS FinTransHedgingClassification,
  external_referenece AS TrsyTrdReqExternalReference,
  assignment AS FinancialTransactionAssignment,
  internal_reference AS FinTransInternalReference,
  characteristics AS FinTransactionCharacteristics,
  profit_center AS ProfitCenter,
  cost_center AS CostCenter,
  cast(wbs_element as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  on_behalf_of_company AS OnBehalfOfCompany,
  Country,
  Segment,
  business_area AS BusinessArea,
  value_date AS ForeignExchangeValueDate,
  traded_amount AS TrsyTrdReqRequestedAmount,
  traded_currency AS TrsyTradeRequestTradedCurrency,
  leading_currency AS TreasuryFXLeadingCurrency,
  following_currency AS TreasuryFXFollowingCurrency,
  buy_sell_indicator AS TrsyTradedAmountBuySellCode,
  fixing_date AS FinTransFixingDate,
  fixing_reference AS ForeignExchangeFixingReference,
  settlement_currency AS CashSettlementCurrency,
  value_date_leg_2 AS FXLeg2ValueDate,
  traded_amount_leg_2 AS FXLeg2TradedAmount,
  traded_currency_leg_2 AS FXLeg2TradedCurrency,
  fixing_date_leg_2 AS FXSwapLeg2FixingDate,
  fixing_reference_leg_2 AS FXSwapLeg2FixingReference,
  settlement_currency_leg_2 AS FXSwapLeg2CashSettleCurrency,
  invest_borrow AS TrsyTradeReqInvestBorrow,
  interest_rate_structure AS TrsyTradeReqInterestRateStruc,
  nominal_amount AS NominalAmountInNominalCurrency,
  nominal_currency AS NominalCurrency,
  min_start_term AS TrsyTradeReqMinStartDate,
  max_start_term AS TrsyTradeReqMaxStartDate,
  min_end_term AS TrsyTradeReqMinEndDate,
  max_end_term AS TrsyTradeReqMaxEndDate
FROM tpit_trade_req
;