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 from TRANSACTIONAL Change Record Comment - TP 
@AbapCatalog.sqlViewName: 'ICHGRECDCOM'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey:true
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #XXL}
@EndUserText.label: 'Change record Comment'
define view 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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMI/CR_COMMENT"
],
"ASSOCIATED":
[
"I_CHANGERECORDBSC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More