C_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 C_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: CLCMRELSTATUS

CREATE VIEW C_LglCntntMRelshpUseCaseStatus AS
SELECT
  LegalTransactionUUID,
  LglCntntMRelshpUseCase,
  _LglCntntMRelshpRegnUseCase.LegalTransactionUUID AS LegalTransactionRelshpUUID,
  LglCntntMUseCaseRegUUID,
  LegalTransactionTopUUID,
  _LglCntntMRelshpUseCaseStatus.LglCntntMTopRelshpUseCase AS LglCntntMTopRelshpUseCase,
  _LglCntntMRegnUseCase.LglCntntMUseCaseExecStatus AS LglCntntMUseCaseJobExecStatus,
  _TopLegalTransaction.LegalTransaction AS LegalTransactionTop,
  _TopLegalTransaction.LegalTransactionTitle AS LegalTransactionTitleTop,
  cast( _LglCntntMRegnUseCase.LglCntntMLogHandler as balloghndl ) AS LglCntntMLogHandler,
  _LglCntntMRelshpRegnUseCase.LegalTransaction AS LegalTransaction,
  _LglCntntMRelshpRegnUseCase.LegalTransactionTitle AS LegalTransactionTitle,
  _LglCntntMRelshpRegnUseCase.LglTransHealthCriticality AS LglTransHealthCriticality,
  _LglCntntMRelshpRegnUseCase.LegalTransactionHealth AS LegalTransactionHealth,
  _LglCntntMRelshpRegnUseCase.LegalTransactionHealthName AS LegalTransactionHealthName,
  cast( _LglCntntMRelshpRegnUseCase.LglCntntMLegalTrLogHandler as balloghndl ) AS LglCntntMLegalTrLogHandler,
  _LglCntntMRelshpRegnUseCase.RelshpLegalTransactionTitle AS RelshpLegalTransactionTitle,
  _LglCntntMRelshpRegnUseCase.RelshpLegalTransaction AS RelshpLegalTransaction,
  _LglCntntMRelshpRegnUseCase.LglCntntMRelshpType AS LglCntntMRelshpType,
  _LglCntntMRelshpRegnUseCase.LglCntntMRelTypeName AS LglCntntMRelTypeName,
  _LglCntntMRegnUseCase._LglCntntMUseCaseStatusVH AS _LglCntntMUseCaseStatusVH
FROM I_LglCntntMRelshpUseCaseStatus AS _LglCntntMRelshpUseCaseStatus
LEFT OUTER JOIN C_LglCntntMRelshpRegnUseCase AS _LglCntntMRelshpRegnUseCase ON LglCntntMUseCaseRegUUID = _LglCntntMRelshpRegnUseCase.LglCntntMUseCaseRegUUID OR LegalTransactionUUID = _LglCntntMRelshpRegnUseCase.LegalTransactionUUID AND LglCntntMRelshpUseCase = _LglCntntMRelshpRegnUseCase.LglCntntMRelshpUseCase  -- association [0..*]
LEFT OUTER JOIN C_LegalTransactionIdValueHelp AS _LegalTransactionIdValueHelp ON legaltransaction = _LegalTransactionIdValueHelp.LegalTransaction  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMRelshpRegUseCase AS _LglCntntMRegnUseCase ON LglCntntMUseCaseRegUUID = _LglCntntMRegnUseCase.LglCntntMUseCaseRegUUID  -- association [1..1]
LEFT OUTER JOIN C_LglCntntMUseCaseVH AS _LglCntntMUseCaseVH ON LglCntntMRelshpUseCase = _LglCntntMUseCaseVH.LglCntntMRelshpUseCase  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMUseCaseStatusText AS _LglCntntMUseCaseStatusText ON LglCntntMUseCaseJobExecStatus = _LglCntntMUseCaseStatusText.LglCntntMUseCaseJobExecStatus AND Language = $session.system_language  -- association [0..1]
;