R_CHANGERECORDHEADER_2

CDS View

Change Record Header

R_CHANGERECORDHEADER_2 is a CDS View in S/4HANA. Change Record Header. It contains 30 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 30 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_ChangeRecordHeader view_entity from TRANSACTIONAL Change Record Header

Fields (30)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordUUID ChangeRecordUUID 1
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 1
ChangeRecordCategory ChangeRecordCategory 1
ChangeRecordDetailDescription ChangeRecordDetailDescription 1
ChangeRecordItemEditMode ChangeRecordItemEditMode 1
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus 1
ChangeRecordReferenceTextUUID ChangeRecordReferenceTextUUID 1
ChangeRecordReferenceUUID ChangeRecordReferenceUUID 1
ChangeRecordStatus ChangeRecordStatus 1
ChangeRecordType ChangeRecordType 1
ChangeRecordUserStatusProfile ChangeRecordUserStatusProfile 1
ChgRecdAuthGroup ChgRecdAuthGroup 1
ChgRecdEngEffectiveDate ChgRecdEngEffectiveDate 1
ChgRecdExpectedCompletionDate ChgRecdExpectedCompletionDate 1
ChgRecdMfgEffectiveDate ChgRecdMfgEffectiveDate 1
ChgRecdPrflIdn ChgRecdPrflIdn 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
ChgRecdSilentDataMigrtnStatus ChgRecdSilentDataMigrtnStatus 1
ChgRecordApplication ChgRecordApplication 1
ChgRecordDescriptionText ChgRecordDescriptionText 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
ExtensionChangeRecordUUID ExtensionChangeRecordUUID 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
ParentChangeRecordUUID ParentChangeRecordUUID 1
Partner Partner 1
ResponsibleChangeRecordUUID ResponsibleChangeRecordUUID 1
RootChangeRecordUUID RootChangeRecordUUID 1 
@AbapCatalog.viewEnhancementCategory:  [#NONE]
@ObjectModel.sapObjectNodeType.name:   'ChangeRecord'
@AccessControl.authorizationCheck:     #MANDATORY
@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Change Record Header'
@VDM: {
lifecycle.contract.type: #SAP_INTERNAL_API,
viewType: #TRANSACTIONAL
}
@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL
}
define view entity R_ChangeRecordHeader_2
  as select from I_ChangeRecordHeader_1      as _Header
    inner join  R_CHGRECDATAMIGRATIONSTATUS as tf on( tf.ChgRecdDataMigrationPhase = 'R')
                                             
{
  key _Header.ChangeRecordUUID,
      _Header.ChangeRecord,
      _Header.ChangeRecordType,
      _Header.ParentChangeRecordUUID,
      _Header.RootChangeRecordUUID,
      _Header.ChangeRecordStatus,
      _Header.ChangeRecordCategory,
      _Header.ChgRecordApplication,
      _Header.ChangeNumber,
      _Header.CreatedByUser,
      _Header.CreationDateTime,
      _Header.LastChangedByUser,
      _Header.LastChangeDateTime,
      _Header.ChangeRecordLifecycleStatus,
      _Header.ChgMgmtUserStatusProfile              as ChangeRecordUserStatusProfile,
      _Header.ChgRecdAuthGroup,
      _Header.ExtensionChangeRecordUUID,
      _Header.ChgRecdReasonForChange,
      _Header.ChgRecdExpectedCompletionDate,
      _Header.ChgRecdPrflIdn,
      _Header.ChangeRecordDetailDescription,
      _Header.ChgRecdEngEffectiveDate,
      _Header.ChgRecdMfgEffectiveDate,
      _Header.ChangeRecordItemEditMode,
      _Header.ChgRecdSilentDataMigrtnStatus,
      _Header.Partner,
 //     _Header.Partner as ChangeRecordPartner,

      _Header.ResponsibleChangeRecordUUID                       as ResponsibleChangeRecordUUID,
      _Header.ChangeRecordReferenceTextUUID,
      _Header.ChangeRecordReferenceUUID,
      _Header.ChgRecordDescriptionText
      
}
where  _Header.ChgRecdSilentDataMigrtnStatus <> '01'

union all select from I_ChangeRecordHeader_2     as _header2
inner join   R_CHGRECDATAMIGRATIONSTATUS        as tf on( tf.ChgRecdDataMigrationPhase = 'F')
                                                       or( tf.ChgRecdDataMigrationPhase = 'R')
association [0..1] to I_ChgRecdSilentDataMigrtnSts as _ChangeRecordSdmStatus        on  _ChangeRecordSdmStatus.ChangeRecordUUID = _header2.ChangeRecordUUID
{
  key     _header2.ChangeRecordUUID,
          _header2.ChangeRecord,
          _header2.ChangeRecordType,
          _header2.ParentChangeRecordUUID,
          _header2.RootChangeRecordUUID,
          _header2.ChangeRecordStatus,
          _header2.ChangeRecordCategory,
          _header2.ChgRecordApplication,
          _header2.ChangeNumber,
          _header2.CreatedByUser,
          _header2.CreationDateTime,
          _header2.LastChangedByUser,
          _header2.LastChangeDateTime,
          _header2.ChangeRecordLifecycleStatus,
          _header2.ChangeRecordUserStatusProfile,
          _header2.ChgRecdAuthGroup,
          _header2.ExtensionChangeRecordUUID,
          _header2.ChgRecdReasonForChange,
          _header2.ChgRecdExpectedCompletionDate,
          _header2.ChgRecdPrflIdn,
          _header2.ChangeRecordDetailDescription,
          _header2.ChgRecdEngEffectiveDate,
          _header2.ChgRecdMfgEffectiveDate,
          _header2.ChangeRecordItemEditMode,
          _ChangeRecordSdmStatus.ChgRecdSilentDataMigrtnStatus,
          _header2.Partner,
//          _header2.ChangeRecordPartner,

          _header2.ResponsibleChangeRecordUUID,
          _header2.ChangeRecordReferenceTextUUID,
          _header2.ChangeRecordReferenceUUID,
          _header2.ChgRecordDescriptionText
          
}

Learn More