C_ChgRecdCmntTop

@AbapCatalog.sqlViewName: 'CCHGRECDCOMM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Change Record Comment'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
   semanticKey: ['ChgRecordCommentaryUUID'],
   createEnabled: true,
   deleteEnabled,
   updateEnabled,
   transactionalProcessingDelegated: true
}

@ObjectModel.usageType: { serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #XXL}
@UI.headerInfo:{
  typeName: 'Comment',
  typeNamePlural: 'Comment',
  title:{value:'CommentId'}
}
define view C_ChgRecdCmntTop
  as select from I_ChgRecdCmntTopTP
  association [1..1] to C_ChangeRecordObjPg    as _ChangeRecordObjPg on $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
  association [0..*] to C_ChgRecdCmntChildRcrs as _ChildComment      on $projection.ChgRecordCommentaryUUID = _ChildComment.ChgRecordParentCommentUUID
{
      @UI.hidden: true
      @ObjectModel.readOnly: true
  key ChgRecordCommentaryUUID,
      @UI.hidden: true
      @ObjectModel.readOnly: true
      ChangeRecordUUID,
      @UI.hidden: true
      @ObjectModel.readOnly: true
      ChgRecordParentCommentUUID,
      @Semantics.text: true
      @Semantics.user.createdBy: true
      @ObjectModel.readOnly: true
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_ChangeRecordCreatedByVH',
                   element: 'CreatedByUser' }
      }]
      @ObjectModel.text.element: [ 'CreatedByUserFullName']
        ChgRecordCreatedByUserName,
      @ObjectModel.readOnly: true
//      _CommentCreatedByUser.FullName as CreatedByUserFullName,

      CreatedByUserFullName,
      ChgRecordCreatedDateTime,
//      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'

//      @ObjectModel.readOnly: true

//      cast( '00000000' as /plmb/created_on )              as CreationDate,

      @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_ROOT,#TO_COMPOSITION_PARENT ]
      _ChangeRecordObjPg,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _ChildComment,
      _CommentCreatedByUser,
      _CommentLastChangedByUser

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDCMNTTOPTP"
],
"ASSOCIATED":
[
"C_CHANGERECORDOBJPG",
"C_CHGRECDCMNTCHILDRCRS",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_CHGRECDCMNTTOPTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/