I_LglTransFailedRelshpSitn

DDL: I_LGLTRANSFAILEDRELSHPSITN SQL: ILTFLRELSIT Type: view COMPOSITE
11 Fields 1 Data Sources

View for Situations failed Legal Transaction

I_LglTransFailedRelshpSitn is a Composite CDS View that provides data about "View for Situations failed Legal Transaction" in SAP S/4HANA. It reads from 1 data source (I_LglTransactionRelshpFailed) and exposes 11 fields with key fields LglCntntMUseCaseRegUUID, LegalTransactionTopUUID.

Data Sources (1)

SourceAliasJoin Type
I_LglTransactionRelshpFailed I_LglTransactionRelshpFailed from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ILTFLRELSIT 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 #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey LegalTransactionUUID view
AbapCatalog.preserveKey true view
EndUserText.label View for Situations failed Legal Transaction view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMUseCaseRegUUID LglCntntMUseCaseRegUUID
KEY LegalTransactionTopUUID LegalTransactionTopUUID Universal Unique ID
LegalTransaction LegalTransactionChild Child Legal Transaction
ChildLglTransHealthName Child Legal Transaction Status
LglCntntMGovLaw _LglTransactionChild LglCntntMGovLaw Governing Law
LglCntntMProfile _LglTransactionChild LglCntntMProfile Profile
LegalTransactionasTopLegalTransaction Top Legal Transaction
LglTransTopHealthName Top Legal Transaction Status
int4asLegalTransactionOverdueDays Overdue Days
LglCntntMCreatedUTCDateTime _LglCntntMRelshpRegnUseCase LglCntntMCreatedUTCDateTime Created On
_LglTransactionTop _LglTransactionTop

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_LglTransFailedRelshpSitn.
-- 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: ILTFLRELSIT

CREATE VIEW I_LglTransFailedRelshpSitn AS
SELECT
  LglCntntMUseCaseRegUUID,
  LegalTransactionTopUUID,
  LegalTransactionChild AS LegalTransaction,
  _LglTransactionChild._LegalTransactionHealthText.LegalTransactionHealthName AS ChildLglTransHealthName,
  _LglTransactionChild.LglCntntMGovLaw AS LglCntntMGovLaw,
  _LglTransactionChild.LglCntntMProfile AS LglCntntMProfile,
  _LglTransactionTop._LegalTransactionHealthText.LegalTransactionHealthName AS LglTransTopHealthName,
  _LglCntntMRelshpRegnUseCase.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime
FROM I_LglTransactionRelshpFailed
;

Learn More