I_TrmCorrespondence

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_TrmCorrespondence.
-- 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: ITRMCORRESPNC

CREATE VIEW I_TrmCorrespondence AS
SELECT
  co.co_uuid AS TreasuryCorrespncObjectUUID,
  co.company_code AS CompanyCode,
  co.dealnumber AS FinancialTransaction,
  co.recipient_type AS CorrespondenceRecipientType,
  co.recipient AS CorrespondenceRecipient,
  cast(co.channel as ftr_cochannel) AS CorrespondenceChannel,
  co.message_format AS CorrespncMessageFileFormat,
  co.co_key AS CorrespondenceObject,
  co.partnr AS BusinessPartner,
  co.profile AS TreasuryCorrespondenceProfile,
  co.function AS TreasuryCorrespondenceClass,
  co.bpgroup AS TreasuryCorrespondenceBPGroup,
  co.corr_country AS Country,
  co.corr_language AS Language,
  co.activity AS FinancialInstrumentActivity,
  co.activitycat AS FinancialInstrActivityCategory,
  co.operation AS TreasuryCorrespncOperation,
  cast(_TreasuryCorrespncOperText.ddtext as ftr_cooperation_text) AS TreasuryCorrespncOpName,
  deal.contract_type AS TreasuryContractType,
  deal.product_cat AS FinancialInstrProductCategory,
  deal.product_type AS FinancialInstrumentProductType,
  _FinancialInstrProdTypeText.FinancialInstrProdTypeName AS FinancialInstrProdTypeName,
  deal.transaction_cat AS FinInstrTransactionCategory,
  deal.transaction_type AS FinancialInstrTransactionType,
  _FinancialInstrTransTypeText.FinancialInstrTransTypeName AS FinancialInstrTransTypeName,
  deal.portfolio AS Portfolio,
  deal.valuation_class AS FinancialInstrValuationClass,
  deal.internal_refnce AS FinancialInstrumentReference,
  deal.assignment AS FinancialInstrumentAssignment,
  deal.trader AS Trader,
  deal.contact_person AS FinancialInstrContactPerson,
  deal.guarantor AS FinancialInstrumentGuarantor,
  deal.external_refnce AS FinInstrExternalReference,
  $session.system_date AS CorrespondenceDeliveryDate,
  deal.security_account AS SecurityAccount,
  deal.security_id AS SecurityClass
LEFT OUTER JOIN tcort_codmd AS deal ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FinancialInstrProdTypeText AS _FinancialInstrProdTypeText ON FinancialInstrumentProductType = _FinancialInstrProdTypeText.FinancialInstrumentProductType AND _FinancialInstrProdTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrTransTypeText AS _FinancialInstrTransTypeText ON FinancialInstrumentProductType = _FinancialInstrTransTypeText.FinancialInstrumentProductType AND FinancialInstrTransactionType = _FinancialInstrTransTypeText.FinancialInstrTransactionType AND _FinancialInstrTransTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN dd07t AS _TreasuryCorrespncOperText ON TreasuryCorrespncOperation = _TreasuryCorrespncOperText.domvalue_l AND _TreasuryCorrespncOperText.domname = 'FTR_OPER' AND _TreasuryCorrespncOperText.as4local = 'A' AND _TreasuryCorrespncOperText.ddlanguage = $session.system_language  -- association [0..1]
;