C_LglCntntMDocCollaboration

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_LglCntntMDocCollaboration.
-- 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.

CREATE VIEW C_LglCntntMDocCollaboration AS
SELECT
  LglCntntMCollabnDocUUID,
  LglCntntMCollabnUUID,
  LglCntntMDocumentUUID,
  _LegalTransCollabn.LglCntntMCollaboration AS LglCntntMCollaboration,
  _LegalTransCollabn.LglCntntMCollabnName AS LglCntntMCollabnName,
  _LegalTransCollabn.LglCntntMCollabnTypeName AS LglCntntMCollabnTypeName,
  _LegalTransCollabn.LglCntntMCollabnType AS LglCntntMCollabnType,
  LegalTransactionUUID,
  _LegalTransCollabn.LglCntntMCollabnStatusName AS LglCntntMCollabnStatusName,
  _LegalTransCollabn.LglCntntMCollabnStatus AS LglCntntMCollabnStatus,
  0 AS LglCntntMCollabnStsCritlty,
  _LegalTransCollabn.LglCntntMScopeOfCollabnName AS LglCntntMScopeOfCollabnName,
  _LegalTransCollabn.LglCntntMScopeOfCollabn AS LglCntntMScopeOfCollabn,
  _LegalTransCollabn.LglCntntMCollabnDescription AS LglCntntMCollabnDescription,
  _LegalTransCollabn.LglCntntMCreatedByUser AS LglCntntMCreatedByUser,
  _LegalTransCollabn.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  cast('' as ad_namtext) AS LglCntntMCreatedByFullName,
  _LegalTransCollabn.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  _LegalTransCollabn.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  _LegalTransCollabn.LglCntntMLogHandler AS LglCntntMLogHandler,
  cast('' as ad_namtext) AS LglCntntMChangedByFullName,
  _LegalTransCollabn.LglCntntMCollabnTeamName AS LglCntntMCollabnTeamName
FROM R_LglCntntMCollabnDocumentTP
LEFT OUTER JOIN C_LegalTransCollaboration AS _LegalTransCollabn ON LglCntntMCollabnUUID = _LegalTransCollabn.LglCntntMCollabnUUID  -- association [0..1]
LEFT OUTER JOIN C_LegalTransCollabnMember AS _LegalTransCollabnMember ON LglCntntMCollabnUUID = _LegalTransCollabnMember.LglCntntMCollabnUUID  -- association [1..*]
LEFT OUTER JOIN I_LCMUserContactCard AS _CreatedByContactCard ON _CreatedByContactCard.ContactCardType = 'User' AND _CreatedByContactCard.ContactCardID = LglCntntMCreatedByUser AND _CreatedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _ChangedByContactCard ON _ChangedByContactCard.ContactCardType = 'User' AND _ChangedByContactCard.ContactCardID = LglCntntMChangedByUser AND _ChangedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
;