I_InvgCsMChangeLog

DDL: I_INVGCSMCHANGELOG SQL: IINVGCSMCHNGELOG Type: view BASIC

ICM Change Log

I_InvgCsMChangeLog is a Basic CDS View that provides data about "ICM Change Log" in SAP S/4HANA. It reads from 2 data sources (cdhdr, cdpos) and exposes 13 fields with key fields InvgCsMChangeLogObjectClass, InvgCsMChangeLogObjectID, InvgCsMChangeLogChangeNumber, InvgCsMChangeLogTableName, InvgCsMChangeLogTableKey.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
cdhdr _header inner
cdpos _item from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINVGCSMCHNGELOG view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label ICM Change Log view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMChangeLogObjectClass cdhdr objectclas
KEY InvgCsMChangeLogObjectID cdhdr objectid
KEY InvgCsMChangeLogChangeNumber cdhdr changenr
KEY InvgCsMChangeLogTableName tabname
KEY InvgCsMChangeLogTableKey tabkey
KEY InvgCsMChangeLogFieldName fname
KEY InvgCsMChangeLogChangeType chngind
InvgCsMChangeLogNewValue value_new
InvgCsMChangeLogOldValue value_old
InvgCsMChangeLogCreatedByID username
InvgCsMChangeLogCreatedDate udate
InvgCsMChangeLogCreatedTime utime
InvgCsMChangeLogTransCode tcode 
@AbapCatalog.sqlViewName: 'IINVGCSMCHNGELOG'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'ICM Change Log'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view I_InvgCsMChangeLog
  as select from cdpos as _item
    inner join   cdhdr as _header on  _item.objectclas = _header.objectclas
                                  and _item.objectid   = _header.objectid
                                  and _item.changenr   = _header.changenr

{

  key _header.objectclas                                                                 as InvgCsMChangeLogObjectClass,
  key _header.objectid                                                                   as InvgCsMChangeLogObjectID,
  key _header.changenr                                                                   as InvgCsMChangeLogChangeNumber,
  key tabname                                                                            as InvgCsMChangeLogTableName,
  key tabkey                                                                             as InvgCsMChangeLogTableKey,
  key fname                                                                              as InvgCsMChangeLogFieldName,
  key chngind                                                                            as InvgCsMChangeLogChangeType,
  
      value_new                                                                          as InvgCsMChangeLogNewValue,
      value_old                                                                          as InvgCsMChangeLogOldValue,

      username                                                                           as InvgCsMChangeLogCreatedByID,
      udate                                                                              as InvgCsMChangeLogCreatedDate,
      utime                                                                              as InvgCsMChangeLogCreatedTime,
      tcode                                                                              as InvgCsMChangeLogTransCode
}

Learn More