R_LegalDocOblgnRemTP

DDL: R_LEGALDOCOBLGNREMTP Type: view_entity TRANSACTIONAL
12 Fields 1 Data Sources 2 Associations

Legal Document Obligation Reminders

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

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMDocOblgnRem I_LglCntntMDocOblgnRem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_LegalDocumentTP _Document $projection.LglCntntMDocumentUUID = _Document.LglCntntMDocumentUUID
[0..1] I_LglCntntMDocOblgnTypeTxt _LglCntntMDocOblgnTypeTxt $projection.LglCntntMDocOblgnType = _LglCntntMDocOblgnTypeTxt.LglCntntMDocOblgnType and _LglCntntMDocOblgnTypeTxt.Language = $session.system_language

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Legal Document Obligation Reminders view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMDocOblgnRemUUID LglCntntMDocOblgnRemUUID Universal Unique ID
LglCntntMDocOblgnUUID LglCntntMDocOblgnUUID Universal Unique ID
LglCntntMDocumentUUID LglCntntMDocumentUUID Universal Unique ID
LglCntntMDocOblgnRemType LglCntntMDocOblgnRemType Reminder Type
LglCntntMDocOblgnRemDate LglCntntMDocOblgnRemDate Valid From
LglCntntMDocOblgnRemRcpntUsr LglCntntMDocOblgnRemRcpntUsr Recipient User
LglCntntMDocOblgnRemSubject LglCntntMDocOblgnRemSubject Reminder Subject
LglCntntMDocObligation LglCntntMDocObligation Obligation ID
LglCntntMDocOblgnType _LegalDocObligation LglCntntMDocOblgnType Obligation Type
_Document _Document
_LegalDocObligation _LegalDocObligation
_LglCntntMDocOblgnTypeTxt _LglCntntMDocOblgnTypeTxt

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 R_LegalDocOblgnRemTP.
-- 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.

CREATE VIEW R_LegalDocOblgnRemTP AS
SELECT
  LglCntntMDocOblgnRemUUID,
  LglCntntMDocOblgnUUID,
  LglCntntMDocumentUUID,
  LglCntntMDocOblgnRemType,
  LglCntntMDocOblgnRemDate,
  LglCntntMDocOblgnRemRcpntUsr,
  LglCntntMDocOblgnRemSubject,
  LglCntntMDocObligation,
  _LegalDocObligation.LglCntntMDocOblgnType AS LglCntntMDocOblgnType
FROM I_LglCntntMDocOblgnRem
LEFT OUTER JOIN R_LegalDocumentTP AS _Document ON LglCntntMDocumentUUID = _Document.LglCntntMDocumentUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMDocOblgnTypeTxt AS _LglCntntMDocOblgnTypeTxt ON LglCntntMDocOblgnType = _LglCntntMDocOblgnTypeTxt.LglCntntMDocOblgnType AND _LglCntntMDocOblgnTypeTxt.Language = $session.system_language  -- association [0..1]
;

Learn More