C_ChgRecdCmntChildRcrs

DDL: C_CHGRECDCMNTCHILDRCRS SQL: CCRECDCOMMREC Type: view CONSUMPTION

Change Record Comment Recursion

C_ChgRecdCmntChildRcrs is a Consumption CDS View that provides data about "Change Record Comment Recursion" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdCmntChildRcrsTP) and exposes 16 fields with key field CommentaryRcrsUUID. It has 2 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdCmntChildRcrsTP I_ChgRecdCmntChildRcrsTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
[1..1] C_ChgRecdCmntTop _ParentComment $projection.ChgRecordParentCommentUUID = _ParentComment.ChgRecordCommentaryUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CCRECDCOMMREC 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
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 Comment view
UI.headerInfo.typeNamePlural Comment view
UI.headerInfo.title.value CommentId view
EndUserText.label Change Record Comment Recursion view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CommentaryRcrsUUID CommentaryRcrsUUID
ChangeRecordUUID ChangeRecordUUID
ChgRecordParentCommentUUID ChgRecordParentCommentUUID
ChgRecordCreatedByUserName ChgRecordCreatedByUserName
CreatedByUserFullName CreatedByUserFullName
ChgRecordCreatedDateTime ChgRecordCreatedDateTime
ChgRecordLastChgByUserName ChgRecordLastChgByUserName
LastChangedByUserFullName LastChangedByUserFullName
ChgRecordLastChgDateTime ChgRecordLastChgDateTime
ChgRecordIsHierarchyTop ChgRecordIsHierarchyTop
ChgRecordCommentText ChgRecordCommentText
ChgRecordDeletedFlagValue ChgRecordDeletedFlagValue
ChgRecordChangeableFlagValue ChgRecordChangeableFlagValue
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus
_ParentComment _ParentComment
_ChangeRecordObjPg _ChangeRecordObjPg 
@AbapCatalog.sqlViewName: 'CCRECDCOMMREC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   semanticKey: ['CommentaryRcrsUUID'],
   createEnabled: true,
   deleteEnabled,
   updateEnabled,
   transactionalProcessingDelegated: true
}

@ObjectModel.usageType: { serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #XXL}

@UI.headerInfo:{
  typeName: 'Comment',
  typeNamePlural: 'Comment',
  title:{value:'CommentId'}
}
@EndUserText.label: 'Change Record Comment Recursion'
define view C_ChgRecdCmntChildRcrs
  as select from I_ChgRecdCmntChildRcrsTP
  association [1..1] to C_ChangeRecordObjPg as _ChangeRecordObjPg on $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
  association [1..1] to C_ChgRecdCmntTop    as _ParentComment     on $projection.ChgRecordParentCommentUUID = _ParentComment.ChgRecordCommentaryUUID
{
      @UI.hidden: true
      @ObjectModel.readOnly: true
  key CommentaryRcrsUUID,
      @UI.hidden: true
      @ObjectModel.readOnly: true
      ChangeRecordUUID,
      @UI.hidden: true
      @ObjectModel.readOnly: true
      ChgRecordParentCommentUUID,
      @Semantics.text: true
      @Semantics.user.createdBy: true
      @ObjectModel.readOnly: true
      @ObjectModel.text.element: [ 'CreatedByUserFullName']
      ChgRecordCreatedByUserName,
      @ObjectModel.readOnly: true
      //      _CommentCreatedByUser.FullName     as CreatedByUserFullName,

      CreatedByUserFullName,
      ChgRecordCreatedDateTime,
      @Semantics.user.lastChangedBy: true
      @ObjectModel.text.element: [ 'LastChangedByUserFullName']
      ChgRecordLastChgByUserName,
      @ObjectModel.readOnly: true
      //      _CommentLastChangedByUser.FullName as LastChangedByUserFullName,

      LastChangedByUserFullName,
      ChgRecordLastChgDateTime,
      ChgRecordIsHierarchyTop,
      ChgRecordCommentText,
      ChgRecordDeletedFlagValue,
      ChgRecordChangeableFlagValue,
      ChangeRecordLifecycleStatus,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _ParentComment,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _ChangeRecordObjPg
}

Learn More