C_RSHMaintSchedCollaborators

DDL: C_RSHMAINTSCHEDCOLLABORATORS SQL: CRSHMNTSCHDCOLB Type: view CONSUMPTION
22 Fields 1 Data Sources 2 Associations

Maintenance Schedule Collaborators

C_RSHMaintSchedCollaborators is a Consumption CDS View that provides data about "Maintenance Schedule Collaborators" in SAP S/4HANA. It reads from 1 data source (I_RSHMaintSchedCollaboratorsTP) and exposes 22 fields with key field MaintSchedCollaboratorUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RSHMaintSchedCollaboratorsTP I_RSHMaintSchedCollaboratorsTP from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_RSHMaintScheduleCollaborator _CollaboratorDetails _CollaboratorDetails.UserID = MaintSchedCollaborator
[1..1] C_RSHMaintSchedSimulation _MaintSchedSimulation _MaintSchedSimulation.MaintSchedSimlnUUID = $projection.MaintSchedSimlnUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CRSHMNTSCHDCOLB view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Schedule Collaborators view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
UI.headerInfo.typeName Maintenance Schedule Collaborators view
UI.headerInfo.typeNamePlural Maintenance Schedule Collaborators view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY MaintSchedCollaboratorUUID MaintSchedCollaboratorUUID UUID
MaintSchedSimlnUUID MaintSchedSimlnUUID UUID
MaintSchedCollaborator MaintSchedCollaborator User Name
UserDescription _CollaboratorDetails UserDescription Full Name
MaintSchedCollaboratorType MaintSchedCollaboratorType Collaborator Type
CollaboratorAddedByUser CollaboratorAddedByUser User Name
CollaboratorAddedAtDateTime CollaboratorAddedAtDateTime Time Stamp
AuthorizationGroup
IsBusinessPurposeCompleted
BusinessPartner
DataControllerSet
DataController1
DataController2
DataController3
DataController4
DataController5
DataController6
DataController7
DataController8
DataController9
DataController10
_MaintSchedSimulation _MaintSchedSimulation

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_RSHMaintSchedCollaborators.
-- 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: CRSHMNTSCHDCOLB

CREATE VIEW C_RSHMaintSchedCollaborators AS
SELECT
  MaintSchedCollaboratorUUID,
  MaintSchedSimlnUUID,
  MaintSchedCollaborator,
  _CollaboratorDetails.UserDescription AS UserDescription,
  MaintSchedCollaboratorType,
  CollaboratorAddedByUser,
  CollaboratorAddedAtDateTime,
  _CollaboratorUser._BusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _CollaboratorUser._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _CollaboratorUser._BusinessPartner.BusinessPartner AS BusinessPartner,
  _CollaboratorUser._BusinessPartner.DataControllerSet AS DataControllerSet,
  _CollaboratorUser._BusinessPartner.DataController1 AS DataController1,
  _CollaboratorUser._BusinessPartner.DataController2 AS DataController2,
  _CollaboratorUser._BusinessPartner.DataController3 AS DataController3,
  _CollaboratorUser._BusinessPartner.DataController4 AS DataController4,
  _CollaboratorUser._BusinessPartner.DataController5 AS DataController5,
  _CollaboratorUser._BusinessPartner.DataController6 AS DataController6,
  _CollaboratorUser._BusinessPartner.DataController7 AS DataController7,
  _CollaboratorUser._BusinessPartner.DataController8 AS DataController8,
  _CollaboratorUser._BusinessPartner.DataController9 AS DataController9,
  _CollaboratorUser._BusinessPartner.DataController10 AS DataController10
FROM I_RSHMaintSchedCollaboratorsTP
LEFT OUTER JOIN I_RSHMaintScheduleCollaborator AS _CollaboratorDetails ON _CollaboratorDetails.UserID = MaintSchedCollaborator  -- association [0..1]
LEFT OUTER JOIN C_RSHMaintSchedSimulation AS _MaintSchedSimulation ON _MaintSchedSimulation.MaintSchedSimlnUUID = MaintSchedSimlnUUID  -- association [1..1]
;

Learn More