C_ChgRecdObjRefCmntTop

DDL: C_CHGRECDOBJREFCMNTTOP SQL: CCHGRECDREFOCOMM Type: view CONSUMPTION

Change Record Obj Ref Comment

C_ChgRecdObjRefCmntTop is a Consumption CDS View that provides data about "Change Record Obj Ref Comment" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdObjRefCmntTopTP) and exposes 17 fields with key field CommentObjRefUUID. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdObjRefCmntTopTP I_ChgRecdObjRefCmntTopTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ChangeRecordObjPg _ChangeRecordObjPg $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
[0..*] C_ChgRecdObjRefCmntRcrs _ChildRefComment $projection.CommentObjRefUUID = _ChildRefComment.ChgRecordParentCommentUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CCHGRECDREFOCOMM view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION 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 Comment view
UI.headerInfo.typeNamePlural Object Reference Comment view
UI.headerInfo.title.value CommentObjRefUUID view
EndUserText.label Change Record Obj Ref Comment view
AbapCatalog.compiler.compareFilter true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CommentObjRefUUID CommentObjRefUUID
ChangeRecordUUID ChangeRecordUUID
ChgRecordIsHierarchyTop ChgRecordIsHierarchyTop
ChgRecordCreatedDateTime ChgRecordCreatedDateTime
ChangeRecordReferenceUUID ChangeRecordReferenceUUID
ChgRecordLastChgByUserName ChgRecordLastChgByUserName
LastChangedByUserFullName LastChangedByUserFullName
ChgRecordCreatedByUserName ChgRecordCreatedByUserName
CreatedByUserFullName CreatedByUserFullName
ChgRecordParentCommentUUID ChgRecordParentCommentUUID
ChgRecordLastChgDateTime ChgRecordLastChgDateTime
ChgRecordCommentText ChgRecordCommentText
ChgRecordDeletedFlagValue ChgRecordDeletedFlagValue
ChgRecordChangeableFlagValue ChgRecordChangeableFlagValue
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus
_ChangeRecordObjPg _ChangeRecordObjPg
_ChildRefComment _ChildRefComment 
@AbapCatalog.sqlViewName: 'CCHGRECDREFOCOMM'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
   semanticKey: ['CommentObjRefUUID'],
   createEnabled: true,
   deleteEnabled,
   updateEnabled,
   transactionalProcessingDelegated: true
}
@ObjectModel.usageType: { serviceQuality: #C,
                          dataClass: #MIXED,
                          sizeCategory: #XXL}
@UI.headerInfo:{
  typeName: 'Object Reference Comment',
  typeNamePlural: 'Object Reference Comment',
  title:{value:'CommentObjRefUUID'}
}
@EndUserText.label: 'Change Record Obj Ref Comment'
@AbapCatalog.compiler.compareFilter:true

define view C_ChgRecdObjRefCmntTop
  as select from I_ChgRecdObjRefCmntTopTP
  association [1..1] to C_ChangeRecordObjPg     as _ChangeRecordObjPg on $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID
  association [0..*] to C_ChgRecdObjRefCmntRcrs as _ChildRefComment   on $projection.CommentObjRefUUID = _ChildRefComment.ChgRecordParentCommentUUID
{
  key CommentObjRefUUID,
      ChangeRecordUUID,
      ChgRecordIsHierarchyTop,
      ChgRecordCreatedDateTime,
      ChangeRecordReferenceUUID,
      @Semantics.user.lastChangedBy: true
      @ObjectModel.text.element: [ 'LastChangedByUserFullName']
      ChgRecordLastChgByUserName,
      @ObjectModel.readOnly: true
      @Semantics.text: true         
      @UI.hidden: true
       LastChangedByUserFullName,
      @Semantics.user.createdBy: true
      @ObjectModel.text.element: [ 'CreatedByUserFullName']
      ChgRecordCreatedByUserName,
      @ObjectModel.readOnly: true
      @Semantics.text: true         
      @UI.hidden: true
      CreatedByUserFullName,
      ChgRecordParentCommentUUID,
      ChgRecordLastChgDateTime,
      @Semantics.text: true
      ChgRecordCommentText,
      ChgRecordDeletedFlagValue,
      ChgRecordChangeableFlagValue,
      ChangeRecordLifecycleStatus,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ChangeRecordObjPg,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _ChildRefComment
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDOBJREFCMNTTOPTP"
],
"ASSOCIATED":
[
"C_CHANGERECORDOBJPG",
"C_CHGRECDOBJREFCMNTRCRS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More