I_LegalTransactionReminder

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_LegalTransactionReminder.
-- 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: ILEGALTRREM

CREATE VIEW I_LegalTransactionReminder AS
SELECT
  lcm_lt_reminder.legaltransactionreminderuuid AS LegalTransactionReminderUUID,
  lcm_lt_reminder.legaltransactionuuid AS LegalTransactionUUID,
  lcm_lt_reminder.legaltransactionremindertype AS LegalTransactionReminderType,
  lcm_lt_reminder.legaltransactionreminderdate AS LegalTransactionReminderDate,
  lcm_lt_reminder.legaltransactionremsubject AS LegalTransactionRemSubject,
  lcm_lt_reminder.lglcntntmrecipientuser AS LglCntntMRecipientUser,
  lcm_lt_reminder.lglcntntmremisautogenerated AS LglCntntMRemIsAutoGenerated,
  lcm_lt_reminder.legaltransactiondateuuid AS LegalTransactionDateUUID,
  lcm_lt_reminder.lglcntntmchangedutcdatetime AS LglCntntMChangedUTCDateTime,
  lcm_lt_reminder.lglcntntmremfrequency AS LglCntntMRemFrequency,
  lcm_lt_reminder.lglcntntmremfrequencyunit AS LglCntntMRemFrequencyUnit,
  lcm_lt_reminder.lglcntntmreminderenddate AS LglCntntMReminderEndDate,
  lcm_lt_reminder.lglcntntmnextreminderdate AS LglCntntMNextReminderDate,
  lcm_lt_reminder.lglcntntmremrecipienttype AS LglCntntMRemRecipientType,
  lcm_lt_reminder.lglcntntmremrecipientteam AS LglCntntMRemRecipientTeam,
  lcm_lt_reminder.lglcntntmremrecipientfunction AS LglCntntMRemRecipientFunction,
  lcm_lt_reminder.lglcntntmremrcpntintcntcttype AS LglCntntMRemRcpntIntCntctType
FROM lcm_lt_reminder
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMRemFrqcyUnitText AS _LglCntntMRemFrqcyUnitText ON LglCntntMRemFrequencyUnit = _LglCntntMRemFrqcyUnitText.LglCntntMRemFrequencyUnit AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMRemRcpntTypeText AS _LglCntntMRemRcpntTypeText ON LglCntntMRemRecipientType = _LglCntntMRemRcpntTypeText.LglCntntMRemRecipientType AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LCMIntContactTypeText AS _LCMIntContactTypeText ON LglCntntMRemRcpntIntCntctType = _LCMIntContactTypeText.LglCntntMIntCntctType AND Language = $session.system_language  -- association [0..1]
;