I_LegalTrRelationshipEmail

DDL: I_LEGALTRRELATIONSHIPEMAIL SQL: ILTRELEMAIL Type: view COMPOSITE Package: VDM_LCM_LT
10 Fields 1 Data Sources 2 Associations

Basic View for Email LT in Relation

I_LegalTrRelationshipEmail is a Composite CDS View that provides data about "Basic View for Email LT in Relation" in SAP S/4HANA. It reads from 1 data source (I_LegalTrRelationship) and exposes 10 fields with key fields LegalTransactionRelshpUUID, LegalTransactionUUID. It has 2 associations to related views. Part of development package VDM_LCM_LT.

Data Sources (1)

SourceAliasJoin Type
I_LegalTrRelationship I_LegalTrRelationship from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LegalTransaction _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID
[1..1] I_LegalTransaction _RelshpLglTransaction $projection.RelshpLegalTransactionUUID = _RelshpLglTransaction.LegalTransactionUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ILTRELEMAIL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Basic View for Email LT in Relation view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionRelshpUUID LegalTransactionRelshpUUID Universal Unique ID
KEY LegalTransactionUUID LegalTransactionUUID Universal Unique ID
RelshpLegalTransactionUUID RelshpLegalTransactionUUID Universal Unique ID
LegalTransactionasLegalTransaction
LegalTransactionTitle _LegalTransaction LegalTransactionTitle Title
LegalTransactionHealth _LegalTransaction LegalTransactionHealth LT Status
LegalTransactionasRelshpLegalTransaction
RelshpLegalTransactionTitle _RelshpLglTransaction LegalTransactionTitle Title
LglCntntMRelshpType LglCntntMRelshpType Relationship Type
_LegalTransaction _LegalTransaction

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 I_LegalTrRelationshipEmail.
-- 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: ILTRELEMAIL

CREATE VIEW I_LegalTrRelationshipEmail AS
SELECT
  LegalTransactionRelshpUUID,
  LegalTransactionUUID,
  RelshpLegalTransactionUUID,
  _LegalTransaction.LegalTransactionTitle AS LegalTransactionTitle,
  _LegalTransaction.LegalTransactionHealth AS LegalTransactionHealth,
  _RelshpLglTransaction.LegalTransactionTitle AS RelshpLegalTransactionTitle,
  LglCntntMRelshpType
FROM I_LegalTrRelationship
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LegalTransaction AS _RelshpLglTransaction ON RelshpLegalTransactionUUID = _RelshpLglTransaction.LegalTransactionUUID  -- association [1..1]
;

Learn More