R_LglCntntMCollabnTeamChnlTP

DDL: R_LGLCNTNTMCOLLABNTEAMCHNLTP Type: view_entity TRANSACTIONAL

Collaboration Team Channel - TP

R_LglCntntMCollabnTeamChnlTP is a Transactional CDS View that provides data about "Collaboration Team Channel - TP" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMCollabnTeamChnl) and exposes 9 fields with key field LglCntntMCollabnChannelUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMCollabnTeamChnl I_LglCntntMCollabnTeamChnl from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_LglCntntMCollaborationTP _LglCntntMCollaboration $projection.LglCntntMCollabnUUID = _LglCntntMCollaboration.LglCntntMCollabnUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Collaboration Team Channel - TP view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMCollabnChannelUUID LglCntntMCollabnChannelUUID Channel UUID
LglCntntMCollabnTeamUUID LglCntntMCollabnTeamUUID Team UUID
LglCntntMCollabnUUID LglCntntMCollabnUUID Collaboration UUID
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LglCntntMCollabnTeamChnlID LglCntntMCollabnTeamChnlID Team Channel UUID
LglCntntMCollabnChnlDriveID LglCntntMCollabnChnlDriveID Channel Drive UUID
_LglCntntMCollabnTeam _LglCntntMCollabnTeam
_LglCntntMCollaboration _LglCntntMCollaboration
_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 R_LglCntntMCollabnTeamChnlTP.
-- 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 R_LglCntntMCollabnTeamChnlTP AS
SELECT
  LglCntntMCollabnChannelUUID,
  LglCntntMCollabnTeamUUID,
  LglCntntMCollabnUUID,
  LegalTransactionUUID,
  LglCntntMCollabnTeamChnlID,
  LglCntntMCollabnChnlDriveID
FROM I_LglCntntMCollabnTeamChnl
LEFT OUTER JOIN R_LglCntntMCollaborationTP AS _LglCntntMCollaboration ON LglCntntMCollabnUUID = _LglCntntMCollaboration.LglCntntMCollabnUUID  -- association [1..1]
;