I_LglCntntMRelshpUseCaseStatus

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_LglCntntMRelshpUseCaseStatus.
-- 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: ILCMRELUSECASST

CREATE VIEW I_LglCntntMRelshpUseCaseStatus AS
SELECT
  LegalTransactionUUID,
  I_LglCntntMUseCases.LglCntntMRelshpUseCase AS LglCntntMRelshpUseCase,
  _LT_RelRegn.LglCntntMUseCaseRegUUID AS LglCntntMUseCaseRegUUID,
  _LT_RelRegn.LglCntntMUseCaseExecStatus AS LglCntntMUseCaseExecStatus,
  _LT_RelRegn.LegalTransactionTopUUID AS LegalTransactionTopUUID,
  _LT_RelRegn.LglCntntMLegalTrLogHandler AS LglCntntMLegalTrLogHandler,
  _LT_RelRegn.LglCntntMTopRelshpUseCase AS LglCntntMTopRelshpUseCase
FROM I_LegalTransaction
CROSS JOIN I_LglCntntMUseCases
LEFT OUTER JOIN I_LglCntntMRltnLglTransUseCase AS _LT_RelRegn ON LegalTransactionUUID = _LT_RelRegn.LegalTransactionRelshpUUID AND _LT_RelRegn.LglCntntMTopRelshpUseCase = 'X' AND LglCntntMRelshpUseCase = _LT_RelRegn.LglCntntMRelshpUseCase  -- association [0..1]
LEFT OUTER JOIN I_LegalTransaction AS _TopLegalTransaction ON legaltransactiontopuuid = _TopLegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LglCntntMUseCaseText AS _LglCntntMUseCaseText ON LglCntntMRelshpUseCase = _LglCntntMUseCaseText.LglCntntMRelshpUseCase AND Language = $session.system_language  -- association [0..1]
;