I_ChangeRecordHistoryBasic

DDL: I_CHANGERECORDHISTORYBASIC Type: view_entity BASIC

Change Record history

I_ChangeRecordHistoryBasic is a Basic CDS View that provides data about "Change Record history" in SAP S/4HANA. It reads from 2 data sources (cdhdr, I_ChangeRecordBsc) and exposes 14 fields with key fields ChangeRecordUUID, ChangeDocument, ChangeDocDatabaseTableField.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
cdhdr _ChgHdr inner
I_ChangeRecordBsc reference from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Change Record history view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #BASIC view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID I_ChangeRecordBsc ChangeRecordUUID
KEY ChangeDocument _ChgDoc changenr
KEY ChangeDocDatabaseTableField _ChgDoc fname
LastChangedDate cdhdr udate
ChangeRecdLastChangedTime cdhdr utime
ChangeDocPreviousFieldValue _ChgDoc value_old
ChangeDocNewFieldValue _ChgDoc value_new
ChangeRecordType I_ChangeRecordBsc ChangeRecordType
ChgRecdAuthGroup I_ChangeRecordBsc ChgRecdAuthGroup
Partner I_ChangeRecordBsc Partner
ChangeRecord I_ChangeRecordBsc ChangeRecord
_LogAccMObjectTypeActive I_ChangeRecordBsc _LogAccMObjectTypeActive
_LogAccMObjectUserAuthzn I_ChangeRecordBsc _LogAccMObjectUserAuthzn
_LogAccMObjSecureIDAssgmt I_ChangeRecordBsc _LogAccMObjSecureIDAssgmt 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Change Record history'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@Search.searchable: true
@VDM.viewType: #BASIC

define view entity I_ChangeRecordHistoryBasic
  as select from           I_ChangeRecordBsc as reference
    left outer to one join cdpos             as _ChgDoc on _ChgDoc.objectid = bintohex(
      reference.ChangeRecordUUID
    )
    inner join             cdhdr             as _ChgHdr on _ChgHdr.changenr = _ChgDoc.changenr

{
  key    reference.ChangeRecordUUID          as ChangeRecordUUID,
  key    _ChgDoc.changenr                    as ChangeDocument,
         @Search.defaultSearchElement: true
         @Search.ranking: #HIGH
  key    _ChgDoc.fname                       as ChangeDocDatabaseTableField,
         _ChgHdr.udate                       as LastChangedDate,
         _ChgHdr.utime                       as ChangeRecdLastChangedTime,
         _ChgDoc.value_old                   as ChangeDocPreviousFieldValue,
         _ChgDoc.value_new                   as ChangeDocNewFieldValue,

         // elements for access control object

         reference.ChangeRecordType          as ChangeRecordType,
         reference.ChgRecdAuthGroup          as ChgRecdAuthGroup,   // note 3526771


         @Consumption.hidden: true
         reference.Partner                   as Partner,
         reference.ChangeRecord              as ChangeRecord,
         reference._LogAccMObjectTypeActive  as _LogAccMObjectTypeActive,
         reference._LogAccMObjectUserAuthzn  as _LogAccMObjectUserAuthzn,
         reference._LogAccMObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt

}

where
        _ChgHdr.objectclas = '/PLMI/CR_ENG'

  and   _ChgDoc.fname      = 'LCYCLE_CD'
  or    _ChgDoc.fname      = 'USER_STATUS_01'
  or(
        _ChgDoc.fname      = 'EXPECTED_COMP_DAT'
    and _ChgDoc.tabname    = '/PLMI/CR_HDR_EXT'
  )

Learn More