C_LglCntntMDocOblgnReminder

DDL: C_LGLCNTNTMDOCOBLGNREMINDER SQL: CLCMOBLGNREM Type: view CONSUMPTION
19 Fields 1 Data Sources 2 Associations

Legal Document Obligation Reminders

C_LglCntntMDocOblgnReminder is a Consumption CDS View that provides data about "Legal Document Obligation Reminders" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMDocOblgnRemTP) and exposes 19 fields with key field LglCntntMDocOblgnRemUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMDocOblgnRemTP I_LglCntntMDocOblgnRemTP from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LCMUserContactCard _ReminderContactCard _ReminderContactCard.ContactCardType = 'User' and _ReminderContactCard.ContactCardID = $projection.LglCntntMDocOblgnRemRcpntUsr and _ReminderContactCard.ContactCardRole = 'Creator'
[0..1] C_LegalTrRemTypeValueHelp _LegalDocOblgnRemTypeText $projection.LglCntntMDocOblgnRemType = _LegalDocOblgnRemTypeText.LegalTransactionReminderType

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CLCMOBLGNREM view
EndUserText.label Legal Document Obligation Reminders view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.semanticKey LglCntntMDocOblgnRemUUID view
ObjectModel.representativeKey LglCntntMDocOblgnRemUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
UI.headerInfo.typeName Obligation Reminder view
UI.headerInfo.typeNamePlural Obligation Reminders view
UI.headerInfo.title.value LglCntntMDocOblgnRemSubject view
UI.headerInfo.description.value LegalTransactionRemTypeName view
AbapCatalog.preserveKey true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMDocOblgnRemUUID LglCntntMDocOblgnRemUUID Universal Unique ID
LglCntntMDocOblgnUUID LglCntntMDocOblgnUUID Universal Unique ID
LglCntntMDocumentUUID LglCntntMDocumentUUID Universal Unique ID
LglCntntMDocument _LCMDocumentTP LglCntntMDocument Document
DocumentDescription _LCMDocumentTP DocumentDescription Doc. Name
LegalTransactionUUID _LCMDocumentTP LegalTransactionUUID Universal Unique ID
LegalTransaction _LCMDocumentTP LegalTransaction Legal Transaction ID
LglCntntMDocOblgnRemType LglCntntMDocOblgnRemType Reminder Type
LegalTransactionRemTypeName _LegalDocOblgnRemTypeText LegalTransactionRemTypeName Long Text
LglCntntMDocOblgnRemSubject LglCntntMDocOblgnRemSubject Subject
LglCntntMDocOblgnRemDate LglCntntMDocOblgnRemDate Date
LglCntntMDocOblgnRemRcpntUsr LglCntntMDocOblgnRemRcpntUsr Recipient
FullName _ReminderContactCard FullName Name
LglCntntMDocObligation LglCntntMDocObligation Obligation
LglCntntMDocOblgnType LglCntntMDocOblgnType Obligation Type
LglCntntMDocOblgnTypeName _LglCntntMDocOblgnTypeTxt LglCntntMDocOblgnTypeName Oblgn Types
_ReminderContactCard _ReminderContactCard
_LglCntntMDocOblgnTypeTxt _LglCntntMDocOblgnTypeTxt
_DocumentAuth _DocumentAuth

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_LglCntntMDocOblgnReminder.
-- 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: CLCMOBLGNREM

CREATE VIEW C_LglCntntMDocOblgnReminder AS
SELECT
  LglCntntMDocOblgnRemUUID,
  LglCntntMDocOblgnUUID,
  LglCntntMDocumentUUID,
  _LCMDocumentTP.LglCntntMDocument AS LglCntntMDocument,
  _LCMDocumentTP.DocumentDescription AS DocumentDescription,
  _LCMDocumentTP.LegalTransactionUUID AS LegalTransactionUUID,
  _LCMDocumentTP.LegalTransaction AS LegalTransaction,
  LglCntntMDocOblgnRemType,
  _LegalDocOblgnRemTypeText.LegalTransactionRemTypeName AS LegalTransactionRemTypeName,
  LglCntntMDocOblgnRemSubject,
  LglCntntMDocOblgnRemDate,
  LglCntntMDocOblgnRemRcpntUsr,
  _ReminderContactCard.FullName AS FullName,
  LglCntntMDocObligation,
  LglCntntMDocOblgnType,
  _LglCntntMDocOblgnTypeTxt.LglCntntMDocOblgnTypeName AS LglCntntMDocOblgnTypeName
FROM I_LglCntntMDocOblgnRemTP
LEFT OUTER JOIN I_LCMUserContactCard AS _ReminderContactCard ON _ReminderContactCard.ContactCardType = 'User' AND _ReminderContactCard.ContactCardID = LglCntntMDocOblgnRemRcpntUsr AND _ReminderContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN C_LegalTrRemTypeValueHelp AS _LegalDocOblgnRemTypeText ON LglCntntMDocOblgnRemType = _LegalDocOblgnRemTypeText.LegalTransactionReminderType  -- association [0..1]
;

Learn More