I_CHGRECDOBJREFCMNTRCRSBSC

CDS View

Change Record Obj Ref Comment Recursion

I_CHGRECDOBJREFCMNTRCRSBSC is a CDS View in S/4HANA. Change Record Obj Ref Comment Recursion. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ChgRecdObjRefCmntRcrsTP view from TRANSACTIONAL CR Obj Ref Comment Recursion - TP 
@AbapCatalog.sqlViewName: 'ICHGRECDREFOCOMR'
@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 Obj Ref Comment Recursion'
define view I_ChgRecdObjRefCmntRcrsBsc
  as select from /plmi/cr_objr_c as com
  association [1..1] to I_ChangeRecordBsc as _ChangeRecordBsc on $projection.ChangeRecordUUID = _ChangeRecordBsc.ChangeRecordUUID
{
  key com.db_key                             as ChangeRecordObjRefCommentUUID,
      com.root_key                           as ChangeRecordUUID,
      com.parent_key                         as ChangeRecordReferenceUUID,
      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 = ' '

Learn More