C_LegalTrRelationShipEmail

DDL: C_LEGALTRRELATIONSHIPEMAIL SQL: CLTRELEMAIL Type: view CONSUMPTION Package: ODATA_LCM_LT
10 Fields 1 Data Sources 2 Associations

Email for LegalTransaction in Relation

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

Data Sources (1)

SourceAliasJoin Type
I_LegalTrRelationshipEmail I_LegalTrRelationshipEmail from

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_LegalTransactionHealthVH _LegalTransactionHealthVH $projection.LegalTransactionHealth = _LegalTransactionHealthVH.LegalTransactionHealth
[0..1] C_LCMRelationshipTypeValueHelp _LCMRelationshipTypeValueHelp $projection.LglCntntMRelshpType = _LCMRelationshipTypeValueHelp.LglCntntMRelshpType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CLTRELEMAIL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Email for LegalTransaction 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
LegalTransactionTitle LegalTransactionTitle Title
LegalTransactionHealth LegalTransactionHealth LT Status
LegalTransactionHealthName _LegalTransactionHealthVH LegalTransactionHealthName Long Text
RelshpLegalTransactionTitle RelshpLegalTransactionTitle Title
LglCntntMRelshpType LglCntntMRelshpType Relationship Type
LglCntntMRelTypeName _LCMRelationshipTypeValueHelp LglCntntMRelTypeName Rel. Type Name
_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 C_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: CLTRELEMAIL

CREATE VIEW C_LegalTrRelationShipEmail AS
SELECT
  LegalTransactionRelshpUUID,
  LegalTransactionUUID,
  RelshpLegalTransactionUUID,
  LegalTransactionTitle,
  LegalTransactionHealth,
  _LegalTransactionHealthVH.LegalTransactionHealthName AS LegalTransactionHealthName,
  RelshpLegalTransactionTitle,
  LglCntntMRelshpType,
  _LCMRelationshipTypeValueHelp.LglCntntMRelTypeName AS LglCntntMRelTypeName
FROM I_LegalTrRelationshipEmail
LEFT OUTER JOIN C_LegalTransactionHealthVH AS _LegalTransactionHealthVH ON LegalTransactionHealth = _LegalTransactionHealthVH.LegalTransactionHealth  -- association [0..1]
LEFT OUTER JOIN C_LCMRelationshipTypeValueHelp AS _LCMRelationshipTypeValueHelp ON LglCntntMRelshpType = _LCMRelationshipTypeValueHelp.LglCntntMRelshpType  -- association [0..1]
;

Learn More