I_LEGALTRANSACTIONREMINDER

CDS View

Basic View for Legal Transaction Reminder

I_LEGALTRANSACTIONREMINDER is a CDS View in S/4HANA. Basic View for Legal Transaction Reminder. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LegalTransactionReminderTP view from TRANSACTIONAL TP View for Legal Transaction Reminder
R_LegalTransactionReminderTP view_entity from TRANSACTIONAL Legal Transaction Reminder
@AbapCatalog.sqlViewName: 'ILEGALTRREM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#CHECK
@VDM.viewType : #BASIC
@Metadata.ignorePropagatedAnnotations: true

@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel: {
  representativeKey: 'LEGALTRANSACTIONREMINDERUUID',
  usageType.serviceQuality: #A,
  usageType.sizeCategory: #L,
  usageType.dataClass: #TRANSACTIONAL
}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Basic View for Legal Transaction Reminder'

define view I_LegalTransactionReminder
  as select from lcm_lt_reminder
  association [1..1] to I_LegalTransaction          as _LegalTransaction          on  $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID

  association [0..1] to I_LglCntntMRemFrqcyUnitText as _LglCntntMRemFrqcyUnitText on  $projection.LglCntntMRemFrequencyUnit = _LglCntntMRemFrqcyUnitText.LglCntntMRemFrequencyUnit
                                                                                  and Language                              = $session.system_language

  association [0..1] to I_LglCntntMRemRcpntTypeText as _LglCntntMRemRcpntTypeText on  $projection.LglCntntMRemRecipientType = _LglCntntMRemRcpntTypeText.LglCntntMRemRecipientType
                                                                                  and Language                              = $session.system_language
                                                                                  
  association [0..1] to I_LCMIntContactTypeText as _LCMIntContactTypeText on  $projection.LglCntntMRemRcpntIntCntctType = _LCMIntContactTypeText.LglCntntMIntCntctType
                                                                                  and Language                              = $session.system_language                                                                                  
{

  key 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,
      _LegalTransaction,

      _LglCntntMRemFrqcyUnitText,
      
      _LglCntntMRemRcpntTypeText,
      
      _LCMIntContactTypeText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"LCM_LT_REMINDER"
],
"ASSOCIATED":
[
"I_LCMINTCONTACTTYPETEXT",
"I_LEGALTRANSACTION",
"I_LGLCNTNTMREMFRQCYUNITTEXT",
"I_LGLCNTNTMREMRCPNTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/