C_LegalTransactionRemEmail

DDL: C_LEGALTRANSACTIONREMEMAIL SQL: CLEGALTRREMEML Type: view CONSUMPTION
31 Fields 1 Data Sources 5 Associations

Legal Transaction Reminder

C_LegalTransactionRemEmail is a Consumption CDS View that provides data about "Legal Transaction Reminder" in SAP S/4HANA. It reads from 1 data source (C_LegalTransactionReminderTP) and exposes 31 fields with key field LegalTransactionReminderUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
C_LegalTransactionReminderTP LegalTransactionReminder from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_LegalTransactionTP _LegalTransactionTP $projection.LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID
[0..1] C_LegalTransactionDateTP _LegalTransactionTermnDateTP $projection.LegalTransactionUUID = _LegalTransactionTermnDateTP.LegalTransactionUUID and _LegalTransactionTermnDateTP.LglCntntMDateType = 'SAP3'
[0..1] C_LegalTransactionDateTP _LegalTransactionRnwlDateTP $projection.LegalTransactionUUID = _LegalTransactionRnwlDateTP.LegalTransactionUUID and _LegalTransactionRnwlDateTP.LglCntntMDateType = 'SAP4'
[0..1] C_LegalTransactionDateTP _LegalTransactionEndDateTP $projection.LegalTransactionUUID = _LegalTransactionEndDateTP.LegalTransactionUUID and _LegalTransactionEndDateTP.LglCntntMDateType = 'SAP2'
[0..1] C_LglCntntMMainEntity _LglCntntMMainEntity $projection.LegalTransactionUUID = _LglCntntMMainEntity.LegalTransactionUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CLEGALTRREMEML view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.semanticKey LegalTransactionReminderUUID view
ObjectModel.representativeKey LegalTransactionReminderUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Legal Transaction Reminder view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionReminderUUID C_LegalTransactionReminderTP LegalTransactionReminderUUID Universal Unique ID
LegalTransactionUUID C_LegalTransactionReminderTP LegalTransactionUUID Universal Unique ID
LegalTransactionReminderType C_LegalTransactionReminderTP LegalTransactionReminderType Reminder Type
LegalTransactionRemTypeName _LegalTrRemTypeValueHelp LegalTransactionRemTypeName Long Text
LegalTransactionRemSubject C_LegalTransactionReminderTP LegalTransactionRemSubject Reminder Subject
LegalTransactionReminderDate C_LegalTransactionReminderTP LegalTransactionReminderDate Valid From
LglCntntMRemFrequency C_LegalTransactionReminderTP LglCntntMRemFrequency Reminder Frequency
LglCntntMRemFrequencyUnit C_LegalTransactionReminderTP LglCntntMRemFrequencyUnit Frequency Unit
LglCntntMReminderEndDate C_LegalTransactionReminderTP LglCntntMReminderEndDate Valid To
LglCntntMNextReminderDate C_LegalTransactionReminderTP LglCntntMNextReminderDate Valid From
LglCntntMRemRecipientType C_LegalTransactionReminderTP LglCntntMRemRecipientType Assignment Type
LglCntntMRecipientUser C_LegalTransactionReminderTP LglCntntMRecipientUser Recipient User
LglCntntMRemRecipientTeam C_LegalTransactionReminderTP LglCntntMRemRecipientTeam Recipient Team
LglCntntMRemRecipientFunction C_LegalTransactionReminderTP LglCntntMRemRecipientFunction Recipient Function
LglCntntMRemRcpntIntCntctType C_LegalTransactionReminderTP LglCntntMRemRcpntIntCntctType Contact Type
FullName
EmailAddress
LegalTransaction
LegalTransactionTitle
LegalTransactionHealth
LegalTransactionHealthName
LglCntntMEntity
LglCntntMEntityName _LglCntntMMainEntity LglCntntMEntityName
LglCntntMTermnDate _LegalTransactionTermnDateTP LglCntntMFromDate Valid From
LglCntntMRnwlDate _LegalTransactionRnwlDateTP LglCntntMFromDate Valid From
LglCntntMEndDate _LegalTransactionEndDateTP LglCntntMFromDate Valid From
_LegalTransactionTP _LegalTransactionTP
_LegalTransaction _LegalTransaction
_LegalTransactionTermnDateTP _LegalTransactionTermnDateTP
_LegalTransactionEndDateTP _LegalTransactionEndDateTP
_LegalTransactionRnwlDateTP _LegalTransactionRnwlDateTP

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_LegalTransactionRemEmail.
-- 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: CLEGALTRREMEML

CREATE VIEW C_LegalTransactionRemEmail AS
SELECT
  LegalTransactionReminder.LegalTransactionReminderUUID AS LegalTransactionReminderUUID,
  LegalTransactionReminder.LegalTransactionUUID AS LegalTransactionUUID,
  LegalTransactionReminder.LegalTransactionReminderType AS LegalTransactionReminderType,
  _LegalTrRemTypeValueHelp.LegalTransactionRemTypeName AS LegalTransactionRemTypeName,
  LegalTransactionReminder.LegalTransactionRemSubject AS LegalTransactionRemSubject,
  LegalTransactionReminder.LegalTransactionReminderDate AS LegalTransactionReminderDate,
  LegalTransactionReminder.LglCntntMRemFrequency AS LglCntntMRemFrequency,
  LegalTransactionReminder.LglCntntMRemFrequencyUnit AS LglCntntMRemFrequencyUnit,
  LegalTransactionReminder.LglCntntMReminderEndDate AS LglCntntMReminderEndDate,
  LegalTransactionReminder.LglCntntMNextReminderDate AS LglCntntMNextReminderDate,
  LegalTransactionReminder.LglCntntMRemRecipientType AS LglCntntMRemRecipientType,
  LegalTransactionReminder.LglCntntMRecipientUser AS LglCntntMRecipientUser,
  LegalTransactionReminder.LglCntntMRemRecipientTeam AS LglCntntMRemRecipientTeam,
  LegalTransactionReminder.LglCntntMRemRecipientFunction AS LglCntntMRemRecipientFunction,
  LegalTransactionReminder.LglCntntMRemRcpntIntCntctType AS LglCntntMRemRcpntIntCntctType,
  LegalTransactionReminder._LCMUserValueHelp.FullName AS FullName,
  LegalTransactionReminder._LCMUserValueHelp.EmailAddress AS EmailAddress,
  LegalTransactionReminder._LegalTransactionTP.LegalTransaction AS LegalTransaction,
  LegalTransactionReminder._LegalTransactionTP.LegalTransactionTitle AS LegalTransactionTitle,
  LegalTransactionReminder._LegalTransactionTP.LegalTransactionHealth AS LegalTransactionHealth,
  LegalTransactionReminder._LegalTransactionTP._LegalTransactionHealthText.LegalTransactionHealthName AS LegalTransactionHealthName,
  LegalTransactionReminder._LegalTransactionTP.LglCntntMEntity AS LglCntntMEntity,
  _LglCntntMMainEntity.LglCntntMEntityName AS LglCntntMEntityName,
  _LegalTransactionTermnDateTP.LglCntntMFromDate AS LglCntntMTermnDate,
  _LegalTransactionRnwlDateTP.LglCntntMFromDate AS LglCntntMRnwlDate,
  _LegalTransactionEndDateTP.LglCntntMFromDate AS LglCntntMEndDate
FROM C_LegalTransactionReminderTP AS LegalTransactionReminder
LEFT OUTER JOIN C_LegalTransactionTP AS _LegalTransactionTP ON LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN C_LegalTransactionDateTP AS _LegalTransactionTermnDateTP ON LegalTransactionUUID = _LegalTransactionTermnDateTP.LegalTransactionUUID AND _LegalTransactionTermnDateTP.LglCntntMDateType = 'SAP3'  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionDateTP AS _LegalTransactionRnwlDateTP ON LegalTransactionUUID = _LegalTransactionRnwlDateTP.LegalTransactionUUID AND _LegalTransactionRnwlDateTP.LglCntntMDateType = 'SAP4'  -- association [0..1]
LEFT OUTER JOIN C_LegalTransactionDateTP AS _LegalTransactionEndDateTP ON LegalTransactionUUID = _LegalTransactionEndDateTP.LegalTransactionUUID AND _LegalTransactionEndDateTP.LglCntntMDateType = 'SAP2'  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMMainEntity AS _LglCntntMMainEntity ON LegalTransactionUUID = _LglCntntMMainEntity.LegalTransactionUUID  -- association [0..1]
;

Learn More