I_LegalTransactionDocLink

DDL: I_LEGALTRANSACTIONDOCLINK SQL: ILTDOCLINK Type: view COMPOSITE Package: VDM_LCM_LT

Basic View Legal Transaction Doc Link

I_LegalTransactionDocLink is a Composite CDS View that provides data about "Basic View Legal Transaction Doc Link" in SAP S/4HANA. It reads from 1 data source (I_LegalTransDocLinkBase) and exposes 11 fields with key field LegalTransactionDocLinkUUID. It has 2 associations to related views. Part of development package VDM_LCM_LT.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransDocLinkBase LegalDocLink from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LegalTransaction _LegalTransaction $projection.LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID
[1..1] I_LcmDocument _Document $projection.LglCntntMDocument = _Document.LglCntntMDocument and _Document.LglCntntMDocumentIsTopVersion = 'X'

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILTDOCLINK view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey LegalTransactionDocLinkUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Basic View Legal Transaction Doc Link view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionDocLinkUUID I_LegalTransDocLinkBase LegalTransactionDocLinkUUID Universal Unique ID
LegalTransactionUUID I_LegalTransDocLinkBase LegalTransactionUUID Universal Unique ID
LglCntntMDocument I_LegalTransDocLinkBase LglCntntMDocument Document ID
LglCntntMDocumentLinkedObject _Document LglCntntMDocumentLinkedObject Object
LglCntntMDocumentLinkedObjKey _Document LglCntntMDocumentLinkedObjKey UUID Char32
LglCntntMAgingTemperature I_LegalTransDocLinkBase LglCntntMAgingTemperature Data Aging
LglCntntMDocAccessLvl _Document LglCntntMDocAccessLvl Acs. Level
LglCntntMDocContentType _Document LglCntntMDocContentType Content Type
InternalDocumentStatus _Document InternalDocumentStatus Status
_LegalTransaction _LegalTransaction
_DocumentAuth _Document

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_LegalTransactionDocLink.
-- 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: ILTDOCLINK

CREATE VIEW I_LegalTransactionDocLink AS
SELECT
  LegalDocLink.LegalTransactionDocLinkUUID AS LegalTransactionDocLinkUUID,
  LegalDocLink.LegalTransactionUUID AS LegalTransactionUUID,
  LegalDocLink.LglCntntMDocument AS LglCntntMDocument,
  _Document.LglCntntMDocumentLinkedObject AS LglCntntMDocumentLinkedObject,
  _Document.LglCntntMDocumentLinkedObjKey AS LglCntntMDocumentLinkedObjKey,
  LegalDocLink.LglCntntMAgingTemperature AS LglCntntMAgingTemperature,
  _Document.LglCntntMDocAccessLvl AS LglCntntMDocAccessLvl,
  _Document.LglCntntMDocContentType AS LglCntntMDocContentType,
  _Document.InternalDocumentStatus AS InternalDocumentStatus
FROM I_LegalTransDocLinkBase AS LegalDocLink
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LcmDocument AS _Document ON LglCntntMDocument = _Document.LglCntntMDocument AND _Document.LglCntntMDocumentIsTopVersion = 'X'  -- association [1..1]
;