C_LglTransactionTopFailed

DDL: C_LGLTRANSACTIONTOPFAILED SQL: CLTRTOPFL Type: view CONSUMPTION Package: ODATA_LCM_LT
10 Fields 1 Data Sources 1 Associations

C view for failed Top LT in a Rel

C_LglTransactionTopFailed is a Consumption CDS View that provides data about "C view for failed Top LT in a Rel" in SAP S/4HANA. It reads from 1 data source (I_LglTransactionRelshpFailed) and exposes 10 fields with key fields LglCntntMUseCaseRegUUID, LegalTransactionTopUUID, LegalTransactionRelshpUUID. It has 1 association to related views. Part of development package ODATA_LCM_LT.

Data Sources (1)

SourceAliasJoin Type
I_LglTransactionRelshpFailed I_LglTransactionRelshpFailed from

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CLTRTOPFL view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label C view for failed Top LT in a Rel view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMUseCaseRegUUID LglCntntMUseCaseRegUUID
KEY LegalTransactionTopUUID LegalTransactionTopUUID Universal Unique ID
KEY LegalTransactionRelshpUUID LegalTransactionRelshpUUID Universal Unique ID
LegalTransactionTop LegalTransactionTop Legal Transaction ID
LegalTransactionTitleTop LegalTransactionTitleTop Title
LegalTransactionHealth LegalTransactionHealth LT Status
LegalTransactionHealthName _LegalTransactionHealthVH LegalTransactionHealthName Long Text
LglCntntMUseCaseExecStatus LglCntntMUseCaseExecStatus Usecase Execution Status
LglCntntMRelshpUseCase LglCntntMRelshpUseCase Rel. Use Case
_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 C_LglTransactionTopFailed.
-- 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: CLTRTOPFL

CREATE VIEW C_LglTransactionTopFailed AS
SELECT
  LglCntntMUseCaseRegUUID,
  LegalTransactionTopUUID,
  LegalTransactionRelshpUUID,
  LegalTransactionTop,
  LegalTransactionTitleTop,
  LegalTransactionHealth,
  _LegalTransactionHealthVH.LegalTransactionHealthName AS LegalTransactionHealthName,
  LglCntntMUseCaseExecStatus,
  LglCntntMRelshpUseCase
FROM I_LglTransactionRelshpFailed
LEFT OUTER JOIN C_LegalTransactionHealthVH AS _LegalTransactionHealthVH ON LegalTransactionHealth = _LegalTransactionHealthVH.LegalTransactionHealth  -- association [0..1]
;

Learn More