C_ChgRecdObjRefCmntRcrs

DDL: C_CHGRECDOBJREFCMNTRCRS SQL: CCRECDREFORCOMM Type: view CONSUMPTION
16 Fields 1 Data Sources 2 Associations

Object Reference Comment Recursion

C_ChgRecdObjRefCmntRcrs is a Consumption CDS View that provides data about "Object Reference Comment Recursion" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdObjRefCmntRcrsTP) and exposes 16 fields with key field CommentObjRefRcrsUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdObjRefCmntRcrsTP I_ChgRecdObjRefCmntRcrsTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
[1..1] C_ChgRecdObjRefCmntTop _ParentComment $projection.ChgRecordParentCommentUUID = _ParentComment.CommentObjRefUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CCRECDREFORCOMM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Object Reference Comment Recursion view
ObjectModel.createEnabled true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
UI.headerInfo.typeName Object Reference Recursive Comment view
UI.headerInfo.typeNamePlural Object Reference Recursive Comment view
UI.headerInfo.title.value CommentId view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CommentObjRefRcrsUUID CommentObjRefRcrsUUID
ChangeRecordUUID ChangeRecordUUID NodeID
ChgRecordParentCommentUUID ChgRecordParentCommentUUID
ChgRecordCreatedByUserName ChgRecordCreatedByUserName
CreatedByUserFullName CreatedByUserFullName Description
ChgRecordCreatedDateTime ChgRecordCreatedDateTime
ChgRecordLastChgByUserName ChgRecordLastChgByUserName
LastChangedByUserFullName LastChangedByUserFullName Name
ChgRecordLastChgDateTime ChgRecordLastChgDateTime
ChgRecordIsHierarchyTop ChgRecordIsHierarchyTop
ChgRecordCommentText ChgRecordCommentText
ChgRecordDeletedFlagValue ChgRecordDeletedFlagValue
ChgRecordChangeableFlagValue ChgRecordChangeableFlagValue
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus Issue Lifecycle
_ParentComment _ParentComment
_ChangeRecordObjPg _ChangeRecordObjPg

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_ChgRecdObjRefCmntRcrs.
-- 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: CCRECDREFORCOMM

CREATE VIEW C_ChgRecdObjRefCmntRcrs AS
SELECT
  CommentObjRefRcrsUUID,
  ChangeRecordUUID,
  ChgRecordParentCommentUUID,
  ChgRecordCreatedByUserName,
  CreatedByUserFullName,
  ChgRecordCreatedDateTime,
  ChgRecordLastChgByUserName,
  LastChangedByUserFullName,
  ChgRecordLastChgDateTime,
  ChgRecordIsHierarchyTop,
  ChgRecordCommentText,
  ChgRecordDeletedFlagValue,
  ChgRecordChangeableFlagValue,
  ChangeRecordLifecycleStatus
FROM I_ChgRecdObjRefCmntRcrsTP
LEFT OUTER JOIN C_ChangeRecordObjPg AS _ChangeRecordObjPg ON ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID  -- association [1..1]
LEFT OUTER JOIN C_ChgRecdObjRefCmntTop AS _ParentComment ON ChgRecordParentCommentUUID = _ParentComment.CommentObjRefUUID  -- association [1..1]
;

Learn More