C_LglCntntMCollaboration

DDL: C_LGLCNTNTMCOLLABORATION Type: view_entity CONSUMPTION Package: ODATA_LCM_LT_COLLABN
21 Fields 1 Data Sources 2 Associations

Collaborations in Legal Transaction

C_LglCntntMCollaboration is a Consumption CDS View that provides data about "Collaborations in Legal Transaction" in SAP S/4HANA. It reads from 1 data source (R_LglCntntMCollaborationTP) and exposes 21 fields with key field LglCntntMCollabnUUID. It has 2 associations to related views. Part of development package ODATA_LCM_LT_COLLABN.

Data Sources (1)

SourceAliasJoin Type
R_LglCntntMCollaborationTP R_LglCntntMCollaborationTP from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LCMUserContactCard _CreatedByContactCard _CreatedByContactCard.ContactCardType = 'User' and _CreatedByContactCard.ContactCardID = $projection.LglCntntMCreatedByUser and _CreatedByContactCard.ContactCardRole = 'Creator'
[0..1] I_LCMUserContactCard _ChangedByContactCard _ChangedByContactCard.ContactCardType = 'User' and _ChangedByContactCard.ContactCardID = $projection.LglCntntMChangedByUser and _ChangedByContactCard.ContactCardRole = 'Creator'

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Collaborations in Legal Transaction view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Collaboration view
UI.headerInfo.typeNamePlural Collaborations view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMCollabnUUID LglCntntMCollabnUUID Collaboration UUID
LglCntntMCollaboration LglCntntMCollaboration Name
LglCntntMCollabnName LglCntntMCollabnName Collaboration Name
LglCntntMCollabnTypeName Collaboration Type
LglCntntMCollabnType LglCntntMCollabnType Collaboration Type
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LglCntntMCollabnStatusName
LglCntntMCollabnStatus LglCntntMCollabnStatus Status
LglCntntMCollabnStsCritlty 0
LglCntntMScopeOfCollabnName Scope of Collaboration
LglCntntMScopeOfCollabn LglCntntMScopeOfCollabn Collaboration Scope
LglCntntMCreatedByUser LglCntntMCreatedByUser Created By
LglCntntMCreatedUTCDateTime LglCntntMCreatedUTCDateTime Created On
LglCntntMCreatedByFullName
LglCntntMChangedByUser LglCntntMChangedByUser Changed By
LglCntntMChangedUTCDateTime LglCntntMChangedUTCDateTime Changed On
LglCntntMChangedByFullName
LglCntntMLogHandler LglCntntMLogHandler Handle
_CreatedByContactCard _CreatedByContactCard
_ChangedByContactCard _ChangedByContactCard
_LegalTransaction _LegalTransaction

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_LglCntntMCollaboration.
-- 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_LglCntntMCollaboration AS
SELECT
  LglCntntMCollabnUUID,
  LglCntntMCollaboration,
  LglCntntMCollabnName,
  _LglCntntMCollabnTypeText[1: Language = $session.system_language].LglCntntMCollabnTypeName AS LglCntntMCollabnTypeName,
  LglCntntMCollabnType,
  LegalTransactionUUID,
  _LglCntntMCollabnStatusTxt[1: Language = $session.system_language].LglCntntMCollabnStatusName AS LglCntntMCollabnStatusName,
  LglCntntMCollabnStatus,
  0 AS LglCntntMCollabnStsCritlty,
  _LglCntntMScopeOfCollabnTxt[1: Language = $session.system_language].LglCntntMScopeOfCollabnName AS LglCntntMScopeOfCollabnName,
  LglCntntMScopeOfCollabn,
  LglCntntMCreatedByUser,
  LglCntntMCreatedUTCDateTime,
  cast('' as ad_namtext) AS LglCntntMCreatedByFullName,
  LglCntntMChangedByUser,
  LglCntntMChangedUTCDateTime,
  cast('' as ad_namtext) AS LglCntntMChangedByFullName,
  LglCntntMLogHandler
FROM R_LglCntntMCollaborationTP
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]
;

Learn More