I_CHGRECDCMNTBSC

CDS View

Change record Comment

I_CHGRECDCMNTBSC is a CDS View in S/4HANA. Change record Comment. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChgRecdCmntTopTP view_entity from TRANSACTIONAL Change Record Comment - TP 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #A,
                         dataClass: #TRANSACTIONAL,
                         sizeCategory: #XXL}
@EndUserText.label: 'Change record Comment'
define view entity I_ChgRecdCmntBsc
  as select from /plmi/cr_comment as com
  association [1..1] to I_ChangeRecordBsc as _ChangeRecordBsc on $projection.ChangeRecordUUID = _ChangeRecordBsc.ChangeRecordUUID
{
  key com.db_key                             as ChangeRecordCommentUUID,
      com.parent_key                         as ChangeRecordUUID,
      com.hierarchy_id                       as ChgRecordParentCommentUUID,
      com.ishierarchytop                     as ChgRecordIsHierarchyTop,
      com.comment_text                       as ChgRecordCommentText,
      com.created_by                         as ChgRecordCreatedByUserName,
      cast( com.creation_time as tzntstmps ) as ChgRecordCreatedDateTime,
      com.changed_by                         as ChgRecordLastChgByUserName,
      cast( com.change_time as tzntstmps )   as ChgRecordLastChgDateTime,
      com.deleted_flag                       as ChgRecordDeletedFlagValue,
      com.changeable_flag                    as ChgRecordChangeableFlagValue,
      com.lcycle_cd                          as ChangeRecordLifecycleStatus,
      _ChangeRecordBsc
}
where
  ishierarchytop = 'X'

Learn More