P_IHBMstrDataObjChangeDocument

DDL: P_IHBMSTRDATAOBJCHANGEDOCUMENT Type: view_entity COMPOSITE

P_IHBMstrDataObjChangeDocument is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_ChangeDocument, I_ChangeDocumentItem, I_IHBMasterDataObject) and exposes 13 fields with key fields IHBObjectUUID, ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_ChangeDocument _ChangeDocument from
I_ChangeDocumentItem _ChangeDocumentItem inner
I_IHBMasterDataObject _IHBMasterDataObject inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY IHBObjectUUID I_IHBMasterDataObject IHBObjectUUID
KEY ChangeDocObject I_ChangeDocument ChangeDocObject
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass
KEY ChangeDocument I_ChangeDocument ChangeDocument
KEY DatabaseTable I_ChangeDocumentItem DatabaseTable
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType
CreatedByUser I_ChangeDocument CreatedByUser
CreationDate I_ChangeDocument CreationDate
CreationTime I_ChangeDocument CreationTime
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view entity P_IHBMstrDataObjChangeDocument
  as select from I_ChangeDocument      as _ChangeDocument
    inner join   I_IHBMasterDataObject as _IHBMasterDataObject on _ChangeDocument.ChangeDocObject = bintohex(
      _IHBMasterDataObject.IHBObjectUUID
    )
    inner join   I_ChangeDocumentItem  as _ChangeDocumentItem  on  _ChangeDocumentItem.ChangeDocObject      = _ChangeDocument.ChangeDocObject
                                                               and _ChangeDocumentItem.ChangeDocObjectClass = _ChangeDocument.ChangeDocObjectClass
                                                               and _ChangeDocumentItem.ChangeDocument       = _ChangeDocument.ChangeDocument
{
  key _IHBMasterDataObject.IHBObjectUUID,
  key _ChangeDocument.ChangeDocObject,
  key _ChangeDocument.ChangeDocObjectClass,
  key _ChangeDocument.ChangeDocument,
  key _ChangeDocumentItem.DatabaseTable,
  key _ChangeDocumentItem.ChangeDocTableKey,
  key _ChangeDocumentItem.ChangeDocDatabaseTableField,
  key _ChangeDocumentItem.ChangeDocItemChangeType,

      _ChangeDocument.CreatedByUser,
      _ChangeDocument.CreationDate,
      _ChangeDocument.CreationTime,

      _ChangeDocumentItem.ChangeDocPreviousFieldValue,
      _ChangeDocumentItem.ChangeDocNewFieldValue

}
where
       _ChangeDocument.ChangeDocObjectClass            =  '/PF1/IHBMDOBJ'
  and(
       _ChangeDocumentItem.ChangeDocItemChangeType     <> 'D'
    or _ChangeDocumentItem.ChangeDocItemChangeType     <> 'I'
  )
  and  _ChangeDocumentItem.ChangeDocDatabaseTableField is not initial
  and  _ChangeDocumentItem.ChangeDocDatabaseTableField <> 'KEY'

Learn More