C_LegalTransactionReminderTP

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 C_LegalTransactionReminderTP.
-- 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: CLEGALTRREMTP

CREATE VIEW C_LegalTransactionReminderTP AS
SELECT
  LegalTransactionReminderUUID,
  LegalTransactionReminder.LegalTransactionReminderType AS LegalTransactionReminderType,
  _LegalTrRemTypeValueHelp.LegalTransactionRemTypeName AS LegalTransactionRemTypeName,
  LegalTransactionReminder.LegalTransactionRemSubject AS LegalTransactionRemSubject,
  LegalTransactionReminder.LegalTransactionReminderDate AS LegalTransactionReminderDate,
  LglCntntMRemFrequency,
  LglCntntMRemFrequencyUnit,
  _LglCntntMRemFrqcyUnitText[ 1: Language = $session.system_language].LglCntntMRemFrqcyUnitName AS LglCntntMRemFrqcyUnitName,
  LglCntntMReminderEndDate,
  LglCntntMNextReminderDate,
  LglCntntMRemRecipientType,
  _LglCntntMRemRcpntTypeText[ 1: Language = $session.system_language].LglCntntMRemRecipientTypeName AS LglCntntMRemRecipientTypeName,
  LegalTransactionReminder.LglCntntMRecipientUser AS LglCntntMRecipientUser,
  LglCntntMRemRecipientTeam,
  _LglCntntMRemRcpntTeamVH.LglCntntMRemRecipientTeamName AS LglCntntMRemRecipientTeamName,
  LglCntntMRemRecipientFunction,
  _LglCntntMRemRcpntFuncVH.LglCntntMRemRecipientFuncName AS LglCntntMRemRecipientFuncName,
  LglCntntMRemRcpntIntCntctType,
  _LCMIntContactTypeText[ 1: Language = $session.system_language].LglCntntMIntCntctTypeName AS LglCntntMIntCntctTypeName,
  LglCntntMRemIsAutoGenerated,
  _ReminderContactCard.FullName AS FullName,
  LegalTransactionReminder.LegalTransactionUUID AS LegalTransactionUUID,
  LglCntntMChangedUTCDateTime
FROM I_LegalTransactionReminderTP AS LegalTransactionReminder
LEFT OUTER JOIN C_LegalTransactionTP AS _LegalTransactionTP ON LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN C_LegalTrRemTypeValueHelp AS _LegalTrRemTypeValueHelp ON LegalTransactionReminderType = _LegalTrRemTypeValueHelp.LegalTransactionReminderType  -- association [0..1]
LEFT OUTER JOIN C_LCMUserValueHelp AS _LCMUserValueHelp ON _LCMUserValueHelp.UserID = LglCntntMRecipientUser  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _ReminderContactCard ON _ReminderContactCard.ContactCardType = 'User' AND _ReminderContactCard.ContactCardID = LglCntntMRecipientUser AND _ReminderContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMRemRcpntTeamVH AS _LglCntntMRemRcpntTeamVH ON LglCntntMRemRecipientTeam = _LglCntntMRemRcpntTeamVH.LglCntntMRemRecipientTeam  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMRemRcpntFuncVH AS _LglCntntMRemRcpntFuncVH ON LglCntntMRemRecipientFunction = _LglCntntMRemRcpntFuncVH.LglCntntMRemRecipientFunction  -- association [0..1]
;