C_LglCntntMMyLglTransReminder

DDL: C_LGLCNTNTMMYLGLTRANSREMINDER SQL: CLCMMYREM Type: view CONSUMPTION
21 Fields 1 Data Sources 1 Associations

My Legal Transaction Reminders

C_LglCntntMMyLglTransReminder is a Consumption CDS View that provides data about "My Legal Transaction Reminders" in SAP S/4HANA. It reads from 1 data source (C_LegalTransactionReminderTP) and exposes 21 fields with key fields LegalTransactionReminderUUID, LegalTransactionUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
C_LegalTransactionReminderTP C_LegalTransactionReminderTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_LglCntntMMyUsrInIntCntct _LglCntntMMyUsrInIntCntct $projection.LegalTransactionUUID = _LglCntntMMyUsrInIntCntct.LegalTransactionUUID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CLCMMYREM view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
UI.headerInfo.typeName My Legal Transaction Reminders view
UI.headerInfo.typeNamePlural My Legal Transaction Reminders view
EndUserText.label My Legal Transaction Reminders view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionReminderUUID LegalTransactionReminderUUID Universal Unique ID
KEY LegalTransactionUUID C_LegalTransactionReminderTP LegalTransactionUUID Universal Unique ID
LegalTransaction _LegalTransactionTP LegalTransaction Legal Transaction ID
LegalTransactionTitle _LegalTransactionTP LegalTransactionTitle Title
LegalContext _LegalTransactionTP LegalContext
LglCntntMContextVersion _LegalTransactionTP LglCntntMContextVersion Context Version
LegalTransactionReminderType LegalTransactionReminderType Reminder Type
LegalTransactionRemTypeName _LegalTrRemTypeValueHelp LegalTransactionRemTypeName Long Text
LegalTransactionReminderDate LegalTransactionReminderDate Valid From
LglCntntMNextReminderDate LglCntntMNextReminderDate Valid From
LegalTransactionHealth _LegalTransactionTP LegalTransactionHealth LT Status
LegalTransactionHealthName
LglCntntMCreatedUTCDateTime _LegalTransactionTP LglCntntMCreatedUTCDateTime Created On
LglCntntMEntity _LegalTransactionTP LglCntntMEntity Entity ID
LglCntntMEntityType _LegalTransactionTP LglCntntMEntityType Entity Type
LglCntntMProfile _LegalTransactionTP LglCntntMProfile Profile
LglTransAccessLvl _LegalTransactionTP LglTransAccessLvl Acs. Level
LglCntntMMainOrgCoCode _LegalTransactionTP LglCntntMMainOrgCoCode Entity ID
LglCntntMMainOrgSalesOrg _LegalTransactionTP LglCntntMMainOrgSalesOrg Entity ID
LglCntntMMainOrgPurOrg _LegalTransactionTP LglCntntMMainOrgPurOrg Entity ID
IsEndOfPurposeBlocked _LegalTransactionTP IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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_LglCntntMMyLglTransReminder.
-- 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: CLCMMYREM

CREATE VIEW C_LglCntntMMyLglTransReminder AS
SELECT
  LegalTransactionReminderUUID,
  C_LegalTransactionReminderTP.LegalTransactionUUID AS LegalTransactionUUID,
  _LegalTransactionTP.LegalTransaction AS LegalTransaction,
  _LegalTransactionTP.LegalTransactionTitle AS LegalTransactionTitle,
  _LegalTransactionTP.LegalContext AS LegalContext,
  _LegalTransactionTP.LglCntntMContextVersion AS LglCntntMContextVersion,
  LegalTransactionReminderType,
  _LegalTrRemTypeValueHelp.LegalTransactionRemTypeName AS LegalTransactionRemTypeName,
  LegalTransactionReminderDate,
  LglCntntMNextReminderDate,
  _LegalTransactionTP.LegalTransactionHealth AS LegalTransactionHealth,
  _LegalTransactionTP._LegalTransactionHealthVH.LegalTransactionHealthName AS LegalTransactionHealthName,
  _LegalTransactionTP.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  _LegalTransactionTP.LglCntntMEntity AS LglCntntMEntity,
  _LegalTransactionTP.LglCntntMEntityType AS LglCntntMEntityType,
  _LegalTransactionTP.LglCntntMProfile AS LglCntntMProfile,
  _LegalTransactionTP.LglTransAccessLvl AS LglTransAccessLvl,
  _LegalTransactionTP.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  _LegalTransactionTP.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg,
  _LegalTransactionTP.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  _LegalTransactionTP.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM C_LegalTransactionReminderTP
LEFT OUTER JOIN I_LglCntntMMyUsrInIntCntct AS _LglCntntMMyUsrInIntCntct ON LegalTransactionUUID = _LglCntntMMyUsrInIntCntct.LegalTransactionUUID  -- association [1..1]
;

Learn More