I_FinTransActivity

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_FinTransActivity.
-- 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: IFINTRANSACTY

CREATE VIEW I_FinTransActivity AS
SELECT
  Activity.bukrs AS CompanyCode,
  Activity.rfha AS FinancialTransaction,
  Activity.rfhazu AS FinancialInstrumentActivity,
  Activity.sfgzustt AS FinancialInstrActivityCategory,
  Activity.delfz AS TermEndDate,
  Activity.sincle AS TermEndDateIsInclusive,
  cast( Activity.sincle as ftr_term_start_end_inclusive preserving type ) AS FinTransTermStartEndInclusive,
  Activity.notice_date AS FinTransNoticeDate,
  cast(Activity.dvtrab as ftr_acty_conclusion_dte preserving type ) AS FinTransActyConclusionDate,
  Activity.tvtrab AS FinTransActyConclusionTime,
  Activity.zvtrab AS FinTransActyConclusionTimeZone,
  Activity.limitdat AS FinTransOrderValidityEndDate,
  Activity.dfix AS FinTransFixingDate,
  Activity.fixing_ref_id AS ForeignExchangeFixingReference,
  Activity.rdealer AS Trader,
  Activity.gsppart AS FinancialInstrContactPerson,
  Activity.nordext AS FinInstrExternalReference,
  Activity.sstogrd AS TreasuryReversalReason,
  Activity.sconfirm AS FinTransConfirmationStatus,
  Activity.dexdat AS FinTransConfirmationDate,
  Activity.uexnam AS FinTransConfirmedByUser,
  Activity.sreconfirm AS FinTransCntrconfStatus,
  Activity.dredat AS FinTransCntrconfDate,
  Activity.urenam AS FinTransCntrconfCreatedByUser,
  Activity.wlwaers AS LeadingCurrency,
  Activity.wfwaers AS FollowingCurrency,
  Activity.kkurs AS ExchangeRate,
  Activity.kkassa AS SpotExchangeRate,
  Activity.kswap AS SwapExchangeRate,
  Activity.kwliqui AS LiquidityEffectValue,
  case when (Activity.wlwaers is not initial and Activity.wfwaers is not initial) then cast( concat(concat(Activity.wlwaers, '/'), Activity.wfwaers) as ftr_curr_pair) end as CurrencyPair AS wfwaersasftr_curr_pairendasCurrencyPair,
  Activity.peffzins AS EffectiveInterestRate,
  Activity.seffmeth AS EffectiveInterestMethod,
  Activity.sznspro AS FinTransIntrstHndlgAtRollover,
  Activity.dznsstd AS RolloverDfrrdIntrstPyoutDte,
  LetterOfCredit.lc_number AS LetterOfCredit,
  LetterOfCredit.applicant AS TreasuryApplicant,
  LetterOfCredit.benficiary AS TreasuryBeneficiary,
  LetterOfCredit.advising_bank AS TreasuryAdvisingBank,
  LetterOfCredit.issuing_bank AS TreasuryIssuingBank,
  LetterOfCredit.bg_number AS BankGuaranteeNumber,
  LetterOfCredit.bg_type AS BankGuaranteeType,
  TransactionType.sfgtyp AS FinInstrTransactionCategory,
  ProductType.sanlf AS FinancialInstrProductCategory
FROM vtbfhazu AS Activity
INNER JOIN at10 AS TransactionType ON /* join condition not captured in parsed metadata */
INNER JOIN tzpa AS ProductType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tlct_activity AS LetterOfCredit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinTrans ON CompanyCode = _FinTrans.CompanyCode AND FinancialTransaction = _FinTrans.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_FinTransActivityCategory AS _ActivityCategory ON CompanyCode = _ActivityCategory.CompanyCode AND FinancialTransaction = _ActivityCategory.FinancialTransaction AND FinancialInstrActivityCategory = _ActivityCategory.FinancialInstrActivityCategory  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON FinTransActyConclusionTimeZone = _TimeZone.TimeZoneID  -- association [0..1]
LEFT OUTER JOIN I_FXFixingReference AS _FixRef ON ForeignExchangeFixingReference = _FixRef.ForeignExchangeFixingReference  -- association [0..1]
LEFT OUTER JOIN I_TreasuryReversalReason AS _RevReason ON TreasuryReversalReason = _RevReason.TreasuryReversalReason  -- association [0..1]
LEFT OUTER JOIN I_FinTransConfStatus AS _ConfStatus ON FinTransConfirmationStatus = _ConfStatus.FinTransConfirmationStatus  -- association [0..1]
LEFT OUTER JOIN I_FinTransCntrconfStatus AS _CntrconfStatus ON FinTransCntrconfStatus = _CntrconfStatus.FinTransCntrconfStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _LeadingCurrency ON LeadingCurrency = _LeadingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FollowingCurrency ON FollowingCurrency = _FollowingCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ApplicantBP ON TreasuryApplicant = _ApplicantBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BeneficiaryBP ON TreasuryBeneficiary = _BeneficiaryBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _AdvisingBankBP ON TreasuryAdvisingBank = _AdvisingBankBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _IssuingBankBP ON TreasuryIssuingBank = _IssuingBankBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_FinInstrActivityCategory AS _ActivityCategory2 ON FinancialInstrProductCategory = _ActivityCategory2.FinancialInstrProductCategory AND FinInstrTransactionCategory = _ActivityCategory2.FinInstrTransactionCategory AND FinancialInstrActivityCategory = _ActivityCategory2.FinancialInstrActivityCategory  -- association [0..1]
;