R_TreasuryTradeRequestTP

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 R_TreasuryTradeRequestTP.
-- 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 R_TreasuryTradeRequestTP AS
SELECT
  TreasuryTradeRequestUUID,
  TreasuryTradeRequest,
  TrsyTrdReqInstrumentGroup,
  TreasuryTradeRequestStatus,
  TreasuryTradeRequestCategory,
  CompanyCode,
  TrsyTrdReqInstrumentCategory,
  HedgingArea,
  HedgeRequestIdentifier,
  TrsyTradeReqCancellationReason,
  TreasuryTradeRequestNote,
  TrsyTrdReqIsDocumentAvailable,
  TrsyTradeRequestDescription,
  TreasuryTradeRequestCreatedBy,
  TreasuryTradeRequestCreatedAt,
  TrsyTradeRequestLastChangedBy,
  TrsyTradeRequestLastChangedAt,
  TrsyTrdReqRefObjectCategory,
  TrsyTrdReqRefObjectIdentifier,
  TrsyTradeRequestNodeCategory,
  TrsyTradeRequestNodeReference,
  ForeignExchangeValueDate,
  TrsyTrdReqRequestedAmount,
  TrsyTradeRequestTradedCurrency,
  TrsyTrdRequestOppositeCurrency,
  TreasuryFXLeadingCurrency,
  TreasuryFXFollowingCurrency,
  TrsyTradedAmountBuySellCode,
  FinTransFixingDate,
  ForeignExchangeFixingReference,
  CashSettlementCurrency,
  FXLeg2ValueDate,
  FXLeg2TradedAmount,
  FXLeg2TradedCurrency,
  FXSwapLeg2FixingDate,
  FXSwapLeg2FixingReference,
  FXSwapLeg2CashSettleCurrency,
  TrsyTradeReqInvestBorrow,
  TrsyTradeReqInterestRateStruc,
  NominalAmountInNominalCurrency,
  NominalCurrency,
  TrsyTradeReqMinStartDate,
  TrsyTradeReqMaxStartDate,
  TrsyTradeReqMinEndDate,
  TrsyTradeReqMaxEndDate
FROM I_TreasuryTradeRequest
LEFT OUTER JOIN I_TrsyTradeRequestCategory AS _TradeRequestCategory ON TreasuryTradeRequestCategory = _TradeRequestCategory.TreasuryTradeRequestCategory  -- association [0..1]
LEFT OUTER JOIN I_TreasuryTradeRequestStatus AS _TradeRequestStatus ON TreasuryTradeRequestStatus = _TradeRequestStatus.TreasuryTradeRequestStatus  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON _CompanyCodeText.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyHdgFXHdgReqInstrCatTxt AS _InstrumentCategoryText ON _InstrumentCategoryText.CmmdtyHdgFXHdgReqInstrCategory = TrsyTrdReqInstrumentCategory AND _InstrumentCategoryText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_TrsyTrdReqBuySellCodeText AS _BuySellCodeText ON _BuySellCodeText.TrsyTradedAmountBuySellCode = TrsyTradedAmountBuySellCode  -- association [0..*]
LEFT OUTER JOIN I_TrsyTradeReqCanclnRsn AS _TradeRequestCancelReason ON _TradeRequestCancelReason.TrsyTradeReqCancellationReason = TrsyTradeReqCancellationReason  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON _CreatedBy.ContactCardID = TreasuryTradeRequestCreatedBy  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedBy ON _ChangedBy.ContactCardID = TrsyTradeRequestLastChangedBy  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _TradedCurrencyText ON _TradedCurrencyText.Currency = TrsyTradeRequestTradedCurrency  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _OppositeCurrencyText ON _OppositeCurrencyText.Currency = TrsyTrdRequestOppositeCurrency  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _FXLeadingCurrencyText ON _FXLeadingCurrencyText.Currency = TreasuryFXLeadingCurrency  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _FXFollowingCurrencyText ON _FXFollowingCurrencyText.Currency = TreasuryFXFollowingCurrency  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _CashSettlementCurrencyText ON _CashSettlementCurrencyText.Currency = CashSettlementCurrency  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _FXLeg2TradedCurrencyText ON _FXLeg2TradedCurrencyText.Currency = FXLeg2TradedCurrency  -- association [0..*]
LEFT OUTER JOIN I_CurrencyText AS _FXSwapLeg2CashSettleCrcyText ON _FXSwapLeg2CashSettleCrcyText.Currency = FXSwapLeg2CashSettleCurrency  -- association [0..*]
LEFT OUTER JOIN R_TrsyTrdReqAddlAttributesTP AS _AdditionalAttributes ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN R_TrsyTrdReqFinTransactionTP AS _FinancialTransaction ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_TrsyTrdReqActionHistoryTP AS _ActionHistory ON /* condition not available in parsed metadata */  -- association [1..*]
;